Tagged Questions
PostgreSQL is an open source object-relational database system.
1
vote
0answers
14 views
clustering points in postgresql to create contour map
I have a postgresql / postgis table with a grid of weighted points, and I'd like to essentially create a contour map of those points. My goal is to get one or more polygon that surrounds points of a ...
0
votes
1answer
22 views
Can't create view in postgresql
I have a PostgreSQL table containing some point of interest data. I have a second table with overlapping continent polygons. The following code splits the POI into the continents, but instead of ...
-1
votes
1answer
34 views
Shortest Path Dijkstra
I would like to calculate the shortest path with dijkstra algorithm.
sample query
SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra('
SELECT gid AS id,
...
0
votes
1answer
23 views
How to cut/split multipolygon with blade (linestring) into two pieces using PostGIS? [on hold]
I struggle to do split operation in postgis I tried to build a query but Im always fail.
Id like to cut a multipoligon with a blade (a linestring) into two pieces. These two objects have specific ...
1
vote
0answers
12 views
plpgsql | insert into a table a RECORD data type variable (NEW varieble) [migrated]
I would like in a trigger insert into a table a RECORD data type variable (NEW variable). What would the sql look like?
I've tried so far with the following attempts without success:
EXECUTE 'INSERT ...
3
votes
1answer
54 views
Importing multiple shapefiles into single PostGIS table
I have a folder full of shapefiles that I want to import into a single PostGIS table. This table should have the following columns:
id, filename, multipolygon
I can bulk import all shapefiles using ...
3
votes
1answer
46 views
PostGIS intersection function
I have a problem with intersection function. I built my query following http://manual.linfiniti.com/en/postgis/geometry.html, 5.7 section.
I made my clip object, a red linestring frame:
But after ...
1
vote
1answer
25 views
Error: Coordinate values are out of range [-180 -90, 180 90] for GEOGRAHY type on Postgis?
when I run a query on Postgis
select st_astext(ST_SetSRID(f.geom,4326) ),st_astext(st_centroid(ST_Transform(b.wkb_geometry,4326))) from a,b where ST_Distance_Sphere( ...
0
votes
0answers
56 views
How to insert shapefiles from Google Maps into PostgreSQL database using QGIS? [on hold]
I have already tried a few shapefiles which are available online but they are old or not proper.
I want the shapefiles of present Mumbai with traffic data analysis (cost of any edge from source to ...
0
votes
2answers
54 views
PostgreSQL function does not exist
I have PostgreSQL 9.2 with Pgrouting extension, but when I want to call a function(pgrouting)
does not work.
Id like to compute the shortest path between two point.
SELECT gid, AsText(the_geom) AS ...
1
vote
0answers
36 views
pgrouting php problem “pg_fetch_result(): Unable to jump to row 0 on PostgreSQL result index 3”
I'm trying to build a simple routing web-app using pgrouting, followed some tutorial and the latest workshop. Because I'm using PostgreSQL 9.3(x64), Postgis 2.1.1, and pgrouting 2.0 so I did some ...
1
vote
1answer
37 views
+50
case insesitive CQL-openlayers filter
I have the following filter in openlayers 2.13
var filter_c = new OpenLayers.Filter.Comparison({
type: OpenLayers.Filter.Comparison.LIKE,
property: 'p_name',
value: ...
0
votes
0answers
18 views
How to force dropping a table/Index
I was working to import CSV Files into PostGres.
CREATE TABLE NY(Name varchar,Latitude float,Longitude float);
COPY NY FROM 'data/NY.csv' DELIMITERS ',' CSV;
ALTER TABLE NY ADD COLUMN gid serial ...
3
votes
1answer
47 views
how to snap two line vertex in two different layers used in QGIS
I want to snap between two poly-lines from 2 different layers (Layer1 in Brown and Layer 2(postGIS layer) in Pink color- ), but my snap option don't work. I have changed the tolerance to different ...
0
votes
0answers
39 views
Indoor mapping with floor plans and item(s) to track
Warning: GIS noob here.
Essentially I want to be able to create a floor plan for a given room. Consider the following image of a floor plan in image format:
I would have the measurements of every ...
