PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
0
votes
0answers
8 views
pgrouting pgr_dijkstra forcing route along a selected edge?
I have routing working where a user clicks 2 points on the map, I find the closest vertex to those 2 clicked locations and pass that to a pgr_dijkstra function.
What I would like is give the edge a ...
1
vote
0answers
25 views
Calculating Distances Between Geometry Columns of Differing SRIDs
I am attempting a relatively simple task but have been running into trouble. I have two tables, one which has lat and lon points which were geocoded using google (SRID 3857) and another table which ...
1
vote
0answers
7 views
Geoserver - How to make a psql-backed timestamp that uses timezones
I'm working on an application that extends geoserver and am frustrated as I'm trying to define a SimpleFeature that has timestamps that include timezones.
I've tried declaring my timestamp field ...
0
votes
1answer
28 views
Plotting Street Map for City - Where do I start?
Please excuse my ignorance of this and if I break any of the rules please be gentle as this is my first post here and I'm not GIS expert either. I need people to steer me in right direction so that I ...
2
votes
0answers
11 views
Not able to get the PostGIS Layer Viewer running in pgAdmin or command line
I've installed PostGIS Layer Viewer as a plugin for pgAdmin. I've downloaded postgis_viewer.py from the official repository on GitHub! and followed the install instructions described on Web site!. ...
1
vote
0answers
19 views
I am getting error in PostGIS 'function st_clip(raster, integer, geometry) does not exist'? [on hold]
I have to find the count of the number of pixels in a given band of a clipped raster.
For clipping, I am using ST_clip(). Through clip function raster is clipped with a polygon.
I am getting ...
1
vote
0answers
27 views
error importing shp into postgis using ogr2ogr
I run an automated script that copies a number shapefiles into PostGIS. I have a problem with one dataset which fails during the export. As the roads.shp dataset is maintained by someone else, I ...
0
votes
0answers
23 views
How to get pixel values/cell values for stored raster files in postgis?
Raster files in tiff format are storing into database.However I gets only an attribute table.
Is there any way to retrieve pixel values/cell values in the table.
I have used raster2pgsql command for ...
1
vote
1answer
73 views
Why doesn't my spatial index work?
I have a table with 50 million test points. The points are stored as latitude / longitude with SRID = 4326. The create script for the table:
CREATE TABLE points
(
name character varying,
point ...
1
vote
1answer
25 views
Geoserver GeoWebCache caches tiles of incomplete layers
I have data in a PostGIS database that is being pulled into Geoserver using a PostGIS (JNDI) store. The dataset I am using is a continuous polygon grid, but the dataset itself isn't all that large. ...
1
vote
0answers
17 views
PostGIS is not seeing any GDAL drivers
I've tried setting POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL as an environment variable. As well as running SET postgis.gdal_enabled_drivers = 'ENABLE_ALL'; from psql. (With a pg_ctl restart after each) ...
4
votes
1answer
50 views
PostGIS: Strategy for fastest select by BBox with an ORDER BY polygon area clause. Cluster?
Update 2 (below) suggests 14% of the table geometries are stored out-of-line with the rest of the table records. This may be a useful clue.
The Problem:
We've got a table with appx 170,000 WGS84 ...
0
votes
1answer
33 views
find all circles intersecting another in a table [duplicate]
I am using postGreSQL (9.3) and postGIS (2.1).
I have a table containing names and circles (point + radius).
Given a name and a circle (point + radius), I would like to find all the database lines ...
0
votes
1answer
17 views
Preserving styles when going from KML to WMS
I'm currently losing styling information somewhere along my chain of applications:
KML -> ArcGIS Layer (via ArcGIS Desktop)
ArcGIS .gdb -> PostGIS via ogr2ogr
PostGIS -> GeoServer
GeoServer ...
0
votes
0answers
7 views
Extract table-embedded attributes in KML using ogr2ogr
I'm loading a number of diverse data files into a PostGIS database, using ogr2ogr. One of these data files is a KML with useful attributes embedded as an HTML table in a description column:
...
4
votes
2answers
123 views
PostGIS: ST_Equals false when ST_Intersection=100% of geometry?
I have 2 datasets consisting of cadastral parcel data - roughly 125,000 rows each. The geometry column is WKB polygons representing parcel boundaries; all data are geometrically valid (the polygons ...
0
votes
1answer
36 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 ...
2
votes
2answers
58 views
Find the area of points in PostGIS?
I have points that form a line. I would like to assign a radius to each point to give them volume, e.g. 50m and then find the area of the combined points. Does anyone know of a way to do this in ...
0
votes
1answer
26 views
Calculate area of a raster for an irregular polygon in PostGIS
I have a number of polygons with irregular shapes (i.e. non-rectangular) and want to calculate their areas after I have converted them to rasters.
Here are my steps:
Convert my geometry to a ...
0
votes
0answers
35 views
Implement Leaflet search box for 370,000 points stored in PostGIS served as raster tiles
I have built http://opentrees.org. It's a TileMill/PostGIS/Leaflet stack with raster tiles and UTFGrid interactivity. I'd like to add a search box, so users can search for a feature – trees in this ...
0
votes
1answer
28 views
Creating point using ST_GeomFromText with SQL parameters?
I'm trying to insert points using C# into a PostGIS / PostgreSQL database. I'm using the Npgsql driver. I suspect this is less a driver issue and more a syntax issue due to me being unfamiliar with ...
0
votes
0answers
27 views
ST_MakePoint returns an error when using Python
I am trying to use ST_Point or ST_MakePoint to create points from a table of latitude and longitudes coordinates. However I am consistently getting an error even when trying the examples.
For example
...
0
votes
2answers
37 views
How to make interactive OpenStreetMap layers in TileMill?
If I'm reading the UTFGrid spec right, you can only have 65,501 different interactive features. Or more precisely, every feature needs a unique ID in the range 0-65501.
TileMill uses UTFGrid for its ...
0
votes
0answers
18 views
GeoDjango: Find all points within radius?
I am working in GeoDjango (with a Django 1.7 and PostGIS 2.1.4 backend). I have a model with a PointField in my database and I am trying to find all items within 10km radius of a point.
Here is my ...
0
votes
0answers
44 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 ...
1
vote
1answer
33 views
Create a raster with fixed 10meter pixel scale in PostGIS
I have a series of points that I would like to convert to a raster, and then calculate the area of the raster as a proxy for "amount of area covered". I'm trying to do this using PostGIS rather than ...
0
votes
1answer
13 views
how to configuring geomajas wih oracle spatial db?
I have just done intial setup of the geomajas project and trying to config its data source with oracle database.
I am following the given example for sqlserver and POSTGIS.
My oracle layerroad xml ...
0
votes
0answers
36 views
Is geotools transformation of EPSG:3785 (Web mercator) to EPSG:4326 wrong?
Using postgres (9.3.6) and postgis:
select st_astext(st_transform(ST_GeomFromEWKT('SRID=3785;POINT( 7550310.77 4139679.02 )'), 4326));
This returns POINT(67.8255956454323 34.8217133646348)
Using ...
0
votes
1answer
22 views
Problem with ST_Intersection in postgis
I have got a problem with ST_Intersection as bellow query. I do not know why I can not get element z of this intersection?
----query:
SELECT ST_AsText(ST_Intersection('LINESTRING Z (0 0 0, 2 2 2)',
...
3
votes
1answer
69 views
How to edit a PostGIS database using ArcGIS for Desktop Add-In/Extension? (no ArcSDE)
I need to improve an existing solution to be able to do multiuser editing within a PostGIS database from ArcMap.
Available for the solution is ArcGIS for Desktop 10.3 [Basic]. (No non-free Extensions ...
1
vote
0answers
30 views
Calculate surface map from PostGIS
We need to create surface maps from the website. The data is stored on PostGIS (2.1) as a table of Point geometries with a field indicating a thematic value.
The optimal solution would be to produce ...
1
vote
1answer
20 views
Extracting specific geometry point from MultiPoint geometry using PostGIS?
I am working with multipoint geometries in postgis and would like to extract the geometry point associated with the greatest y value of the multipoint geometry. How may I accomplish such a task?
For ...
1
vote
0answers
49 views
Is there PostGIS equivalent to arcpy.sa.Slice() function?
I have an existing system built on an 8.3 PostgreSQL database which uses a ArcGIS - Spatial Analyst for a couple of raster operations. The system is moving to PostgreSQL 9.2 and I'm evaluating if the ...
1
vote
0answers
66 views
PostGIS: Ordering by the sum of two distances
I have an SQL statement that selects possible bus routes between two points, ordered by the walking distance required from the start point to the departure bus stop (distance1) and the arrival bus ...
0
votes
0answers
13 views
problem with to addlister event google maps in same html file
I try to make two actionlistener one when the mouse over a marker show a infowindows and the other is for get when click on a market the lat and long and make an AJAX request
the two lister code is ...
0
votes
0answers
37 views
Make PostGIS points from Ajax data in a php file
I have an AJAX a string which has lat-long parameters in a request. I try to make point in an SQL query but I get this error
37.15452626 ERROR; parse error- invalid geometry
HINT: ...
0
votes
0answers
25 views
Import KML file into GeoDjango
I'm trying to import a KML file into an existing GeoDjango app (using a Postgres 9.3 database). This is my Django model:
class PCT(models.Model):
code = models.CharField(max_length=3, ...
0
votes
1answer
24 views
Fast way to check if postgis bounding box contains any points/linestrings
I have a bounding box given and want to know if this bounding box contains (or better intersects) any points or linestrings. So the query should return true if the first point/linestring was found and ...
0
votes
0answers
13 views
Load a shape file in postgresql DB with php
I am trying to load a shapefile in a postgis database using the exec() command.
I have read the format I have to follow from here and I checked several similar questions from the forum.
Based on the ...
0
votes
1answer
23 views
How to use WGS84 in postgis?
I am getting NMEA output (WGS84) from my GPS and would like to put that into Postgis table.
Format of the coordinate is 3267.56N 02575.92W.
Is there way to insert that coord in db ?
2
votes
1answer
17 views
Postgis 2.1: ERROR: Shell is not a line - SQL state: XX000
My current setup is PostgreSQL 9.3.6 & PostGIS 2.1.5
I have a table with contour lines (multilinestrings) that I wish to group by the attribute 'elevation', and make polygons out of them. The ...
0
votes
0answers
25 views
PostGis without shp2pgsql
I recently reinstalled postgis on my pc, following
these instructions link.
The installation is successful, and for several days work using PostgreSQL and PostGIS without problems.
Now, I need to ...
1
vote
0answers
25 views
ST_Split and looping problems PostGIS
I am a total PostGIS noob, and am having trouble understanding the finer points of SQL syntax. I am trying to take a large set of line data and clip it with a polygon. I then want to create a new ...
1
vote
0answers
17 views
Tool, API of or code samples for calculating spatial similarity between Lines
I migrating a database with a road network to an other external data provider.
We have joined our own data about roadworks, temporary speed-limits etc. using ID en Linear referencing on this data.
So ...
0
votes
0answers
5 views
Changing color of multispectral Raster Image using PostgreSQL/PostGIS query
Would like to change the color of a multispectral Raster Image. looking for changing band rendering values for Red, green and Blue bands using PostgreSQL/PostGIS query.
I have loaded the raster ...
1
vote
0answers
21 views
pgRouting. pgr_ksp() returns -1 as id3
The documentation (http://docs.pgrouting.org/dev/src/ksp/doc/index.html) says that the result should be 0 for the last row. Is the same 0 than -1?
I'm new on this. Thaks for the help.
0
votes
1answer
43 views
Convert string column back to geometry column?
I had a table with a column set to 'point' in doctrine2, but this was changed to 'string' and updated.
I can't change it back to 'point' in doctrine2, I get an error:
...
0
votes
0answers
18 views
Update Statement in PostGIS ERROR
I am trying to update a column in PostGIS using information from a column in another table where they spatially intersect. I looked up how to do this on the PostgreSQL tutorial and I think that I ...
0
votes
0answers
25 views
Clipping vector data (Point) with one class in symbolised raster
I have some .asc raster data I symbolised with ranges in two classes. Say 2.145 to 10.000 and 10.001 to 30.1254. Now I want to clip vector data with the area covered by 2.145 to 10.000. How can I ...
0
votes
0answers
27 views
Displaying measurements on a grid of the Earth
I'm developing an application where I need to draw the averaged results of some measurements on a map.
Right now, I'm using Leaflet to draw the map with MapQuest/OpenStreetMap tiles, and have the ...
