PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
3
votes
1answer
94 views
Visualizing Spatial Query
I'm new to GIS applications and trying to figure out what options I have for visualizing spatial query results that combine raster and vector data using OpenLayers/GeoExt/GeoServer/PostGIS.
A ...
1
vote
0answers
68 views
How to add legend in WFS openlayers
How i can publish WFS openlayer with legend, have tried different examples such as http://api.geoext.org/1.0/examples/vector-legend.js. But when i used tried this fire-bug shows an error=> ...
0
votes
1answer
65 views
Assigning a nearest polygon to a point
I have a point layer of households and a polygon layer of tax lots. I want to assign a nearest tax lot polygon to each household point. Note that as the household points are coded on road, not within ...
0
votes
1answer
32 views
Finding polygon parents
I have a PostGIS table full of polygon geometries.
Some of these polygons are contained inside other polygons in the same table.
I need to find which polygons have parents and self-relate them to ...
0
votes
0answers
39 views
Shooting star algorithm in postgres 8.4 and postgis1.4 showing fatal error and remaining are working fine
When I try to run this shooting star algorithm, the postgis suddenly loosing connection to postgres and showing error no connection to server
SELECT * FROM shortest_path_shooting_star('
SELECT gid ...
5
votes
1answer
158 views
Geometry errors when importing data from ESRI file geodatabase to PostGIS
When I run the following command to import by data from an ESRI fgdb to postgis...
ogr2ogr -f "PostgreSQL" -a_srs "EPSG:28355" -t_srs "EPSG:3857" PG:"dbname=tp_test user=postgres port=54321 ...
2
votes
1answer
44 views
Can Geoserver return the raster value of a lat/lon point
I have a GeoTIFF published by Geoserver 2.2 and being used by Leaflet via WMS. How can I get Geoserver to return the raster value at a lat/long point?
I'm guessing it has to do with using WCS, but ...
1
vote
1answer
66 views
How to find the country in which a point is located?
I have a PostGis database created with osm2pgsql. I am looking for a way to add the country name in which a point is located to the point row. It must work also for countries with enclaves, such as ...
2
votes
1answer
216 views
RT Sql Layer plugin giving an error
I am trying to use the aforementioned plugin with QGIS 1.7 and Postgres 9.0/PostGIS 1.5.
Added a PostGIS spatial layer w/out a problem and then clicked on the RT Sql layer button which displayed the ...
1
vote
1answer
48 views
Incorrectly Projected PostGIS data in TileMill
When I bring PostGIS data in EPSG:900913 into TileMill, my layers end up on other continents.
This is my workflow:
(1) Save shapefiles in QGIS to EPSG:900913
(2) Import the shapefiles using PostGIS ...
4
votes
3answers
340 views
How to efficiently find points within an elliptical area?
Using PostGIS 2.0.0 I need to filter the results of a function, which returns many POINTs, to find the ones that lie within an elliptical area defined by two points and a distance (all parameters ...
2
votes
0answers
16 views
Spatial overlay data from many lines into a single line
Hello I have joined lines in my data set into longer lines (based on similar attributes) to reduce the number of rows in my data set. Now I want to take the information from the original smaller lines ...
0
votes
1answer
40 views
Wrong projection on WFS layer with OSM baselayer [duplicate]
I am trying to add a vector layer with a WFS protocol.
var wfs = new OpenLayers.Layer.Vector("WFS", {
strategies: [new OpenLayers.Strategy.BBOX({resFactor: 1})],
...
1
vote
1answer
128 views
How to create routable network by pgrouting with assign_vertex_id?
I'm trying to create the routable network as per http://underdark.wordpress.com/2011/02/07/a-beginners-guide-to-pgrouting/and use assign_vertex_id. Do I still need to create the node table? How would ...
1
vote
1answer
66 views
Win7 Senior users_Which pgRouting and postGIS versions are stable with postgreSQL8.4?
I'm working on a postgreSQL ,postGIS and pgRouting project on Windows 7
I need to work on a stable version (no time for risks), and I can see that many people are asking the same question many ...
0
votes
0answers
137 views
why preview image is blank for ImageMosaicJDBC (postgis raster) layer?
I follow http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html to publish a ImageMosaicJDBC layer in geoserver.
the layer seems published ok and saved, but the preview of this layer ...
1
vote
5answers
131 views
Unable to install the PostGIS extension to PostgreSQL on Ubuntu 12.04 LTS
I just installed Linux Ubuntu 12.04 LTS (on a virtual machine). I then successfully installed the PostgreSQL 8.4 database management system. I am now trying to install PostGIS, which is an extension ...
1
vote
1answer
101 views
How to link pgrouting edges with street names to rout user based in street names?
I have installed postgreSql + postGis + pgrouting and I have loaded OSM data into my database using osm2po and shp2pgsql. How can I search for points in the map using the street names and then route ...
2
votes
1answer
33 views
How to install multiple versions of postgres in same os windows 7 64-bit?
I have already installed PostGIS along with opengeosuite and it is the latest version. Now I want to run pgrouting but the latest stable version does not compatible to the latest postgres versions. ...
-3
votes
0answers
49 views
What versions of Postgres, PostGIS and pgRouting shall I use on a 64bit windows os? [closed]
Please give me the links and stepwise instructions briefly for installing all the three.
Condition : There shouldn't be any bug in shooting star algorthm. So the comaptable stable versions of the ...
0
votes
0answers
27 views
Join Geological Linework based on shared attributes while obeying rules
I'd like to join all adjacent geology faults within a table if they share the same attributes in f_type, f_class, f_name and f_conf columns. However I don't want to join adjacent lines with equal ...
4
votes
1answer
164 views
Stamen toner postgis setup
I'm trying to render Stamen's toner map with Landez which uses Mapnik. The style I'm rendering is from Stamen's toner project. I'm using the one which only renders labels (no lines). I imported the ...
1
vote
2answers
70 views
Public PostGIS Server available?
can anyone point me to a (if possible at all) list of public PostGIS Servers, where one can set up it's own database/tables ?
It's just that I would need a PostGIS 24h on, while dont having these ...
1
vote
1answer
137 views
postgis distance calculation between points with lat, long coordinates
Team,
I am new to postgis, but a postgres user for quite a while. I would like to compare
the geospatial capabilities between postgresql and mongodb.
I have the lat.lon, zip code of US locations;
...
0
votes
2answers
93 views
I can't export in QGIS a Shape file to PostGis
When I try export a pipe network shape to postgis i get this error:
Problema inserindo feições do arquivo:
C:/PP/gvSIG_Projects/Shapes/Abastecimento/QGIS_VATROCOADUTOR.shp
Ocorreu um erro no banco ...
2
votes
3answers
70 views
Connnect to PostGIS db using QGIS - when not on localhost
I"m just getting started with PostgreSQL/PostGIS db (v9.2) and I'm wanting to connect to db while not on the localhost using QGIS. I've been able to connect successfully on localhost, however I'm not ...
0
votes
1answer
50 views
raster2pgsql missing in Opengeo-suite installation
I installed opengeo-suite 3.0.2 on Ubuntu 12.04 and although the stack seems to be working fine, raster2pgsql is no where to be seen!
root@mywebsite:/usr/local/lib/postgresql/9.2# locate raster2pgsql
...
1
vote
1answer
50 views
Does each road segment need to be digitized into a separate entry for a road network?
I am trying to understand this code in pgRouting for creating topology:
CREATE OR REPLACE VIEW road_ext AS
SELECT *, startpoint(the_geom), endpoint(the_geom)
FROM road;
CREATE TABLE node AS
...
0
votes
0answers
40 views
Identifying Intersections of Geology using PostGIS
I'm having problems identifying intersections on a layer of linework, the lines are representative of contacts and faults (geological rock formations). I am trying to select where there are connected ...
0
votes
0answers
40 views
What are the rules for digitizing roads for creating a road network?
I want to create shortest route tool using pgRouting. But I digitised roads in a random manner. Shall I need to give a separate row for each road segment?
1
vote
1answer
137 views
Quantum GIS returns “Invalid Layer” message when trying to add Postgis view
I'm new to Postgis and Quantum GIS. I created a view defined as
CREATE OR REPLACE VIEW pupr.vstudentmuni AS
SELECT m.id AS munid, m.name AS muname, m.geom, s.code,
(s.name::text || ' '::text) ...
0
votes
0answers
60 views
QGIS SPIT errors loading shapefile into PostGIS
With QGIS 1.8 on Windows 7, I just installed PostgreSQL / PostGIS and tried to load my first data into it, a shapefile using SPIT, but failed:
ERROR: Geometry type (Polygon) does not match column ...
3
votes
1answer
37 views
How can I check if a multipolygon can be represented as a simple polygon?
I have a large (30m+ records) spatial data set I have imported into a PostGIS database. I did not expect to find multipolygons in the data set, but it does have a few of them. I'd like to take a ...
0
votes
0answers
25 views
not able to view imported .tif file in geoserver
I am using geoserver. I have imported a .tif file using postgis, which has been saved in vector type layer in geoserver. Now, whenever, I preview it, the layer gets automatically downloaded as wms ...
0
votes
0answers
50 views
Add dynamic layer to geoext tree
I'm trying to add a dynamic OpenLayers Layer in a folder(children) of tree.
I've tryed the following code and it works, but I don't know how to associate the layer with a layer of OpenLayers() type:
...
0
votes
0answers
15 views
view the imported .tif file on geoserver [duplicate]
I am using geoserver. Using raster2pgsql, I have imported a .tif file in database. However, now, when I'm trying to import that .tif file in geoserver using postgis, I'm unable to preview it, since ...
0
votes
2answers
61 views
How to create a new column to store the length of a linestring in postgis?
I am working with pgRouting, following this nice guide：A Beginner’s Guide to pgRouting
I am now in this step：Calculating shortest routes, with these codes below
SELECT * FROM shortest_path('
SELECT ...
5
votes
2answers
80 views
Which function for creating a POINT in PostGIS?
When defining a Point in PostGIS, when do you decide to use which of the following?
ST_SetSRID(ST_MakePoint(lon,lat),4326)
ST_SetSRID(ST_Point(long,lat),4326)
ST_SetSRID(ST_GeomFromText('POINT(lon ...
2
votes
1answer
53 views
point of intersection issues
I have a table containing a set of points of intersections.
Most of the roads intersects whith just one road BUT i have some roads which intersects with two, therefore three different point of ...
3
votes
1answer
113 views
How to import QGIS Raster into PostGIS
I have created a IDW heatmap using QGIS 1.8.0 and need to import the raster into PostGIS 2.0.1. QGIS saves the raster layer as a .asc file.
How do you import the raster into PostGIS as a Raster? What ...
5
votes
3answers
97 views
What is the easiest one click install method for PostGIS and it's entire dependencies?
For someone new to database servers and their dependencies, what is the easiest assured way of installing PostGIS on a machine with no other software beyond what comes with its operating system? I'd ...
2
votes
1answer
71 views
Get the lines between all points of a polygon in PostGis : avoid nested loop?
I am trying to get all the lines between the points of a polygon, by writing PostGreSQL functions. I have written the two following functions that do the job fine :
the first function to get all the ...
1
vote
2answers
55 views
Where can I get public transportation locations for USA
I am trying to find a list of all public transportation/transit locations like subway stations, airports, bus terminals and bus stops for USA. Only major transit locations are required, rural bus ...
1
vote
1answer
70 views
How to visualize pgrouting query results in mapguide open source
I would like to make a spatial query using postgis 2.0 and pgrouting 1.05 then visualize results in Mapguide open source.Any suggestions?
1
vote
0answers
54 views
Creating polygons for a choropleth map using PostGIS
I have a grid of points, each with a value to it as shown in the image below. The data was retrieved from PostGIS and rendered in Quantum GIS. The final result should be a polygons of a choropleth map ...
0
votes
0answers
55 views
How to fix 'pgsql2shp: command not found' in PostGIS Query Editor Plugin?
I'm using QGIS 1.8 on Macbook Pro running OSX 10.8.3 and I am having difficulty using the PostGIS Query Editor plugin.
When I try and execute a query in this plugin I get the following error in the ...
1
vote
0answers
89 views
How can I map data points to OpenStreetMap (OSM) line data?
my goal is to filter measuring points of vehicles by mapping them to streets.
So I could filter out all the false data located in fields and rivers and so on.
I imported my data into a PostGIS ...
0
votes
2answers
55 views
Is PostGIS doing a full table scan?
I am trying to retrieve all points p that are within polygons c. While building the query, I came across this strange behavior.
Question: Why does query 2 takes so long compared to query 1? Is it ...
1
vote
0answers
76 views
PostGIS Better ST_Intersects Query
I am currently using the following queries to return all features that intersect a large and complex polygon. I initially tried to use a single ST_Intersect query but because the number of features it ...
2
votes
2answers
104 views
PostGIS: Convert meters to arbitrary spatial reference units?
I'm writing a query that needs to be able to work with data of any SRID. The basic problem is very simple - I get two pieces of information:
A point (SRID = 900913)
A distance (unit = meters)
I ...
