PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
1
vote
0answers
70 views
How to add legend in WFS openlayers
How i can publish WFS openlayer with legend, have tried different examples such as http://api.geoext.org/1.0/examples/vector-legend.js. But when i used tried this fire-bug shows an error=> ...
1
vote
0answers
54 views
Creating polygons for a choropleth map using PostGIS
I have a grid of points, each with a value to it as shown in the image below. The data was retrieved from PostGIS and rendered in Quantum GIS. The final result should be a polygons of a choropleth map ...
1
vote
0answers
76 views
PostGIS Better ST_Intersects Query
I am currently using the following queries to return all features that intersect a large and complex polygon. I initially tried to use a single ST_Intersect query but because the number of features it ...
1
vote
0answers
91 views
How can I map data points to OpenStreetMap (OSM) line data?
my goal is to filter measuring points of vehicles by mapping them to streets.
So I could filter out all the false data located in fields and rivers and so on.
I imported my data into a PostGIS ...
1
vote
0answers
35 views
Can I use RGeo::Point data in PostGIS queries without multiple conversion?
How can I represent RGeo::Point ( CAPI implementation ) in some way where I don't have to convert it once more in Sql?
Now I have something like this:
class Poly
scope :enclosing ->(geom) do
...
1
vote
0answers
44 views
New geographical point won't show on map
I did recently ask a question about how to add a new point to a PostGIS table. Now when I've got the new point in the table it should be visible on my map, but it isn't.
I'm using Mapnik together ...
1
vote
0answers
113 views
View PostGIS geometry in QGIS
I am a newbie to GIS systems so please be patient.
I have a PostGIS database set up with a spatial data table. One of the columns is of Geometry type and contains Points with SRID 4326. I want to ...
1
vote
0answers
43 views
How to import multiple shapefiles each with different source projections to postgis
I have a couple thousand .zip files each with a .shp, .dbf, .shx, and .prj inside them that I want to load into postgis. The problem is, they have many different source projections (each defined in ...
1
vote
0answers
36 views
Problems combining (union) Multipolygons in geodjango
I'm using geodjango and postgis (1.x),
What is the best way to combine (union) a list of multipolygons.
in what i assume is rather inefficient i'm looping trough like this
combined = multipolygon
...
1
vote
0answers
105 views
Setting geometry types importing to PostGIS with OGR
I'm using ogr2ogr to import data into a PostGIS database. Each dataset I need to import has (theoretically) the same exact data structure, but it appears that they are not the same geometry types. ...
1
vote
0answers
75 views
GeoDjango / PostGIS - Cut geometry by bounding box
I am looking for a solution to retrieve the geometry(ies) from a polygon/multipolygon within a bounding box in a GeoDjango application.
The application I am developing has a requirement to serve out ...
1
vote
0answers
132 views
working with multiple wfs-t layers
I am using multiple wfs layers and using editing tools in that like edit,draw,save etc.
The code is shown here......
var district = new OpenLayers.Layer.Vector("district(wfs)", {
...
1
vote
0answers
37 views
postgis union geometries in consecutive order
Database is postgres 9.2, POSTGIS="2.0.2 r10789" GEOS="3.3.6-CAPI-1.7.6" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.8"
i have geometries in consecutive order. Here is query:
SELECT ...
1
vote
0answers
50 views
Postgis walk through multilinestring
Maybe question title not correct, i have no idea how to formulate my question.
Database is postgres 9.2, POSTGIS="2.0.2 r10789" GEOS="3.3.6-CAPI-1.7.6" PROJ="Rel. 4.7.1, 23 September 2009" ...
1
vote
0answers
103 views
Function for Selecting Points in a Polygon
I've been banging on this for a few hours, but since I'm relatively new to PostgreSQL and PostGIS, I can't find the solution. I'm trying to create a stored procedure (function) which will return all ...
1
vote
0answers
79 views
Are there limitations with gdal virtual raster option?
I am new at Postgis and I'm groping...
I pretend to rasterize some weighty vector layers in Postgis, do some map algebra and reclassification with them and visualize intermediate as well as final ...
1
vote
0answers
109 views
How to merge linestrings which are connected with each other?
I would like to join linestrings which are connected to each other. The preferred output is a longer linestring based on all joined single linestings!
The table that holds my single linestrings is ...
1
vote
0answers
87 views
Break LINESTRING values in postgis into mutiple LINESTRINGs
Figure A below is the visual representation of what i have in my road data set. Line 1, Line 2, Line 3 in illustration are each represented as 1 row postgis DB inside a geometry column, some of these ...
1
vote
0answers
55 views
How can I snap 2 lines in QGIS so the st_distance between them is 0?
Sometimes when I snap the ends of 2 LineStrings together and I check the st_distance between those endpoints I get a value in the order of 1.1E-10 while at the same time when I check for equality of ...
1
vote
0answers
65 views
Renaming Columns in Geotools FeatureType
I am attempting to build a simple java program that loads shapefiles into a Postgis 2.0 database. Everything is working out great except that I would like to be able to modify the FeatureType in the ...
1
vote
0answers
53 views
django + apache mod_tile
I'm not sure if I'm doing this right and I need your opinion on this current situation. I'm creating a Web Interface using django and postgres as the database. With regards to the slippy map, I went ...
1
vote
0answers
71 views
Why is not ST_GeomFromEWKB() working?
The following SQL is working fine from the terminal:
SELECT MIN(ST_Distance(
ST_Transform(ST_GeomFromText('POINT(-3.163916 55.926528)',4326),32630),
...
1
vote
0answers
82 views
Query to find lat/lon of a house by street.name & house.number
How can I get house coordinates (latitude, longitude) by street.name and house.number? If it is possible, how I can get it?
Many thanks!
1
vote
0answers
132 views
Importing grib, grib2, netcdf to PostGIS
According to grib2 to raster? (grib2 -> raster2pgsql -> PostGIS 2.0 -> GeoServer), it seems like that grib2 can be treated as raster directly. Is it the so called "standard" way?
How about ...
1
vote
0answers
61 views
Geoserver WMS and filtering tables with cyrillic column names
I try to serve PostGIS tables with Geoserver WMS (both 2.1 and 2.2). Some column names are in cyrillic.
Problem is - service fails, when I try to filter by those cyrillic columns (both with CQL and ...
1
vote
0answers
42 views
How can I assign road names from OSM to gis linestrings using open source tools?
Starting with a shapefile of linestrings I want to assign street names to these lines if there is a match with a road/street in OpenStreetMap.
There are no exact matches as the linestrings have a ...
1
vote
0answers
117 views
pgrouting shortest path result in wrong order
I am using the Dijkstra shortest path algorithm to plot a route between two points using the latest version of pgrouting in postgresql 9.1 with postGIS 2.0.1.
I am able to get a correct result ...
1
vote
0answers
69 views
Convert native box to geometry
I have an old table that contains bounding boxes of lat long coordinates in a "box" type.
How do I convert them to PostGIS geometry ?
I tried using ...
1
vote
0answers
88 views
GeoServer and PostGIS connection technology
Does anybody know how GeoServer connects to PostGIS. Which technology is used? Is it JDBC?
Thanks
1
vote
0answers
183 views
How to handle postgresql/postgis geometry type errors in a function?
I have created the following function in PL/SQL to make a polygon from a set of linestrings:
CREATE OR REPLACE FUNCTION _myfunction(
_fid integer,
_rid integer
)
RETURNS VOID AS $$ ...
1
vote
0answers
27 views
Is it possible to permanently save the Edit Widget for a Postgis layer?
Is there a way of configure the editing type for a POSTGIS layer through Edit Plugin and do not lose the changes after remove the layer or exit the program?
1
vote
0answers
75 views
How to config geoserver to read style of vector layer from postgis/SQL store?
I've imported vector layers from map info pro to both SQL server and post gis using easy loader.
In both cases I've included style column in the exported table.
When I create new store in geoserver ...
1
vote
0answers
92 views
How can I use Convex Hull to select an area with a space from the points?
This refer to this post : Read Here
My goal is to select an area covering some points, but maintaining some space from points of border, like in the follow picture :
I think ST_Convexhull will do ...
1
vote
0answers
159 views
How to debug 'Layer is not valid error' from Python plugin?
I'm trying to understand what goes wrong with a QGIS python plugin.
Basically I'm trying to render a series of POINT.
The query works fine, at least giving it by hand from inside PostGIS DB:
"SELECT ...
1
vote
0answers
31 views
Converting geometry_dump to Point geometry vertex
If this was a Point geometry 010100000001DE02098A1B52C090A0F831E62E4640, is it possible to
represent the above geometry_dump Point Vertex. I am trying with St_collection...,
1
vote
0answers
58 views
footprint polygon from raster data with postgis
how can I create a polygon, containing the actual outlines (aka footprint) of a raster file with postgis?
I just need the outlines of the data containing parts of the raster.
ST_PixelAsPolygon ...
1
vote
0answers
106 views
Error recognising password; importing OSM to PostGIS in QGIS
When selecting OSM Tools (Import into PostGIS) , attching my .osm file in the Input option, selecting my OSM Database, and then clicking run, I am prompted to enter a password for connection.
"Enter ...
1
vote
0answers
82 views
Calculating spaces between roads from PostGIS database
Is it possible to calculate the spaces between the roads using a select statement in a PostGIS/PostGre Database? I tried using some combinations of the predefined functions as ST_Intersects & ...
1
vote
0answers
109 views
Postgres function with BOX3D error “doesnt start with BOX3D”
everybody. I created function search nearest point (pois) by using pg_routing as folowing
CREATE OR REPLACE function find_pois(inn_point text, distance int) RETURNS float[] AS --point(x y)
$$
...
1
vote
0answers
91 views
post gis command prompt problem
While I'm working in post gis sql command prompt its mode changing automatically.
I mean that the general form of command prompt as follows
template_postgis=#(we type query's here)
While working ...
1
vote
0answers
120 views
How to view error feedback in qgis when testing connection to postgres database?
Using qgis 1.8 on Ubuntu 10.04 with Postgres 8.4.13
I am creating a new (and my first) Postgresql connection in qgis.
I can connect to the user and the db using the pgsql client.
...
1
vote
0answers
426 views
searching GeoJSON features
After googling for many days and reading the OL documentation, I don't understand well how the filterToParams in OpenLayers.HTTP protocol should work, what I'm trying to do is to find and display the ...
1
vote
0answers
184 views
Why won't this PostGIS query display in QGIS
I am having trouble rendering the following PostGIS query in qgis1.803.
SELECT
s.musym,
st_intersection(s.the_geom,f.the_geom) as geo,
nextval('"soilsplittersequence"'::regclass) as k
From ...
1
vote
0answers
56 views
Database has duplicate values after running pgrouting
I am a newbie with postgresql and sql statements so maybe it is a trivial question, I'm sorry for that.
I am working on a postgis database and try to use the pgrouting function. My goal is to store ...
1
vote
0answers
69 views
How to export dxf of window view from postGis MasterMap layer
I have managed to get qgis to show my Mastermap data which is stored in a postGis database. It's national coverage so seems to take ages to load but that's another question.
I basically want to ...
1
vote
0answers
80 views
Is this pgRouting perfomance acceptable for my tiny server?
I'm testing pgrouting functions in a tiny server with 2GB of RAM and a dual core processor.
I wrote a program that create client process and they connect to the server in a specific hour to perform a ...
1
vote
0answers
242 views
Openlayers WFS Overlay Problem
a) I am running a PostGIS database, and I want to display a Table with a about 500 Points of Interest. The POIs have the projection EPSG 4326.
b) Geoserver is installed, running and connected to my ...
1
vote
0answers
470 views
How to fire a query from OpenLayers to GeoServer to fetch 'the_geom' column in PostGIS table?
I am coloring the polygon shapes of world_country. I have OpenLayers in my UI, GeoServer as server and PostGIS as db.
All I want is fire this query:
select the_geom from world_country where ...
1
vote
0answers
56 views
Make a thumbnail of a raster in PostGIS
I'm fiddling around trying to create a thumbnail of a fairly large (originally 27MB) raster, chunked into 64x64 blocks. I've got the following and it works, quite well, but I'm wondering if there is a ...
1
vote
0answers
105 views
PostGIS reports invalid Curve GML
PostGIS version POSTGIS="1.5.3" GEOS="3.3.1-CAPI-1.7.1" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.3" USE_STATS
Postgresql version PostgreSQL 9.1.2
I'm having issues inserting Curves into a ...
Related Jobs
Related Tags
postgresql × 45qgis × 44
geoserver × 34
openlayers × 22
pgrouting × 17
raster × 16
openstreetmap × 13
shapefile × 9
python × 9
sql × 7
postgis-2.0 × 6
linestring × 6
polygon × 5
wms × 5
mapserver × 5
database × 4
wfs × 4
qgis-plugins × 4
spatial-database × 4
php × 4
osm2pgsql × 4
gdal × 4
geodjango × 4
projection × 3
routing × 3
