Tagged Questions
info
newest
frequent
votes
active
unanswered
PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
learn more… | top users | synonyms
0
votes
1answer
18 views
Why is raster data in range 0-255 in PostGIS?
I'm having trouble interpreting some data I've loaded into a PostGIS database. I scraped rasters from here and converted to sql files using raster2pgsql. I'm now using PostGIS's special functions to ...
postgis raster postgresql raster2pgsql
asked 3 hours ago
lin_bug
1
1
vote
0answers
9 views
How to use ST_Difference to create linestrings from non-intersecting polygon boundaries?
There are two tables with polygon features in my PostgreSQL database. I want to create linestring features where the boundries of the polygons are not intersecting.
CREATE TABLE schema.poly_a
(
gid ...
qgis postgis postgresql linestring differences
asked 4 hours ago
Lunar Sea
73112
1
vote
0answers
6 views
QGIS crashes when using PostgreSQL/PostGIS triggers
When using PostgreSQL/PostGIS triggers saving layer edits gets slower and slower every time when saving a layer edit. This issue occurs after a few up to a few dozen saved layer edits. Finally QGIS ...
qgis postgis postgresql trigger
asked 5 hours ago
Lunar Sea
73112
-2
votes
0answers
19 views
no generate file [on hold]
por favor necesito ayuda.
tengo este codigo. esta en java.
conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgis_23_sample","postgres", "admin");
conn.setAutoCommit(false);
...
postgis
asked 5 hours ago
Carlos Alberto Rojas Casique
23
0
votes
0answers
31 views
How to check the encoding in the .dbf files?
I am having difficulties when I try to load a shapefile into my database, the is because I do not know the encoding of the dbf portion of the shapefile.
The attribute tables are in Spanish, I have ...
qgis postgis dbf encoding
asked 7 hours ago
B.J. A.A.
285
0
votes
1answer
25 views
Can't create PNG file with “st_png” function PostGIS and Java
I have this code in Java:
conn = DriverManager.getConnection ("jdbc: postgresql: // localhost: 5432 / postgis_23_sample" "postgres", "admin");
conn.setAutoCommit (false);
String s = "SELECT ...
postgis java
asked 9 hours ago
Carlos Alberto Rojas Casique
23
3
votes
2answers
31 views
How can I cluster all points in a postgis table together based on their distance from each other?
I have a PostGIS (in postgres 9.3) table which has Points. I want to figure out the "clusters" in the data. If 2 points are < X distance apart, they should be added to a cluster, and this should be ...
postgis postgresql sql clustering
asked 11 hours ago
Rory
244310
1
vote
1answer
15 views
PostGIS update statement returns wrong information
I have two tables in postgis with polygon data. Both are in wgs84. I want to update a column (column1) in the one table (table1) with information from a column (column2) in the other table (table2), ...
postgis sql
asked 17 hours ago
Thunderbolt
368114
1
vote
0answers
26 views
Performing raster calculations with more than two bands in PostGIS?
We need to perform raster calculations using more than two bands in PostGIS. At the moment, ST_MapAlgebra has a two-band form but doesn't support more than that.
I'm open to any solution others ...
postgis raster gdal
asked 21 hours ago
dadbot
263
0
votes
0answers
24 views
How to “INSERT” geotiff raster into postgresql/postgis table using psycopg2
Can someone walk me through how to insert a raster into a prebuilt postgresql table? The table has the postgis extension and I've been able to manually insert a geotiff using raster2pgsql, but I would ...
python postgis postgresql raster-conversion psycopg2
asked yesterday
GISUser9
10310
0
votes
0answers
15 views
GeoDjango, distance filter based on database column
I have a geodjango model with fields
coverage = 10 * 1609.344
reference_point = Point(-72,45) #or some other lat lng
class ServiceArea (geo_models.Model):
center = ...
postgis distance geodjango circle django
asked yesterday
kennethj
62
2
votes
1answer
22 views
Select a subset of a PostGis table
I'm using a big table imported by a *.shp file of the city of San Diego. When I run pgr_dijkstra it takes more or less 5000ms, even for small distances. I was thinking, in order to improve ...
postgis postgresql pgrouting
asked yesterday
tvieira
566
1
vote
0answers
10 views
PostGIS: Find nearest point given coordinates from another table
So I have two tables, one table is called stores which has the name of the store as well as the geom column that contains the coordinates for the stores. The other one is customers which has the ...
postgis
asked yesterday
Minh Mai
1598
4
votes
0answers
23 views
Wrong coordinates after loading OSM to postgre
After loading OSM data for whole Europe to postgres (Osm2pgsql) I'm trying to add them to Geoserver, but the coordinates are totally wrong. The SRS is correct (4326), but the coordinate values are ...
postgis geoserver postgresql openstreetmap
asked yesterday
Anna
212