PostgreSQL Tutorial: How to import Shapefile into PostGIS [EN]

[PostgreSQL tutorial] In this video, I will show you and explain step by step, How to add Shapefile into PostgreSQL + PostGIS on Windows 10.

==== What is PostgreSQL ====
PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and technical standards compliance. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server and is also available for Linux, FreeBSD, OpenBSD, and Windows.

==== What is PostGIS ====
PostGIS is an open-source project, and support is available from a number of sources. It is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL and compiles with open geospatial consortium (OGC).

============================

============================
0:30 Import Shapefile
3:45 Open table and display GIS data

============================
GIS4Dev : GIS for beginners
QGIS for beginners, QGIS tutorial, GIS tutorial, GIS web services tutorial, WMS tutorial, WMTS tutorial,
WFS tutorial, WCS tutorial, Google Earth Engine tutorial, ESRI ArcGIS tutorial, Postgresql tutorial, Postgres tutorial,
PostGIS tutorial, GeoServer tutorial for beginners, GeoServer tutorial, OGC, open source software, Google Maps, How to use Google Maps, Google Map tutorial

============================

============================
Music Credit: LAKEY INSPIRED
Track Name: "Better Days"
Official "LAKEY INSPIRED" YouTube Channel HERE:

License for commercial use: Creative Commons Attribution 3.0 Unported "Share Alike" (CC BY-SA 3.0)

============================
#PostgreSQL #PostGIS #GIS #Shapefile #Extension #Plugin #DBFloader #Windows #PgAdmin4 #geo #geospatial #mapping #geography #spatial

[pattrawuth]

Let's see how to import shapefile into PostgreSQL via Shapefile and DBF Loader.

[lisandro-abulatif]

Thanks! Simple and straight to the point. Helped me a lot!!!

[cedricvumisa]

good job! thank you for sharing your shapefile very useful

[MarombeiroNerd]

you have the program for download?
postgis you used this video?

[emreakdeniz]

Thanks, it is very utilitarian tutorial. May I ask that; I have done everything what you show but I don't see the world-map base behind drawing. How is it possible to success it ?

[mahshidahmadi]

thank you for sharing your information. I have a problem when I clicked import, this massage appeared "Unable to convert data value to UTF-8 (iconv reports "Invalid or incomplete multibyte or wide character")." . what should I do ?? Can you help me ??

[abdelhafidhzarroug]

Pour quoi il me rendre un message "can not be opened.
Shapefile import failed."

[amirullfitri]

hey man I want to ask how to get the srid number I cant find it

[arcgis]

hello dear here is an error accouring when i try to open ArcGis bundle error like libintl-9-.dll