Latest Contributions by JoeBorgione

‎07-11-2013

Nope. But I cycle my services off and on more often now; that drops any that might be there.

‎07-10-2013

I am currently doing a course on GIS, and this was 1 of the questions that we had to go and research. B B E E E E A A A E E E D D B E E E D D B B E E D D D D D E D D D D E E (See above) If the compressed run length encoding is as follows 2,B,7,E,3,A,2,D,1,B,5,E,2,B,7,D,3,E,4,D What would the spiral encoding technique be below. 5 5 5 5 1 1 1 1 1 1 2 2 2 2 1 1 1 1 2 2 2 2 3 3 1 1 2 2 2 3 3 3 1 1 1 1 7 7 4 4 1 1 1 1 7 7 4 4 1 1 1 1 4 4 4 4 1 1 1 1 4 4 4 4 If I should write the spiral code would it be as follows 4,5, 4,1,4,3,3,2... Regards, Denzil Tell you what Denzil- I've only got 23 years in the field, and this is something I've never heard of. Granted, I'm just a gray haired middle aged guy and perhaps this has slipped by me....

‎07-09-2013

Maybe you guys could explain what it is you are doing or want to do; geocoding on this forum pertains to the translation of a descriptive location (specifically an address like 1234 Main St) to a pair of X,Y coordinates that the GIS can map. A google search of Spiral Encoding was anything but address related...

‎07-08-2013

Thanks for the reply again. I went over the entire process again, but can't really tell what went wrong. Would it be possible for you to take a look at the files that I'm working with, if that's not too much of work for you? Let's take this offline; send me a private message and we can discuss it that way.

‎07-08-2013

Yes, that solved the problem. But after running the spacial join, I don't see the information about the polygons in the attribute table for the join output. What could have gone wrong there? Without knowing what your actual steps were I can't even guess. I just performed a point in polygon spatial join and it works for me.

‎07-06-2013

"The event table has no OID field or no unique value field, selections are not possible". I also tried to "join data", but a similar message occurs ("Source table must have an ObjectID column to perform a Join By Location") Again, thank you in advance for the help! It sounds like you overlooked a step: You can then add your spreadsheet table as an xy event layer. After that, you can save that layer as point feature class. In the table of contents, right click on the event layer (the one that actually shows up as points). Select DATA and then EXPORT DATA, and follow the dialog. You can save it as a shapefile or you can save it as a geodatabase feature class, which is what I personally prefer. You'll be prompted to add the resulting shapefile/feature class to your ArcMap session. This is what you'll want to spatially join to your polygons. One last step, don't be shy about the instructions in my signature block...

‎07-03-2013

I just tried it and it works for me. But.... I'm still using 9.3.1 locators. Might be one of the changes in 10.0 & 10.1 if you that's what you are using. Maybe make sure your intersection designator / and \ are turned off?

‎07-03-2013

Just hit the mother lode for Denver. I couldn't get to this site earlier today, but it's got just what I had hoped to find and then some: http://data.denvergov.org/dataset/city-and-county-of-denver-street-centerline And this place has many other Colorado jurisdictions: http://data.opencolorado.org/

‎07-03-2013

