codeforsandiego/infrastructure — pull request #98 by milafrerichs (2014-03-24 20:52:41+00:00)
Title: New Data & GeoJSON

#### What's this PR do?
Adds two new command line commands:
##### Import Data
Import new Data and update existing.
```shell
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
````shell
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](https://f.cloud.github.com/assets/688980/2505101/025f3fbc-b396-11e3-966a-3d0b8a11e8c6.png)
![bildschirmfoto 2014-03-23 um 18 07 43](https://f.cloud.github.com/assets/688980/2505102/05d4e250-b396-11e3-85ae-74c1eca76642.png)

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