Latest Contributions by JoeBorgione

Hi jborgion! Do you happen to know if there's a way to create geometric intersections of street features where they don't currently exist? For example, say I want to geocode something to the point where Main St passes over I-80. I would need that to be considered an intersection in order to retrieve a match when geocoding "I-80 & Main St". Any advice would be greatly appreciated! Amy Amy-  personally I think you are looking for trouble but yes it can be done; I actually found an old (very old, like 9 years) post of mine here.  This is a link to the current Planarize Lines tool. So why don't I like the idea?  As GIS practitioners our job is to model features in geographic space as closely as we can to the real-world.  Quite frankly, Main and I-80 DON'T intersect.  Creating such an intersection compromises the data integrity.  😞 You may be geocoding against these features today, and next week your boss says 'Hey, whats this thing I read about called Network Analysis?'  All of the sudden you are scrambling because your routes include the Main St overpass to I-80 connectivity. (Boss: 'Amy!  How the h-e-double-hockey-stick did that delivery truck just drop 75 feet from Main to I-80?')  :mad: Also, consider that you've spent all this time getting your address ranges just the way you want them.  You planarize the streets and instead of having one continuous line segment of Main St with a range of 100-500, you have TWO; each with the exact same range.  Ouch.  Back to (re)editing ranges!  😛 Depending on the number of non-intersections you are dealing with, you might consider creating a point feature class to depict them.  My guess is you'll thank me in the morning!  :rolleyes: Hope this helps- ... View more

Echo what Vince said... So when you check out the properties of a given feature class, you are not given the path to the geodatabase as shown in my image above?  Seems odd, but it might be because he saved his mxd without storing the relative paths to the data(Total WAG; wild a** guess). Can you post a screen capture as I did so we can see shat you are seeing. ... View more

Are you sure you flipped the lines? Have you verified the edits were saved?  Any chance you can post a subset of your streets?  And  some of your addresses you need matched?  Sounds like an interesting project; I would be happy to provide an extra set of eyes. That may be all you need. ... View more

Hi folks, a former colleague (who is not available at the moment) handed my over his old GIS Pooject. He processed his data using a Geodatabase. I want to rebuild his project but unfortunately for each layer type (like a DEM or a landuse layer) I found several versions and I don't know which one he was using in first place. I tried to figure it out by taking a closer look at the layer attributes which were related to the Geodatabase but I didn't find the source. When I look at "Source" it tells me that the Geodatabase itself is the source, but I want to know where the layer itself is stored. How can I tell from a Geodatabase where the layers were stored (or are stored) before they were related to a Geodatabase? Thanks for reading and best regards Scholtes If he saved the mxds the source data should give you the specific feature class name.  See my attached image.  I don't understand your question:  How can I tell from a Geodatabase where the layers were stored (or are stored) before they were related to a Geodatabase?  It would be impossible to tell where the origin of the data is if he transferred them into a geodatabase from some other source. I would study the geodatabase contents that you have available to you and make a determination which is the most current. ... View more

I am a newcomer to Network Analyst.  I need to select streets within a 5 mi. driving distance of the fire station to prepare a coverage polygon.  What is the best way to do this selection? You might make a search on service area analysis here on this forum; there are a number of posts.  You can also start here.  Or check out the tutorial.  What you want to do is bread and butter network Analysis. Hope this helps ... View more

Nothing like an error message to sink your teeth into.... Check your table; somewhere in there I bet you have a null value or an empty value or something along those lines. ... View more

....I'm no DBA and this might be an idea from the chamber of horrors for DBAs. Regards I like that... A lot!   😉 ... View more

Will you be able to elaborate on # 3 please? As we tried to create a locator (from SDE point file) using US street style and having "combinedAddress" as primary address field. But no luck so far. Also, Do all ESRI based Geocode services have [Zip code] a mandatory field? I can't see how you can use points in a us street style; that style of locator uses ranges for address interpolation.  When using streets as the basis to match to, intersections are 'found' by actual geometric intersections of the features.  So if Main St and Elm Ave intersect as features, you can get a hit by using Main ST & Elm Ave as the address.  However, if Main St over passes I-80, you can not get a match with I-80 & Main St. As far as aliases, that's an art in and of itself.  Depending on how lazy your geocoding staff is, you'll need a varying degree of aliases.  Out of the box, a 100% match for an intersection needs to be entered just as the streets are parsed in the locator.  So if you define pre-dir, street-name, suf-dir street-type etc, you need to enter your intersections accordingly: S MAIN ST & E ELM AVE So your geocoding staff need to on their game. But if you alias or use use a series of locators that don't parse out the components in a composite, you can get good results with: MAIN & ELM So the geocoding staff gets to be lazy.  As far as zip codes go, in all the years I've been geocoding and all the records I've geocoded (I work at two large 9-1-1 call centers) I've never used Zip Codes. City-Codes at times, but no zip codes.  Your mileage may vary.... Hope this helps- ... View more

Hello , We were trying to set up a geocoder for intersecting streets. We took the intersecting points from street file, which has the information to set up geocoder. Then we dissolved all points to get 2 points per intersection. We then combined street names like "COUCHMAN AVE & POPPY ST" into addressCombined (new field) to bring all intersecting street field to search upon? Questions are - 1. Is this a right way to set up geocode service for intersections? 2. Can point file work to set up geocode for intersections and what Locator Style, i will have to use? 3. Can geocode for intersection work just on input as "COUCHMAN & POPPY" or it needs Zipcode or City also? Thanks and Regards, Shay ~ 1: It's one way to do it.  I suspect you have two points because one is called Street A & Street B while the other is called Street B & Street A, right? 2: Yes you can use points; look here for a description of what types of locators are used with a specific feature type. Sometimes these single point type of locators are not very forgiving. 3. Personally, I just use a US Streets with alt names for geocoding for intersections.  If the propper name is say E COCHMAN AVE and S POPPY ST, you need to have alias names that allow it to match with just Cochman & Poppy.  You can also add your preffered intersection connectors:  I like &, and, @.... Hope this helps ... View more

Why not load the new points into the exisiting feature class with the simple data loader? ... View more

Hi I am getting the following messages Standalone user-defined junction is detected not quite sure what this means. I have been sent Bridge and Weight restistriction in point format from my source and would like to incorporate this into my road network. I have previously played around with a handful of restrictions however, I built the maxheight restriction in the linear segment corresponding to where the restriction exists and it seemed to work ok. Can points be used as restrictions parameters? As far as I can tell all my point are coincident with the lines. Many thanks, Igor Igor-  the short answer is Yes, you can use points for your restrictions. See this link. There is an additional entry in the online help called "Correcting stand alone junctions".  It's a little vague (to me) but it might get you going in the right direction. Hope this helps- ... View more

OK I need some advice on incorporating stop signs and Red light intersections.  I've identified all my red light intersections and working on the stop sign locations.  Are these created as point features and then loaded into a VRP analysis? Jt You should be able to use them as barriers with some sort of impedance value.  An alternative is creating turns, and they can get ugly... ... View more

I use replication through SDE, not server. I wonder if part of the issue is 9.3.1 to 10. Sorry, not much help. ... View more

You might want to check your math.... ... View more