Well this is not a looking for help post.I just want to marvel at the speed of postgis database.I have been working on a BI (Business Intelligence) project broadcasting gigabytes of spatial thematic data over the internet.QGIS server along is part of the answer, qgis2map is a life-savior. the problem is the speed of access datasets in the shapefile format. Now，when i switch to postgis as the data source, the speed is LIGHTENING fast! So what I am seeing is that this workflow can be a valuable part of the BI system of most corporations in the world. Raw data is stored in Hive on the cloud, fetched by Spark ad processed in python, whose results are then fed to a postgis database. The thematic layers in postgis database are collected by QGIS server and broadcast out as WMS. Then, an apache server displays the frontend map with openlayers(batch generated by qgis2map). speed, data security, spatial information embedded into big data infrastructure. simply wow
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