Hi, I am a student conducting a research on North Korean economic development. I think this must be a very basic question but could you help me with converting the GIS map into an excel spreadsheet? So I downloaded the administrative districts of the country (which I got from http://diva-gis.org/datadown) and imported that data to ArcMap 10.1. The map contains polygons each representing certain district, and what I'm trying to do is make an excel spreadsheet in which each cell represents a certain point of the map (based on latitude and longitude) and shows 1 if that point is included in that district or 0 if not. If my question is not so clear, I can elaborate more on that. Thank you so much in advance! With all due respect, economic development in North Korea is going to be a very brief research project.... I think what you need to do is leave your polygons just the way they are, and create a spreadsheet (I prefer a database table) of your latitude, longitude pairs. You can then add your spreadsheet table as an xy event layer. After that, you can save that layer as point feature class. Finally you can perform a spatial join, (point in polygon) to get the polygon information as part of your point attributes table. Adding a table. Adding XY Data Spatial Join

‎07-03-2013

Hello again! I am having trouble creating the address locator from the street data I have and my data table. I obtained the street data from a US Major Roads layer found on ArcGIS online, and selected and exported only the roads in Colorado. I have read many tutorials and watched some videos online about creating an address locator and I am afraid the street layer does not have all of the necessary data. I have attached a copy of the project data I am using as well as a snapshot of the street attribute table (which consists of 13015 attributes). Does the street layer need more information such as distance from/to the right/left/etc? I appreciate all the help! Cameron- let's get some nomenclature taken care of first: the street data you show has 13015 RECORDS but only a handful of attributes: records are rows, attributes are columns. This particular street data does not have the proper attributes to support geocoding. I've been surfing around looking for a good source of street centerline data for Colorado this morning. So far the best information is the tiger-line data from the US Census; check out this pdf that has download instructions and use instructions. Once the sun comes up, I'll make a call or two to some of my Colorado contacts and see what they can suggest as well. Your address data looks good, but needs a few minor tweaks: get rid of any special characters, suite numbers and then standardize your street types. For example: 603 Main STREET, Suite 2 should be cleaned up to 603 MAIN ST Some of your address have STREET others have ST. Some have AVENUE others have AVE. No sense reinventing the wheel here; the USPS has a list of standards you can follow.Click on the abbreviations tab. (I use these in two major 9-1-1 call centers in Utah and geocode/dispatch hundreds of thousands of calls per year: when seconds count, help is only minutes away...) This should keep you busy; I'm grabbing another cup of coffee and watch the sunrise. (BTW, don't be shy about following the instructions given in my signature block below.)

‎07-01-2013

Import Feature from the Right Click menu? That didn't work for me. I never tried the Toolbox route though, maybe that works? Edit: Oh, I think you mean when you set the Coord. system of the Feature Dataset in SDE. Good idea. In my case, the Feature Dataset was already existing. Sorry, poor choice of words. Use the import button in the New Feature Dataset dialog. (See attached image.) If you have an existing feature dataset and you are unsure of it's spatial characteristics, you can Export the feature class of your choice from ArcMap to the feature dataset. It will take care of the projection for you.

‎07-01-2013

Check the XY Resolution and XY Tolerance. See if they match between the SDE Feature Dataset and the File GDB Feature Class. Just having the same WKID isn't enough in this case. Which is exactly why using the import feature is the way to go...

‎07-01-2013

I have an SDE Geodatabase running with SQL Server 2008 R2. I created my Feature Classes, now I have decided it a good idea to include some Feature Datasets to group like Feature Classes into. 1) I created a Feature Dataset, set it's coordinate system to the same of the Feature Classes. 2) I load the Feature Classes into the Feature Dataset and I get the message "Spatial References Do Not Match", none of my data gets loaded. I also tried Copy/Paste, no luck. Any idea how to resolve this? Are you specifically referencing the feature class using the import button? That's how I prefer to set the coordinate system. However, I'm not a big fan of feature datasets used as organizational tools, especially in an SDE database, and urge you to reconsider this approach. See this discussion.

‎06-25-2013

Thanks for the response, and, yes, I did post something similarly last week. I was just having difficulty finding a layer with sufficient street data. However, I've resorted to doing it by county, but I am having difficulty joining the table to the layer of Colorado counties. I need to create a many-to-one relationship between the table and counties layer because some counties have more than one project that was completed in that county. When I join them, it takes the first project from each county and that's it, so out of the 63 projects I want to map, only 24 show up. Is there a better way to do this? I appreciate all the help (this week and last). You can create a locator based on the county name: look here to learn about a general, sing field type of locator. I believe that this method will 'stack' your project points in a pile at the centroid of the county polygon centroid. Take a look at using the dot density method to represent them on a map.

‎06-24-2013

This is like deja vu all over again; I swear I replied to this same post last week or so and I remember someone from ESRI responding as well. My response was to get some local street data from Colorado or the Counties; the other response was to use the packaged data that comes with ArcGIS. Either way, take a look at the online help on how to create a locator, and you'll be good to go.

Online Status	Offline
Date Last Visited	‎05-19-2026 11:56 AM

My Ideas

Latest Contributions by JoeBorgione

Re: Hung/Orphan Process in SDE

Re: Sprial encoding technique

Re: Sprial encoding technique

Re: Converting polygons to spreadsheet

Re: Converting polygons to spreadsheet

Re: Converting polygons to spreadsheet

Re: Street Names with Fractions

Re: Geocoding Project

Re: Converting polygons to spreadsheet

Re: Geocoding Project

Re: Feature Datasets, SDE, and Spatial References Do Not Match Error

Re: Feature Datasets, SDE, and Spatial References Do Not Match Error

Re: Feature Datasets, SDE, and Spatial References Do Not Match Error

Re: Geocoding Project

Re: Geocoding Project

Topology in a Versioned GDB

Re: How do I edit metadata with Python?

Attribute Pane Properties

Re: Artificial Intelligence in GIS

Re: Data Scrubbing Addresses

Addressing

911 GIS