13,707 reputation
13265
bio website sites.google.com/site/mwtoews
location Wellington, New Zealand
age 34
visits member for 3 years, 6 months
seen 2 hours ago

I'm a hydrogeologist. An expert of many random things.


4h
comment postgresql export database with command or pgAdmin III
I don't know much about SDE on PostgreSQL, but the pg_geometry data type will not be touched by PostGIS, just like any other data type, and will be restored on a host DB only if the pg_geometry datatype exists.
7h
answered postgresql export database with command or pgAdmin III
1d
answered How to rename ogr2ogr tables on export to Spatialite?
1d
comment create the postGIS table error No such driver: PostgreSQL
All contact info here: cran.r-project.org/web/packages/rgdal
1d
comment create the postGIS table error No such driver: PostgreSQL
Is your only geometry type Point? If so, then yes there are easier options..
1d
comment create the postGIS table error No such driver: PostgreSQL
The only way to add a PostgreSQL driver is to compile the rgdal package, which is not an easy thing to do. The PGDump option is by far the simplest option, even if it isn't perfect. As I mentioned before, I encourage you to contact the maintainer to kindly ask support for the PostgreSQL driver.
1d
awarded  Guru
2d
comment create the postGIS table error No such driver: PostgreSQL
That's a separate installation of GDAL/OGR. The version used by rgdal is rgdal.dll, which has a bug, so the file needs to be edited as suggested above. Did the edits work?
2d
answered shell script ogr2ogr export
2d
answered Buffer multiple roads to find points within and compare?
2d
comment Find the closest line vertex from the linestring using PostGIS
@user32876 updated answer to convert to MultiPoint
2d
revised Find the closest line vertex from the linestring using PostGIS
closest point and closes vertex
2d
revised Find the closest line vertex from the linestring using PostGIS
ST_ClosestPoint
2d
answered Find the closest line vertex from the linestring using PostGIS
Aug
26
comment How to convert shp to csv
Why bother program and debugging a single-purpose tool when something similar already exists? E.g. ogr2ogr -f CSV -lco GEOMETRY=AS_XY points.csv points.shp made batchable using something like this.
Aug
26
comment create the postGIS table error No such driver: PostgreSQL
The last fix to file.sql is to edit "OGC_FID" to OGC_FID (remove quotes). It can be done with search->replace in most text editors. This is a simple bug in the driver, which I think is fixed for the next version of GDAL/OGR.
Aug
23
comment create the postGIS table error No such driver: PostgreSQL
@zina_GIS you don't have the "PostgreSQL" driver, and it isn't easy to add since it needs to be compiled. A workaround is to use the "PGDump" driver, then load this file in separately.
Aug
23
revised create the postGIS table error No such driver: PostgreSQL
add PGDump method
Aug
23
comment How can I insert a bounding box or polygon in a PostGIS geometry field?
That's not what I said. I was specifically singling out the meaning of a PolygonZ geometry. On the other hand, I think PointZ and LineStringZ are fantastic geometry types for features with elevation.
Aug
21
answered create the postGIS table error No such driver: PostgreSQL