In Progress

ArcMap: Spatial join

OVERVIEW

------------------

This project will involve taking some (longitude, latitudes), and then in ArcGIS joining them to a series of shape files I will provide (you should have a copy of ArcGIS version 9.3 or 10). All scripts as well as the output files will be submitted.

FILES/DELIVERABLES

------------------------------------

(0) FILES

- [url removed, login to view]

- Freelancer_WY+[url removed, login to view] --> contains two zips referred to in (i) and (ii) below

(i) ArcGIS Shape files (see: [url removed, login to view])

-WY: 2003-2010 (separate files for each year)

-NE: 2000 (separate files for USD, SCSD, ELSD)

(ii) Files to spatially join (see: [url removed, login to view])

There will be 50 files to join. There are three kinds of files and I list the number of each which will need to be joined below. The full list of files will be uploaded after the project is accepted and begun.

- [url removed, login to view]: N=23

- [url removed, login to view]: N=23

- [url removed, login to view]: N=4

(iii) Final output

- for each file, the WY shape files should be spatially joined in ArcGIS. There will be variables for each year 2003-2010 and I will send along labels for the variables after the project is accepted.

- for each file, the NE shape file should be spatially joined in ArcGIS. There will be variables for USD, SCSD, ELSD and I will send along labels for the variables after the project is accepted.

- after the sample files are processed, these should be submitted for me to review. Work should continue to be submitted as it is completed

- the final files which include the joined variables should be:

(a) in CSV format

(b) renamed as:

FirstPass\_[states+years]\_[year-month].csv

SecondPass\_[states+years]\_[year-month].csv

Airportfile\_[states\_years]_[originalname].csv

where:

* FirstPass are files of the first format from the sample files in (ii): [url removed, login to view], N=23

* SecondPass are files of the second format from the sample files in (ii): [url removed, login to view], N=23

* Airportfile are files of the third format from the sample files in (ii): [url removed, login to view], N=4

* [states+years] is "WY2003-2010" for all files except the ones which also get the NE shape files in which case it is "WY2003-2010+NE-USD-SSD-ESD"

* [year-month] is the year and month of the file, e.g. "2003-04" for the first two sample files in (ii)

* [originalname] is the original name of the file (except the extension) for the third kind of sample file in (ii)

(c) need only include the following columns from the original file in additional to the new ones from the spatial join.

IMPORTANT NOTE: if the columns below are missing in any file, let me know so I can modify the columns to be kept

* files of the first format from the sample files in (ii) ([url removed, login to view], N=23): first 25 variables = FID\_1 FID\_1\_1 FID\_1\_1\_1 FID\_1\_1\_\_1 FID\_1\_1\_\_2 FID\_1\_1\_\_3 FID\_1\_1\_\_4 Status Score Match\_type Side X Y Match\_addr ARC\_Street ARC\_City ARC\_State ARC\_ZIP id street city state zip F6 FID_2

* files of the second format from the sample files in (ii) ([url removed, login to view], N=23): first 20 columns = FID\_1 FID\_1\_1 FID\_1\_1\_1 FID\_1\_1\_\_1 FID\_1\_1\_\_2 FID\_1\_1\_\_3 FID\_1\_1\_\_4 FID\_1\_1\_\_5 FID\_1\_1\_\_6 FID\_1\_1_\_7 key found y x zip street city state id FID\_2

* files of the third format from the sample files in (ii) ([url removed, login to view], N=4): keep all columns

(d) if any scripts are used, please submit them

NOTE for DoctorWebbie: see GeocodedAddressFile_Summary+[url removed, login to view] on home Lacie

Skills: Cartography & Maps, Geolocation

See more: Arcmap, spatial join, arcmap spatial join, spatial join format csv arcmap, scsd, arc com, shape file, join them, join me, esd, dbf, City Maps, cartography, cartography and maps, arc in, arcmap csv, county zip, city county state, project 2003 2010, lacie, county state city, arcmap extension, join file, dbf file sample, city state csv file

About the Employer:
( 6 reviews ) Chicago, United States

Project ID: #4326668

Awarded to:

AlexYes

Hello, I have 5 years of experience in working with GIS software like ArcMap and so on. I have solid understanding of different kinds of geodata and I believe I could help you. Please check the sample in your inbox. More

$220 USD in 3 days
(9 Reviews)
5.1