Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Artifact ID: | d1f953cf63330714941fe06556b55e00996f8cd1 |
|---|---|
| Page Name: | ZippedSHP |
| Date: | 2020-05-07 15:52:09 |
| Original User: | sandro |
| Parent: | 92e307619c5f458be88dc0a7db871be81a09e62d (diff) |
| Next | 64df71ad6734f958727608ce4e1f6c3dd10bb7d4 |
Content
Back to main SpatiaLite page
Reading SHP and DBF files directly from within a Zipfile
Starting since version 5.0.0 SpatiaLite has the capability to directly read any Shapefile (or DBF file) contained within a compressed Zipfile.Several closely related SQL functions have been introduced as well.
Accessing a Zipped SHP
All these new SQL functions are now supported:- ImportZipSHP(): the main function allowing to import a whole Shapefile into a new Spatial Table into the currently connected Database.
- PROJ_GuessSridFromZipSHP(): a helper fuction for attempting to guess the SRID for a given zipped SHP.
- Zipfile_NumSHP(): a helper function returning the total count of Shapefiles contained within a given Zipfile.
- Zipfile_ShpN(): a helper function returning the basename for the Nth Shapefile contained within a given Zipfile.
We'll now start a quick tutorial about using all these new SQL functions.
SELECT Zipfile_NumSHP ( 'c:/users/afuri/Downloads/Limiti01012020.zip' ) ------------ 4
Accessing a Zipped DBF
All these new SQL functions are now supported:- ImportZipDBF(): the main function allowing to import a whole DBF file into a new Table into the currently connected Database.
- Zipfile_NumDBF(): a helper function returning the total count of DBF files contained within a given Zipfile.
- Zipfile_DbfN(): a helper function returning the filename for the Nth DBF file contained within a given Zipfile.
Back to main SpatiaLite page