Tag Info

New answers tagged

0

The Issue was resolved with a fresh installation of OSGeo


3

One of the best place to search and explore source code for PostGIS is through the GitHub mirror: https://github.com/postgis/postgis For instance, search ST_DWithin, where you will then search LWGEOM_dwithin, then lwgeom_mindistance2d_tolerance, then lw_dist2d_comp, then lw_dist2d_recursive, and then different versions of lw_dist2d_distribute* ...


0

A self-join allows you to operate on the relationship between pairs of two features. But I don't think you're interested in pairs: for each feature, you want to operate on the relationship between that feature and all other features in your dataset. You can accomplish this with a subquery expression: CREATE TABLE parcels_trimmed AS SELECT id, ...


1

A better way to explore changing projections is just to work in QGIS. Load both your datasets, and ensure your 'correct' one has the right coordinate system defined. Do this by double clicking on the layer, going to the general tab of the properties, and ensuring the coordinate reference system is set correctly. Now ensure that you have enabled 'on the ...


3

Setting aside the GeoJSON serialization, the following takes about 6.3 seconds on my laptop: SELECT ST_MakePolygon( ST_ExteriorRing( (ST_Dump( ST_Union( ST_Buffer(geom, 20, 2)))).geom)) FROM bz_edges Looking at the data in OpenJUMP, I noticed quite a bit of detail in the street segments, relative to the desired level of ...



Top 50 recent answers are included