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 - [login to view URL] - Freelancer_WY+[login to view URL] --> contains two zips referred to in (i) and (ii) below (i) ArcGIS Shape files (see: [login to view URL]) -WY: 2003-2010 (separate files for each year) -NE: 2000 (separate files for USD, SCSD, ELSD) (ii) Files to spatially join (see: [login to view URL]) 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. - [login to view URL]: N=23 - [login to view URL]: N=23 - [login to view URL]: 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): [login to view URL], N=23 * SecondPass are files of the second format from the sample files in (ii): [login to view URL], N=23 * Airportfile are files of the third format from the sample files in (ii): [login to view URL], 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) ([login to view URL], 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) ([login to view URL], 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) ([login to view URL], N=4): keep all columns (d) if any scripts are used, please submit them NOTE for DoctorWebbie: see GeocodedAddressFile_Summary+[login to view URL] on home Lacie