PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.

learn more… | top users | synonyms

0
votes
1answer
75 views

pgRouting not returning node with correct z-value

have an issue with pgRouting that I've modified to consider multi-floor indoor areas. I've created a mock floor plan of any typical hotel. I copied the floor plan and assigned a different z-value to ...
0
votes
0answers
121 views

How to relate a Spatial and Non Spatial table in PostGIS to be visualized in QGIS

first of all I'm quiet new in PostGIS. I'm working in pgadminIII with postGIS. I have in one database two tables. See the two tables SQL Pane. CREATE TABLE gw_body_characterisation2 ( ...
0
votes
0answers
208 views

How to convert a geojson from Postgresql to geojson format readable in rCharts in R?

I am creating a Rshiny interface on that can take in user input and SELECT the respectively map layer from Postgresql database based on the input. The package I am using to plot the map is rCharts. ...
0
votes
0answers
74 views

Raising height of a certain part of choropleth

I have a working choropleth map which shows number of patients in a certain coloured area. I want to raise the height of the specific area according to the patient count. The variable height is equal ...
0
votes
2answers
228 views

Exporting layers from ArcGIS into PostGIS while preserving attributes such as color

I have managed to import/convert a KML into ArcGIS 10.0 (ArcMap) using the built-in conversion tools and now have a series of layers. Next, I export these layers to a PostGIS database using the ...
0
votes
0answers
152 views

Create a route by using points (pgRouting)

I'm currently working on a routing model for 17th and 18th century voyages. These routes are based on data from old shipping logbooks. I made a separate layer in QGIS which contains point. I exported ...
0
votes
2answers
174 views

How can I measure linestring on postgis?

I have a linestring and I want to measure this line. I try it on google maps. the result is that 0,65 km ...
0
votes
0answers
46 views

pgRouting with my bus network and select the best of the available routes? [duplicate]

so here's the case: I have been using postgresql/postgis, openlayers and pgrouting to create an online application that selects and visualizes the best of the availabble routes. My problem is though: ...
0
votes
0answers
81 views

From a point find the closest line [duplicate]

I tried to find a LineString from my table road the nearest line to a point I give, but it is return me all the table SELECT gid, ST_Distance(ST_Transform(ST_GeomFromText('POINT(39.240443 ...
0
votes
2answers
1k views

Converting coordinates to 4326 for Google Maps.

I have a MultiLinestring, example coordinates, (698745.50201423 4210011.04002000) and I would like to convert them to something like (24.362 42.458) to use in Google Maps. When I try to get the SRID ...
0
votes
0answers
389 views

numeric issue while loading floating point-valued GeoTIFF into PostGIS

I am trying to import a floating point GeoTIFF image into PostGIS (2.1), using the following command: raster2pgsql -s 4326 -I -M -F -C tif_dir/*.tif public.map | psql -U postgres -h localhost -d ...
0
votes
0answers
147 views

R PostGIS convert SpatialPolygon to PostGIS table

I've been having some success in scraping some webdata and converting it from HTML to spatial data as originally asked here: Parse PHP/HTML to shapefile or similar I've been using R to both fetch the ...
0
votes
1answer
230 views

How can I find the segment of a line that lies within a polygon using Postgis?

Given a "road", represented by a line, that crosses a "state", represented by a polygon: What is the SQL query I can use to find the segment of the road that is within the state? A concrete example. ...
0
votes
1answer
157 views

convert data from osm to osm tiles/marble

I need to convert the raw thata OSM XML to tiles styled like standard OSM tiles (and other styles if possible) From the research I've done I've found I need to have osm2pgsql and put it on the same ...
0
votes
3answers
425 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 ...
0
votes
2answers
349 views

Unable to implement pgrouting(plugin) pgr_astar routing algorithm (shortest path) [duplicate]

I have been working on a project for indoor navigation. I made the floorplan of the building and road-map for routing purposes as shp files (using JOSM, making GeoJSON and then converting to shp file ...
0
votes
1answer
393 views

Aiming to retrieve source and destination from Android, use pgrouting dijkstra to find shortest path and display it back on Android

I have created an Android application that will accept source and destination from the user. It then calls a php page which takes in the lattitude and longitude of the destination and the source. I am ...
0
votes
1answer
307 views

How to automatically convert line features into polygons using QGIS/PostGIS?

I have a master table of line features and a number of tables that I use to join (in the SQL sense) to produce various layers. Some of theses layers consist of boundaries of administrative zones ...
0
votes
1answer
220 views

Can I view a Postgis Geometry Array in QGIS?

I have got an array of geometry as a column in postgis database. Is it possible to view the data (even the nth element?) in qgis?
0
votes
1answer
716 views

How to upgrade PostGIS 2.0 to 2.1 on Windows 7?

PostGIS 2.1 was recently released and I would really like to upgrade from 2.0, but can't quite figure it out. I had previously installed PostgreSQL 9.2 and PostGIS 2.0 using StackBuilder. Running ...
0
votes
1answer
1k views

PostGIS error reads “Geometry has Z dimension but column does not” [duplicate]

I try to store a polygon in GeoJSON format into my PostGIS table. Both are using the CRS EPSG:3857. This is how the polygon is defined. Note that I put in some whitespace to make it more readable. { ...
0
votes
1answer
250 views

What should I start with WebGis Mapserver?

I'm not native English Speaker and I'm a graduated student who want to have a master degree in software engineering. I have a thesis relative with "Build a WebGis for air pollution in Vietnam's ...
0
votes
2answers
159 views

Manually add a new point to PostGIS table [duplicate]

I did accidently delete a table row - or well, in fact a whole subway station. My attempt to solve the problem was this PostGIS function: ST_GeomFromText('POINT(coordinates)') But then PostgreSQL ...
0
votes
1answer
185 views

How to find features within a distance? [duplicate]

I insert the values from lat/long into the points. Those users move around and send me new Lat/long and of course , I made an update of the position. I need to find people that are in a distance ...
0
votes
1answer
257 views

Get lon/lat of feature in postgis

I'm hava a problem I have a point layer (shapefile) insert to postgis! I'm using MapServer and OpenLayer to display layer on map! Now, i want get lon/lat all feature of layer! Hope somebody can help ...
0
votes
1answer
578 views

How to insert non-spatial data through WFS-T insert?

When i perform wfs-t insert operation using postgis database only spatial data and primary key gets inserted. Can anyone point me to some examples in which attribute data are also inserted along ...
0
votes
2answers
341 views

shp2pgsql srid 2262 polygons NOT in geocordinates

Imported the following shape file: shp2pgsql -c -s 2262 MCGIS_Towns_Villages public.towns | pgsql -d database Queried: SELECT gid, name,st_astext(the_geom) as the_geom FROM towns The ...
0
votes
1answer
1k views

QGIS and MapInfo Projections - EPSG 27700 (British National Grid)

I have some data in a PostGIS table with the projection EPSG 27700. If I export this data from QGIS (v1.8) to MapInfo TAB / MIF when I open the data in MapInfo it has a shift on it. Does anyone know ...
-1
votes
1answer
525 views

QGIS and Python - create line with multiple points in postgis [closed]

How can I create a line, with Python functions, with many points that are records in Postgis? Thank you
-2
votes
1answer
1k views

Postgis error on select all intersetcs of a polygon [closed]

i can get all polygon on intersects this:-7.9245860488441 -37.122384500713,-7.9245860488441 -37.11904223938,-7.9233955716106 -37.1187601948 SELECT * FROM propriedades WHERE ST_Intersects( ...