Latest Contributions by JoeBorgione

I may have stated that wrong....I am actually trying to get the Zip4 codes....all of the records have 0000 at the end of them. Well.... Good luck with that.  Have you tried a local agency or the USPS for the information you are looking for?  The  geocoding process doesn't automagically generate data; it works against existing data and 'simply' changes an address that you and I understand to an x,y pair of coordinates that the GIS understands... ... View more

I am trying to generate Zip4 postal codes from an address list.  I have the address which is currently in this format      Address                 City                State               ZIP 111 Camp Rd       Pensacola          FLORIDA        325040000 I have tried using the ZIP+4 address locator when geocoding but I only get xy coordinates and no ZIP+4 are generated. Is there a certain process to this or do I need business analyst. I currently just have home single use license. Looks like you have the zip+4 data in your zip field: you should be able to extract the last four digits/characters with vba: You can add a couple of fields called ZIP1 and ZIP2, where ZIP1 is the first 5 characters and and ZIP2 is your zip+4. In the field calculator calc ZIP1 = left([zip],5) In the field calculator calc ZIP2 = right([zip],4) Is that what you want to do? ... View more

Not sure what you mean by hot or cold;  I have a SQL Server back end and run a back up there nightly. ... View more

Hello, I have a large list (over 6,000) of points in which some of the lat/long fields are blank, and some are in State Plane that need to be converted to lat/long. I am trying to determine the best and most efficient workflow to complete this project. Any input or ideas would be greatly helpful. I am trying to compile a list of all the resources I have at my disposal, the best one will most likely be a dataviewer which will provide aerial photos of each point. Thanks in advance! I typically stay away from terms like best and most effecient. But that said... Back up your orginal file. If you have no xy coordinate data for some, that is no lat long and no State plane, toss them.  No need to worry about them unless your Harry Potter wand is working. (Did I mention to back up your original file?) Split out those that have state plane coordinates into thier own table.  Add these to an ArcMap session as an XY event.  Save them as a point feature class.  In that new point feature class, add two fields as double: Latitude and Logitude.  Use the calculate geometry function to calc the X and Y values of the point in the flavor of latitude/longitude of your liking. (You have a back up copy of the original file right?) Merge those records back into the list of just Lat Long populated data. Hope this works. If it dosen't, you still have the backed up copy of the original file.... ... View more

Try joining your summary table to your geocoding results attribute table. ... View more

I use a Spillman toolbar to produce outfiles for the Dispatch Center.  I recently upgraded my old computer from ARCGIS 9.3.1 to ARCGIS 10.0 and updated my toolbar as well.  There are a couple of tools on the toolbar that are not working: 1. Auto populate fields from zones - after running this tool, there are 600 or so lines that do not show the city code in the field for Rcitycd. 2. Create Zones  -  This tool is supposed to create a mastervalues.dbf and a tbzones.dbf, which it does, but both of these tables are empty except for the column names.  I am wondering if anyone else in the ESRI community produces outfiles for Spillman using the ARCGIS 10.0 add in toolbar?  If so, have you experienced any of the above problems?  If so, what do you suggest I do?  At this point, I am thinking of backloading 9.3.1 to produce the out files. Thanks in advance for any help/advice. Call Spillman Tech Support; my guess is you have a wrong or bad build for the toolbar.  I just ran outfiles the other day, but I don't use the functions you mention: My streets have city codes and I keep a mastervalues and tbzones tables on hand... ... View more

Just a WAG (wild *** guess) but I think a restriction would be the way to go.  Think of it this way; if you add a cost all that does is give the solver a reason to minimize the cost.  But what if it can't?  Lets say a route for a vehicle is restricted due to barriers of some sort.  It would then route under/over the bridge in question just because it could.  The cost is what it is.  But the real problem is you routed a truck over a bridge that can't support it's weight or under one that isn't tall enough for the load to pass.  Ouch... A restriction like XXX,XXX lbs or XX feet would ensure you from what I like to call a 'resume generating event'... ... View more

Sorry- don't know the answer to that; I'm a roll-yer-own kinda guy and use my oown data for my analyses... edited a moment later; That data is on the media discs I think... ... View more

I am a PhD student and my project involves supply chain analysis in Montana. I want to use Network Analyst to analyze routes from logging operations and mill sites to potential conversion facilities and to refineries. My input road file is massive, and I got it from the Montana GIS website. I have been cleaning it up using the Topology toolbar, but there are still a lot of bugs. My questions: 1. Is this the best input road file to use, or can I download and use an ESRI road file? 2. I created a network dataset with the file and ran the "stops" to see if it would give me an optimized route between two points, and it created the most convoluted path I've ever seen. I could really use some pointers on how to set up the Impedances, and any other tips you have. Thanks! natalie m. route[ATTACH=CONFIG]18850[/ATTACH] You can try the ESRI data and see if it takes less clean up.  Take a look at the online help. There is a tutorial in there as well. I'm leaving the tips and pointers out; unless you want me on your committee!  :cool: ... View more

If it were me, I'd do one of two things: (1)delete the offending polygon, or (2)merge it into the surrounding polygon, or (3) delete each of the vertices of the offending polygon... ... View more

I wouldn't bother turning them into lines; in an edit session just right click on the offending vertices and delete them. ... View more

Having a regular back up schedule is an essential element of any enterprise database system.... ... View more

This sounds something like the Chinese Postman problem that as far I as I know is not supported in NA.  Perhaps Jay S or one of the Network Analyst developers can chime in on this one. ... View more

We have a Default version and a child version. One of my colleague had deleted a feature class from Child version. Is it possible to retrieve the deleted feature class to the child version. I'm confused with your terminology: Typically DEFAULT refers to a versioned database.  All versions are contained within the same data base.  All subsequent versions have a relationship back to default.  If you choose to reconcile and post any changes made to a specific version, you do so with respect to the version from which it was spawned. Typically, CHILD refers to a replicated database.  Replication is between TWO separate databases. The relationship between a child and its parent can be one or two way.  In a one way replication scenario, changes can only go one way: from either parent to child or child to parent.  In a two way scenario, changes made to the parent can be syncronized to the child and/or changes to the child can be syncronized to the parent. If you delete a version, default is secure.  If you delete a child, the parent is secure.  You stand to lose an changes however that were not reconciled and posted or syncronized respectively. ... View more

Short answer; right click on the field of choice and select summarize. Longer answer(s): here and here ... View more