Loads calculated fold from CSV file to GIS database
Project description
Seismic Fold Db GIS
module to load calculated fold from CSV file to GIS database
-
Dependencies:
SQLAlchemy>=1.3.22 GeoAlchemy2>=0.8.4
-
CSV format
- first line is header
- comma separated
- columns order: 'Easting', 'Northing', 'Fold', 'Bin Number', 'Row', 'Column'
-
DB engine connection
- SQLite with spatial extension
def load_spatialite(dbapi_conn, connection_record): dbapi_conn.enable_load_extension(True) dbapi_conn.load_extension('/usr/lib/x86_64-linux-gnu/mod_spatialite.so') db_file = '/some_folder/fold.sqlite' engine = create_engine('sqlite:///' + db_file, echo=True)
- PostgreSQL with PostGIS extension
engine = create_engine('postgresql://user:password@db_host/db_fold')
- SQLite with spatial extension
-
Usage:
engine = create_engine('postgresql://user:password@db_host/db_fold') fold = FoldDbGis(engine) fold.create_table() # to load fold file to empty db fold.load_from_csv(csv_file1) # to update db with fold file that do not overlap previously loaded data fold.load_from_csv(csv_file2) # to update db with fold file that overlaps with previously loaded data (i.e. two adjacent zippers) fold.update_from_csv(csv_file3)
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
SeismicFoldDbGis-0.0.3.tar.gz
(3.3 kB
view hashes)
Built Distribution
Close
Hashes for SeismicFoldDbGis-0.0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b0bc6d3c8cfe03eb574ef3d4ad6ca9355188910da96fac0ee1e94df429b8aafb |
|
MD5 | d9eccaaa203295738f10b511f4f9bd0c |
|
BLAKE2b-256 | 4f71cacafe00903e06b08d0d1b440a5ff1b7db808ca15e9f9332bbfe6a32bb4c |