Latest Contributions by JoeBorgione

Hello Everyone, ArcGIS 10 SP5 - SQL Server 2008 We have an address locator built off of our street centerline feature class. Some of our street segments will have an address range on one side of 0-0. This occurs along our divided highways / streets. Our problem is that any address along the entirety of the street (any segment) will be geocoded against the segment that has a range of 0-0. For example, we search for 902 Church St. The geocoder first two results are for the divided section of road, block 1400 Church St. Hard to explain so I attached two images. One details the error and the other displays the settings for our address locator. Thanks, Shaun And even harder to understand;  To me your illustration shows two segements; one has a range of 0-1414 and the other 0-1411.  902 falls well within that range. Check your street data, and be sure your 0 - 0 ranges are on one side or the other. ... View more

When you unregister a replica, be sure to do it on both ends; you need to 'cut the cord' between parent and child on the parent end and the local/ child end as well. ... View more

The problem you are trying to solve is know as the Chinese Mailman Problem; I can't remember why it's called that, but I do know that at this time, ArcGIS Network Analyst is not able to provide a solution. You might look at the Traveling Salesman Problem (TSP) as your approach.  You would need to have a point file for each address on your route. My guess is Jay or Patrick with ESRI will spot this thread on their radar screen and be able to offer better details.... ... View more

Shawna-  I'm using version 10.0 but.....  I use the locators provide in 9.3.1; that may be the difference. That blog post is pretty cool; almost makes the process interesting.  I don't know how large in terms of centerlines your area of operations is, but you might try just test section to see how it goes. ... View more

You might try creating a point feature class of your intersections and then name the point (keyfield) the intersection without spaces.  Then you could have your street based locator and a point based locator in one composite locator. (If this seems horribly tedious and time consuming, it's because it probably would be.) edited moments later....  I just tried leaving out the spaces between my intersection symbol and it works for me.  What does not work is when I leave off pre-dir, suf-dir or street-type of either or both of the streets of the streets; this is just using the interactive geocoding toolbar, not a list. ... View more

Hi Joe, I liked your response to this question and am wondering if you can explain to me what are the benefits to using a file geodatabase as opposed to just using shape files in an .mxd.  I will explain, I am creating maps for oil and gas companies, the data I receive is not represented well so I pull it and create my own shape file (Pipelines.shp) this way I can move the lines slightly so they are better displayed on the map and I also add more attribute data.  Would it be better if I had this and the other data in a file geodatabase? Holly Holly- Shapefiles first hit the scene sometime in the mid to late 90's, and they were all that and a bag of chips.  That was then.  This is now.  You can still use them; I do occasionally to email feature classes. A file geodatabase acts as a container for your data.  Since it's the native data format for ArcGIS, it's optimized for robustness and speed.  A feature class in a geodatabase also provides a way establish topological relationships, network analysis and other gis analyses. If I'm working on a particular project I like to create a geodatabase just for that project and add the appropriate feature classes.  Everything in one place.  My mxd points to one data source.  Simple. Easy. Here is a link to another thread that discusses this same topic.  Derick and Vince from ESRI two of the top guys if terms of geodatabase knowledge and skills on this forum.  When they talk, I listen, and they have helped me out of a jam more than once. ... View more

Thanks for the link and vid Marco! ... View more

Thanks much, Joe. I have a shape file for zip codes (Tiger shapfiles), so do I need to add that as a layer on my map first?  I was tasked with geocoding this excel list of zip codes (I suppose, basically getting X,Y coordinates and mapping out).  I tried geocoding to the .pri coordinate file within the Tiger shapefile but got no matches. You need to create a locator using your Tiger data.  Refer to the links provided above and see if you can figure it out.  You'll get more out of it doing it that way.  I could give you all the answers but where is the fun in that? ... View more

I am in charge of a GIS project for an internship I am doing this summer. I have taken a few GIS classes but by no means am I an expert, and no one in the office knows much about GIS. I have to map the locations of their projects, most of which have been in Colorado. I have the specific addresses for most of the projects as well as the counties. What would be the best way to go about this? I have added the USA state boundaries and the USA counties layers, but I am having difficulty joining the excel sheet with the information about the projects to the county layer. Using the specific address would be a better representation of the projects, but I don't know how to do that from scratch. Any tips would be greatly appreciated! Thanks! See this thread I recently responded to.  You need to get some data to geocode against; in the other thread the guy only has zip codes.  You've got addresses. You should be able to find good street data to match against in Colorado. There are a ton of good people doing tons more good work there.  I just googled 'gis data colorado download' and hit the jackpot... [Looks like Lucas beat me to it; two for two though... Geocoding is what you want to do...] ... View more

Hi all, I have a dataset with only zip codes.  I'm trying to geocode but cannot find a coordinate system that will allow me to match to a zip code-level. I see Tom Tom has something, not sure if it's a coordinate system, allowing users to do this, but I do not have access to those files (see attached screen shot). [ATTACH=CONFIG]25339[/ATTACH] Can anyone recommend a solution to geocoding to zip-only level and allowing me to match? Thanks I see this is your first post, so if I may...  This dataset of zip codes; is it a polygon or point feature class/shapefile or is it a list of zip codes? At a very elementary level, the process of geocoding is a method of translation by which we translate a string of text (typically an address) that we humans understand into a pair of x,y coordinates the GIS understands.  That way we can visualize the location of our address on a map. You really don't geocode against a coordinate system.  You geocode or match against a spatial data feature class.  The coordinate system is embedded within your spatial data feature class. I'm just guessing here, but I think what you have is a list of zip-codes and you would like to map them out.  Consequently, you'll need to find either a polygon feature class or point feature class of zip codes to match your list against.  You may want to start here to get an idea of what is ahead of you.  I'm not sure if the ESRI data cd has zip code information or not.  You might google or bing or whatever the term 'zip code ploygons.  I just did and found a good hit here. ... View more

ArcGIS Server ... View more

It's a file geodatabase. I have access to the drive where the geodatabase is. But there might have been some folder restructuring that I was unaware of. Would this cause problems? 'Folder restructuring' might be translated to 'the network guys tinkered around with stuff and didn't bother to tell anyone'..... I'm sticking with a permission issue as the primary cause, only because I've had fits and fights with them in the past.  First with login changes, then with SAN changes, blah blah blah.  Can you 'see' the database in ArcCatalog? If so, perhaps you can upgrade the database to 10.1 and see if that does it.  I know that 10.1 is supposed to see 10.0 data, but.... ... View more

Bad union...  I thought maybe this was an anti-labor thread... All seriousness aside, I suggest that you create an empty feature class of the same geometry type of the features you wish to combine.  Create the attribute table as you see fit. Then use the simple data loader to add each of the feature classes into your 'master' feature class. Others may suggest append or merge; that's cool but I really like the simple data loader the best. Hope this helps- ... View more

Hi, I created a gdb last summer using ArcGIS 10.0. I'm just now trying to copy that gdb to a different location on our server, and when I try to connect, it gives me the error "Failed to connect to database." I thought this was a copying issue, but when I go back to the original gdb I get the same error. I had made multiple backup copies of the gdb at the time and they all produce the same error as well. We're now using ArcGIS 10.1 so is this maybe the issue? Is there a way to connect to these geodatabases again? Any info would be useful. Thanks! Perhaps you could provide a little more info like is this an SDE database?  If so what flavor? Are you using a client connect or a direct connect? Is it a file geodatabase?  Have you checked that your login has read access to the drive where the database resides? ... View more

Now that you have the demand points mapped sufficiently, take the next step and use network analysis to work the vehicle routing... ... View more