search

opensandiego / infrastructure

Code for San Diego Infrastructure Project
2 stars 2 forks source link

New Data & GeoJSON #98

Closed milafrerichs closed 10 years ago

milafrerichs commented 10 years ago

What's this PR do?

Adds two new command line commands:

Import Data

Import new Data and update existing.

python manage.py import_data csv_file.csv --header

Imports Data from the csv_file. Optional header option, if the csv file includes a header

Update Geometry

Update Geometry for Projects

python manage.py udpate_geo

Updates the geometry field of the project with data from the ArcGIS Server from the city of San Diego: http://maps.sandiego.gov/ArcGIS/rest/services/CIPTrackingPublic/MapServer All three layers are searched for the SEQ_NO If a project is found the response is converted from ESRIs JSON to GeoJSON

Any background context you want to provide?

The updater uses the find endpoint of the ArcGIS Server and not the query endpoint. The query endpoint was not ready at the beginning of this implementation. Might be used later.

Screenshots (if appropriate)

bildschirmfoto 2014-03-23 um 18 07 54 bildschirmfoto 2014-03-23 um 18 07 43

Tickets

fixes #7 fixes #96

Questions:

The South App is used to upgrade the database. Needs to be installed first, or should already be in the requirements.txt