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

learn more… | top users | synonyms

8
votes
1answer
861 views

Is it possible to geocode street intersections using Nominatim?

Is it possible to geocode the location of a street intersection using Nominatim? Example geocode query Commonwealth Ave at Washington Street, Boston, MA Successful Geocode by Google ...
7
votes
1answer
1k views

Generating Interactive Tiles using Nodejs, Mapnik, and PostGIS for Leaflet

I am looking to do something like this but where I have all the data on the same server. I've been following through the set of tutorials @ sparkgeo.com/labs/big/ and I'm having some difficulty. ...
4
votes
1answer
66 views

Finding all segments that makeup a road in OSM

I've spent 2 days trying to figure this out and I'm afraid that it's something that's not possible. If that's the case then I'm thinking the wrong with with respect to OSM data. Let's say I have a ...
0
votes
0answers
336 views

Error adding Geoserver store from PostGIS

I cant get a connection up when creating a PostGIS-store. Geoserver is running fine on IP:80/geoserver. PostGIS is running and working fine with psql commands Created database/table 'mydb' and ...
0
votes
0answers
94 views

OpenStreetMap Road and Polygon Data as 1x1 Degree Shapefiles

I am working on a global project for which I want to use OSM data as a model input. I am looking for advice on the best way to produce 1x1 degree WGS84 shapefiles from either regional extracts or the ...
0
votes
0answers
38 views

Credential Dialog, disabling default Realm information messages disclosing password

I'm using the QgsCredentialDialog for determining user access to the database. When a user is failing to log in correctly the log in credentials are shown in the dialog (Fig. 1). (success, uname, ...
0
votes
0answers
51 views

How to get create new object right in postgresql

I created a .shp in QGIS successfully and now i want to move on this to postgis db, following this command shp2pgsql -s 2964 roads.shp lakes_new | psql qgis_db but i got this error how to solve ...
0
votes
0answers
421 views

PostGIS 2.1 error install with shared object (rtpostgis-2.1.so") Linux Mint

I've Installed Linux Mint 16 mate and install PostGIS with PostGreSQL (I've tried many ways in the Internet from original source to some suggestion) but all is too error: " ERROR: could not load ...
0
votes
0answers
116 views

Adding GIS feature into an existing postgis table using django 1.6

i am using Django 1.6 on my web map. the problem i got is that i cannot import shapefile with features about 200. . the console has given me this traceback. . Saved: 162-05-0001-005-31 Saved: ...
0
votes
0answers
343 views

ECW files to geoserver 2.4

I'm trying to add .ecw files (20 orthophotos) to geoserver 2.4. Geoserver is running on an ubuntu 12.4. Vserver. I'v already installed the GDAL plugin. Is this the right format for the ...
0
votes
0answers
45 views

Speed drastically reduced when including geometry, is there a way to improve?

-- EDIT: Issue is that the shape files being used are at too small of a precision and way too large, output was 488M total, looking for different source -- I'm having some speed issues with a complex ...
0
votes
0answers
102 views

Add memory layer to a preexisting PostGIS table

I'm trying to append a memory layer to a preexisting PostGIS table. The DB connection is already established (in this way: How to properly establish a PostgreSQL connection using QgsCredentials) and, ...
0
votes
0answers
104 views

Extract city boundary from TIGER data

I'm trying to find the bounding box of US cities but I just can't seem to figure out what to do with the TIGER data I download (not to mention, which data to download!). Could someone experienced with ...
0
votes
0answers
67 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 ...
0
votes
0answers
470 views

Draw postgis geometries in google maps api

Postgis have a base with a table of data lines and other points. I'm doing a java applet to query these tables and space to draw on google maps. My question is: what better way to spend these ...
0
votes
0answers
649 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 ...
0
votes
0answers
133 views

Postgis extension is not detected although it's installed

I have a database with postgis extension installed. i can verify it by running \x then \dx. The postgis and postgis_topology is available. But, if i run SELECT PostGIS_Version();, it says ERROR: ...
0
votes
0answers
76 views

Why CQL DWITHIN returns different result than PostGIS DWITHIN?

