Browsed by
Month: March 2013

GeoServer – GetFeatureInfo Template Data Model (structure) ?>

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 UI. But here, I’m going to explain the structure of all available variables. Accessing the variables as following: The result may display as below: This…

Read More Read More

OpenLayers – Custom Style for Individual Features ?>

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 ?>

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