Latest Contributions by JoeBorgione

I have a street file with 5 alternative name fields for each street.  I'd like to use all 5 alternatives for the street-range address locator I'm building.  However, it looks like the Create Address Locator tool only allows me to use 1 alternative name.  One workaround I could do is create multiple address locators using the alternative name fields and combine them using a composite address locator but I thought there may be an easier way. 5 alias names for a given street? Uggh.  At some point everybody forgets the real name, right? I would recommend that you merge all the aliases into one file, and have a unique "joinitem" for the 'real name' that appears in the alias table records.   It'll be some short term pain, but with the long term gain of just having to manage one alias table, I'm pretty sure you'll thank me later. But don't use the OID or a GUID as your unique joinitem; you'll curse me later if you do.... Hope this helps. ... View more

Very good thanks a lot. That helps calculating the start and endpoint of a line-feature. Is there also a way to generate coordinates of vertex points? Found this with a google search (with apologies to bing users...) ... View more

I have a polyline that represents a section of a road in his attributes Km established a field of initial and final Km doer of locating a given Km between that range. Ex Accident. The problem is when I use the locator to locate a specific accident km mark but not me correctly. Not the place you expect considering the initial and final Km. Aguna ideas? many Thanks You are actually trying to perform a linear reference along a route, where as geocoding translates an address (like 1234 Main St) into an X-coordinate and Y-coordinate that the GIS can plot. May I suggest you start here with the on line help topic of Linear Referencing. ... View more

Sounds like you have a hung lock file.  Close out all ArcGIS applications.  You might get it with a reboot or go into the directory where the mdb resides and delete the lock file. Hope this helps. ... View more

A couple of questions and subsequent suggestions for you Sandra: Is the locator published?  If so you should shut the service down and then try to rebuild. Is the locator and or data located on a SAN?  If so, check your permissions there.  They (permissions) have a tendency to get goofy with SANs. Hope this helps- ... View more

Hi there, I am trying to create service area polygons for census block centroids within a city. I used 800 metres as the default break but one of my polygons came out looking very strange with a distance of 92 metres (which is smaller than the default break). Please find the screenshot below. Could anyone help me to figure out the problem? Many thanks in advance. [ATTACH=CONFIG]23533[/ATTACH] Looks okay to me given the fact that your street is not connected to the rest of the network. ... View more

I am having a similar problem. Under my waypoints field the values containing both alpha and numeric characters show up as null in arcmap. I have tried just about everything in formatting and I am at my wits end. Help me. I have attached the problem file as well as highlighted the waypoints which are reading as null in arcmap Your spreadsheet is the problem.  You've got mixed and matched formats in the same column.  Some are true numeric, while others should be treated as text (those with Alpha characters imbedded).  I suggest you create a personal geodatabase, and create a table with the following fields:  XCoord(double), YCoord(double), Waypoint(text).  Load your excel data into that and go to work. ... View more

Hi there, I am exploring the use of GIS to map the location of each CCTV camera that is mounted on building. I was able to geocoded each CCTV camera location on 2D map however would like to seek your opinion on the following: Q1: I noticed there is limitation of using ArcGIS desktop to auto create the viewing area (this would be a polygon form) from each planted camera. May I know is there a third party software/any script I can use to generate the viewing coverage from each camera, the viewing coverage looks like a cone shape. Look forward to hearing any further sharing, thanks. See the attached images. [ATTACH=CONFIG]23493[/ATTACH][ATTACH=CONFIG]23494[/ATTACH][ATTACH=CONFIG]23493[/ATTACH] This is not much unlike mapping Cell Phone Tower quadrants and/or other Radio Antenna broadcast coverage or other viewshed analyses.  There is also a plume modeling extension from NOAA called Aloha that you might want to check out as well. ... View more

I have an SDE geodatabase that has a one way replication to a file geodatabase, where I will make edits to the feature classes offline somewhere. I know that this scenario doesn't support one-way or two-way replication, so is there anyway I can push the updates I made in the file geodatabase back to the SDE geodatabase? What do you mean by 'offline somewhere'? You are describing what two-way replication is. ... View more

Have you tried the county GIS people?  Local sources are often times the best sources.  Don't count on getting a feature class that is 100% perfect for your needs.  Unless you are willing to pay for it. ... View more

Glad it worked out for you; summary tables and relates/joins are really powerful tool in many different applications. All the best- ... View more

Take a look at creating a summary table: you can summarize on your region field and then create stats on any other field you may have. ... View more

In my earlier graphic I used the 'Arrow At End' symbol which shows the direction of the line.  In this graphic I use the same symbology however I have zoomed into the "0,0" location of Salt Lake City, Utah.  Basically the the street grid is split east to west by Main St and north to south by S Temple St. As you 'travel' to the east of the 0,0 the streets ascend in addresses with an 'EAST' prefix.  As you travel west of the 0,0 point the addresses ascend with a 'WEST' prefix.  As you travel north from the 0,0, the addresses ascend with a NORTH prefix and finally, as you travel south, they ascend with a 'SOUTH' prefix. You'll notice that the directions of the the lines themselves (From-To) are oriented with respect to the 0,0 location.  Most areas have multiple address grids.  I'm really lucky that my area of operation is here in Utah. (Not just for addressing; the skiing and mtn biking is over the top, but I digress...)  Here in the Salt Lake Valley we have only one 0,0 location.  To the south of here is the Utah Valley, and every city down there has their own 0,0, which is pretty typical across the U.S.  As you move from one city to the next addresses re-orient to the local 0,0. The trick is knowing where your 0,0 is for a given jurisdiction. ... View more