Version 2.0 of PostGIS brought a heavy set of new extensions for the PostgreSQL object-relational database, adding greater support for spatial objects.
2
votes
1answer
214 views
How to visuilze PostGIS data in GeoJSON format with PHP
I need to visualize PostGIS Geometry column as an overlay of a Leaflet tiled Map. I started a question here ,but didn't get any simple and satisfied answer. So I am starting this question. I got an ...
0
votes
0answers
218 views
PostGIS data visualization
I have dump my data in PostGIS from shapefile successfully. I made a postgres connection through PHP and that also returning the data of other field. But the main problem is GEOM field visualization. ...
5
votes
1answer
203 views
How to snap line string start & end vertex to the nearest point?
I have a point layer and a line layer. The points are road junctions, collected using DGPS, while the lines are the connecting roads, collected through Handheld GPS in tracking mode. As a result, the ...
7
votes
2answers
161 views
How to get distance between one point and all other points in a table?
I have a table in Postgres with lat and long columns. Can I use the ST_Distance_Sphere or ST_Distance_Spheroid methods to get the distance between one point and all other points in the table? Do I ...
3
votes
2answers
143 views
How to clip from a point layer using postgis?
I've loaded a LIDAR xyz file into a PostGIS2.0 database and created a 3D point geometry column ("tblCLOUD") from the data.
I've also loaded into the database a shapefile that contains six ...
2
votes
1answer
114 views
How to filter or query data in GRASS?
I have a PostGIS dataset with just over 2 million rows. Each row has a PostGIS geometry point value and several attributes.
I'd like to do some analysis on certain subsets of the data, but I can't ...
0
votes
0answers
53 views
Can't drop table with geography column
I imported shp to postgis 2.0.1 with shp2pgsql and chose to use geography instead of geometry. However, now when I try to drop the table, the pgadmin/sql console/phpPgAdmin freezes. I can't neither ...
7
votes
1answer
242 views
How to set up GeoDjango with PostGIS 2.0?
I would like to run GeoDjango (Django 1.4) with Postgis 2.0.
Whenever I try to run syncdb I get the following error for geographic fields:
Failed to install index for stores.Store model:
operator ...
1
vote
0answers
49 views
blank preview image for ImageMosaicJDBC (postgis raster) layer
In geoserver, while publishing ImageMosaicJDBC layer seems no problem, the preview of this layer does not give me an meaningful overview image, only a blank image with the correct lat lon extend. Also ...
1
vote
2answers
97 views
Is the PostGIS documentation correct for ST_Project?
In example of the page ST_Project the select is
SELECT ST_AsText(ST_Project('POINT(0 0)'::geography, 100000, 45));
st_astext
------------------------------------------
...
1
vote
1answer
194 views
How to find the nearest line from a point?
I have a table of Roads in PostGIS which geometry is "geometry(MultiLineString,4326)".
Its attribute are
gid osm_id name ref type oneway bridge maxspeed geom
Now i want to know ...
0
votes
1answer
112 views
Open Source GIS Problem [closed]
I am new at open source GIS platform. I am using Ubuntu 12.10. I have tried to install the followings but without 2-3 tools I could not install anyone. Can any body help me how can I install the ...
3
votes
1answer
456 views
Postgres/Postgis doesn't work after update
I work on OpenSUSE 12.1 and after today's upgrade (2012 NOV 14) Postgres and Postgis doesn't work. If I login to Postgres server by PgAdmin, get the message: translated from polish
"ERROR: can't acces ...
2
votes
1answer
108 views
How to fix 'GEOSDifference: TopologyException'?
Why does Postgis throws an error in this SQL?
Error:
ERROR: GEOSDifference: TopologyException: found non-noded intersection between LINESTRING (-5.67027 43.5374, -5.67085 43.5376) and LINESTRING ...
2
votes
1answer
136 views
Problems with QGIS (v 1.8.0) layer labels [closed]
I have a PostGIS (v 2.0) layer representing lakes. The attributes "chinchar" and "chintrans" contain Chinese characters and Pinyin (Roman) characters in UTF8 format. When I use Layer -> Labeling in ...
2
votes
1answer
159 views
Querying PostGIS Raster with MultiPoint
For one of my projects using PostGIS 2 I have a table with GPS tracks (igc_files). It holds records including a MULTIPOINT() column that has about 1,000 points for each record and a column that has an ...
3
votes
1answer
147 views
nearest neighbor within table using PostGIS
using PostGIS 2.0 and PostgreSQL 9.1 I have a table of photographic observations, sco_photos. The location column contains a PostGIS geometry point specifying where the observation was made. The table ...
2
votes
2answers
183 views
What's the fastest way to search for polygons that intersect with others?
I'm querying the database for searching polygons that intersect with others, but is very slow research, wanted to increase the speed.
I thought of using sphinx, solr, elastic search googled but did ...
10
votes
0answers
503 views
How to publish PostGIS Rasters in Geoserver?
What is the best solution to publish postgis rasters using Geoserver?
I have spent a lot of time trying to create a Raster datasource using Image Mosaic JDBC but with no luck.
Steps performed:
1. ...
16
votes
1answer
153 views
Can we create views over a raster table in Postgis2.0?
Is it possible to create PostgreSQL views over a table that contains raster data?
I have succeeded in creating the view but the entry in raster_columns is not correct (all the raster info is ...
2
votes
1answer
46 views
How do I append PostGIS commands to the system path?
I'd like to be able to call psql instead of having to put in the full path everytime. I went into Environment Variables through My Computer and added the path to the semi-colon separated list, but ...
0
votes
1answer
118 views
What is the fastest way to identify the two nearest linestrings using PostGIS?
I want to be able to identify the closest roads to two points that are generated through geocoding (a start and end address). The points will likely be near a linestring. Two approaches that I have ...
3
votes
1answer
846 views
Postgis 2.0 - public.geometry_columns view does not contain correct info for views
We have recently updated our database to Postgis 2.0.
In our system we used to create views for tables containing a geometry column. After creating the view we also manually updated the ...
2
votes
1answer
244 views
How to find polygons inside polygon with PostGIS 2.0
I have a relation representing all the counties in my country and the other one containing all the districts - e. g. each and every county is composed of several districts.
How do I select them with ...
4
votes
1answer
116 views
Update PostGIS after updating GDAL?
I am using PostGIS 2.0 and I want to use the raster functionality through mapserver. It seems as if the latest official GDAL release 1.9.1 has an unstable PostGIS raster driver, as pointed out in a ...
-1
votes
1answer
129 views
PostGIS raster support
I have the following requirements to manage raster data
1) Convert raster-maps from BSB format to PNG or GeoTIFF
2) Cut the borders of the map
3) Merge individual maps to form a contiguous coverage ...
2
votes
1answer
311 views
Access PostGIS Raster layer through mapserver
I am trying to use a cgi script calling mapserver to display a raster layer that is stored in a PostGIS database. However, only a blank white image is returned and I don't know where the problem is.
...
5
votes
5answers
727 views
How to split OSM roads into individual segments at intersections?
I want to create a road-network for use with pgRouting using OpenStreetMap data. I loaded a shapefile from GeoFabrik into a Postgres table (with PostGIS enabled). However, one problem I had was that ...
7
votes
1answer
222 views
Are Zonal Statistics possible in PostGIS2?
Now with postgis2 which supports rasters by default is it possible to do a zonal statistics analysis?
I've google it but I haven't found anything solid? Is there a tutorial outthere to get me ...
2
votes
3answers
426 views
How to import data with SRID 4269 to GEOGRAPHY type?
In PostGIS, we are importing various US census bureau shapefiles (with SRID = 4269) using shp2pgsql loader. I have medium-sized database with several tables containing fields of type geography ...
3
votes
2answers
719 views
Loading geotiffs into PostGIS using raster2pgsql
I have an issue with loading some Ordnance Survey raster data into PostGIS. I have been using the following raster2pgsql command to load a tif that I have placed in my C:\Program ...
1
vote
2answers
97 views
st_intersection; What Im doing wrong?
Im trying to run this query :
create TABLE data.agri_grc as select
id, code_00,
ST_Intersection(data.agri.geom,data.grc_bor.geom) as geom from
data.agri;
But im getting this error:
ERROR: missing ...
0
votes
1answer
615 views
How to export data from QGIS to display in Google Maps?
I'm exporting layers of a project for a quantum gis postgis table and visualizing the data in gmaps, but the coordinates are very wrong.
is there any special way to export the quantum gis? postgres ...
1
vote
0answers
1k views
Create a stacked bar chart with matplotlib [closed]
I'm trying to create a stacked bar chart in python with matplotlib and I can draw my bar one up the other
# -*- coding: utf-8 -*-
import psycopg2
import matplotlib.pyplot as plt
import numpy as np
# ...
-2
votes
1answer
171 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(
...
3
votes
1answer
163 views
How can I find the nearest points (plural) on a line segment using PostGIS
I'm locating the nearest point on a line segment with PostGIS and ST_ClosestPoint, I can select the point on each of these line segments which is closest to the starting point. Which looks something ...
2
votes
1answer
340 views
How to render PostGIS raster with Mapnik XML?
I'm trying to manage raster files from PostGIS, which to be rendered using Mapnik. I used raster2pgsql to load those GeoTIFF images to PostGIS, and I think the loading process turned out OK. The ...
1
vote
1answer
284 views
Importing planet files into Nominatim
After a gruesome night installing PostgreSQL 9.1, PostGIS 2 and Nominatim 2 on CentOS 6.3 using the instructions here, I am finally at the stage of importing a US planet file.
Problem: In ...
3
votes
2answers
457 views
Force SRID in views in Postgis 2.0
I have a very tricky problem:
I have a Postgis 2.0 database, used as datastore for Geoserver 2.1.3
I have a table with a geometry column (named shape), with SRID 4326
I have created a view like ...
1
vote
1answer
286 views
PostGIS and geometry column
I have a csv table. Each record includes a start node (lat1,lon1) and an end node (lat2,lon2).
I have already imported the .csv into Postgresql 8.4. Now I would like set the geometry column. I tried ...
1
vote
0answers
111 views
How could I make this PostGIS query run faster?
SELECT st_band(rast, 1), st_width(rast), st_height(rast),
st_bandpixeltype(rast, 1), st_bandnodatavalue(rast, 1),
st_scalex(rast), st_scaley(rast), st_upperleftx(rast),
st_upperlefty(rast) FROM ...
2
votes
1answer
73 views
Join Zip Codes Table to Nearest City from Second Table
I have two tables, siteareas and ziplookup. The former contains large cities in the US; the latter all US zips with lat/lngs. I have a foreign key into the former table in the latter: sitearea_id. I ...
2
votes
0answers
67 views
Are geotiffs with the embedded georeferencing information supported?
I am able to load raster data into my postrgreSQL data base however when I display in Quantum GIS the pixel height and width of the image is being translated into real world lat/lon coordinates, as a ...
1
vote
1answer
289 views
error performing wfs-t insert in postgres 9.1.4
I am getting error performing insert exception while performing wfs-t insert operation when i use postgres 9.1.4 and postgis 2.0. but i get successful insert when using postgres 9.0.1 and postgis ...
3
votes
1answer
210 views
Are there limitations using a PostGIS out-db raster?
I have been trying to import a large raster into a PostGIS 2.0 database and hit a few stumbling blocks.
Initially when I tried to import the raster using raster2pgsql, I would receive the following ...
2
votes
0answers
52 views
How to convert FROM Navit to PostGis or SHP?
I have a Navit BIN file which I want to use in PostGis or QGis, so I need to import it to PostGis or convert it to a shapefile. I have found a lot of information on how to convert data TO the Navit ...
-5
votes
1answer
161 views
How to create,store and retrieve the spatial data in postgresql [closed]
i am new to postgresql/postgis
can anyone explain in steps about how to store the spatial data and retrieve the spatial data and visualise in map in a proper steps.. pls . its very urgent..
2
votes
1answer
261 views
Error creating a spatial database. ERROR : could not load library “/usr/pgsql-9.1/lib/rtpostgis-2.0.so”
I am running PostgreSQL 9.1 with Postgis 2.0 on Fedora 15.
When trying to install the raster support,
psql -d mydb -f rtpostgis.sql -v ON_ERROR_STOP=1
I get the following error
...
2
votes
1answer
581 views
How to find the nearest point by using PostGIS function?
table A:
lat | long | the_geom | code | sign
13.8433095 | 100.6360357 | 0101000020E61.... | ABC | start_point
13.7544738 | 100.5459646 | 0101000020E6..... | ABC | end_point
13.4124215 | 100.6232332 ...
0
votes
1answer
41 views
Can I use in a postgis db within the same table a combination of CRS?
I'm experimenting around with my postgis2.0 database. I want to create a basic table to store all my point data and in the process,I realized that the coordinates are in different CRSs. So naturally ...
