Hot answers tagged postgresql
Postgis is an extension to Postgres, rather than a stand alone application, that provides a spatial data type to Postgres, and provides numerous spatial functions that operate on geometry(ies). Spatial indexing, which you will surely need to find n closest points efficiently, is implemented as an extended R-tree, but the indexing mechanism comes from ...
You have two issues mixed. First: pgRoute, uses precreated topology based on LineString geometry. Such geometry doesn't have direct links on osm Nodes. You could get geospatial points for built route, not osm Nodes. To get Nodes, you could build an index among osm Nodes geometries and perform distance lookup. In other words, select all nodes which are not ...
You need to use osm2psql for example, if you want to import data, that is not (road) network data. osm2pgrouting only handles linestring geometries and will not work with point data.
You need to also grant privileges for the table's sequence too: GRANT USAGE, SELECT ON SEQUENCE topology_id_seq TO public; Or if you want to provide liberal privileges for all sequences: GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO public;
as you can see in your relation_members table, the member_role belonging to your id ( 57582 ) is 'R' <<-- Relation. So your id (108786) contains another relation. Check: select * from relation_members where id = 57582; to see if there is another relation nested within this one. Your can select the id from the nodes or way table if the corresponding ...
Your Reader and Writer types are incorrect. They should be readers.las and writers.pgpointcloud, respectively. The name change happened here: https://github.com/PDAL/PDAL/commit/b7cde7e1fb13f28db1de7797dbb31392db1f7dfc. You can run pdal --drivers to get a complete list of drivers supported on your system.
Only top voted, non community-wiki answers of a minimum length are eligible