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.4.tar.gz
(3.4 kB
view hashes)
Built Distribution
Close
Hashes for SeismicFoldDbGis-0.0.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ed8fd9acc45f4ced0f57ba63cf11ff3d812b86f82fe7df60f7c4e3bbb654e64b |
|
MD5 | 5129412da1488731813ed3e93819579c |
|
BLAKE2b-256 | 103a0500ed7123fbc596906e095647d2421347632cb839ddd1d08dabfb077477 |