All Questions
Tagged with boundless-suite postgis
34 questions
6
votes
1
answer
22k
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 ...
- 449
0
votes
1
answer
1k
views
The geometry_type of a spatial column cannot be changed (Requested changing type from "MULTIPOLYGON" to "GEOMETRY" for column "geom" in table X)
Using Symfony 2.8.24, Doctrine 2 and Jsor's doctrine-postgis library, the latter to make Doctrine get along with spatial types like geometry, geography, etc.
So, I have a table with a column of type ...
- 205
1
vote
0
answers
1k
views
Import SHPs and DBFs to PostgreSQL in pgAdmin 4 on a Mac
I am receiving the following error when trying to import a dbf file into PostgreSQL (v 12, pgAdmin 4) using the Boundless/OpenGeo Suite for Mac pgShapeLoader GUI (which was recommended for Mac users ...
- 1,108
8
votes
6
answers
17k
views
GeoServer replies HTTP Error 503
I've seen this question was asked before but I couldn't find any solution to the problem.
Since today, my GeoServer does not reply on any requests anymore, I can't even access the GeoServer UI. I ...
- 233
2
votes
1
answer
690
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 ...
- 21
1
vote
1
answer
297
views
pgShapeLoader cannot be opened because of a problem
I installed the OpenGeo Suite 4.8 on MacOS 10.13. I can open pgadmin3 from the package, as well as PostGIS. When opening the pgShapeLoader I get the following error:
pgShapeLoader cannot be opened ...
- 975
5
votes
1
answer
11k
views
How to install multiple versions of PostgreSQL in same os Windows 7 64-bit?
I have already installed PostGIS along with OpenGeo suite and it is the latest version. Now I want to run pgrouting but the latest stable version is not compatible to the latest PostgreSQL versions.
...
- 653
1
vote
1
answer
575
views
Print button greyed out on GeoExplorer?
I have recently downloaded and installed the OpenGeo Suite from Boundless, and I am running through a few tutorials. I'm using GeoExplorer to manipulate layers defined in GeoServer (running from my ...
- 147
10
votes
1
answer
9k
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 ...
- 588
2
votes
1
answer
2k
views
Import point cloud into PostgreSQL/ pdal pipeline fails
I have a point cloud dataset that I would like to upload to my postgres/postgis database.
I followed this tutorial and I could install everything without problems (on ubuntu 14.04. On ubuntu 12.04 ...
- 1,519
2
votes
0
answers
232
views
GeoExplorer cannot upload shapefiles into PostGIS [closed]
I have installed OpenGeo 4.1 on Ubuntu Linux 12.04 following the official instructions.
I then followed the tutorial Load your data with GeoExplorer.
I was able to zip and upload a few shapefiles. ...
- 11.2k
2
votes
3
answers
255
views
Start postgis (Opengeo suite azure linux vm)
I have a fresh Azure Linux VM based on Opengeo suite. The dashboard and geoserver are working. But I can't connect or configure postgis. I follow this guide.
Via putty, logged in with the only ...
- 31
2
votes
1
answer
2k
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 ...
- 331
6
votes
1
answer
246
views
Interactive geographic region definitions [closed]
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 user-...
- 711
2
votes
1
answer
364
views
Error printing pdf in OpenGeo Suite client SDK app
I am using OpenGeo Suite 3.0.2. I created an app using Client SDK and stored the raster and vector data on postgreSQL/PostGIS.
The print tool is not working, giving error the following error:
Java....
- 81
1
vote
1
answer
379
views
OpenGeo Suite 4.0.1 Activating SSL for remote connection
I have installed OpenGeo Suite 4.0.1 on my Windows 7 OS and created a spatially database. Now i want to connect to my database remotely but then it seems like i have to generate a self-signed key. i ...
- 41
1
vote
1
answer
478
views
OpenGeo Explorer for QGIS 2.6.1 - No module named ogr2ogrtopostgis
I'm trying to use the OpenGeo Explorer plugin for QGIS (v2.6.1) to import shapefiles to my PostGIS database. I can connect to the server, but when I try to import, I get the following error:
No module ...
- 295
3
votes
2
answers
433
views
OpenGeo postgres installation not working from command line but works from PGadminIII on fresh install
Problem:
I just did a default install of opengeo suite (4.1) on Ubuntu 12.04 and followed instructions exactly. The problem is that I can connect just fine to my postgresql through pgadminIII (1.18....
- 187
4
votes
1
answer
791
views
How to install PostGIS correctly with OpenGeo Suite 4.0 community edition on Windows 7?
I have installed the OpenGeo Suite community edition, version 3, onto Windows 7 multiple times in the past, with virtually no problems.
With the latest version of OpenGeo Suite (4.0.1) (which ...
- 51
1
vote
1
answer
2k
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
...
- 1,695
2
votes
2
answers
3k
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 ...
- 331
3
votes
2
answers
643
views
Updating apps on OpenGeo suite Community Edition
I would like to update PostgreSQL and PostGIS on OpenGeo suite Community Edition to a newer version, maybe the other applications too (GeoServer, OpenLayers, etc.). Can it be done? Can someone point ...
- 279
0
votes
1
answer
116
views
Can OpenGeo Suite co-exist with Homebrew-installed PostGIS/PostgreSQL in Yosemite?
I installed PostgreSQL (9.4.1) and PostGIS (2.1.7) using Homebrew in Yosemite (10.10.3). I'm just starting my way through "PostGIS In Action." I've been starting and stopping the server in Terminal ...
- 103
5
votes
1
answer
1k
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 ...
- 1,035
1
vote
1
answer
479
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 ...
1
vote
1
answer
108
views
OpenGEO templates and postGIS
I am trying to display my shapefiles.shp with ol3edit template. On OpenGEO Suite I have successfully created an ol3edit application.I'm in possession of the ol3editApplication.war but the shapefiles....
- 111
0
votes
1
answer
222
views
Installing Cartaro using Acquia Dev Desktop and link it with GeoServer and PostGIS
How do I configure GeoServer and PostGIS so that I don't get the following error when installing Cartaro using the Acquia Dev Desktop. I am just installing Cartaro locally for testing, or else how can ...
- 11
2
votes
3
answers
959
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 ...
- 31
3
votes
1
answer
2k
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 ...
- 653
1
vote
1
answer
901
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 ...
- 398
2
votes
2
answers
585
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 ...
- 855
2
votes
2
answers
454
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 ...
- 21
1
vote
1
answer
139
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.
...
- 645
3
votes
1
answer
177
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?
- 551