Limitations of PostGIS Shapefile Import GUI tool?

I would like to improve my knowledge regrading this issue.

I am using PostgreSQL version 9.5 (x64bit) on Windows 7 Enterprise (x64bit Machine). I have a table containing 3515214 rows of X,Y coordinates and a geometry column. Every time I tried to import this table to my Postgres DB using GUI tool i.e., PostGIS Shapefile and DBF Loader 2.2, I found some missing x, y values in this table when I viewed the data in SQL editor using:

Select * from my_table; 

I cross-checked for missing geometry values as well like this:

SELECT COUNT(*) FROM my_table WHERE geom IS NULL; 

The count result was zero means no missing geometry values. However, when I checked for X coordinate:

SELECT COUNT(*) FROM my_table WHERE x IS NULL; 

There were 89k+ missing x (and y) values. I am aware that I can use shp2pgsql() or ogr2ogr() tool as well but I am not sure how these will work for this large dataset. However, my point is: are there any limitations in using GUI tool while importing a large table? How may I tackle with this ambiguity?

Replay

Category: postgis Time: 2016-07-28 Views: 1

Related post

  • Unable to load Shapefile using pgShapeloader / shp2pgsql-gui (pgAdmin3's PostGIS Shapefile Import/Export Tool) 2013-04-02

    I am trying to load a shapefile (http://dds.cr.usgs.gov/pub/data/nationalatlas/statesp020_nt00032.tar.gz) into PostGIS 2.0.1 using pgAdmin3's PostGIS Shapefile Import/Export Tool. However its not allowing me to import the shapefile, showing the error

  • Error importing Shapefile to PostGIS using Importer GUI 2011-07-06

    I'm trying to import a shapefile into a PostGIS database using the graphical importer. I just installed POSTGRESQL, and PostGIS. The GUI looks like this: After testing that my database worked, I chose the shapefile that I wanted to upload, and then r

  • Is the PostGIS Shapefile Import Manager able to upload to phpmyadmin or only pgadmin III? 2012-11-08

    After trying to import a shapefile into pgadmin III with no success I was wondering how to successfully upload it, but also if it is possible to upload to phpmyadmin instead. In any case, how exactly do I change the encoding so that they are compatib

  • Loading Shapefiles into PostGIS using shapefile import/export manager 2014-02-19

    I am a complete beginner with PostGIS. I've started learning it using the tutorials provided by Boundless. In section 4 of this tutorial where I want to import shapefile in PostGIS, I do not have the PostGIS shapefile Import/Export Manager tool in th

  • Importing shapefile issue postgis. no import made or recognized reference 2016-06-28

    I am doing an exercise where I am about to load shapefiles into i PostGIS-database. I am doing it from an already created database and schema, this will mean that the only new item is the table that is being loaded into the schema and database. I hav

  • Error import ShapeFile shp2pgsql-gui 2012-12-17

    I'm trying to import a shape file to my PostGIS database but I can not, give a look: Importing with configuration: 12mie250gc_sir, public, geom, / home/samuelribeiro/Desktop/MALHA_DIGITAL/ac/12MIE250GC_SIR, mode = c, dump = 1, simple = 0, geography =

  • GUI tools for PostgreSQL/PostGIS? 2013-11-20

    as a cartographer I work with TileMill to visualize geodata. I installed a local PostgreSQL server with PostGIS and osm2pgsql. Everything works fine. Anyhow, I am new to working with servers and the command line approach. So, in learning the basics o

  • Problem in importing shapefile to Postgis with postgis Shapefile manager 2015-01-25

    i have a problem with importing my shapefile to postgreSQL, it's a poroblem with the encoding, here's the screenshot: i tried to change encodingin "options" buti get this message: "Failed in pgui_exec(): ERREUR: séquence d'octets invalide p

  • Install the Pgadmin3 shapefile importer plugin on a Mac(10.8)? 2013-05-23

    I'm new to GIS related things and I'm setting up a Postgre/Postgis database for geospatial queries. I'd like to import various shapefiles into the database and I found that Pgadmin3 has a shapefile importer. How do I install the shapefile import plug

  • PostgreSQL Shapefile import failed 2016-06-28

    I am very new to PostGIS/PostgreSQL. In fact, I downloaded it because of the answers I got to this question: Distance between centroid and farthest point of polygon I installed both PostgreSQL and PostGIS. But I am not able to import a shapefile to t

  • GUI tool to configure ldap client 2010-11-25

    I am using this wiki to configure LDAP client in Ubuntu. Now i am looking for a GUI tool to configure LDAP client in Ubuntu. Because my colleagues( They don't have much technical knowledge) often complains that configuring LDAP client in ubuntu is li

  • Using Gui tools and arcpy.mapping 2011-10-05

    For a project I want to create a little program that does simple things like export a map from the python command line, but also users are able to edit said map (without having to open arcmap) e.g change font text, replace a street name with another

  • How can I enable PostGIS Shapefile and DBF Loader 2.0 plugin in PgAdmin III? 2013-06-13

    I am on Windows and I want to download/enable the plugin "PostGIS Shapefile and DBF Loader 2.0". I installed PostGIS 2.0 using StackBuilder of PostgreSQL installer. --------------Solutions------------- This might be what you need - this is added

  • GUI tool For PowerShell 2013-10-17

    Goal: User PowerShell in a user-friendly approach Problem: I have seen PowerShell using for MS-dos but there is not tool such as Visual studio as PowerShell? Any softeware with GUI for PowerShell with purpose to faciliate the coding approach? -------

  • Postgis shapefile loader 2.1 error: dbf file can not be opened 2013-10-18

    The .shp, .dbf and the rest of files are fine, I open them in QGIS, AGOL with no problem. In fact, I've tried 3 different layers, and get always the same error. Anyone can please help, as I really need to migrate my .shp's to postgis, and have no ide

  • PostGIS Shapefile and DBF Loader - automatically Linked dbf file 2016-06-24

    This is my system: Windows 7 Postgresql 9.5 PGADMIN 3 PostGIS Shapefile and DBF Loader plugin I have imported data from a DBF file correctly with the plugin. My problem: This DBF file changes every day. Is there any option to have the file linked wit

  • Is there a GUI tool for managing VirtualBox drives/machines? 2009-06-03

    Is there a Windows GUI tool (or even a collection of "Send to..." scripts) to manage VirtualBox .vdi drives and/or virtual machines? What I'm looking for is a way to right-click on a drive and clone it without resorting to the command line. A to

  • GUI tools to administer Linux Box 2009-10-28

    What GUI tools do you advise to improve the usability of Linux for those accustomed to doing system administration the windows-way? Users new to Linux often get confused when they need to configure something: editing a text configuration file may see

  • GUI tools for Linux Box administration 2009-11-06

    What GUI tools do you advise to improve the usability of Linux for those accustomed to doing system administration the windows-way? Users new to Linux often get confused when they need to configure something: editing a text configuration file may see

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.257 (s). 13 q(s)