I have 2 tables in PostGIS that I publish to geoserver. both have same SRS (2039). When I do the following query in PostGIS , I get 69 results : SELECT a.gid,b.gid FROM Table_A a INNER JOIN ...
0
votes
0answers
204 views

Mapscript. Converting pixel coordinate to latitude longitude for postgis

I have a map created with mapscript. It is a 2D (PNG format) that's being shown on a web browser. I want to get the lat/long coordinates whenever the user click on the image, and then save it in my ...
0
votes
0answers
26 views

Linking Google Sheets with PostGIS

I am curious if there is a way to link a PostGIS table with a Google Sheets? Both tables (Post and Google) have a unique ID that can be used as a linkage. I am hoping to be able to build a view that ...
0
votes
0answers
382 views

postgresql 8.4 and postgis 1.5 error: type modifier is not allowed for type 'geometry'

I would like to generate a buffer (within a limit of 3km ) where the user clicked point. In pgAdmin, select my database and open a query editor and create 2 PostGIS functions (UTM Zone Function and ...
0
votes
0answers
145 views

Using Terraformer to convert to WKT

I'm using Terraformer to parse some ArcGIS JSON into a Terraformer primitive. I'd like to store the geometry in PostGIS for other purposes. So I'm trying to use the WKT.convert tool to convert this ...
0
votes
0answers
138 views

issue with QGIS Scale Level

I have different layers of shape files. I have imported all shape files into PostGIS. Now i want to show 3 layers Country, State & District with different scale/zoom level I tried to set scale ...
0
votes
0answers
49 views

SQL questions testing pgRouting 2.0

Following the post:pgRouting 2.0 for Windows quick guide, cuz I have some problem with DB manager(here is the problem I posted:DB manager in QGIS 2.0), I skip DB manager and save the test shapefile, ...
0
votes
0answers
203 views

Split lines at polygon intersection with attributes saving

This relates to this question but what about keeping the attributes. Having line_layer (id, geom, attribute1, attribute2) poly_layer (id, geom, attribute3, attribute4) How do I split the lines ...
0
votes
0answers
148 views

How do I convert MULTIPOLYS into LINESTRINGS in PostGIS

I have a table with a geom column as a geometry(MULTIPOLYGON) I would like to create an additional column of type geometry(LINESTRING) How can I do this using a PostGIS Query? I need to be able to ...
0
votes
0answers
2k views

Postgresql Connection issue “unexpected EOF on client connection”

I'm using Tomcat, Apache (for Load Balencing),OpenLayers - 2.11,GeoServer 2.13, ExtJS 3.4, PostgreSQL 8.4,PostGIS 1.5 and Java for developing GIS based web applications. I have 2 Server. Server1 ...
0
votes
0answers
126 views

Postgis template1 database missing

I want to create a template_postgis for connecting postgis via qgis So I follow the step on following page how to create a new postgis database for usage with QGIS under windows But when I follow ...
0
votes
0answers
111 views

Transforming WFS Projection

I am trying to overlay features from a WFS using OpenLayers, my geometries in database are in EPSG:27700 and my map's projection is EPSG:3857. My mapfile returns data in EPSG:27700. Is there any way ...
0
votes
0answers
284 views

Why does QGIS not show my new geometry columns?

I am trying to connect a few PostGIS Tables to Quantum GIS. The problem is that the geometry columns QGIS is showing are not the ones from the PostGIS database. QGIS shows me some columns I used to ...
0
votes
0answers
120 views

Geonode's geoserver failing (generating 404's)

I'm working on a Geonode installation, and some days ago, it stopped working correctly. After restarting geoserver, it only would show 404 pages (on myhost.com/geoserver) HTTP ERROR: 404 ...
0
votes
0answers
74 views

How to avoid intersection in pgRouting

I'm a newbie in pgrouting. I want to create a web-app with routing function. I want to ask how to avoid a road intersection with pgRouting? For example, there are some traffic jams happened in several ...
0
votes
0answers
111 views

Polygon dynamic grid creation for a shape file

