3
votes
2answers
121 views

Recommended opensource solution for storing, publishing and querying GIS data

Our company has millions of feature classes currently stored through ArcSDE on SQL Server 2008 R2. We are kind of slowly making our way to opensource software. What we want to achieve is to be able ...
4
votes
2answers
109 views

pgAdmin vs psql

I have downloaded postgreSQl 9.3 and Postgis 2.1 recently as an educational adventure and have been working with both through the pgAdminIII interface. I haven't used psql yet when working with my ...
1
vote
2answers
47 views

How can I determine which polygons contain other polygons?

I am using only free, open source tools. I have two shape files: a shape file of voting precincts and a shape file of census tracts. I want to know: which voting precincts fit inside which census ...
1
vote
0answers
73 views

How can I edit spatial data automatically on postgis and check for topology errors on said data whitout using shapefiles?

So, I have spatial data stored in postgis (points, lines and polygons) and would like to edit and update those in an Open Source software (quantum GIS, grass, etc.) to check for topologic errors, ...
6
votes
4answers
2k views

Open Source equivalent to Collector for ArcGIS to use with QGIS/PostGIS?

From my reading of the Esri web pages the Collector for ArcGIS is tightly tied to that platform. I would be delighted to learn that I am wrong about this. I have a strong interest in generic mobile ...
0
votes
1answer
96 views

Creating a postgis database a GML application schema

Is there any open Source tool(automated or semi-automated) that converts GML application schema to a POSTGIS database/table .Specifically I have a huge application schema containing many ...
7
votes
1answer
282 views

Looking for free / opensource Lidar web viewer

I have lidar data which I want deploy my users using web viewer. I will probably hold the data in PostGIS (not sure yet). Is there good opensource/free lidar viewer that I can integrate with ...
6
votes
2answers
576 views

Are there open source solutions for travel demand modelling?

I'm looking for open source tools for travel demand modelling (eg The four-step UTMS). Preferably in a GIS environment. That works well with Qgis, Grass and Postgis. My question is not related to ...
2
votes
1answer
264 views

Are there Open Source alternatives to ArcGIS Aggregate and Extract Value to Points?

I am looking for some kind of Open source GIS library which can perform spatial analytic functions same as ArcGIS. My use case is : I am processing GeoTIFF file provided by USGS and performing ...
1
vote
0answers
96 views

How can I assign road names from OSM to gis linestrings using open source tools?

Starting with a shapefile of linestrings I want to assign street names to these lines if there is a match with a road/street in OpenStreetMap. There are no exact matches as the linestrings have a ...
1
vote
1answer
264 views

Automatic bulk snapping with FOSS

I'm looking for a tool that would be able to automatically snap features closer than a given distance. Is there such a tool/plugin for QGIS/GRASS/OpenJump? Would it be possible to achieve that with ...
5
votes
1answer
299 views

Parse error while inserting values into polygon feature

I created a polygon as follows create table boundary (id int, name text); table created; select AddGeometryColumn ('',boundary', 'latlon' 4326,'POLYGON', 2); geometry column added; then i'm ...
5
votes
1answer
790 views

How you can repair invalid topology errors within postgis?

I've imported the shapefile of corine land cover project to my postgis database and the select gid, ST_IsValidReason(geom) from gis.clc2000 where not ST_IsValid(geom); returns in every occasion ...
2
votes
2answers
192 views

Opensource Tools for Optimizing Server Performance

I use a server with a basic Microsoft OS primarily for data storage and as a central repository for edited vector data. These data are not intended to be used as mapping or GIS products available ...
2
votes
3answers
513 views

Which open source software to create desktop interface for Geo-processing tools?

I want to create an desktop interface to create geo-processing tool and that to using Open source GIS software. I will be using Postgresql and postgis too to save and retrieve data for operations. I ...
15
votes
4answers
4k views

How to create a simple front-end for a PostGIS database?

My organisation collects a lot of environmental monitoring data (stream flow, water chemistry etc.) most of which is currently stored in Excel. I’d like to get everything into a database – probably ...
1
vote
1answer
980 views

How to connect GeoServer with Java to a PostGIS/PostGres database?

I am having trouble using GeoServer to perform a shortest path analysis between two network points. My question is about connecting GeoServer with Java to a PostGIS/PostGres database. I know that in ...
5
votes
1answer
569 views

Memory leak in ArcGIS aggregate points/buffer/Addfield/cursor

I am starting to have concerns about the ability of ArcGIS 10 to fulfill a deliverable of mine. It got me to wondering what exactly else there is, that can perform similar functionality? ET ...
3
votes
2answers
165 views

How to bring polygons closer to a point?

I have some scattered polygons with a lot of space between them. I want to make a thematic map but all that white space doesn't look very good, so I want to bring the polygons closer to the center of ...
8
votes
2answers
673 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 ...
5
votes
3answers
978 views

In Qgis, Is it possible to edit the datasource of a Postgis layer?

After creating a layer with RT_SQL_Layer plugin, I want to change some details in the query. Is it possible? or I have to aways create a new layer every time I want to change something in the query? ...
10
votes
2answers
3k views

How to import esri Personal Geodatabase (.mdb) to PostGIS on Linux

We have esri Personal Geodatabases that we need to import into PostGIS. Ultimately, we'd like to allow people to upload an MDB on a web server, and have it import the layers into PostGIS. On ...
1
vote
1answer
827 views

psycopg2 error with QGIS 1.5

So I just installed QGIS 1.5 using the windows installer not the osgeo4w one and now any plugins that need access to PostgreSQL databases don't seem to work, they all throw a: "Couldn't import Python ...