3
votes
1answer
737 views

Loading Shapefiles into PostGIS using shapefile import/export manager

I am a complete beginner with PostGIS. I've started learning it using the tutorials provided by Boundless. In section 4 of this tutorial where I want to import shapefile in PostGIS, I do not have the ...
1
vote
1answer
634 views

How to install PostGIS correctly with OpenGeo Suite 4.0 community edition on Ubuntu?

I have installed the OpenGeo Suite community edition, version 3 and 4, onto Ubuntu Server 10.04 and 12.04 multiple times in the past, with virtually no problems. With the latest version of OpenGeo ...
1
vote
1answer
60 views

Opengeosuite 4 unable to open psql

When I try and open psql from the postgis menu in opengeosuite 4 on the Mac I get the following error message. “psql” can’t be opened because PostGIS is not allowed to open documents in Terminal. ...
2
votes
3answers
123 views

How should I implement a many-to-many relationship in a web mapping application?

Scenario: I am given a layer of point locations called "problems." These will be displayed on a web map. Users will then use the web map interface to create and populate field information for a point ...
2
votes
2answers
280 views

Possible to downgrade Postgresql and PostGIS versions and still be compatible with latest OpenGeo Suite?

I'm trying to connect ArcGIS Desktop 10.1 to PostGreSQL/PostGIS tables. I have PostGreSQL 9.2/PostGIS 2.0, which was installed with the latest OpenGeo suite. Unfortunately ArcGIS direct connections to ...
1
vote
0answers
97 views

can Geocat Bridge enable me to connect to existing PostGIS database and make edits through ArcGIS?

We are planning to set up a Webgis to share our GIS data on the web. Currently, we are on a desktop GIS and using ESRI's File geodatabase format. We are considering ArcGIS Server or using Opengeo ...
2
votes
2answers
378 views

Problem with PostGIS in Opengeo Suite in Ubuntu 13?

Everything is working fine after installing the Opengeo Suite in Ubuntu except PostGIS issues. In the dashboard the PostGIS manage is disabled(grey) but PostgreSQL is working via pgadmin3. And also ...
1
vote
1answer
236 views

Loading PGadmin III GUI Linux

Having tested out the functionality of OpenGeo Suite Community, I have installed the Linux version on my Centos 5 Server. However unlike in windows the dashboard is greyed out for Post GIS. I believe ...
0
votes
1answer
135 views

error printinf pdf in opengeo suite client sdk app

I am using OpenGeo Suite 3.0.2 I created an app using Client SDK. Stored the raster and vector data on postgreSQL/PostGIS print tool is not working, giving error i.e. "Java.io.IOException: the ...
5
votes
1answer
1k views

How to import GeoTIFF via postGIS into GeoServer?

As a simple test case, I'm trying to configure the software stack of OpenGeo such that I can display a GeoTIFF as an overlay to a normal map like OSM. So I perform the following steps: Create a ...
2
votes
1answer
429 views

How to install multiple versions of postgres in same os windows 7 64-bit?

I have already installed PostGIS along with opengeosuite and it is the latest version. Now I want to run pgrouting but the latest stable version does not compatible to the latest postgres versions. ...
1
vote
1answer
342 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 ...
3
votes
1answer
114 views

OpenGeo Suite PostGIS Data Location

I have OpenGeo Suite installed on a server. I want to have the PostGIS data stored on a different drive (D) on the server instead of on the C drive under my username. How do I do this?
3
votes
1answer
370 views

How to put data in remote geoserver?

I created some layers and upload it to PostGIS and then GeoServer and then styled it using GeoExplorer. I have done all this in localhost. I used the iframe generated in GeoExplorer and used it in my ...
5
votes
1answer
428 views

PostGIS - Why are my ST_Union results (stored in a new table) outputting as points and not polygons?

I've decided to move to PostGIS to merge polygons rather than spend hours doing in in QGIS. However, I'm hitting an issue where the results of an ST_Union query are being stored, or at least outputted ...
2
votes
2answers
281 views

Why does GeoServer copy my PostGIS tables?

I have some geospatial data in a PostGIS database. I want to serve that data to a web map app with GeoServer. But every time I add a table as a layer in GeoServer, it creates a duplicate table in ...
1
vote
1answer
129 views

Intersecting 3 tables with Spatial SQL

I have three tables I need to intersect but not sure how to get the third Heres what I have so far: SELECT nyc_neighborhoods.name, SUM(nyc_census_blocks.popn_total) AS POP FROM nyc_neighborhoods JOIN ...
5
votes
1answer
123 views

Interactive geographic region definitions

Background An organization has regions within a province, but has no list of coordinates that define region boundaries. I would like to draw custom polygon areas on a map using a web-based and ...
3
votes
2answers
519 views

Updating Apps on OpenGEO suite Community Edition

I would like to update PostgreSQL and PostGIS on Opengeo CE to a newer version, maybe the other apps too (geoserver, openlayers, etc). Can it be done? Can someone point me the right direction? ...