Arcpy / Python script to create a themed map in Arcmap 10.1

IN PROGRESS
Bids
1
Avg Bid (USD)
$120
Project Budget (USD)
$30 - $250

Project Description:
ArcMap V10.1 Script


Script Inputs:

Script input file #1: Shapefile (see attached zip file) for all the parcels in a particular county. The fields contain the following data:

Column 1:”FID” (object ID)
Column 2:”SHAPE” (geomentry)
Column 3:”CODE” (long)
Column 4:”PIN” (text)
Column 5:”MAPPER” (text)
Column 6:”REDEVELOPM” (long)
Column 7:”LASTMODIFI” (date)
Column 8:”x” (double)
Column 9:”Y” (double)
Column 10:”LOT” (text)
Column 11:”LINK_ACPA” (text)
Column 12:”ACCURACY” (long)
Column 13:”SOURCE” (long)
Column 14:”ACRES_CALC” (double)
Column 15:”ACRES_CAMA” (double)
Column 16:”ACRES_LEGA” (double)
Column 17:”EDITOR_NAME” (text)
Column 18:”EDIT_DATE” (date)
Column 19:”SHAPE_AREA” (double)
Column 20:”SHAPE_LEN” (double)


Script input file #2: A Comma delimited file (attached) containing the following data:

Column 1:”Account_No” (text)
Column 2:“Adv_No” (integer)
Column 3:”Batch” (integer)
Column 4:”Face_Amount” (long)
Column 5:”Homestead” (integer)
Column 6:” Prior_Certs_Outstand”(integer)

Description of geoprocessing

The script shall ask for the file location of the shape file and the file location of the comma delimited file.

Once inputted it will join the two tables into one based upon the “PIN” field in the shapefile and the “Account_No” of the comma delimited file. The tables are to be joined where only those records in the input that match a row in the join table will be present (inner join). In other words, if there is no match from the comma delimited file in the shapefile, then the row from the shapefile needs to be discarded in the joined table.

The remaining data shall be plotted on a map with a Table of Contents as follows:

Group Layer: “Batch 1”
• Layer: “Homestead”
• Layer: “Non-Homestead”
• Layer: “Has Prior Certificates”
• Group Layer: “Cert. Value”
o “Cert. Value &10000”


X
X
X

Group Layer: “Batch 6”
• Layer: “Homestead”
• Layer: “Non-Homestead”
• Layer: “Has Prior Certificates”
• Group Layer: “Cert. Value”
o “Cert. Value &10000”


Each of the layers in a group layer “Batch” shall have their own symbology scheme which will be a simple color with boarders and set opacities (typically 50%) see attached screen shot. The symbology and layer names will be identical for each batch group layer and there will be 6 batch group layers

When a resulting parcel on the map is clicked with the “identify” selection enabled, it needs to show the following fields:

“Parcel Identification Number” : some value
“County URL Link” : some value
“Lot Size (Acres)” : some value
“Certificate Number” : some value
“Value” : some value
“Batch” : some value
“Homestead” : some value
“Number of Prior Certificates” : some value

The resulting map must use features that are compatible with the “map to kml” feature or have some other way to export the map to google earth AND RETAIN all the symbology and group layer structures defined above.

Skills required:
Python
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire pengfeiwu
$ 120
in 11 days