Latest Contributions by JoeBorgione

Hello, I am trying to geocode a table of addresses which contain many duplicates.  This list of addresses is a list of emergency incidents over a period of time, and I would like the symbology to represent the number of times each address requested service.  Is there a way to do this within the geocoding process or do I have to separately sort/count the incidents and map them as quantities in symbology? Currently I get one geocoded point for an address that has 20+ representations in the dataset. I'd like to be able to weight that point more heavily so a person viewing the data can tell the difference between an address that requested service once vs. an address that had multiple requests. Thanks! I think you'll want to do it before or after the actual geocoding process;  what I suggest is creating a summary table.  If you do it before the geocoding process, you'll only geocode a percentage of the overall incidents.  If you summarize it after wards, obviously you'll geocode them all. You could then symbolize them using the count attribute in the summary table. ... View more

If you are working with some flavor of SDE, you can create a trigger that gets pulled when the delta table gets updated; this trigger updates the field.  With incremental numbers it gets a little tricky, but I've seen posts that discuss it. ... View more

When you create the network dataset, what connectivity model did you choose: End Point or Any Vertex? If it is End Point, then you will not get the node to connect to a middle of an edge as shown in your picture. In that case, switch to Any Vertex and re-build your network. Regards, Jay Sandhu Jay-  as many of my posts indicate, I'm not a fan of 'Any Vertex' connectivity.  But there has to be a reason that this option is available: When is Any Vertex connectivity advantageous to End Point connectivity? All the best- ... View more

I have never used network analyst before and need some help. I am running Arcmap 9.3. I can upgrade to 10, just too lazy to do so. Here is the problem that has been presented to me.           We have 20 offices located in North Eastern US.   We want to hire two people to work out of two of these offices.  These two employees will visit the other offices on a regular basis via motor vechicle.  Flying is not an option. I need to calulate which two office locations will result in the fewest amount of driving to the other 18. I can come up with a point coverage of office locations as well as a road coverage but beyond that I have no idea how to use the network analyst tool set to solve this problem. ANy help would be greatly appreciated. Gino Luzader First thing I recomend is visit this link and work through the tutorial listed therein.  After that start small and work your way into the full blown application of NA on your problem.  Along the way, let us know how you are doing or post some specific questions or problems you run into. [edited moments later] Here is a link to a forum posting below as well.... Good luck- ... View more

I knew all I would have to do was post the question and I would stumble into the answer. My problem was the 'Connectivity Policy' When I changed it from End to Any Vertex, then the other roads became available to the solution. The clue was when I realized the routes only worked if they were connected at the ends, not in the middle. Be careful with vertex connectivity; you may find yourself touting from an over pass to the freeway below.... ... View more

We are running reports out of the database and trying to find a way to sort by Lat\Long in SQL.  Has anyone come across a way to tackle this issue?  We don't want to maintain a field only for the purpose of ordering records. Would this work? Ordering by two columns. This query first sorts in ascending order by the FirstName column, then sorts in descending order by the LastName column. Copy SELECT LastName, FirstName FROM Person.Person WHERE LastName LIKE 'R%' ORDER BY FirstName ASC, LastName DESC ; Found it at a microsoft site after a google search.... ... View more

Using the closest facility tool, I've noticed that when I try to figure out the shortest distance between two nodes there are some discrepancies.  Case in point, I'm trying to connect nodes to several transit locations - trying to see which routes are closest to transit in the surrounding communities.  I have 10 transit stations (Facilities) and about 700 nodes (Incidents).  Some Incidents are not being routed to the closest Facility.  There's no hierarchy in my network dataset, it's just a bare bones one (just using TIGER files in which I ensured its topological accuracy and checked for dangling nodes).  Any thoughts would be greatly appreciated!  It's only happening a few times out of hundreds so it's not terrible but still a little puzzling. I'm just curious as to how you are sure that "Some Incidents are not being routed to the closest Facility" ?  What criteria are basing your solver upon? Distance only?  What are the units of your data and what are your units of distance that you are solving for? If you are only seeing it in a few cases, you might isolate those cases and see if you do in fact have connectivity along the route you think it should be taking.  What I've done in cases like this is manually place stops along the route I like and see if it will solve along the way. ... View more

