Latest Contributions by JoeBorgione

Hmmm.... Given you posted this to the network analyst forum, and what you describe is a classic network problem, naturally I assumed there was a network involved.  My bad. ... View more

Say I have a Feature Class and a Stand alone table set up with a Relationship Class Say this is an inspection based Feature CLass....Say hydrants.  I inspect these locations once a year. I have the relationship class there to hold the historical records of the inspections over time. How do I add records to the related table?  If I add a record it creates a New Record in the Hydrant table...but how do I apply edits nand new records to the related table to house the historical records? Can I edit the historical table in ArcMap? ArcGIS online?  THanks Sounds like you have a two-way communication relationship or composite relationship: that is, a record in the table must have a record (feature) in the feature class.  It also sounds like you don't want that.  My guess is what you really want is a relationship that creates a record in your table IF/WHEN you add a fire hydrant to your feature class, right? If so, you need to redefine your relationship class.  Once you get that straightened out, using a relationship class (or just a simple relate) is a really cool way to manage your data.  When you select a feature that is related to the table, you can add or edit records that are subsequently selected in the table through the relationship. ... View more

Hi, so i have created within a polygon 20 sample points, now i have been asked to find the best path to start and finish at the same point location. so doing a loop and covering all points. any ideas? cheers Matt Let me make sure I have this straight:  leave point A and visit points 1-20 once and then return to point A.  If that's correct, you are modeling the Traveling Salesman Problem (TSP).  Take a look here for starters:  http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//004700000053000000 and then on to here:  http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Route_analysis/004700000045000000/ That ought to answer you question. ... View more

This raised 3 questions,  First how do I get access to the 9.x locators, next why wouldn't you use the 10.x locators.  Would this work on your station IF you used the 10.x locator? 1.  They are in your 9.x install disc.  I simply saved mine and then installed them after the 10.0 migration. 2.  I use third party software that requires them. 3.  Sounds like you've already answered that; this is odd behavior for sure. Starting with 10.1 sp1, ESRI is pretty much forcing everyone to use their world geocode service, which is a $FEE$, not free, based service that requires an online subscription.  Its designed to eat up your credits, if you have any. Prior to that you could use any one of the free online locators happily at no cost. In theory you should be able to still create your own address locator if you have high quality street data, however that seems to be getting harder as well.  I have the streetmap data and am not easily figuring it out. I'm not aware of an ESRI conspiracy to force anyone to use their online services, and in the business I'm in (9-1-1 dispatch), my clients,the public in public safety insist on the highest quality data available as well as the most reliable service.  One of the dispatchers I worked with thought we should use Google Map for dispatch instead of what I provide .  I told him he could use Google Map to dispatch to his mothers house, but I wanted him to use my data if my Wife or sons called 9-1-1. (BTW, that guy doesn't dispatch any more.... Now he's a cop....) None the less, depending on your needs and your area of operation, there is a lot of good data out there to geocode against. ... View more

Interesting.  I see you are using 9.x.  I'm using 10.1.  US street dual range.  Not sure why this would cause a problem but I can't get mine to work. Thanks for trying. I'm actually using 10.0 but I use the 9.3 locators.  Try a us streets type; I've never quite understood what a dual range is good for, at least in my area of operations.  Good luck. ... View more

I've attached a zip file that contains a small street file and a list of addresses.  I can't get the geocoding to work.  Not sure why.  I'd appreciate some help. Brian I just downloaded your data and created a us streets locator.  All five addresses hit at 100%.  Without a few more details I can't be more specific for you... ... View more

Dear All, Can you help me to calculate the euclidean distance. Whats the file we use as input. thanks in advance There was this guy... Pythagoras... He was always drawing lines and triangles and messing around with mathematical formulas on a piece of slate with charcoal.  I don't think he has a YouTube channel, but he may have a FaceBook page... ... View more

1. If feature class added to the enterprise geodatabase then it is not added to the replica when synchronize That is correct: there is a way to add other features to an exisiting replica, but the method escpes me.  Personally, I create individual replicas for each feature class I replicate.  It keeps things separate if the process goes south. 2. If a field is added to a feature class in the enterprise geodatabase then this field is not added to its feature class in the replica Correct again:  That's actually a pretty cool feature of replication.  The parent/child feature class can have different attributes and only share a set of core attributes.  I manage an enterprise database of streets: each of the clients (various cities) have thier own specific needs and uses for the data. I use it for 9-1-1 dispatch.  So I don't care what type of paint a city uses to to stripe the roads, or when that paint was applied.  On the other hand, they have no need for for dispatch zones etc that I use.  But, we all need address ranges, names, prefixes suffixes, typest etc. But originally, why do I need to create replica? Beats me.  What are you trying to accomplish?  I like to use one way replication for what you mention below.  I only edit the parent/SDE feature class and then replicatate to a FGDB which is tapped for publishing. I publish the data from the replica (file geodatabase) but not from the enterprise geodatabase to gain some performance. If the data is published directly from the enterprise geodatabase then accessing the published data (services) gets quite slow. I suggest you DELETE the published service and then try to delete the FGDB associated with it. ... View more

jborgion, I am having the same problem.  What can I do to clean up my data? I have already removed leading and trailing spaces by using Excel's TRIM function. My data has hyphens and pound signs and who knows what else in the address field. Is there a canonical list of characters to be avoided? I am thinking about writing a Python script to pull out addresses with special characters, but I don't know what ones are critical. Is there a better way to do it? Thanks, Typically a space at the end and trailing space aren't game changers.  Personally, I don't like any special characters in any addresses that I process.  You might write some kind of [split] function on those addresses with hypens and pound signs: that way you can preserve the original data, and extract the true address out of the list/array like 1234 S Main St #5B  becomes 1234 S Main St 4321 S Main St - Apt1  becomes 4321 S Main St or whatever... ... View more

It's string.... Hmmmm.  That's really weird.  But you know that already!  What about other values; can you calculate something other than "" successfully?  Do you have any domains set?  That shouldn't matter... Sorry, more questions than answers...  This is a head scratcher.... ... View more

Does anyone know how to calculate a field to completely blank (not null or 0)? Seems really simple but I couldn't figure it out and Google didn't help. Thanks!! Is it a numeric field?  I don't it's possible to have a blank field value. ... View more

Have to ask: do you have a Network Analyst License for ArcGIS Server?  If yes, I'm sure one of the Silverlight fans can provide the info.  If no, you are out of luck with Silverlight or any other web bsed app. ... View more

How to copy network dataset to ArcSDE SQL backend? Copy and paste doesnt work. I don't like having feature datasets within SDE geodatabases: see this discussion.  Feature datasets have a tendency to misbehave in SDE. However, if you absolutely, positively, gotta do it, you should probably copy the entire feature dataset in which the network resides while in an ArcCatalog session.  (But don't say I didn't warn you...) ... View more

Hello guys, I have to analyse traffic accident data in order to investigate the density of such point events. A standard (planar) Kernel Density Estimation (KDE) aims to produce a smooth density surface of spatial point events over a 2-D geographic space. However, the planar KDE may not be suited for analysis point events, which usually occur inside a linear space. Does anyone have suggestion how to analyze traffic acciden data and detect hot spot using ArcGIS tools? Thanks! And linear space isn't 2-d?  I guess you could perform a spatial join or a nearest analysis where your streets could assume the values of your point attributes.  You might need to do a few summaries here and there as well as a relationhip class or two, but you should be able map the street segments by numbers of accidents for a given segment. ... View more