Reputation
21,676
Top tag
Next privilege 25,000 Rep.
Access to site analytics
Badges
3 54 91
Newest
 Necromancer
Impact
~888k people reached

22h
answered PostGIS - Linestring doesn't contain a Point - Problem
1d
comment Krovak projection EPSG 5514: Correct data transfer between R and ArcGIS?
the version of GDAL is require(rgdal); rgdal::getGDALVersionInfo()
1d
comment Big datasets in QGIS
Yes, loading the full attribute table in QGIS will take a while, as it is essentially getting the 400 MB minus geometry data from PostgreSQL. With a recent version of QGIS, there is a filter button at the bottom left of the Attribute table. Try changing this to "Show Features Visible On Map", or set a field filter to an attribute of interest. There are a few other tricks to try.
2d
comment Best-practices for databases and APIs with geographic data spanning the antimeridian
One limitation is that a geography should be no longer/wider than 180º (see advanced FAQ). However, you could just use this rule for the vertexes and do something silly like this: LINESTRING(179.9 -17, 60 -16.9, -60 -16.8, -179.8 -16.7), which sort-of wraps around.
2d
revised Best-practices for databases and APIs with geographic data spanning the antimeridian
links
2d
answered Best-practices for databases and APIs with geographic data spanning the antimeridian
2d
comment Krovak projection EPSG 5514: Correct data transfer between R and ArcGIS?
What version of GDAL do you have in R? There were some improvements for Krovak projections for GDAL 2.0.
May
4
revised PostGIS query to get a list of points
edited tags
May
4
revised PostGIS query to get a list of points
multi
May
4
answered PostGIS query to get a list of points
May
1
comment Can I set up a PostGIS store/connection in GeoServer without user password for database?
update: to answer my own suggestion, no jdbc does not use pgpass
May
1
comment Can I set up a PostGIS store/connection in GeoServer without user password for database?
I'm not sure if pgpass work with GeoServer, but it does for many other programs like psql, pgAdmin, ogr and others.
May
1
comment Why can't PHP insert new geometry on PostGIS?
Ah, the SELECT permissions were not granted for the role to see the SRS info from the spatial_ref_sys table. This would cause the odd "SRID (0)" error.
May
1
answered What is the easiest way to avoid shapefile columns being imported as PostGIS `numeric(p,s)` data type?
Apr
27
revised St_ClosestPoint within St_MakeLine Query problem
better tags
Apr
27
comment Postgis query to sort geometries by latitude
PostgreSQL calls this an implicit cast, where the type is automatically converted to match another type used by the function. You can see that the geometry->box2d cast is marked IMPLICIT to enable this handy feature.
Apr
26
revised Decoding POSTGIS dump file
typo
Apr
26
comment Spatial clustering with PostGIS
@maxd no. Given A = πr², then r=√(A/π).
Apr
26
comment How to get WKT for various Spatial Reference Systems?
epsg.io is under active development, and has a good Web API and source code is available. Spatialreference.org is pretty much abandoned since 2013 and is out of sync with updates to spatial reference changes and corrections.
Apr
25
revised Decoding POSTGIS dump file
typo