PostgreSQL is an open source object-relational database system.
0
votes
1answer
95 views
one row is discarded while importing shapefile into postgres
Please help me in following issue. I need to import a polyline shapefile into Postgres9.1 through shp2pgsql command.When i did like this, i got an error as
"NOTICE: CREATE TABLE will create ...
1
vote
0answers
186 views
add description to a new polygon and save -> postgres + geoserver + openlayers -> wfs-t insert
actually it is possible to draw a new polygon with openlayers and save it over WFS-T-insert (geoserver wfs-t 1.1.0) in my postgres-db:
var save = new OpenLayers.Control.Button({
title: "Save ...
5
votes
2answers
251 views
How to put 20K points on a map
I have an sqlite 3 database with 20K entries each of which has lat long data and I wanted to create a layer from that data. From what I have read I need to import it into a postrgres DB but I'm not ...
2
votes
1answer
539 views
pgRouting: unable to execute routing_core.sql
I'm unable to execute the routing_core.sql, receiving following error.
I'm using pgAdmin III, Windows 7, PostgreSQL 9.1, PostGIS 2.0.
ERROR: could not load library "C:/Program ...
1
vote
2answers
273 views
Geocoding like Google - how to do this?
I have Postgre database with network table that contains country, street name, numbers from left – to left, numbers from right-to right.
I finished geocoding function to use like this: user fills 3 ...
5
votes
1answer
234 views
Advice on ideal server specifications
I am looking for your thoughts on ideal server specifications for a moderately sized habitat mapping project. My current server is about to reach its storage capacity, so I am researching buying a ...
1
vote
1answer
364 views
Create closest point on multilinestring to use in shortest_path()
I am working a routing based application where I need to create a route between two points of interest. The problem which I am facing occurs after calculating network topology using ...
0
votes
3answers
2k views
Get geometry from coordinates
I have a table with geometry column called point, saved in SRID 4326. I want to get the geometry by its coordinates, but something didn't work. I suspect database configuration or something.
Here is ...
1
vote
3answers
808 views
Joining 2 tables to create layer in Geoserver with MultiPolygon and Point data types
I got problem when using the SQL View function. My objective is to create layer in geoserver from joining 2 tables.
I have 2 tables, table_a:
Table "public.table_a"
...
0
votes
1answer
160 views
How to use ST_Length?
I want to calculate the lenght of the line inside the polygon.
If I do this:
SELECT ST_Length(ST_Intersection(ST_Transform('SRID=3035;LINESTRING(4000000 3000000,
...
2
votes
2answers
671 views
Why am I unable to publish a postgis layer to geoserver?
I left arcgis and microsoft sql and now I am trying to connect Qgis+PostgreSQL (PostGIS) + GeoServer.
I've brought my postgis database to the server, created a "store". And now I'm trying to publish ...
8
votes
1answer
202 views
How to get the length of a line inside a polygon
How can I get the length (brown marked part) of the "Road 7" inside the red polygon?
My start:
SELECT ST_Length(way) FROM lines WHERE road = "Road 7" AND ST_Intersects(line, polygon)?
With that, ...
5
votes
3answers
680 views
connecting to Postgresql
I am trying to connect to Postgresql database that I just installed on my server machine. As instructed by Esri I have download from postgres and installed psqlodbc. However, when I tried to add the ...
3
votes
2answers
606 views
Using PHP with a web application?
I have been working on creating a web mapping application using ArcServer 10 and the JavaScript API. Recently I was told that queries need to be run using PHP due to prior work by another team. The ...
2
votes
2answers
225 views
How to pull lat/lng from a map canvas and update a database
So if i want to pull out lat/lngs after user clicks on a map canvas (lat/lngs are pulled using any javascript API (leaflet, wax etc.) and add this to a postgresql database using a query, how do i do ...
5
votes
2answers
1k views
Can we direct connect to PostgresSQL without ArcSDE
I have postgreSQL installed on my machine.My machine already has ArcGIS 10. No Sde installed. Can we create geodatabase in PostgreSQL with out installing ArcSDE?
Jay Cummins is right. I am intended ...
3
votes
2answers
285 views
Unable to create a geometric network in a PostgreSQL Spatial Database Connection
I've created in ArcCatalog a Spatial Database Connection to an PostgreSQL database server. I've imported there all my data (from a local hard drive) and now I want to edit them. But apparently I ...
6
votes
2answers
228 views
Do large vertex counts cause performance issues?
I have a table of several thousand tuples - each tuple has a geometry column. The problem is, these geometries have a large vertex count. The max vertex count is 400, while the average is 200. ...
1
vote
1answer
126 views
Interpreting the geom_way in the table created using osm2po [duplicate]
Possible Duplicate:
Issues while plotting the results of pgRouting shortest path
I am trying to actually figure out what this column exactly represents and how to use that in my case. I ...
0
votes
1answer
214 views
How to get points in bounding box by degrees for map
I have some concerns about working of BOX3D PostGIS function. I tried to find places in square -158.721365889063 66.09275164148659, 154.608712235937 52.56807548751039(degrees). But this where ...
3
votes
1answer
179 views
How to update attribute values of points outside an area?
I have two datasets in PostGIS 1.5 (on Postgres 9.1) one of polygons and one of points.
I am hoping to create a SQL command that will select all of the points in a dataset that are not within of the ...
1
vote
1answer
109 views
How to select data inside a tile?
I have an OpenStreetMap PostGIS database and would like to select specific data (for example all shops) of each tile (on a defined zoomlevel) on the planet. Is this possible to achieve and if yes, ...
1
vote
0answers
341 views
Geometry contains non-closed polygon: GeoServer output from PostGIS
I have imported a shp file using PostGIS shapefile loader plugin for pgAdmin3. The geometry type of the table created is MultiPolygon. I have cross checked the same using the following query.
SELECT ...
2
votes
3answers
208 views
PgRouting routing algorithm from start to end via nodes with restrictions
I have the following situation:
I want to find the shortest route from A to B through nodes (C,D,E, etc.) with turn directions and road type filtering.
Is there a way to accomplish this using ...
5
votes
1answer
2k views
How to create a tables from existing tables (applying new schemas) in postgis DB?
I have a table that is geospatially enabled; that contain world borders. I want to break it down to different schemas (global, europe etc..) . My thought is to use use something that looks like this:
...
2
votes
4answers
244 views
Any pgrouting enabled hosting providers?
I am really interested if any of you know about a hosting provider that offers postgis & pgrouting pre-installed?
If not, can I just go ahead and purchase a linode hosting account and do all the ...
2
votes
3answers
334 views
Which open source software to create desktop interface for Geo-processing tools?
I want to create an desktop interface to create geo-processing tool and that to using Open source GIS software. I will be using Postgresql and postgis too to save and retrieve data for operations. I ...
5
votes
1answer
351 views
How to find the two furthest points between a group of points?
I have a table with 20000 records and with those columns Shop, longitude, latitude, geom
I would like to find a way to find the pair of ths farthest shops between a selection of shops
For example we ...
1
vote
1answer
131 views
Is it possible to use assign_vertex_id() POLYGONs?
I'm trying to use pgrouting in order to create a graphe and I have two questions :
Is it possible to use the function assign_vertex_id() with a POLYGON geometry type? I always have the following ...
-1
votes
0answers
37 views
Determine the Closest road to a GPS point [duplicate]
Possible Duplicate:
Calculate distance of point from an arc/polyline
I have been trying to find the road to which a GPS point is closest to. I have a postGIS database which i loaded with ...
2
votes
0answers
224 views
How to solve postgreSQL error when using QGIS Cloud plugin?
I created a qgis cloud account and installed the plugin. When I attempted to Upload Data using the plugin, I got the following error:
postgreSQL exception:
ERROR: "MD5" authentication with pgpool ...
2
votes
1answer
269 views
osm2pgsql finishes processing without creating vertices_tmp table
I am using postgresql 9.1 database with posgis installed. I also have pgroute installed on same database. I am trying to use osm2pgsql tool to import data for routing. But osm2pgsql tool finishes ...
3
votes
2answers
445 views
Merging polygons that intersect by more than a specified amount
I am working with a dataset that contains a subset of property boundaries in a local government area, thus my dataset is made up of several thousand properties but not all are touching. Since it is a ...
4
votes
4answers
1k views
Calculate distance of point from an arc/polyline
Using Postgres/PostGIS, I am trying to query the database for the closest arc to a particular GPS point. Each Arc is made up of two nodes that are GPS points on a map. Is there a way I could query ...
0
votes
0answers
301 views
PostgreSQL Dump: One row discarded [closed]
I created a table with a column "integer".
I'm populating this table with a PostgreSQL database dump, and basically, it inserts new data from SQL commands:
INSERT INTO my_table (..., my_column, ...) ...
1
vote
1answer
1k views
Google Maps MarkerClusterer - Remove all clusters
So, I have a PostGreSQL DB with 317 datapoints - all spatially enabled through PostGIS. I have queried this using PHP as GeoJSON and overlaid it on Google Maps (using a converting routine). I have ...
7
votes
2answers
7k views
How to insert a point into postgis?
I have created one table in my Postgis. But I can not insert point. I do not know what's wrong with my query?
CREATE TABLE app (
p_id INTEGER PRIMARY KEY
);
SELECT ...
4
votes
2answers
2k views
Struggling with enabling a PostGIS database on Mac
I have installed PostGIS on the mac using the binaries available on http://www.kyngchaos.com/software:postgres
Postgres v 9.1.3
PostGIS v 2.0
After that I want to enable postgis for my database. I ...
2
votes
1answer
1k views
KML PHP parser to INSERT into database
So I have a KML file which has attribute data(Inside the tag with about 12 data points). This file was generated on ArcGIS. I'm trying to write a PHP script to parse this KML file and insert the ...
6
votes
1answer
334 views
Data visualization and maintenance tool
Background
Looking to leverage an existing GIS system for exploring organizational data.
Architecture
The following figure represents a high-level overview of the system's desired features:
The ...
4
votes
1answer
595 views
How to design model in Django using GeoDjango?
I am using Postgresql 9.0 and PostGIS 2.0. I am using Django 1.3 and GeoDjango.I have model with id,latitude,longitude and placename. All the places are in USA.
My requirement is following -
User ...
2
votes
2answers
328 views
Why does Mapserver throw “msQueryByPoint(): Search returned no results.”?
I have been trying to configure a QUERY using mapserver. Below is the mapfile:
MAP
NAME "Fourth"
UNITS dd
EXTENT 58.206740 5.756104 ...
1
vote
1answer
212 views
Identify functionality using mapserver
I am just creating a simple web application using mapserver. It has the basic pan, zoom in/out functionality. Now what I want to try is to get an identify functional added into it so that when I click ...
2
votes
1answer
237 views
Error while rendering a layer from postgresql in mapserver
I got a point layer into QGIS from postgresql database. After this I used a plugin to export it to a map file.After exporting the following is the starting of the map file.
NAME "QGIS-MAP"
# Map ...
4
votes
3answers
938 views
Geometry issues when creating table from existing spatial table
In short, I want to split an existing spatial table into two parts. The split itself is straight forward. I start with this (fully functioning) table:
CREATE TABLE table
(
my_identifier smallint,
...
2
votes
4answers
1k views
How to ceate a point layer from a table in PostGIS?
I have a table in PostgreSQL(postgis). This table has latitude and longitude values in it.
Now I want to plot these point in qgis. The only thing I could get done was connecting to the database from ...
3
votes
2answers
501 views
How do I get the distance meter value between two geometries in PostGIS?
I have a simple question about calculating distances in PostGIS.
I would like to get the distance between two geometries. I am using this sid : 4269 in meters
what i am doing now is this : ...
4
votes
1answer
218 views
Find the farthest point (PostGIS)
I have a table with 2000 records and with those columns
OutletName, longitude, latitude, geom
I would like to find a way to find the farthest outlet between a selection of outlets
For example we ...
4
votes
1answer
1k views
Output polygon data from postGIS and read it on Google Maps API
So, I have a group of polygons stored in PostGIS. I'm trying to build a web application with Google Base maps (using Google Maps API). Now, How do i output the polygons in the right format so that ...
4
votes
2answers
606 views
Loading data onto PostGIS using KML files with attibute data
So, I have a kml file which contains 317 data points (317 polygons and the respective 317 names). The kml file also contains attribute data which pops up in a bubble on Google earth with about 12 ...
