0
votes
2answers
89 views

How to add polygon height in QGIS or PostGIS?

Is there an easy way to set the height of polygons in QGIS or PostGIS? I am trying to visualize polygons by turning them into volumes (same shape at the base and roof, but with walls). I would then ...
0
votes
0answers
38 views

Displaying 3D city model from PostGIS 3D backend

I know that openlayers doesnt support 3D yet. I heard about Kartograph has 3D features but Does Kartograph support reading data from backend database especially PostGIS? I would like to create a 3D ...
1
vote
1answer
53 views

Possible to store 3D features such as dome into geospatial database?

Is it possible to store 3D features such as dome into geospatial database such as PostGIS? I know that it can store x,y,z data, can such complex features be stored into database?
1
vote
0answers
35 views

PostGIS 3D Extrude function

I selected buildings from OSM (which represents my city). I insterted a new column 'height' and I filled with a random number exactly number 2, so every building have 2metres altitude. Buildings are ...
1
vote
0answers
40 views

How to define Z dimension on table with PostGIS for import in TileMill?

I'm trying to reproduce the idea behind this blogpost from Mapbox, but with other data, for example the ne_10m_populated_places_simple dataset from Natural Earth. By adding a z-dimension to the data ...
2
votes
1answer
42 views

ST_ZMax() does not exist in PostGIS

I'm trying to follow this example on Mapbox blog, about using 3D shapes in PostGIS. The database-query is this: DROP TABLE tilemill_buildings; CREATE TABLE tilemill_buildings AS SELECT ogc_fid, ...
0
votes
1answer
84 views

How could I insert a 3-D LineString into postgis table?

Using: CREATE TABLE trajectories( gid SERIAL PRIMARY KEY, vehID VARCHAR(10), state INTEGER, geom geometry(MULTILINESTRING) ) I get an error, for instance, after inserting: INSERT INTO ...
1
vote
2answers
142 views

how to build topology with 3d linestring in pgrouting

I have some 3d linestrings in postgis database, and I want to use pgrouting for calculating shortest path with Dijkstra. when I execute "select pgr_createTopology('route2', 0.000001, 'geo3d', 'id');" ...
2
votes
0answers
204 views

3D features (Polyline, Polygon) intersection library

For my research I am looking for a (python) library to get the intersection of some 3D features. The features can be Polygons or Polylines. Mostly I need to intersect a plane with my features and get ...
2
votes
1answer
158 views

3D KNN index in PostGIS

I am looking for a way to do fast KNN queries on a dataset of 10+ million 3D points (and growing). I was hoping PostGIS would do the trick with its new <-> and <#> operators, but they don't seem ...
1
vote
2answers
353 views

Importing MaxSea 3D Database to PostGIS

I am currently working on a project, where I combine several MaxSea 3D databases, which contain depth measurements made by the echosounder onboard on a ship. The idea is to combine these databases to ...
3
votes
3answers
394 views

Visualization of a big graph in 3D from postgresql/postgis

We have a graph in 3D in a PostgreSQL/PostGIS database. It contains something like 50'000 edges and 50'000 vertices, with x-y coordinates and floors. We would like to visualize this graph with ...
6
votes
2answers
160 views

How to sample a 3D raster along a 3D path (or 4D raster along 4D path)?

I have a 3d raster dataset of atmospheric variables (lat x lon x altitude). I would like to sample this raster dataset along a 3d path. Any idea how I can achieve this, preferable with qgis or ...
4
votes
1answer
200 views

Exporting 3D geometry from PostGIS 2.0

I have a table containing 3D geometry in a PostGIS 2.0 database (the geometry is of type LINESTRING Z). I need to get the geometry out and into a DXF, DGN or 3D Shapefile. What is the easiest way to ...
7
votes
2answers
232 views

How do you treat partial 3d features in PostGIS?

We have features from survey data that contain partial 3d information. The most common example would be a 2D LineString representing a road, that contains elevation information in certain points ...
3
votes
2answers
299 views

Invoke PostGIS functions outside of the database? Need to force 3D in GeoDjango

I'm looking to ensure that all geometries saved to the database are three-dimensional. It's easy enough to do with a call to the database, select ST_Force_3D( ST_GeomFromText( blah blah ) ) ...but ...
2
votes
1answer
398 views

PostGIS - table with 3d points with fast ordering by distance

I am pretty new to PostGIS and I am trying to solve the following problem. I need a table with 3D points (x,y,z) that will contain around 1-10million points. I want to be able to efficiently ask the ...
13
votes
3answers
1k views

Visualization of 3D shapefiles with Mapserver and Postgis

I'm wondering is there a way to visualize 3d data with mapserver? 3D .shp files are in postgis database, and I already connected mapserver to database, but with simple layer in mapfile.
7
votes
1answer
323 views

Assign Z value to start & end of PostGIS line

I have a line table in my PostGIS database and a table with invert levels for the start and end of each line. My goal is to create create 3D lines in my table, from my invert data. I know I can use ...
6
votes
2answers
329 views

Clarification of the “25D” option in ogr2ogr

[EDIT: In my original post, I had received an error that was based on a typo, so I scrapped that part of the question, but left the questions that still apply.] In the ogr2ogr docs it says: -nlt ...
8
votes
1answer
1k views

PostGIS 3D in Action

I was wondering if there is a website that showcases Openlayers and PostGIS 3D in Action