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

learn more… | top users | synonyms

0
votes
1answer
168 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
111 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
2answers
277 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
662 views

Will MapInfo only read PostGIS data that has been loaded via EasyLoader?

NMZ says in this thread that MapInfo will only read data in PostGIS that has been loaded by MapInfo's EasyLoader. I wasn't sure if this was still the case so I've loaded data into postgis via ogr2ogr ...
0
votes
1answer
299 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
223 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
2answers
630 views

calculating the difference between 2 angles using st_azimuth and dot product

the function below tries to calculate the difference between 2 angles. I use the mathematical reasoning is as follows : 1) Obtain the 2 angles : angle1 = ST_Azimuth(ST_StartPoint(l1), ...
0
votes
1answer
965 views

How to fix “Connection failed - Check settings and try again” when connecting to PostGIS?

I have Postgres running via Postgres.app on rails already and am trying to connect QGis to the database. PostGIS is working already. (questions already found online deal with this issue only) I do ...
0
votes
1answer
498 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
970 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
227 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
139 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
160 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
246 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
514 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
327 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
451 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
777 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( ...