Anyone work with GIS?

You need to do a Join of the Excel Table to the Existing shapefile you have. Base the join on the Parcel numbers.

Are the parcels you need already included in the existing shape file?

 

yep they are all in there but when i tried to do a join it would not select the parcel in the excel file. It was just blank in the drop down box :/

 

Let me mess with it at work tomorrow and see what your looking at. I can't remember off the top of my head. You could go in and manually select all 423 parcels, and the export to a new shape file if worst comes to worst

 

Ya that will be my last ditch effort... I just dont want to weed through almost 106,000 parcels to find 423! But if it comes to that I will Thanks for your help, I really appreciate it! I was playing with joins and relations all afternoon

 

Gis cant read unformatted excel tables. In excel create a new field and call it ObjectID and make it first column. Save and exit out of excel. Restart arcmap. In arcmap add excel spreadsheet to map. Right click on your existing shapefile or newly added excel file and do a table join. Select appropriate fields and follow prompts. Problem solved. Also make sure your field for parcel ids in excel has a header for first line.

 

Ya I am programmer for satellite & gis application we use esri, bing and google map. Def not the easiest to code, presenting bunch of dots on the map and grouping them when zoom in out then there is unit conversion USNG is my favorite just for the American military.

 

This is what I tried before... I'll give it a try again though.
Again, the help is very much appreciated, thanks guys

 

You have to obviously make sure that your header fields are not using reserved words etc etc etc.

I always make object id fields just because it eliminates possibility of any arising issues because of it.

In my case when I do table joins worst thing that happens is that it skips records which gives me a clue that not all records are the same. Look at what you have, make sure that naming conventions match and do qaqc on both shapefile and spreadsheet.

Another thing to consider is that joining is very finnicky. For example 00049 =/= 49 and " 49" =/= "49" and "49" =/= "49 "

Find a record that you know to be "same" and cross reference it between spreadsheet and shapefile. Another thing you can do is based on your license level you can try running something like a table compare tool. Also make sure that your numbers are stored as numbers in both places or stored as text in both places.

 

...many different ways to do it, ...you can actually do this using the "model builder" (geoprocessing modeling) that comes w/ arcgis... in simple terms, you'd make a model that loads both excel worksheets, then performs a join operation using the "parcel id" field in the second dataset, and outputs the result to a shapefile or to a geodatabase...

 

I have been using ArcGIS every day at work for the past few months. I am drawing in all of the sewer service connections from homes to the mains. 75% of our sewer lines have been televised and recorded. I go through the recordings using Granite XP and locate the connections from there. There are over 3000 lines in town and more than 150 miles of pipe to look at. GIS is a very powerful tool and I am learning more every day.

 

Awesome! Ya the learning curve is steep but it's such a great tool.

 

Got my Masters degree in GIS. Arc is a weird program, not the most user-friendly, but once you learn some of the tricks it comes easy. The online resource center is a super helpful source of information when you're stuck, lots of really good step-by-step tutorials.

Now that I've got my degree I've decided I can't stand jobs that require sitting on your ass in front of a screen all day. Oh well!

 

Want to have some fun with ArcGIS, throw in the Schneider Fiber Manager add-on.
ArcGIS is great for mapping and water/sewer... even for power distribution.
Fiber? That's worse than telecom... multiple 144 strand cables is too much without a separate database handler.

Thankfully, I've got a temp doing it

 

Newbie to all this, but are any of you guys surveyors? Didn't know if ARC factored into that

 

not a surveyor... but our office surveyor does use GIS

 

Gotcha! Is a 4-year degree required for what ya'll do?

 

Sometimes it seems like a 4 year degree is needed to use ArcGIS.

It is a seriously intense program. Makes Autocad 2000 look like Windows Paint.
We added the Schneider Fiber Manager module for plotting our fiber optic network and just the plug-in was a 5-day class for the two of us.

My position, a degree in electrical engineering is one requirement, but the degree can be waived in lieu of professional experience.

Our "smart" GIS guy is actually moonlighting from his job as a manager in the tire install shop at Costco. He puts in 4 hours a day with us and then goes to Costco, but it is only a temporary position. Once he's mapped our fiber, he's gone. We considered using an intern, but you get what you pay for... the last intern didn't do shit for 4 months.

 

Ah gotcha. When I was in high school, I had an interest in a career as a surveyor, but never really knew how to go about doing so as none of the universities around me offered an actual surverying degree.

 

Sometimes it does seem like it.. but there are cert programs out there for it. At UC Davis you could minor in it and get the cert.

 

x2 on the cert programs that's what I did. I just added it on to my 4 year degree at MN Duluth, which only took one semester since I was geography major/geology minor and already did most of the core courses...