How to Import/Export Shapefile into Databases with PostGIS Manager | Part 3 | English Subtitles
Material for Practice: https://gisschools.com/course_details...
In this third part of the "Learn Spatial Databases with PostGIS and QGIS" series, delve into the process of importing shapefiles into a PostgreSQL database using PostGIS Manager. Understand the structure of shapefiles, their components, and how they are essential for storing attribute and geometric data. Follow along as we import shapefiles into the database, configure spatial references, and explore the PostgreSQL environment.
Chapters:
0:00:19 - Introduction
0:00:33 - Understanding Shapefiles
0:01:06 - Components of a Shapefile
0:01:29 - Shapefile Formats
0:02:37 - Exploring Shapefile Contents in QGIS
0:04:10 - Accessing PostgreSQL via PGAdmin
0:04:45 - Creating a New Database in PGAdmin
0:05:21 - Creating a New Database via Query
0:06:34 - Configuring Database Security
0:07:58 - Exploring Database Schema
0:09:06 - Introduction to Query Builder
0:10:58 - Integrating PostGIS with PostgreSQL
0:14:47 - Importing Shapefile with PostGIS Bundle
0:17:48 - Importing Shapefile into Database
0:21:42 - Checking SRID and Geometry Type
0:22:22 - Viewing Geometry as Text
0:23:53 - Exporting Table as Shapefile
0:24:38 - Verifying Exported Shapefile in QGIS
Complete Course : Learn Spatial Databases with PostGIS and QGIS
1) How to Install PostgreSQL | Learn Spatial Databases with PostGIS and QGIS
• How to Install PostgreSQL | Learn Spa...
2) How to Install PostGIS | Learn Spatial Databases with PostGIS and QGIS
• How to Install PostGIS | Learn Spatia...
3) How to Import/Export Shapefile into Databases with PostGIS Manager
• How to Import/Export Shapefile into D...
4) How to Import / Export Shapefile from QGIS DB Manager into PostGIS
• How to Import / Export Shapefile from...
5) Working with PostGIS By using pgAdmin and QGIS DB Manager
• Working with PostGIS By using pgAdmin...
6) PostgreSQL Backup and Restore Spatial Database with PGAdmin4
• PostgreSQL Backup and Restore Spatial...
7) Postgres: SQL SELECT Statement | PostGIS and QGIS | Eng Subtitles
• Postgres: SQL SELECT Statement | Post...
8) PostgreSQL: The WHERE clause | Learn Spatial DB with PostGIS and QGIS
• PostgreSQL: The WHERE clause | Learn ...
9) Aggregate Functions and GROUP BY | Learn Spatial DB with PostGIS, QGIS
• Aggregate Functions and GROUP BY | L...
10) Multi Table Joins in PostgreSQL | Learn Spatial DB with PostGIS, QGIS
• Multi Table Joins in PostgreSQL | L...
11) The CASE Statement, DataType and Operators in Postgres | PostGIS, QGIS
• The CASE Statement, DataType and Oper...
12) Spatial Reference ID and Geometry Field in PostGIS | PostgreSQL, QGIS
• Spatial Reference ID and Geometry Fie...
13) Spatial Queries - Working with Geometries PostGIS | PostgreSQL | QGIS
• Spatial Queries - Working with Geomet...
14) Measurements Area, Length in PostGIS | Geography vs Geometry
• Measurements Area, Length in PostGIS...
15) Find latitude, Longitude (X,Y) from Multi-Geometry in PostGIS
• Find latitude, Longitude (X,Y) from M...
16) How to Handel Spatial Relationships of GIS Objects in PostGIS | PostgreSQL
• How to Handel Spatial Relationships o...
17) Spatial Joins with Multi-Table in PostGIS | PostgreSQL
• Spatial Joins with Multi-Table in Pos...
18) Geometry Processing Functions and Spatial Joins in PostGIS | QGIS
• Geometry Processing Functions and Spa...
19) Step-by-Step: Create Spatial Tables & Add Geometry Columns in PostGIS with QGIS
• Step-by-Step: Create Spatial Tables &...
20) How to Create Spatial and Attribute Indexes in PostGIS with QGIS
• How to Create Spatial and Attribute I...
21) How to Add Geometry to a Feature Using the INSERT Statement in PostGIS with QGIS
• How to Add Geometry to a Feature Usin...
----------------------------------------
#Shapefile #PostgreSQL #PostGIS #QGIS #GISDevelopment #Spatial #Database
------------------------------------------
-----Searching Topics:------
------------------------------------------
Learn PostgreSQL Tutorial - Full Course for Beginners.
PostgreSQL Tutorial For Beginners | Learn PostgreSQL | Introduction to PostgreSQL.
PostgreSQL Tutorial For Beginners In Hindi Introduction to PostgreSQL.
Introduction to PostGIS.
PostgreSQL (Postgres) - Installation & Overview |¦| SQL Tutorial |¦| SQL for Beginners.
What is PostgreSQL?.
Learn Database Administration - PostgreSQL Database Administration (DBA) for Beginners.
How to Set Up PostgreSQL and Create Databases(Step by Step).
Intro To PostgreSQL Databases With PgAdmin For Beginners - Full Course.
How to Install and Setup PostgreSQL on Windows 10.
MYSQL vs POSTGRESQL vs SQL SERVER | LET'S CHOOSE THE BEST DATABASE.
PostgreSQL performance in 5 minutes.
SQL For Beginners Tutorial.
Getting started with PostGIS - Installation.
Geolocations Using PostGIS.
------------------------------------------
------------Contact Me:------
------------------------------------------
Email: [email protected]
Website: https://gisschools.com/
Website: https://gisittools.com/
Facebook: / gisandittools
Instagram: / sohailgoheer
Please Subscribe to my Chanel @GISSchools
Watch video How to Import/Export Shapefile into Databases with PostGIS Manager | Part 3 | English Subtitles online without registration, duration hours minute second in high quality. This video was added by user GIS Schools 17 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,889 once and liked it 47 people.