{"id":438,"date":"2012-08-09T20:37:43","date_gmt":"2012-08-09T20:37:43","guid":{"rendered":"http:\/\/landviser.biz\/dotcomsandbox\/?p=438"},"modified":"2017-08-29T17:55:03","modified_gmt":"2017-08-29T17:55:03","slug":"add-lat-long-to-shapefile","status":"publish","type":"post","link":"http:\/\/landviser.biz\/dotcomsandbox\/add-lat-long-to-shapefile\/","title":{"rendered":"Adding Lat-Long for the centroids of USA counties in a new point shapefile (ArcMap 10)"},"content":{"rendered":"
\n
\n\t

Software:<\/strong>\u00a0ArcGIS - ArcEditor\u00a09.2, 9.3, 9.3.1, 10\u00a0ArcGIS - ArcInfo\u00a09.2, 9.3, 9.3.1, 10\u00a0ArcGIS - ArcView\u00a09.2, 9.3, 9.3.1, 10\u00a0ArcGIS for Desktop Advanced\u00a010.1\u00a0ArcGIS for Desktop Standard\u00a010.1<\/p>\n

\"USA<\/a><\/p>\n

This is documented step-by-step and hands-on exercise on how to create XY point shapefile for the centers of USA counties (with linked basic demography and FIPS) in ArcMap 10.1. You don\u2019t need to follow those steps (and if you don\u2019t have ArcGIS for Desktop, you cannot) and may just grab the resulted layer file in various formats at the end of this post. Formats available are MS Excel table, CSV table with XY, zipped SHP file package, and KMZ file.<\/p>\n

This layer is not directly shareable on ArcGIS Online, as it has more than 1000 features (3143, to be exact), we may post it there later as partial files\u2026<\/p>\n

If you need help with your GIS project, please, do not hesitate to contact Landviser, LLC - post comment, email\u00a0info@landviser.com<\/a>, or call 609-412-0555.<\/p>\n

1. Linking County shapefile with State shapefile (from 9.3 version data DVD) \u2013 to get state abbreviation in table with FIPS. Link based on State name (full).<\/p>\n

\"image_34_5FC33B5A\"<\/a><\/p>\n

2. Export joint file as shapefile and clean table of not needed state records.<\/p>\n

3. Download new county shapefile with 2010 demographics and 2007 farm data of ArcGIS Online. Created Point file for the centroids of a new file:<\/p>\n

\"image_thumb_5FC33B5A\"<\/a><\/p>\n

\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Add X_Longitude and Y_Latitude as Double data format (6, 2) for two decimal points.<\/p>\n

\u00a0\u00a0\"image_thumb_2_5FC33B5A\"<\/a>\"image_thumb_1_5FC33B5A\"<\/a><\/p>\n<\/div>\n

For both X and Y right click the column and choose \u201cCalculate Geometry\u201d and X or Y coordinate of Centroid respectively. Choose units as Decimal degrees.<\/p>\n

\"image_thumb_4_5FC33B5A\"<\/a>\"image_thumb_6_5FC33B5A\"<\/a><\/b><\/p>\n

\"image_thumb_8_5FC33B5A\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Export to a table. In the attribute table, select Options > Export.<\/p>\n

Specify a name and location for the new table.<\/p>\n

Add the new table to current map.<\/p>\n

\"image_thumb_9_5FC33B5A\"<\/a><\/p>\n

Go to your map Legend (Table of Content) and choose to display XY data:<\/p>\n

\"image_thumb_10_5FC33B5A\"<\/a><\/p>\n

4. Oops! Where are the center points? If you had selected wrong projection for your original map they might all be stuck in the middle of whole USA as a tiny replica:<\/p>\n

\"image_thumb_12_0DB08E13\"<\/a>\"image_thumb_11_0DB08E13\"<\/a><\/p>\n

You will need to go and change a projection to Geographic WGS 1984.prj<\/p>\n

\"image_thumb_13_0DB08E13\"<\/a><\/p>\n

Finally, you\u2019re your new point data layer matches your map extent!<\/p>\n

\u00a0\"image_thumb_14_0DB08E13\"<\/a><\/p>\n

5. Now, you will need to export the Event Layer to a shapefile by right-clicking on the layer and navigating to Data > Export Data.\"image_thumb_17_5FC33B5A\"<\/a><\/p>\n

6. Spatially Join the center point in the file created in step 6 to the data layer created in step 2. Delete duplicate fields in joint shapefile. Export as table, KML, shapefile, whatever.<\/p>\n

\"image_thumb_18_0DB08E13\"<\/a><\/p>\n

This layer is not directly shareable on ArcGIS Online, as it has more than 1000 features (3143, to be exact), we may post it there later as partial files\u2026<\/p>\n

If you need help with your GIS project, please, do not hesitate to contact Landviser, LLC - post comment, email\u00a0info@landviser.com<\/a>, or call 609-412-0555.<\/p>\n<\/div>\n<\/div><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"

Software:\u00a0ArcGIS – ArcEditor\u00a09.2, 9.3, 9.3.1, 10\u00a0ArcGIS – ArcInfo\u00a09.2, 9.3, 9.3.1, 10\u00a0ArcGIS – ArcView\u00a09.2, 9.3, 9.3.1, 10\u00a0ArcGIS for Desktop Advanced\u00a010.1\u00a0ArcGIS for Desktop Standard\u00a010.1 This is documented step-by-step and hands-on exercise on how to create XY point shapefile for the centers of USA counties (with linked basic demography and FIPS) in ArcMap 10.1. You don\u2019t need to follow those steps (and if you don\u2019t have ArcGIS for Desktop, you cannot) and may just grab the resulted layer… Read more about Adding Lat-Long for the centroids of USA counties in a new point shapefile (ArcMap 10)<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":439,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[29,17,31],"tags":[],"class_list":["post-438","post","type-post","status-publish","format-standard","has-post-thumbnail","category-diy","category-geography","category-gis","entry"],"_links":{"self":[{"href":"http:\/\/landviser.biz\/dotcomsandbox\/wp-json\/wp\/v2\/posts\/438","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/landviser.biz\/dotcomsandbox\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/landviser.biz\/dotcomsandbox\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/landviser.biz\/dotcomsandbox\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/landviser.biz\/dotcomsandbox\/wp-json\/wp\/v2\/comments?post=438"}],"version-history":[{"count":9,"href":"http:\/\/landviser.biz\/dotcomsandbox\/wp-json\/wp\/v2\/posts\/438\/revisions"}],"predecessor-version":[{"id":1011,"href":"http:\/\/landviser.biz\/dotcomsandbox\/wp-json\/wp\/v2\/posts\/438\/revisions\/1011"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/landviser.biz\/dotcomsandbox\/wp-json\/wp\/v2\/media\/439"}],"wp:attachment":[{"href":"http:\/\/landviser.biz\/dotcomsandbox\/wp-json\/wp\/v2\/media?parent=438"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/landviser.biz\/dotcomsandbox\/wp-json\/wp\/v2\/categories?post=438"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/landviser.biz\/dotcomsandbox\/wp-json\/wp\/v2\/tags?post=438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}