Alle Beiträge von Flo

MongoDB and geodata part 2 – getting spatial

After importing geodata from the GIS to MongoDB and creating a spatial index (part 1), the exciting (spatial) adventure starts. With „normal“ (relational) databases and their spatial extensions (Oracle spatial, PostgreSQL/PostGIS, SQLite/Spatialite,…) a lot of spatial queries and geoprocessing are possible. So let’s try to find out which adresses have to be evacuated 250m around some „event“…

QGIS_Adressen_Umkreis
How to perform a spatial query like this with MongoDB ?

Weiterlesen

MongoDB and geodata part 1 – from Shapefile to MongoDB 3.2

MongoDB (3.2) is a kind of database-hipster at the moment – with improving support for spatial data. So it was time for me to discover some of it’s features concerning spatial data. As a GIS-user my first intention was to get some bigger simple (point) geodata into MongoDB. Part 1 covers this topic, part 2 will cover some spatial operations within MongoDB. I also want to do some performance checks between PostgreSQL/PostGIS and MongoDB related to geodata.

QGIS_mongoDB_adressen
Geodata in QGIS and MongoDB

Weiterlesen

Finding the right track – defining guideposts with JSON

Many different organisations have to deal with the management of guideposts – especially in alpine regions. Sometimes all the data about the guideposts is managed in databases and GIS-Systems, often no digital data management is in use. In the first case mostly internally developed databases/applications are used and there is no open technical “standard” for storing “guidepost-data” and EXCHANGING it. In some regions – like in Tyrol – governmental standards for the guideposts (“the hardware”) are available (how guideposts have to look like – e.g. size, classification of difficulty, …). Based on the idea that around the world guideposts have some elements (direction, name of target,…) in common, we started to work on a modern technical standard…

guidepostJSON

Weiterlesen