Monthly Archives: March 2013

GeoServer – GetFeatureInfo Template Data Model (structure)

Extend from this GeoServer – Custom Get Feature Info Display Knowledge requirement – Freemaker The standard template files is header.tpl, content.tpl, footer.tpl. header.tpl usually where JavaScript, CSS, meta tag, title placed here. footer.tpl where you put your HTML page footer, Copyright, etc. content.tpl where we going to iterate through all the features to display interactive… Read More »

OpenLayers – Custom Style for Individual Features

Other than the subject, what’s included here, as following: Add Google Map as base map How to create vector layer How to add features to vector layer How to use WKT and display it on Map How to create dynamic label, radius & fill in OpenLayers Style How to display label based on zoom level

PostgreSQL – Import data from CSV

You CSV file similar to the following: The SQL: References: http://forums.enterprisedb.com/posts/list/2819.page http://dba.stackexchange.com/questions/18821/how-to-import-a-csv-file-into-a-postgresql-database-using-copy http://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgres-table http://www.postgresql.org/docs/9.1/static/sql-copy.html http://stackoverflow.com/questions/10079682/copy-function-in-postgresql