Thanks for the help, but seeing as we're still running 9.3, I don't know if the bug fix you provided will work. I've started compiling a new composite geocoder from scratch and checking each individual locator as I go. I'll be sure to update as things progress. I've never had a problem with composites in 9.3 or 9.3.1 which is where I'm now.  If you are trying to create a composite on ArcSDE/ArcGIS Server, that won't work.  You can only have a composite in a personal or file geodatabase.  If you'd like to post some of your data here and describe the locators you are stringing together, I might be able to take a look at it.  Misery loves company right?  That way if if bails out for both of us, two sets of eyes may be better than just one. ... View more

Try the following thread.  About half way down (posted on 2/09/11) I give a workaround to a bug that will be fixed at 10.0 SP3. http://forums.arcgis.com/threads/22064-New-geocoding-engine-is-terrible Brad That's the one I was thinking of! ... View more

Currently I am trying to build a composite geocoder so that I do not have to run multiple locators and export .dbf tables of unmatched addresses for each. When I create the composite, the first (and most effective) locator does not work (does not produce any results). However, when I run them all individually, and in the same order as were specified in the composite, there is no issue. All I am trying to do is expedite the process as there are a lot of datasets that need geocoding. Any ideas on why the composite will not work when the individuals will? Any help or input is appreciated. Thanks! Seems like there was a post not long ago on this very subject. Try a search and see what turns up; I'm pretty sure it was in the last 3-4 months. ... View more

See my reply to your other post... ... View more

To your suggestion "Place impedance values on them like low speed limits". How would you do that? By creating a new cost attribute? How would you then set the evaluators? Thank you so much I'm sorry, I don't have the time and this forum dosen't have the space for a complete description of Network Analysis.  Assuming you are using ArcGIS 10.x may I suggest you start here, and if you are using 9.3, take a look here. There are a couple of tutorials out there too: just google network analyst tutorial and you'll find them. Typically, the street centerline data I use in the network have various attributes that I can use in NA.  For example SpeedLimit.  With it you can do a calculation with the segment length to derive a 'cost' of travel time needed to traverse any given street segment.  In my case, I keep freeways at 65 mph; it sounds like you may want to knock them down to 1 mph, thus making traversing the freeway segments unattractive to the solver if travel time is to be minimized. ... View more

Hi I would like to avoid highways or main roads when doing "best route analysis" (impedance: shortest route). What is the best and easiest way to implement this restriction? Thanks The best and easiest way is what works for you.  A couple of suggestions: Create a network feature dataset WITHOUT your highways and main roads Place barriers on each  (yuck) Place impedance values on them like low speed limits (if you are minimizing travel time) Hope this helps- ... View more

I have a feature class that is comprised of roads in a country. I've created a network that includes this feature class with the following relevant options: 1. Vertex connectivity (not end point). 2. No elevation modeling 3. Length as cost attribute is the only attribute 4. Global turns When I attempt to complete analysis tasks such as OD matrix or even Route, the only paths that are found are those where the points are on the same edge or on edges connected via endpoint. I've taken a good look at this and as soon as I place the next point of the route onto an edge that is joined by intersection, the error dialog pops up saying there is not path to that next point. What should I do next? What version of ArcGIS are you using? If it's 10.x, let'st hope that Jay or one of the other NA team members can help you out.  I've not taken the plunge and still using 9.3.1. Something I would suggest however is re-thinking the connectivity issue.  If your data is from a legacy ArcInfo coverage data model, you will have coincident vertexes for freeway over passes and the freeways themselves.  You'll be routing incorrectly with that situation. ... View more

That's great Joe! I too work in the Public Safety field. We're building an RMS & GIS system for some of the law enforcement agencies in Nevada - Dept of Public Safety is our pilot group and then some PDs & SOs will join. I'm excited and honestly a little overwhelmed at the idea of administering the GIS portion of it. I'm brand spankin' new to GIS, but I'm having a blast learning. 🙂 Michelle-  you've got your work cut out for you;  this forum and all the other ESRI forums are a very good resource.  I don't like it when firms use the forums for business, but if you ever feel the need, I know this guy in Utah that does nothing but GIS/9-1-1 for a living...:rolleyes: ... View more