Skip to main content

All Questions

Filter by
Sorted by
Tagged with
1 vote
0 answers
442 views

How can I access PostGIS Topologies with C#?

I would like to access a PostGIS Topology with C#. I looked through the nPgSQL PostGIS/NetTopologySuite Type Plugin but didn't see anything. With the word topology appearing in so many places, I may ...
Kirk Kuykendall's user avatar
3 votes
1 answer
121 views

PostGIS - Parse coordinates of st_isvalidreason() to a geometry column

With PostGIS, I'm using st_isvalidreason() function to check topologicals errors in my entities. When something is topologically wrong, it returns me something like: Self-intersection[969880.222423769 ...
GeoGyro's user avatar
  • 1,656
1 vote
1 answer
343 views

PostGIS create topogeom from existing geometry column

I tried to create topogeom using postgis.topology extention. SELECT topology.AddTopoGeometryColumn('roadtopo','public','roads','topogeom ','LINESTRING'); UPDATE roads SET topogeom = topology....
user51044's user avatar
  • 629
1 vote
1 answer
87 views

How to find features from edge_id in PostGIS topology?

I have created topology for a set of tables with PostGIS topology extension. Now, I want to get all linear features (which could be in different tables) connected to a particular line using a non-...
Iman Rosstin's user avatar
1 vote
0 answers
79 views

Create continuous line network using PostgreSQL [closed]

I have shapefile which doesn’t have continuous network. I want to connect it to the nearest line and create continuous line from it. the postgis table has three columns- gid,objectid and geom.The geom ...
poonam patel's user avatar
4 votes
1 answer
298 views

PostGIS topology hierarchal topogeometries

I'm seeking guidance on how to correctly organise hierarchal topogeometries. I'm working through PostGIS in Action's chapter on topology and, in summary, it sets up two tables with topogeometries, ...
Gordon's user avatar
  • 41
2 votes
0 answers
149 views

PostGIS topology for merging lines?

I know PostGIS Topology supports splitting road edges while creating a network. I was wondering if PostgIS topology can do the opposite and merge two lines? Does it support merging two consecutive ...
tinlyx's user avatar
  • 11.2k