Closed

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

This project was awarded to pengfeiwu for $120 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
1
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online