Beispiel #1
0
def import_county_shape(file):
    counties = DataSource(file)
    lm = LayerMapping(CountyMap, counties,
                      mapping(counties, geom_name='geometry'))
    lm.save(
        verbose=True
    )  # Saves to database - need to first migrate County and State model to database
Beispiel #2
0
def run():
    import os
    os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'

    from psycopg2 import IntegrityError
    from django.contrib.gis.utils import mapping, LayerMapping, add_postgis_srs

    from world.models import WorldBorders

    try:
        add_postgis_srs(900913)
    except IntegrityError:
        print "The Google Spherical Mercator projection, or a projection with srid 900913, already exists, skipping insert"

    WORLD_SHP = 'apps/world/data/TM_WORLD_BORDERS-0.3.shp'
    layer = LayerMapping(WorldBorders,
                          WORLD_SHP,
                          mapping(WORLD_SHP,geom_name='mpoly',multi_geom=True),
                          transform=False,
                          encoding='iso-8859-1')

    layer.save(verbose=True,strict=True,progress=True)


    print 'Fixing invalid polygons...'
    num = len(WorldBorders.objects.extra(where=['NOT ST_IsValid(mpoly)']))
    for item in WorldBorders.objects.extra(where=['NOT ST_IsValid(mpoly)']):
        corrected = item.mpoly.buffer(0)
        item.mpoly = corrected
        item.save()

    print '....'
    num = len(WorldBorders.objects.extra(where=['NOT ST_IsValid(mpoly)']))
    if num:
      print '%s invalid polygons remain' % num
      print WorldBorders.objects.extra(where=['NOT ST_IsValid(mpoly)'])
Beispiel #3
0
#!/usr/bin/python
"""Utility for adding the Ward layermapping from data/ to the cape.lionhead
   project."""

import os
os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'
from psycopg2 import IntegrityError

from django.contrib.gis.utils import mapping, LayerMapping, add_postgis_srs
from lionshead.models import Ward

try:
    add_postgis_srs(900913)
except IntegrityError:
    print "The Google Spherical Mercator projection, or a projection with srid 900913, already exists, skipping insert"

wards = 'data/wards_4326.shp'
wlayer = LayerMapping(Ward,
                      wards,
                      mapping(wards, geom_name='geometry', multi_geom=True),
                      encoding='Latin1')
wlayer.save(verbose=True, progress=True)
Beispiel #4
0
os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'
from psycopg2 import IntegrityError

from django.contrib.gis.utils import mapping, LayerMapping, add_postgis_srs
from world.models import WorldBorders

try:
    add_postgis_srs(900913)
except IntegrityError:
    print "The Google Spherical Mercator projection, or a projection with srid 900913, already exists, skipping insert"

WORLD_SHP = 'world/data/TM_WORLD_BORDERS-0.3.shp'

layer = LayerMapping(WorldBorders,
                     WORLD_SHP,
                     mapping(WORLD_SHP, geom_name='geometry', multi_geom=True),
                     transform=False,
                     encoding='iso-8859-1')

layer.save(verbose=True, strict=True, progress=True)

print 'Fixing invalid polygons...'
num = len(WorldBorders.objects.extra(where=['NOT ST_IsValid(geometry)']))
for item in WorldBorders.objects.extra(where=['NOT ST_IsValid(geometry)']):
    corrected = item.geometry.buffer(0)
    item.geometry = corrected
    item.save()

print '....'
num = len(WorldBorders.objects.extra(where=['NOT ST_IsValid(geometry)']))
if num:
Beispiel #5
0
    def gishandle( self, model_name, filepath, *args, **options ):
        from django.contrib.gis.utils import ogrinspect, mapping

        print ogrinspect( filepath, model_name, srid=options['srid'], blank=True )
        print "\n\n%s_mapping = %s" % ( model_name.lower(), mapping( filepath ))
os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'
from psycopg2 import IntegrityError

from django.contrib.gis.utils import mapping, LayerMapping, add_postgis_srs
from world.models import WorldBorders

try:
    add_postgis_srs(900913)
