In [1]:

    

import logging

from spandex import TableLoader
from spandex.spatialtoolz import conform_srids


    

In [2]:

    

shapefiles = {'staging.parcels_contra_costa':          'parcels/contra_costa/CAD_AO_ParcelPoly_0410.shp',
              'staging.parcels_contra_costa_pt':       'parcels/contra_costa_pt/CAD_AO_ParcelPoints_int0410.shp',
              'staging.parcels_marin':                 'parcels/marin/Marin_2006_CWP.shp',
              'staging.parcels_napa':                  'parcels/napa/Napa_Parcels.shp',
              'staging.parcels_solano':                'parcels/solano/Parcels.shp',
              'staging.parcels_sonoma':                'parcels/sonoma/PAR_PARCELS.shp',
              'staging.boundaries_blocks':             'boundaries/blocks/block10_gba.shp',
              'staging.boundaries_block_groups':       'boundaries/block_groups/blockgroup10_gba.shp',
              'staging.controls_block_controls':       'controls/block_controls/block10_gba.shp',
              'staging.controls_block_group_controls': 'controls/block_group_controls/blockgroup10_gba.shp',
              'staging.environment_water_bodies':      'environment/water_bodies/OCEAN_BAY.shp'}

# Set log level to INFO to see informational messages.
logging.basicConfig()
logger = logging.getLogger('spandex.load')
logger.setLevel(logging.INFO)

# Load shapefiles specified above to the project database.
loader = TableLoader()
loader.load_shp_map(shapefiles)


    

    




INFO:spandex.utils:Loading table controls_block_group_controls (SRID: 26910) from file controls/block_group_controls/blockgroup10_gba.shp (encoding: UTF-8).
INFO:spandex.utils:Loading table parcels_contra_costa (SRID: 2227) from file parcels/contra_costa/CAD_AO_ParcelPoly_0410.shp (encoding: UTF-8).
INFO:spandex.utils:Loading table environment_water_bodies (SRID: 26910) from file environment/water_bodies/OCEAN_BAY.shp (encoding: LATIN1).
INFO:spandex.utils:Loading table parcels_marin (SRID: 2872) from file parcels/marin/Marin_2006_CWP.shp (encoding: LATIN1).
INFO:spandex.utils:Loading table parcels_contra_costa_pt (SRID: 2227) from file parcels/contra_costa_pt/CAD_AO_ParcelPoints_int0410.shp (encoding: UTF-8).
INFO:spandex.utils:Loading table parcels_sonoma (SRID: 2226) from file parcels/sonoma/PAR_PARCELS.shp (encoding: LATIN1).
INFO:spandex.utils:Loading table boundaries_block_groups (SRID: 26910) from file boundaries/block_groups/blockgroup10_gba.shp (encoding: UTF-8).
INFO:spandex.utils:Loading table boundaries_blocks (SRID: 26910) from file boundaries/blocks/block10_gba.shp (encoding: UTF-8).
INFO:spandex.utils:Loading table parcels_solano (SRID: 2226) from file parcels/solano/Parcels.shp (encoding: LATIN1).
INFO:spandex.utils:Loading table controls_block_controls (SRID: 26910) from file controls/block_controls/block10_gba.shp (encoding: UTF-8).
INFO:spandex.utils:Loading table parcels_napa (SRID: 2226) from file parcels/napa/Napa_Parcels.shp (encoding: LATIN1).

In [5]:

    

# Reproject to project SRID.
staging = loader.tables.staging
conform_srids(loader.srid, schema=staging)


    

    




controls_block_group_controls geom 3740
parcels_solano geom 3740
parcels_contra_costa_pt geom 3740
boundaries_block_groups geom 3740
parcels_marin geom 3740
parcels_contra_costa geom 3740
boundaries_blocks geom 3740
environment_water_bodies geom 3740
parcels_napa geom 3740
parcels_sonoma geom 3740
controls_block_controls geom 3740