Questions tagged [postgresql]
PostgreSQL is an open source object-relational database system.
515
questions
5
votes
3
answers
13k
views
How to enable SFCGAL in PostGIS?
I have the problem with the enabling extension SFCGAL.
CREATE EXTENSION postgis_sfcgal;
doesn't work for me even I have the PostGIS v2.2.
When I do that, it throws an error
ERROR: could not ...
3
votes
1
answer
1k
views
Find closest polygon from point and get its attributes?
Given a set of points and a set of polygons, I am trying to find for each point what the closest polygon is and bring over the attributes from that polygon to the point (together with the actual ...
30
votes
2
answers
22k
views
In PostGIS is it possible to create a View with a unique ID?
When I create a view in PostGIS is there any way to add a unique ID to that view? Just like the "gid" field in any other PostGIS table?
Edit: Sorry I should have included this in the original post. I ...
27
votes
6
answers
35k
views
Shapefile loader in pgAdmin 4
Recently I have updated my postgresql version. I have also upgraded pgAdmin from 3 to 4. But I was unable to load shapefile. I didn't find any plugin called shapefile loader. How can I get the ...
26
votes
3
answers
8k
views
Publishing PostGIS Rasters in GeoServer?
How do I publish PostGIS rasters using GeoServer?
I have spent a lot of time trying to create a Raster datasource using Image Mosaic JDBC but with no luck.
Steps performed:
1. Downloaded and ...
21
votes
3
answers
10k
views
Identifying road intersections using PostGIS
I'm trying to identify where roads intersect each other, and to make a point at this intersection, with the number of roads that form the intersection listed.
I was wondering if there was some way ...
19
votes
3
answers
8k
views
PostgreSQL trouble editing points / lines / polygons in QGIS
I have a problem with PostgreSQL and QGIS:
I can add points/lines/polygons and fillup field
But I can't :
Delete points/lines/polygons
Modify points/lines/polygons (move or modify field)
ex : ...
17
votes
6
answers
12k
views
Deleting duplicate geometry in PostGIS tables
After - I don't know what happened - all my entries in my PostGIS tables are doubled. I tried this to delete them but it does not delete any/all duplicates:
DELETE FROM planet_osm_point
WHERE ...
13
votes
6
answers
10k
views
PostGIS doesn't use spatial index with ST_Intersects
I imported the data from openstreetmap using osm2pgsql and copied it another table structure. If I made a query for containing rows using st_intersects, st_contain or someone else, postgis don't use ...
12
votes
1
answer
2k
views
Batch load multiple shapefiles to Postgis
According to the shp2pgsql help, the options drop, append, create and prepare are mutually exclusive. So, if I want to create a table from a shape and then append multiple other shapefiles, I do ...
10
votes
2
answers
5k
views
Creating custom Coordinate System in PostGIS
I have a Wayne county Michigan parcel dataset with a custom SRID:
when I bring it into ArcGIS
Projected Coordinate System: NAD_1983_HARN_StatePlane_Michigan_South_FIPS_2113_Feet_Intl
Projection: ...
9
votes
1
answer
5k
views
Using PostgreSQL with QGIS and ArcGIS?
Is it possible to use PostgreSQL with QGIS and ArcGIS? i.e. one database for different clients.
Is it anything that I have worry or any problems to use the DBMS from two different software?
I know ...
7
votes
1
answer
2k
views
Automatically Snapping Points to Closest Part of Line
I have some line points representing manholes. I also have line features representing roads. Both of these features are currently living in a PostGIS database. I'd like to automatically move these ...
7
votes
2
answers
19k
views
What does 'DBMS table not found' message mean?
I have a plain postgressql table (version 8.2). I am trying to connect to it to it from ArcGIS desktop 10.0, and use as a query layer, as given in this document: http://help.arcgis.com/en/...
6
votes
2
answers
19k
views
How to find nearest line from point using PostGIS?
I have a table of Roads in PostGIS which geometry is "geometry(MultiLineString,4326)".
Its attribute are
gid osm_id name ref type oneway bridge maxspeed geom
Now i want to know the ...