PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.

learn more… | top users | synonyms

5
votes
1answer
650 views

How to get GeoNetwork to search through PostGIS fields via GeoServer WMS

I can't seem to get GeoNetwork to search through my PostGIS fields via GeoServer WMS. According to the GeoNetwork Documentation: it should loop over datasets served by the service and produce ...
1
vote
1answer
303 views

Error when pointing Geoserver to PostGIS

I have a PostGIS database that contains all my GIS data along with metadata. I have it published as a Store in GeoServer. They are both installed on the same windows server 2008r2. When i try to add ...
12
votes
4answers
445 views

What is a suitable Global/Universal Unique Identifier for a PostGIS database?

I have read that using OIDs as a primary key in a postgreSQL/PostGIS db is poor practice because there are instances where these can be reset. Sounds logical, but then what is a suitable alternative? ...
8
votes
2answers
676 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
2answers
728 views

Some objects missing after importing a .shp into PostGIS

I have a .shp file which I am trying to import into a PostGIS database using the "PostGis SHP and DBF Loader". This works smoothly but some (maybe 5%) of the records have an empty geometry field. (I ...
12
votes
1answer
2k views

Open-source GIS implementation of the Huff model

This might be a stretch, but I was wondering if anyone implemented gravity modeling tools or scripts for Retail Market Analysis (like the Huff Model), to analyze spatial data for customer-store ...
1
vote
2answers
241 views

Keeping SDE for data maintenance, but use postgis for display

We build and maintain GIS data in a production environment with SDE on SQL 2008. We also have a need to open up WMS and WFS that will make a complete ESRI solution really expensive. With an ArcGIS ...
10
votes
2answers
4k views

Selecting by bounding box with PostGIS

I have a large dataset in a PostGIS database. I am viewing it via a web interface that loads the data as GeoJSON. There is too much data to give the client all at once (10s of MBs worth...) so I would ...
5
votes
3answers
979 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? ...
6
votes
3answers
391 views

Organizing PostGIS data of a large database for fast dynamic user searching

I have a large amount of GIS data, roughly 30 layers, each with 50,000 to 100,000 (Geo)records. Some of this data is GPS collected points, others are POI, some is government provided data (roads, ...
22
votes
5answers
8k views

Optimizing osm2pgsql imports for OSM data

I'm currently building an instance on EC2 on which to import the entire Planet.osm snapshot of the whole Earth's worth of data for some projects we're working on. I've spun up a large Ubuntu x64 ...
4
votes
3answers
975 views

Is the Fourth Dimension used in GIS?

Whilst working with OGR, I came across the following field used define a geographic dataset: COORD_DIMENSION The spatial dimension (2, 3 or 4 dimensional) of the column. Whilst I've used 2D and 3D ...
10
votes
2answers
2k views

How do you display related records in QGIS?

Coming from an esri background I have always used relationship classes in a gdb to display records related to a feature. Eg. Relate 1 survey point to many documents, photos etc. Does any one know how ...
9
votes
2answers
965 views

PostGIS: split a polygon in a given ratio

Is there a convenient way to split a polygon into n parts, more-or-less equal in size in PostGIS?
3
votes
2answers
445 views

Is there a common interface for ST_Geometry SDO_Geomtry

I've worked a fair bit with Oracle Spatial and I've had some requests to transition to PostgreSQL Spatial. Is there a common interface for SDO_Geometry and ST_Geometry? I'm working in Java with ...
6
votes
2answers
1k views

How to locate PostGIS AMIs on Amazon EC2?

There are nearly 7000 AMIs on EC2, but I'm having a difficult time figuring out which ones have what I'm looking for--in this case PostGIS on Linux. No specific version/configuation--I want to check ...
5
votes
2answers
963 views

ArcSDE for PostgreSQL installation

I am trying to install ArcSDE 10 for PostgreSQL in CentOS. I tried doing that but am stuck with same errors repeatedly and am thinking of giving one more shot from the scratch. I just want to make ...
14
votes
2answers
3k views

What are hardware requirements for a cloud hosted PostGIS & GeoServer?

I have been playing with a local installation of PostGIS & GeoServer. I would like to move my work online now to share it with several collaborators. The proof of the concept map will consist of ...
6
votes
5answers
2k views

Problem loading OS OpenData multipoint shapefile into PostGIS

I am trying to load the OS OpenData Strategi shapefile dataset into a PostGIS database. I have had no problems with the polyline and polygon shapefiles, but I am unable to get the point shapefiles to ...
27
votes
4answers
3k views

Curved point-to-point “route maps”

I have recently been looking at airlines web pages that display their routes departing a certain city to all other cities they service. I would like to be able to create similar curved routes between ...
12
votes
3answers
922 views

Centralizing shapefile data into database

I've got hundreds of shapefiles from various different GIS projects that I want to start consolidating into a single database platform, currently attempting this with Postgres / PostGIS. Hardly any ...
2
votes
2answers
607 views

GeoServer layers containing cities in each country, given that all the cities reside in the same table

Using GeoServer, I need to provide a graphical representation of the distribution of some metrics on a geographical basis. The geographical regions will be coloured and labelled according to the value ...
6
votes
2answers
1k views

Support for PostgreSQL / PostGIS Inherited Tables in MapInfo/QGIS

Does anyone know if MapInfo and QGIS will support inheritance in a PostgreSQL/PostGIS database? I would like to make use of inheritance but need to make sure the software I use will work with them. ...
17
votes
6answers
3k views

How do I get started with GIS Servers on Amazon EC2?

Are there any tutorials, talks or presentations that discuss the use of EC2 or other cloud computing services to host GIS Servers? Has anyone had any experience in doing it with Amazon's EC2? How hard ...
3
votes
3answers
757 views

Spatial Database Design (PostGIS) - Point data that doesn't always have spatial data

I am creating a spatial database using PostGIS. I am storing the attributes and location of some species records that can be represented as points. The records are recorded from either: a) static ...
3
votes
2answers
1k views

Postgres/PostGIS Spatial Query Performance Problem

I have a query in Postgres/PostGIS that I am a bit confused about. The spatial intersection happens very fast, ~ 2 seconds for 10,000, but the update takes > 15 seconds for the same number of points. ...
3
votes
2answers
2k views

How to get accurate mile markers from DOT ShapeFile?

I'm having trouble getting accurate mile markers through route traversal using PostGIS. Based on the discussion in Geocode from mile marker/milepost to latitude/longitude?, I downloaded Texas ...
21
votes
5answers
3k views

How to create regular point grid inside a polygon in Postgis?

How to create, inside a polygon, a regular grid of point spaced x,y in postgis? Like the example:
14
votes
3answers
1k views

Is there a CASE Tool for modelling spatial databases?

Does anyone knows if there is a CASE Tool that would be possible for modelling spatial tables? I need to create a model and export it to SQL or a database directly. I´m using PostGIS. Thanks in ...
14
votes
4answers
2k views

PostGIS: Select features that do NOT intersect

This seems to me like such a simple question (and it probably is) yet I cannot seem to find an example that gives me the answer. Using PostGIS, I just want to select points that fall outside of ...
11
votes
2answers
256 views

Are there asset management systems for PostGIS?

Are there asset management systems that use PostGIS for asset storage?
6
votes
3answers
761 views

Can GeoNetwork store metadata for a PostGIS table?

Can GeoNetwork be used to store Metadata for a PostGIS table? Or is it only for WMS/WFS services? If it can be used to create a store metadata for a PostGIS table, how is it done? I can't seem to ...
3
votes
2answers
985 views

Querying data linked to a postGIS database

My project is coming along nicely! A brief background on my project. I have a world map that is colored to show the country of origin of the students at a college. Each color represents the ...
6
votes
1answer
411 views

How to use simplify()

i have my Vector Data saved in a PostgreSQL PostGIS enabled Database. The Data im displaying is very detailed, i want to simplify it through the simplify() method of Postgis. I duplicated one of my ...
6
votes
3answers
792 views

Retrieve polygon smallest MBR

I have a postgis table containing polygons. I want to transform my polygons to 4 points polygons : retrieve the smallest MBR. Here comes an illustration of what I want : My original polygon is ...
7
votes
1answer
2k views

How do I get a country border data set into my geography column?

I have a PostGis database with a multipolygon geography (as opposed to geometry) column. I'd like to fill it with the country border data available from ...
5
votes
1answer
297 views

Postgres/postgis cursors

I have a road network with StreetName and min/max address ranges for each segment (ie- StreetName = 'Main St', Min = 100, Max = 199). I also have individual address points with similar information ...
3
votes
3answers
807 views

Can you set the PostGIS SRID when creating a Feature class through ArcCatalog?

I have ArcSDE installed in a Postgresql database and I am using PostGIS geometry. I'm not a DB minded person so feel free to let me know if my process is not right. I create my feature class in ...
3
votes
1answer
605 views

ArcGIS Flex Polygon to PostGIS Polygon

ArcGIS supports building polygons within the flex component that contain self-intersecting rings, as well as rings that touch at multiple points (breaking the "arbitrary" rules here: ...
18
votes
5answers
4k views

How do you best deal with data that spreads across UTM Zones?

I have data that spreads across two UTM Zones GDA/MGA94 UTM Zone 55 and 56. I have layers such as a cadastre, roads, pipelines etc where I want to store measurements like lengths and areas in metres ...
18
votes
4answers
2k views

Generalisation Strategies for Building Outlines

I have a dataset of building footprints vectorised from a raster dataset. The dataset is currently just a vector representation of the raster data. I would like a polygon dataset that only has ...
5
votes
1answer
300 views

GIS project advice

Hello: I have the following: Shapefile of the world with the boundaries of each country Successfully imported shapefile into PostGIS database Can display map of the world in a browser via ...
9
votes
3answers
1k views

How to populate an undirected graph from PostGIS?

This question is more related to resources that I might not have identified yet, although I've been searching the web for a while. In the project I'm working at the moment I need to run a ...
20
votes
4answers
2k views

Would PostGIS offer an advantage over MySQL for a produce farm application?

I have a web app that stores the locations of farms in West Michigan. You can search for a product (e.g. "broccoli") and it will show you all the farms that grow that product. Right now I'm using ...
3
votes
1answer
426 views

Is QGIS compatible with PostgreSQL 8.4 Advanced enterprise DB with Oracle compatibility?

Sorry for such a long question. We are trialling EnterpriseDB Postgres Plus Advanced Server 8.4 with Oracle compatibility and PostGIS 1.5.1. I can create a connection to the database in qgis and the ...
54
votes
8answers
4k views

How do I get started with PostGis

I have been reading a lot about it, but I am struggling to find a good beginner's guide. Which tutorials/books do you recommend? My past experience involves python and arcgis. But I have never worked ...
12
votes
6answers
656 views

PostGIS: Assign ID of point in layer A to closest point in Layer B

This should have been an obvious precursor (that I didn't ask) to my other question: PostGIS function to create spider diagrams? If I do not know the relationship between a point in layer A (stores) ...
4
votes
1answer
388 views

Remove ArcSDE repository and associated files from PostGresql DB

A bit of background first. I have a PostGres DB with PostGIS, I also have ArcSDE installed in this DB and all feature classes created through ArcSDE are using the PG_Geometry. Everything works well! ...
5
votes
3answers
1k views

How to create spider diagrams (hub lines) in PostGIS?

I'm rather new to PostGIS but I have done a lot of reading. One thing that I have been searching for is a function that allows users to create a "spider diagram" (also called "desire lines" or "hub ...
8
votes
1answer
657 views

How do I add an offset to a lat/lon to get a new point using PostGIS

Using PostGIS I have a lat/lon point and want to add an east/west and north/south offset in metres to get a new point. Is that possible?