How to Create Spatial Databases in PostGIS | PostgreSQL | Import Shapefile into the Database
Create spatial databases in PostGIS using PostgreSQL and QGIS. Learn how to import shapefiles and design schema.
View resourceExplore a curated collection of practical spatial database, QGIS, Leaflet, mobile survey and vector-tile projects selected for applied learning.
Work through ten practical GIS and web-mapping projects selected as a focused learning playlist. The Course brings together spatial databases, data conversion, QGIS, Leaflet and mobile survey workflows in a useful project-first sequence.
You will create and populate spatial databases, publish vector data to the web, build interactive maps and explore modern vector-tile delivery with PostGIS and Leaflet.
Create spatial databases in PostGIS using PostgreSQL and QGIS. Learn how to import shapefiles and design schema.
View resourceLearn how to create spatial tables in PostGIS using QGIS DB Manager and digitize directly into your live database.
View resourceUpload shapefiles as spatial data into MySQL using QGIS and FWTools. Step-by-step process without coding.
View resourceImport CSV files and export as shapefiles in PostGIS using QGIS. Learn attribute and geometry conversion.
View resourceGet attribute values from HTML forms and submit to PHP using GET and POST methods. Ideal for web GIS apps.
View resourceLearn how to place a shapefile as a layer on your Leaflet map. No backend, just JavaScript and style!
View resourceWatch what happened when I asked ChatGPT to build a map for me using Leaflet — pure AI-powered fun!
View resourceDesign a full web GIS map from a shapefile in just 2 minutes using QGIS with zero coding required.
View resource