filipkral

import sys, os
sys.path.insert(0, r'C:\OSGeo4W\apps\Python27\Lib\site-packages')
#sys.path.insert(0, r'C:\OSGeo4W\lib')
sys.path.insert(0, r'C:\OSGeo4W\bin')
#os.environ['PATH'] = os.environ['PATH'] + ';' + r'C:\OSGeo4W\lib'
os.environ['PATH'] = os.environ['PATH'] + ';' + r'C:\OSGeo4W\bin'

filipkral

from osgeo import ogr, osr

def read_splt(db):
    drvr = ogr.GetDriverByName('SQLite')
    ds = drvr.Open(db, 0)
    layer=ds.GetLayer('pts')
    for feature in layer:
        print(feature)
        break

filipkral

import sqlite3
from contextlib import closing
import multiprocessing

def prepare_db(db, tbl, col):
    sql = "CREATE TABLE {0} ({1} text);".format(tbl, col)
    with closing(sqlite3.connect(db)) as cnn:
        cursor = cnn.cursor()
        cursor.execute('DROP TABLE IF EXISTS {0};'.format(tbl))
        cursor.execute(sql)

filipkral

# given that you accidentally added a large file to git branch feature/adding, then removed it in another commit, you can reduce the repo size by the following commands
# for more details and alternatives see https://confluence.atlassian.com/bitbucket/reduce-repository-size-321848262.html
git checkout develop
git merge --squash feature/adding
git branch -D feature/adding
#git reflog expire --expire=now --all
git gc --prune=now
git commit -m "Merged"

filipkral

ogr2ogr -f "PostgreSQL" -a_srs "EPSG:4326" -lco SCHEMA=<schema> PG:"host=<ip or hostname> user=<user> password=<password> dbname=<dbname>" -nlt MULTIPOLYGON -nln <table_name> <shapefile_name>.shp