Tagged Questions

1
vote
2answers
44 views

Geoserver SQL view parameterizing

I've got a postgresql table that has the following attributes: name String begintime String endtime String the_geom Point Now I'd like to create an sql view in geoserver (2.2 ...
1
vote
0answers
19 views

error in loading raster tiles on postgreSQL

I am trying to import raster data from PostGIS to GeoServer. I follow the instructions given on this link. ...
0
votes
0answers
13 views

Which all columns should I add in postgresql table so that it stores elevation values and displays them in Geoserver?

I am using geoserver and postgresql. I imported raster (.tif) file to postgresql using raster2pgsql. The file thus imported creates a new table in postgresql. But when that file is previewed in ...
1
vote
1answer
66 views

Win7 Senior users_Which pgRouting and postGIS versions are stable with postgreSQL8.4?

I'm working on a postgreSQL ,postGIS and pgRouting project on Windows 7 I need to work on a stable version (no time for risks), and I can see that many people are asking the same question many ...
0
votes
1answer
50 views

raster2pgsql missing in Opengeo-suite installation

I installed opengeo-suite 3.0.2 on Ubuntu 12.04 and although the stack seems to be working fine, raster2pgsql is no where to be seen! root@mywebsite:/usr/local/lib/postgresql/9.2# locate raster2pgsql ...
0
votes
1answer
38 views

Schema for offline map editing and pass to production environment

I'm working with QuantumGIs and PostgreSQL/Postgis. So when I edit the layers, the changes are reflected on the DB. The thing is I want to do some "offline" editing before committing the changes to ...
0
votes
1answer
42 views

Shp2pgsql - exec() not allowed on external server

Me and my collegue are using the shp2pgsql and psql commands in php code (a Drupal module to be precise). We put these commands in a php variable and use the exec() command to execute them. This ...
0
votes
1answer
152 views

How to store an image in PostgreSQL and display it in an openlayers popup?

This is question regarding storing of image in PostgreSQL and display in openlayers popup through geoserver(using wms service). PostgreSQL is installed in my virtual machine. I tried to store image ...
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
129 views

ajax not working with postgresql

I know is a silly question but I thought I should ask since you guys know more about postgresql. Sorry for being analytical, but I think its the only way to make my question clear. I'm using ...
1
vote
0answers
121 views

SELECT DISTINCT from table in Geoserver SQL view [closed]

The postgis table I have has the following columns, id | name | style_id | unique_id | time_stamp | the_geom(polygon) and logically the unique constraint (not currently imposed in the db) lies with ...
4
votes
2answers
219 views

PostgreSQL, PostGIS and GeoServer publishing 1.7 million records

I have a polygon geodata in postgresql and I am publishing out to geoserver the 1.7 million records. How long is too long when processing? EDIT: Forgot to mention that I successfully published a ...
3
votes
3answers
308 views

Geoserver, PostGIS and Postgres setup better on which web server?

Is it better to have Jetty or Apache as a Webserver for GIS stack?
10
votes
0answers
510 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. ...
3
votes
3answers
162 views

For the non-IT savvy GIS person (not great w/ Linux & Apache) could someone suggest how to set up PostgreSQL, Geoserver, and ISS/Apache?

I've heard of GeoCommon as being an easy GIS solution, but I'd like to host the data locally for internal users. I know of a group called Open Geosuite - but the ongoing maintenance is something I'd ...
0
votes
1answer
181 views

GeoServer and local PostgreSQL database without Internet

simple question: can I work on GeoServer and local PostgreSQL database on my PC without need for Internet connection ? would I be able to connect GeoServer to the database and create layers ? also ...
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 ...
1
vote
0answers
188 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
1answer
238 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
3answers
813 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" ...
2
votes
2answers
674 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 ...
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
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 ...
2
votes
2answers
2k views

What causes this unexpectedly poor GeoServer/PostGIS/OpenLayers performance?

I am having a tough time making this map run smoothly (play around with it for a bit, you'll see). I have taken a few tips from OSGeo's Making Maps Fast document, but I think there's another issue ...
6
votes
2answers
271 views

Memory considerations for cloud based GeoStack

Some time ago I asked about hardware considerations of cloud based GeoStack implementation. As a follow up to this question There are some good pointers in related question already, but they mainly ...
6
votes
4answers
623 views

Rename postGIS table and updating the GeoServer?

I want to rename one of my postGIS tables. However, when I do this by applying a simple ALTER TABLE old_name RENAME TO new_name; The spatial data, as I understand it, isn't updated with the new ...