Questions tagged [postgresql]
PostgreSQL is an open source object-relational database system.
515
questions
0
votes
1
answer
608
views
Identify the direction of traveling road segment
I'm using pgRouting to find the least congested path using time as the cost metric. I am using average speed between two nodes to calculate time taken to travel in a segment. In pgRouting there is a ...
- 141
0
votes
1
answer
2k
views
How to add X/Y coordinates and count of overlapping points in a postgresql table?
How to add to my postgres/postgis table the following columns
X coordinate | Y coordinate | count (number of points in same location)
from an existing table populated with geometries type POINT
- 2,328
0
votes
1
answer
142
views
org.geotools.jdbc.JDBCDataStore: add information that is stored with the shape file?
Is there a way to add metadata such as file name and file creation timestamp as separate table columns in the table when org.geotools.jdbc.JDBCDataStore stores a shape file in a PostgreSQL database?
- 125
0
votes
3
answers
966
views
Faster routing algorithm on pgrouting [duplicate]
I have downloaded data for india as a dbf file then converted it using osm2po to make it routable but the problem is when i make any routing query it takes a lot of time around 300 seconds and these ...
- 1
-4
votes
1
answer
828
views
How to use st_touches to get all nearby states [closed]
I have a table with all US states geometrical data:
USstate
-------
state | The_geom (here filling in random value)
AL | 00012312
NM | 000234234
NJ | 0000234534
NY | 00005465
...
- 247