Tagged Questions
0
votes
0answers
13 views
QGIS Connection PostGIS and shapefile
I'm working on QGIS with a database created in PostGIS and a shapefile. Inside the database, I have geometry type data about location of some points, instead on the shapefile there some selected ...
0
votes
0answers
48 views
PyQGIS + PostGis: FATAL: sorry, too many clients already
I searched for questions regarding this problem and hadn't find one. I'm developing a custom application with a map canvas to show some geographic information from a PostGis database. After some ...
3
votes
2answers
215 views
Adding a GIS feature to existing database entry with QGIS
I've built a database with postgreSQL with tables, which include geometry columns.
When I add some data to my non-geometry columns, I can see them in QGIS when I connect to my database using postgis. ...
2
votes
0answers
22 views
Insertion of a raster geotiff in PostgreSQL database
I am new in PostgreSQL and psql.
What is the method to insert a raster geotiff in a postgreSQL database using command psql? What is the best format? Someone indicates to save a raster image as BLOB ...
1
vote
1answer
170 views
Are database client files platform specific?
I'm just looking for some clarification on a question that came up with me this morning. Are the DLL client files (libeay32.dll, libiconv-2.dll, libintl-8.dll, libpq.dll, and ssleay32.dll) platform ...
0
votes
3answers
900 views
How to create a new 'gis' database in PostGIS?
I'd like to create a new database in PostGIS, so I can load stuff into it while the current database is being used. According to the docs
Some packaged distributions of PostGIS (in particular the ...
3
votes
1answer
293 views
Database connection failed
I am trying to connect from Arc Cataloge (version 10.1) to postgresql 9.2. But every time I try to make "Database Connection" I am getting this error:
Failed to connect to the specified server.
...
2
votes
1answer
421 views
WFS & Feature Access -> Database connection / Database support (ArcGIS 10.2)
Over the last two days I've tried to set up and to use a postgreSQL database to use WFS and Feature Access.
I've also started a thread in the esri forums, but I hope that I can reach a wider audience ...
9
votes
4answers
747 views
Open Street Map and PostgreSQL what do I exactly need?
I make my first steps in the GIS world and everything is very new for me even if I work on a "huge" project (ie: for a single programmer) very related to maps.
My project needs to know informations ...
3
votes
2answers
465 views
Can I import a .gml file into Spatialite in QGIS?
I have some Ordnance Survey Address Base data files which have a .gml extension. I have imported them to GGIS as vector layers along with some mapping data but would like to explore them with ...
0
votes
1answer
124 views
Column exists in DatabaseMetaData, but does not exist in relation?
I am using JDBC to query a PostgreSQL database. And I want to populate a column called wiki_url based on the value of another column, level which will determine which value of 5 columns to concatenate ...
1
vote
0answers
65 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 ...
6
votes
1answer
505 views
Data visualization and maintenance tool
Background
Looking to leverage an existing GIS system for exploring organizational data.
Architecture
The following figure represents a high-level overview of the system's desired features:
The ...
4
votes
1answer
216 views
Spatial index vs two coordinates indexes
I have a table with two columns: latitude and longitude. I want to get all objects inside a "rectangular" (well, rectangular in a lat/lon coordinate metric) bounding box: min-max latitude and min-max ...
4
votes
1answer
327 views
DBMS and ArcSDE Architecture for Large (Mostly Non-Spatial) Dataset
I have ~1000 fixed points representing data collection stations with multiple sensors, and a csv that is ~4.5GB of values in the format:
id pointid sensor measdatetime measvalue
50345 500 ...
3
votes
1answer
1k views
Casting a Geography type in PostGIS
I have the following table defined, which uses PostGIS geography.
CREATE TABLE test_geog (
id SERIAL PRIMARY KEY,
boundary GEOGRAPHY(Polygon)
);
I added the following test polygon to the ...
1
vote
0answers
93 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 ...
8
votes
2answers
607 views
What are the Pros and Cons of hstore data type in postgis?
PostgreSQL has a module named hstore that implement the use of key/value pairs (it's something like the OpenStreetMap model, but in a single table).
What are the Pros and Cons of hstore regarding GIS ...
