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.1.0.tar.gz
(3.4 kB
view hashes)
Built Distribution
Close
Hashes for SeismicFoldDbGis-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 738a2f3ccbdf0174b7e2710b75785424290dfbcec65fa65b1eebe0254788ab71 |
|
MD5 | f506795ef5f5cc5a77cf537e9d4ffaf7 |
|
BLAKE2b-256 | 804612c9cccbe993bcd853d57d7e0c111cdcbbbc2e2139cdbcdc37954abaeb25 |