except IntegrityError:
    print "The Google Spherical Mercator projection, or a projection with srid 900913, already exists, skipping insert"

WORLD_SHP = 'world/data/TM_WORLD_BORDERS-0.3.shp'

layer = LayerMapping(WorldBorders,
                      WORLD_SHP,
                      mapping(WORLD_SHP,geom_name='geometry',multi_geom=True),
                      transform=False,
                      encoding='iso-8859-1')
                    
layer.save(verbose=True,strict=True,progress=True)


print 'Fixing invalid polygons...'
num = len(WorldBorders.objects.extra(where=['NOT ST_IsValid(geometry)']))
for item in WorldBorders.objects.extra(where=['NOT ST_IsValid(geometry)']):
    corrected = item.geometry.buffer(0)
    item.geometry = corrected
    item.save()

print '....'
num = len(WorldBorders.objects.extra(where=['NOT ST_IsValid(geometry)']))
Beispiel #7
0
os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'
from psycopg2 import IntegrityError

from django.contrib.gis.utils import mapping, LayerMapping, add_postgis_srs
from world.models import WorldBorders

try:
    add_postgis_srs(900913)
except IntegrityError:
    print "The Google Spherical Mercator projection, or a projection with srid 900913, already exists, skipping insert"

WORLD_SHP = 'apps/world/data/TM_WORLD_BORDERS-0.3.shp'

layer = LayerMapping(WorldBorders,
                      WORLD_SHP,
                      mapping(WORLD_SHP,geom_name='mpoly',multi_geom=True),
                      transform=False,
                      encoding='iso-8859-1')
                    
layer.save(verbose=True,strict=True,progress=True)


print 'Fixing invalid polygons...'
num = len(WorldBorders.objects.extra(where=['NOT ST_IsValid(mpoly)']))
for item in WorldBorders.objects.extra(where=['NOT ST_IsValid(mpoly)']):
    corrected = item.mpoly.buffer(0)
    item.mpoly = corrected
    item.save()

print '....'
num = len(WorldBorders.objects.extra(where=['NOT ST_IsValid(mpoly)']))
#!/usr/bin/python

"""Utility for adding the Ward layermapping from data/ to the cape.lionhead
   project."""

import os
os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'
from psycopg2 import IntegrityError

from django.contrib.gis.utils import mapping, LayerMapping, add_postgis_srs
from lionshead.models import Ward

try:
    add_postgis_srs(900913)
except IntegrityError:
    print "The Google Spherical Mercator projection, or a projection with srid 900913, already exists, skipping insert"

wards = 'data/wards_4326.shp'
wlayer =  LayerMapping(Ward, wards,
    mapping(wards, geom_name='geometry',multi_geom=True), 
    encoding='Latin1')
wlayer.save(verbose=True, progress=True)
Beispiel #9
0
transaction.commit_unless_managed()

from django.contrib.gis.utils import mapping, LayerMapping, add_postgis_srs
from world.models import WorldBorders

try:
    add_postgis_srs(900913)
except IntegrityError:
    print "The Google Spherical Mercator projection, or a projection with srid 900913, already exists, skipping insert"

WORLD_SHP = "world/data/TM_WORLD_BORDERS-0.3.shp"

layer = LayerMapping(
    WorldBorders,
    WORLD_SHP,
    mapping(WORLD_SHP, geom_name="geometry", multi_geom=True),
    transform=False,
    encoding="iso-8859-1",
)

layer.save(verbose=True, strict=True, progress=True)


print "Fixing invalid polygons..."
num = len(WorldBorders.objects.extra(where=["NOT ST_IsValid(geometry)"]))
for item in WorldBorders.objects.extra(where=["NOT ST_IsValid(geometry)"]):
    corrected = item.geometry.buffer(0)
    item.geometry = corrected
    item.save()

print "...."
Beispiel #10
0
def import_state_shape(file):
    states = DataSource(file)
    lm = LayerMapping(StateMap, states, mapping(states, geom_name='geometry'))
    lm.save(verbose=True)