Latest Contributions by JoeBorgione

I just have to ask; is the 'butcher' still working for you?  700 deletions....  :mad: I guess I'm lucky that I don't deal with such large numbers of edits or editors.  What comes to mind is perhaps your workflow could include comparing the individual editor-versions with the mid-level version and/or sde.default prior to reconciling and posting.  Without knowing what type of data you are working with, maybe a visual inspection is all you need, or maybe you need to get an actual count of features for each.  I use a trigger on the sql end that records the login of the person making the edit and the date of the edit; that has saved me more than once!  Backups & restores can be an administrators best friends. Not much, but I hope this helps- ... View more

Hi everybody, I am totally new to GIS. My advisor has just given me a *.mdb file and I want to open it in ArcGIS 10. Not even sure if that's the right GIS product I should use!! I have been spending like 2 hours looking for a way to open the file but haven't been able to. Could somebody let m eknow how to do that? Thanks .mdb typically indicates a Microsoft Access Data Base. In ArcGIS, one can create what is known as a personal geodatabase to store spatial data. Built into ArcGIS is the Microsoft Database Engine which allows this functionality; you do not need Access installed.  The database provided to you may or may not hold spatial data.  It might just be a generic Access database. A good place to start is here; the online help.  Click on the data management link and then the  Managing Geodatases link for geodatabase information. [edited moments after posting:  Looks like Heather with ESRI beat me to it.  Her reply must have come through as I was typing mine.  Now you've got some consitent information to follow through with.  Good luck! ] Hope this helps- ... View more

Since ArcDesktop 10 does not give us the ability to Rename a field - I had to Add Field, Calculate Field, Delete Field so I could have it  set-up the way I wanted it.             PROBLEM: When I did the Copy Features (to make a new feature class) it screwed by ObjectID Field up - which in returns screws my Attachments feature. That ObjectID needs to remain unchanged. Not sure I can solve your problem, but I might be able to shed some light on the subject... Not being able to rename a field is not new to v10.  It's been that way as long as I can remember (v4.5).  Adding a new field is the tried and true method. The objectIds are not screwed up; when you create a new feature class and copy into it, the objectIds are generated for the new feature class.  ObjectIds should be avoided as join items because of this.  What I do is add a field and call it something like....  Joinitem and calc it to equal the objectId.  That way you know you won't have any repeats. The trick is in automating the increment (joinitem +1 from the last feature/table record).  Hope this helps- ... View more

require adulterating the vendor data. I prefer massage.  Adulterating has such a ugly connotation.  I'm lucky, not only am I a data consumer, but I provide the data I consume..... ... View more

I have reference data where some street segments have L\R odd\even parity, and others have mixed parity, with odd and even on the same segment. Which kind of parity is stored on a field. Is there any way to use that information in building or applying a locator? I can think of a terrible idea: splitting the reference data by parity type and using a composite locator to connect the normal and mixed parity streets. I hope there is a better idea. Am I correct in thinking that if the street segment has 102-197 as an address range on the R side, for instance, that the geocoding engine will find 146 and 147 on the R side? We have a lot of mixed parity cul-de-sacs that are getting missed because the address range is something like R (nothing) L 1-101, mixed parity. A search of my login will reveal a number of geocoding threads discussing accuracy and precision. I'll save you the search and mention the difference here; when you geocode against a linear feature, the resulting point has an interpolated location based on the range of addresses divided by the length of the line.  For example (and this I can type from muscle memory) if you have a street that has a range of 100-200 on the even side and 101-199 onthe even side, the address of 150 will interpolate at just about mid-point on the even side.  Accurate.  However, lets say the actual location of the house with 150 painted on the curb is the last house on block towards to 200 end, and is on odd side of the street.  If you need that kind of precision you'll want to collect point data somehow and geocode against them. Many of the cul-de-sacs I deal with are mixed parity.  For my needs,  I just range the streets even and odd and go for it that way.  The way I see it, if a guy driving a fire truck can't tell which side of the street the smoke is coming from, he shouldn't be driving the truck....  I manage mixed parity on my regular street features that way; smooth them out so they have a level of accuracy.  Even if the point might land on the 'wrong' side of the street, that's a lot more accurate than no hit at all. Linear street data is relatively affordable, generally available, and easy to work with (read: fudge).  But, there are always trade offs, and precision is one of them.  Points are precise, but getting that kind of precision takes time and effort.  And those equate to $$$; US or Canadian! Ask yourself the question(s): Ultimately, how does my agency use this data?  What level of precision do we need to complete our stated mission?  If we need high precision data, do we have the time and budget to create them,or can we go with what we have, and develop the more precise data as we go? Hope this helps- ... View more

These properties will be exposed through the UI at 10.1 but for the time being, they have to be modified through the loc file. Brad That sounds really cool.... ... View more

ESRI whitepaper suggests there is a significant performance hit for using an alt name table. One of our data vendors puts all alt names as duplicate records on the primary street table. The other uses an alt name table. Performance with the alt name table seems better, but there are too many other differences to make conclusions I think. Is there a known answer to this question: better to have alt names as duplicate features in primary feature class or as alternate name table? I have used alt-names tables for a number of years and geocoded countless thousands of addresses.  I don't know the specifics of the white paper you mention, but the last thing I would like to maintain (or pay for) is double (or more) features in the primary street table.  That to me just wreaks of performance hit, if not more headaches than I'm willing to suffer through. I will admit that I have what I call anomalies streets that have the same geometry as existing streets but with local names instead of 'official' or 'official aliases'.  I use these as part of a composite locator only when I have to, and with a 55,000 + primary streets feature class, I only have maybe 200 anomalies. Recently I've been using a tool that creates an alt name of each individual word in a street name.  So, let's say you have a street called S MAIN ST.  It will create an alias of S MAIN, S, MAIN ST, MAIN, and ST.  It has the option to drop certain elements, so I don't have it create one for ST or S.  This creates a lot more aliases than I ever have in the past and I haven't noticed a hit in performance with it; these data are used for 9-1-1 dispatch.  If there is a performance hit, my phone starts ringing from 100 + dispatchers.... My thoughts are to stick with alt names. Be sure to index the join item in the primary streets as well as in the alt names table before you build your locator. Hope this helps- ... View more

HI i dont create network dataset.'''Not Licensed To create a network dataset in this database'-whats it? Do you have a valid, registered license for the Network Analyst extension?  A license for desktop network analyst is not the same as an arcgis server license. ... View more

See this thread. ... View more

How do you change the default location for the output please? See attached image; navigate your way to what ever output location you want.  Personally, I don't like to write to shapefiles, I like geodatabase feature classes. Hope this helps- ... View more

Hello everyone, I work for a organization who uses a very labor intensive routing program for school district transprotation routing.  I would like to switch over to ESRI solution using Network Analsyt.  Our district services approx 65,000 students of which about half require transportation to 67 schools.  We have a fleet of about 400+ buses.  We keep growing and have out grown our current process. I do have many off and on years of ArcGIS expeirience but mostly on single workstation. I guess my beginning questions would be on reccomended reference materials so I can approach this the right way.  I will have to create a test network to demonstrate the capability and advantages of a geodatabase  to support not only the Transportation group but other divisions within the district. I would appreciate any advice from current users of the best approach I should take.  Since I'm starting from scratch I would like to stay on tract. Thanks in advance for your time Jeff Jeff-  big task! Start here... Good luck! ... View more

Keep in mind also at version 10.1 there will be a 'Create Enterprise Geodatabase' tool for this operation as well instead of running through a complete Post Installation Wizard. "The Create Enterprise Geodatabase tool creates a database, storage locations, and a database user to be used as the geodatabase administrator and owner of the geodatabase depending on the database management system (DBMS) used. It grants the geodatabase administrator privileges required to create a geodatabase, then creates a geodatabase in the database. " Hmmmmm.... If it sounds to good to be true.....  All seriousness aside, I'll be real interested to see this.  My last update from 9.3.1 to 10.0 was a real pain in the backside with permissions, schemas, sde in sysadmin group, blah, blah blah.... ... View more

I just googled Candadian Postal codes since I know nothing of them.  Looking at wikipedia, it seems to me that the code is made up of two components; forward sortation area and local delivery unit; is that correct?  I may be oversimplifying this so please, be gentle, but can't that code be used as we use zip codes here in states or do the US Address-Zip types require the zip to be numeric?  For my geocoding I can avoid using zip codes so I'm not sure... edited a few mintues later; after searching the forums, I have over simplified the problem.  The thread between Harry and Brad earlier this month suggests ESRI Cananda for help... ... View more

Take a look at the spatial adjustment tool bar. ... View more