I have used QGIS Vector->ResearchTools-> Vector Grid to create a 1lat x 1 long grid for the landpolygon shape file (from osm). Now, I am interested in creating dynamic grid for the original ...
0
votes
0answers
235 views

How does geoserver determine what SRID to pass to PostGIS [OPERATION ON MIXED SRID GEOMETRIES]

We are using Geoserver to render some data onto maps in a web application. The map shapes are read by Geoserver from a postgis database. The shapes are imported into postgis using the ogr2ogr utility. ...
0
votes
0answers
2k views

How to write a point-in-polygon query for Postgis?

I'm trying to write a query in Postgis which will return all rows where a dynamically changing longitude/latitude point resides within the geometric polygon of that row (in the geom column). This is ...
0
votes
0answers
177 views

several fields and GEOMETRY GetFeatueInfo from Geoserver

Good day!. I have a table in PostGIS 2.0 with several fields of type GEOMETRY. In the geometry_columns they are published in Geoserver 2.2 as layers. This is done as here - geoserver docs, but ...
0
votes
0answers
59 views

Is there any feature limit for Spatial data migration to Postgre SQL9.2…?

I am trying to migrate spatial data to Postgre SQL9.2 using 'Postgis Shapefile & DBF Loader 2.0'....Each time it returns a "Runtime error'. Primary data extension - .shp ; Data type - ...
0
votes
0answers
97 views

What do we have to set in mapfile´s data parameter for SOS?

We are trying to run the MapServer SOS example at this link. However, we don´t know how to configure the data parameter in the mapfile. What do we have to set in mapfile´s data parameter? We need to ...
0
votes
0answers
93 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 ...
0
votes
0answers
136 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?
0
votes
0answers
91 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
517 views

QGIS 1.8.0-Lisboa DBmanager (OSx) can't connect to remote PostGIS 2.0.2 database (Debian)

The PostGIS database is remote but I have made changes to the Postgresql config files and can access it remotely via pgadmin. When I open DBmanager in QGIS I see a note on the bottom that says ...
0
votes
0answers
79 views

Can I edit non geographic tables in geoexplorer?

I'm using postgis, geoserver and geoexplorer to manage my data. However I would like to edit non geographic tables in geoexplorer and edit a field feature based on other tables using a drop-down menu. ...
0
votes
0answers
157 views

Can I do full SQL expressions through the “WHERE” clause in UpdateCursor?

Run as a standalone python script for a shapefile in a toolbox on ArcMap. For example: psql_url_pop = '''SELECT shapefile.NAME_# + shapefile.WIKI_URL FROM public.shapefile''' rows = ...
0
votes
0answers
386 views

I wanted a tutorial link to start with geoserver and Postgis for ASP.NET

I wanted a reference material for coding using C# in ASP.net with geoserver and Postgis. Please tell me reference material for the same. I have searched for several reference material but did not ...
0
votes
0answers
275 views

assign_vertex_id error

I am trying to test if pgrouting works fine or not. To do so I have created a table containing the following attributes. Columns: gid | length | the_geom | source | target Now my ...
0
votes
0answers
449 views

PostGIS geometry aggregation problem

i have a problem with aggregation of geometry either with ST_Collect, ST_Union, Array_Agg after doing intersection with transformed geometry. Faulty PSQL code goes like this: SELECT ...
0
votes
0answers
591 views

Implementing custom (Vincenty/Haversine formula) functions for MySQL vs Using PostGIS?

I currently am using MySQL for all of my relational data. I have hit a crossroads with geo calculations. Since, MySQL does not have good support for spatial functions, I am contemplating on using ...
0
votes
0answers
523 views

How to load postgis layer to map control with mapwingis?

I search over the internet but couldnt find out the resolution. I create GIS app with MapWinGIS library, I have some spatial table in PostgreSQL (table with geometry column). I want to load these ...
-1
votes
0answers
27 views

geoserver 2.6.0 error in postgis database connection

I have been getting this error while connecting postgis database with geoserver version 2.6.0 "Error creating data store, check the parameters. Error message: Unable to obtain connection: Cannot ...