GeoJSON file or DB about corruption_tracker

[Vegasq]

Mobile app don't need geojson, it overhead requirements. We need very small part of information.
Backend don't need geojson. geojson required by javascript lib to draw map.

We can generate this format dynamicly, and provide it to lib. But it's incorrect to think that we need this file and should keep it on client and server parts.

[autogestion]

@Vegasq agree with you. Lets implement your step-by-step plan

In this case, we need two more models:

class Layer :
"""this could be set of polygons of organizations for district, or polygons of districts from whole sity view, or polygons of cities from whole country view""

• name
• type (choicefield - organization/district/county

class Polygon:

• organization (one-to-one-field to Organization model , null=True)
• layer (FK to Layer)
• coordinates

All aditional info would be stored in Organization model

Also leaflet.js provides functionality to draw polygons, this could be included to django admin using django-leaflet package - https://github.com/makinacorpus/django-leaflet#leaflet-map-forms-widgets
and could be tested here http://umap.openstreetmap.fr/en/ by clicking 'create a map'

GeoJSON could be used as fixture, as alternative way to get some polygons into DB

[autogestion]

At all, transition from upper Layer to lower could be done in such way:
User click on polygon of county, js send to server request with polygon/layer id, server agregates polygons of lower level Layer and return them as json to js. Js reload map, make zoom in and draw polygons from gotten json. Same to go down to organizations level

If it is right way, Layers have to be ordered hierarchically. By using FK to self, maybe

[Vegasq]

Also leaflet.js provides functionality to draw polygons, this could be included to django admin using django-leaflet package - https://github.com/makinacorpus/django-leaflet#leaflet-map-forms-widgets

Lets postpone it. If we want to use their native tools, we will have two new binary requirements.

• GEOS binary package to work with geo data.
• PostreSQL to use it with django.contrib.gis.db.backends.postgis

I think we can handle it, but in different patchset, and after discrussion about new requirements.

[autogestion]

Looks like we'll stay with GeoJSON file for a while, and it have to contain:

at top-level:

• layer_id (Kharkiv, Lviv, Ukraine, Saltovka)
• layer_type (organizations, districts)
• set_default(1,0) - if we'll need to load pack of geojsons, one of them must be marked as primary

at polygon-level:

• organization_type (based on OrganizationType.ORG_TYPES
  https://github.com/autogestion/corruption_tracker/blob/master/claim/models.py#L14 )
• organization_name
• coordinates

This values would be parsed by initiate_db comand (
https://github.com/autogestion/corruption_tracker/blob/master/claim/management/commands/initiate_db.py and stored to database

[autogestion]

All data is stored in Postgres