PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
1
vote
0answers
291 views
How to display indoor map using OpenLayers?
I created my osm file in JOSM, and i imported it to my database by osm2pgsql tool.
I created new layer in my osm.xml file, which selecting data with query:
select way from planet_osm_line,
(select ...
1
vote
0answers
686 views
how can we save vector files in openlayers
i'm using Postgis + tomcat + geoserver + openlayers for my application.
with the help of some tutorial i have reached upto gettting feature information of layers.
Next i want to edit and save ...
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 ...
1
vote
0answers
155 views
Add building height from xyz points in PostGIS
I have been trying to get this query right and just can' seem to.
I have a building polygon table with over 7 million polygons, indexed
I then have a grided height XYZ table with attribute 'height' ...
1
vote
0answers
76 views
How to maintain schema when copying feature from layer 1 to layer 2, where both layers have same schema?
If I load two unique layers, wherein each layer contains unique data, but both layers share the exact same schema, why is it when I copy a feature from layer 1, and paste it into layer 2, the ...
1
vote
0answers
183 views
Manifold 'Link drawing to query' - can I do this in QGIS?
Manifold GIS allows the creation of dynamic drawings linked to queries.
Unfortunately I do not have access to Manifold as my employer refuses to pay for it, so am currently investigating ...
1
vote
0answers
203 views
Live KML Feeds - From the Ground Up, How Would You Build It and Why?
I found the "Live KML from PostGIS to Google Earth" post very informative but a bit daunting for someone new to the open source world of products like PostGIS and GeoServer.
If I am building the ...
1
vote
0answers
126 views
I am getting a blank layer preview from geoserver after Quick Exporting my shapefile to postgis and then getting postgis to point to geoserver
What could be the potential problems? Looking at the layer's data fields/form the one thing that isn't filled is the Native SRS and its source, but I have already passed in the projection info as it ...
1
vote
0answers
482 views
Cannot Display Data From POSTGIS
I try to display the data that I have converted shp into PostGIS database with MapServer and OpenLayers. When I try to show directly shp file is successfully displayed in OpenLayers, but when I try to ...
1
vote
0answers
139 views
How to add column “EDGE” in pgRouting?
I am a newbie in PostGis and pgRouting. I have installed and configured both on my windows PC, following FOSS4G tutorial. I am able to see the result in browser, using GeoServer and OpenLayers. ...
1
vote
0answers
84 views
Getting started with storing LoST and GML searching
I am working on a logging and search database application.
The application will receive event records containing XML LoST values (RFC5222 Location-To-Service-Translation). These records will be ...
0
votes
0answers
39 views
Mapping latlng values to a point on a HRAP grid
I have a copy of some NWS rainfall data loaded into a PostGIS database. Given a lat lng point, I want to find the rainfall for that given day.
The original data are in XMRG format and projected ...
0
votes
0answers
34 views
polygon/raster intersection artifacts
I'm intesecting a polygon with a raster using PostGIS > 2.0. The outer boundary of the polygon is formed by the convex hull of polygons (building outlines plus safety margin) and the inner rings are ...
0
votes
0answers
44 views
QGIS Plugin Development - Displaying Data from a feature
I want to display data based on the feature currently selected/clicked on.
I am following a tutorial from http://www.qgisworkshop.org/html/workshop/plugins_tutorial.html.
It initially shows you how ...
0
votes
0answers
20 views
Loading raster from PostGIS DB into QGIS: succeeded yesterday, fails now
I have a PostgreSQL(v.9.2)/Postgis(v.2.0.3) database which includes raster layers (added through raster2pgsql).
To open them in QGIS (v.1.8.0-Lisboa), the "Add Postgis layer" menu will not work; ...
0
votes
0answers
21 views
NYC Building Perimeter Shapefile after 2011
I've been using the following NYC building perimeter shapefile from the DOTT for some work. This file however dates back to 2010. Is there a newer one available, and if so where?
I have found this ...
0
votes
0answers
39 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
40 views
Identifying Intersections of Geology using PostGIS
I'm having problems identifying intersections on a layer of linework, the lines are representative of contacts and faults (geological rock formations). I am trying to select where there are connected ...
0
votes
0answers
42 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
61 views
QGIS SPIT errors loading shapefile into PostGIS
With QGIS 1.8 on Windows 7, I just installed PostgreSQL / PostGIS and tried to load my first data into it, a shapefile using SPIT, but failed:
ERROR: Geometry type (Polygon) does not match column ...
0
votes
0answers
26 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
50 views
Add dynamic layer to geoext tree
I'm trying to add a dynamic OpenLayers Layer in a folder(children) of tree.
I've tryed the following code and it works, but I don't know how to associate the layer with a layer of OpenLayers() type:
...
0
votes
0answers
55 views
How to fix 'pgsql2shp: command not found' in PostGIS Query Editor Plugin?
I'm using QGIS 1.8 on Macbook Pro running OSX 10.8.3 and I am having difficulty using the PostGIS Query Editor plugin.
When I try and execute a query in this plugin I get the following error in the ...
0
votes
0answers
28 views
Join Geological Linework based on shared attributes while obeying rules
I'd like to join all adjacent geology faults within a table if they share the same attributes in f_type, f_class, f_name and f_conf columns. However I don't want to join adjacent lines with equal ...
0
votes
0answers
29 views
How to get a session id based map in Geoserver or: best practice to display map in Geoserver from dynamically created Postgis tables
I am trying the following: I have a large table (~2 mill. rows) of the following design
Table "public"."cells_ids_and_counts"
Column | Type
...
0
votes
0answers
35 views
tinyows failing to connect to postgresql - Ident authentication failed for user “postgres”
I'm getting the above error on a new and local tinyows installation on Centos 6. Postgresql 9.2, PostGIS 2.0.
I can connect to PostGreSQL locally and from my LAN using several other methods (psql, ...
0
votes
0answers
19 views
calculating st_simplify tolerance for openlayers
I want to display a vector layer in openlayers. Users can scale the map before they load the vector layer and I'd like to simplify the geometry with st_simplify before sending it to the client.
Does ...
0
votes
0answers
52 views
QGIS cannot view raster loaded to PostGIS through raster2pgsql
I tried to load a raster GeoTIFF image to a PostGIS database using "raster2pgsql" following the OpenGeo Suite Manual. The command I used is:
C:\>raster2pgsql -s 4283 -I -C -M "C:\Program ...
0
votes
0answers
40 views
Table for feature layer in PostGIS database cannot be published and enabled on GeoServer
I have tried to publish a table for feature layer in a PostGIS database to GeoServer 2.2.5. The layer was added and published. However, the layer has got a yellow exclamation mark in the "Enabled?" ...
0
votes
0answers
64 views
geoserver PointStacker
I'm trying to implement a clustering solution using geoserver (version 2.3.0 ), for this I'm using the Rendering Transformation Point Stacker and the clustering itself works fine.
However I have ...
0
votes
0answers
44 views
Problem in joined table
I test to join two postgis layers, one geometryc and other without geometryc data.
Data are loaded properly in qgis (1.8 in Osgeo4w distribution) and the joins seem been done properly but when i try ...
0
votes
0answers
193 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
72 views
Creating maps using Polymaps
We are already working with the TIGER/Line Shapefiles. Now we want to be able to produce maps. Trying out Polymaps made us realize that it makes calls to Cloudmade to get the mapping tiles.
Is this ...
0
votes
0answers
101 views
How to pass parameter postgres sql to Map file - java
I am new to GIS. I want to pass a parameter map file dynamically. Or how map file fetches the data from the database. I can't find out the solution. This is my map script.
LAYER
CLASSITEM ...
0
votes
0answers
41 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
102 views
how to plot point on openlayer google street layer programmatically
I want to plot points on google street layer using python programming and postgresql database.
Mainly I want to extract data from database and plot it on the google street layer on Quantum GIS 1.8 ...
0
votes
0answers
107 views
Merging OSM files with OSMOSIS and import to Postgres with OSM2PGSQL
I have a problem merging and then importing two OSM files.
I downloaded to distinct .osm-files from cloudmade. They are not sharing any geographical attribute (as the first is the country Monaco, the ...
0
votes
0answers
81 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
62 views
activerecord-postgis-adapter doesn't work with array columns?
I've successfully installed PostGIS, but when I try to run rake db:migrate in my Rails app, that uses postgres_ext for Postgres' array column support, it fails, even when I remove any array column ...
0
votes
0answers
138 views
why preview image is blank for ImageMosaicJDBC (postgis raster) layer?
I follow http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html to publish a ImageMosaicJDBC layer in geoserver.
the layer seems published ok and saved, but the preview of this layer ...
0
votes
0answers
49 views
Refreshing a KML Superoverlay
I am testing a Geoserver/PostGIS/KML stack and am having trouble getting the superoverlay to regionate correctly as a superoverlay. Specifically, once the database is updated with new features the ...
0
votes
0answers
105 views
how to show LINESTRING intersection with other layers in Openlayers?
I'm using Postgis/Geoserver/Openlayers and I have a query that gets al the "towns" that are near a "road". Now, "road" and "towns" are different layers, and I want to show them in Openlayers.
But I ...
0
votes
0answers
152 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
104 views
Can Nominatim use another OSM importer?
Nominatim comes with osm2pgsql by default and uses it to import the osm files during the initial set up (utils/setup.php).
Problem: I am experiencing problems with importing us-northeast.osm.pbf ...
0
votes
0answers
82 views
Nominatim (postgresql) import problem: unable to start pgsql
While importing the planet files into Nominatim, I encounter the following error below. The import command used is ./setup.php --osm-file us-northeast.osm.pbf --all
I have been following the ...
0
votes
0answers
181 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
228 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
178 views
SELECT query PostGIS/Shapefile
I'm writing an QGis Python Add-on which should check the quality of digitized data.
My first question: is there any way to use SELECT commands on Shapefile Layers?
Because i didn't find anything ...
0
votes
0answers
331 views
How to add ECW support to GDAL bundled with PostGIS Windows
I'm currently trying the new raster functionalities of PostGIS 2.0 and I successfully imported some GeoTIFF file into PostGIS (although it only find one band so it's all black and white for some ...
0
votes
0answers
87 views
Why does Geoserver save features in wrong projection?
I edit WFS layer with openlayers and after editing save changes. But edited object saved in wrong projection.
At first Geoserver get layer from PostGIS with projection EPSG70066. In geoserver i ...
