In Progress

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

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”




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: Python

See more: arcpy layer symbology, match layer symbology arcpy, fid object integer arcmap, set data structures, map in c, link structures, data structures set, shapefile, shape file, python script, python data, code script link description, create zip code, input pin code, map data google, batch python, python code identify text, python create file, python file create, arcpy script, county zip, kml python, google certificate, simple google earth, python batch

About the Employer:
( 1 review ) Gainesville, United States

Project ID: #4245736

Awarded to:


GIS PHD. Many Years of experience in GIS applications development

$120 USD in 11 days
(1 Review)