Latest Contributions by JoeBorgione

I have been trying for hours to create a Single House locator using our point address feature class in ArcSDE (or in a folder - neither works). I do not get any usable error information, sometimes ArcCatalog crashes and others the 'background process' fails. I have tried right-clicking the connection and selecting New, Address Locator. I have tried using the Create Locator tool in ArcToolbox, a model and ultimately a Python script which also crashes. Any ideas what I should be looking for? I was able to create a Dual Range locator using our centerline feature class. Any help appreciated, April Nunn Does the feature class you are using in your locator draw up okay by itself?  This is nothing more that a wild a## guess (wag) but could the feature class be corrupted some how?  Could there any empty geometry records?  Perhaps you could run the Check Geometry tool to find out. Good Luck- ... View more

The only thing I can suggest is dig into the data and see what's going on.  It doesn't matter if it's 0,1,2 or B,F,T; you may need to split the streets and code them as needed.  Anything in Network Analysis is data-intensive and data-sensitive.  One of the short comings of the national brand data sets is they are one size fits all.  Until you find out it doesn't fit you! Good luck ... View more

I'm not familiar with Navetech data but in the network datasets I've built I use a oneway attribute that has a coded domain of 0,1,2 with o being the default value. A value of 0 allows no restiction. A value of 1 restricts direction of travel to the direction of the line: from node to node. A value of 2 restricts the direction of travel opposite of the line: to node from node. Perhaps you could use a similar approach in your application. ... View more

Ruth is absolutely correct: you don't have to ditch excel but you may want to. If you search for excel in this forum, you're going to find a whole lot more 'problems with excel' over 'I love excel so much' threads. Don't get me wrong; excel is a very good product and a convenient tool to use in some cases. I just prefer to perform GIS analyses with true data base tools. ... View more

I am using a parcel layer as the reference data for building an address locator.  The address locator builds without errors but does not return any matches when I use it to geocode a table of addresses.  I do not have good documentation on the process, so maybe I am just missing a step.  I am using ArcMap 10.  The parcels layer has individual fields for house number, street name, and street type.  The address table is in Excel and I have used text to columns to create individual fields identical to the parcels layer.  Where am I going wrong? First, ditch excel; import that data into a table in a geodatabase.  Be sure that none of your field names have spaces or other special characters in them. Excel is famous for these.  Instead of 'exploding' your table of addresses, leave them in the form of '1234 S MAIN ST'  Make sure your have pointed to the correct individual fields in your reference table. ... View more

File corruption can happen.  (I had a client lose a 9TB RDBMS instance when a mirroring backup process failed to detect filesystem corruption and overwrote the last successful backup with random garbage -- two weeks later they had to restart a 15 week load procedure from CD and DVD media). - V OUCH!  That's a real bummer... ... View more

Hello, My apologies in advance if I'm getting the terminology wrong or missing something obvious. I'm interested in assessing how well a facility is situated within its service district by getting a rough calculation of a proxy for the potential cost of transportation to that facility (in my project, facilities = schools and service area = school districts) I know how to calculate, given a distance, a service area for each facility; I'm interested in reversing the inputs.  Is there a way to calculate the distance required to cover a service area, given the facility's location and its polygonal service district? If I were to neglect the road network, I would try to find a way calculate the "average" distance from all points in each polygon to the facility location (using integrals?), but I don't know how to do that either. Thanks in advance for any help you may be able to provide, Dub Have you tried drawing lines instead of polygons for a service district?  There may be a way to truncate them at the edge of the district ploygon. Not sure how 'neglecting' the network in a  Network Analysis application would work for you... ... View more

I created an address locator based on a shapefile of roads for a county. I created my table in excel (.xlsx). Checked and rechecked column headers and address formats. when I try to geocode the addresses it tells me "000006 : Could not open the address table." help? What version of ArcGis are you using. I don't think 9.3.1 and earlier will open xlsx files. If Im wrong about that, make super sure you have no spaces or special characters on you field names. Null values somewhere might toss you a curve as well. ... View more

A suggestion; typically you can click on the error for a hyperlink with 'details ' of the error. I use the the word details quite liberally here. The next suggestion would be to bundle up your data and contact tec support. It maybetough this week with the UC running. ... View more

All this can be done with network analyst, but you'll need to take some time to learn how to use the extension.  There is an ESRI tutorial available and you can search the on line help for specific information. ... View more

You'll probably get more and better answers in the appropriate forum: Geoprocessing or Spatial Analyst. From your post, I'll toss out an uneducated guess; are you using the getcellvalue on a raster that isn't a multiband (aka an image)?  If so, my guess is you'll need to be licensed for the spatial analyst extension. ... View more

I currently have a problem getting the desired result out of network analyst. The project: I'm doing an network analysis of the interstate system in the state of michigan to determine the number of exits 20 miles upstream and downstream of each rest area in the state. I have a network dataset built for the roads, and shapefiles for rest area and exit locations. Currently I'm using closest facility to determine which exits are near the rest areas (within 20 miles). My problem is that I cannot get network analyst to only look at the road that the facility is on. For example: I have a facility located on I-75 in Detroit. When I run the closest facility analysis, it finds routes 20 miles upstream and downstream on I-75, and every other route on the network within the 20 mile allowance (I-94, m-10, I-96..etc). Is there an easy way to write a script or use restrictions to keep the analysis on the road the facility is on? Any help is appreciated. -Adam Why not build a network based on just those segments that are I-75?  Select from your full feature class RoadName (or what ever) = I-75.  Then do a spatial selection for roads the intersect the select I-75 segments.  that ought to get you your ramps and rest areas.  If you get any extras, like over passes, just unselect them.  Export the ones you keep to a feature class and build your I-75 network. ... View more

Are you sure it's a geodatabase?  What flavor?  When you say it shows up in windows explorer, what does it show up as: a microsoft access file (mdb) or a directory (gdb)? A personal geodatabase is an access database on steroids and it carries the extension of .mdb.  Nothing more, nothing less.  Just an access database with a bunch of extra tables built in so it works geographically. A file geodatabase is a proprietary database by ESRI and it carries the extention of .gdb; it will show up in windows explorer as a directory with a bunch of meaningless files inside it when you expand the directory. ... View more

The network dataset came from a shapefile that was cropped out of the streetmap_na data that came with ArcGIS.  The setting are Facilities to find: 5 Travel From: Incident to Facility Allow U Turns:  Everywhere Output Shape Type: True Shape Are you sure you want to rout from incident to facility and not faclity to incident? ... View more

Dear Alan, Thank you for your explanation, it definitely helped me understand the situation a bit more. However, I still do not understand why I have to use the Integrate tool to my features before generating my network dataset. Even if I set a higher tolerace (like 0.002) to my original dataset and then generate the network dataset, there are no connections. Even if the nodes are only 0.001 m away from the edges. Shouldn't it work without using the integrate tool? Kind regards, Eleni Eleni; the integrate tool actually moves feature elements (vetexes in you case) to become absolutely coincident with others found within the snapping tolerence.  Is it possible for you to post a portion of your data with known inconsistencies here on the forum?  I would be happy to execute the integrate tool upon those features to see if I can recreate the issue you are having. ... View more