Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 148560

PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.

5 votes
1 answer
378 views

ST_SnapToGrid takes a long time on

Created a second column named "snapped_geometry" that is the location_point snapped to a postGIS grid. …
GNG's user avatar
  • 441
3 votes
1 answer
267 views

Clustering geometry points, return a point's label if the point does not belong to a cluster?

With SQL and postGIS functions, I would like to fetch clusters and the name of any point that is the only point in a cluster. I am nearly there. …
GNG's user avatar
  • 441
2 votes
0 answers
960 views

Upgrade to PostGIS 3.0 in pgAdmin

I would like to use the new ST_TileEnvelope() function from PostGIS 3.0. My current version is 2.4.4. I would like to update to PostGIS 3.0 in pgAdmin. Is this possible? … I initially installed our older version of postGIS (2.4.4) with no postGIS file on my computer. Nevertheless, I downloaded postgis-3.0.0 and I can now find this folder in the Windows File Explorer. …
GNG's user avatar
  • 441
1 vote
1 answer
236 views

US Census block boundaries shapefile [closed]

I am searching for a single file of all roughly 11 million US census blocks. Where can I find this?
GNG's user avatar
  • 441
0 votes
0 answers
969 views

Downloading Census data to PostgreSQL PostGIS TIGER extension for Amazon RDS database

I followed these instructions in the command prompt on my Windows machine ... https://sparkgeo.com/blog/building-a-us-census-tracts-postgis-database/ When I got up to mget *, the ftp connection responded …
GNG's user avatar
  • 441
0 votes
0 answers
43 views

Importing shapefile into PostgreSQL failing [duplicate]

I installed the PostGIS extension as well. I would like to import a shapefile and am using shp2pgsql-gui to do so. The import is failing and there is no explanation why. Any ideas? …
GNG's user avatar
  • 441