Showing posts from 2014

Spatial reference systems and transformations in Austria

Transforming data from Austrian local coordinate system to WGS84 should be a no brainer but this is GIS stuff we are talking about and therefor it isn't :) First I am posting some great references for my own sanity that I find it again and that other GIS, Geoinformatik students find some help. Link to epsg codes for Austria ESRI Synergis: Für Datumsübergänge von MGI nach WGS 1984 sollte, falls keine genauen Werte für die 7 Parameter Transformation vorliegen, jene der ÖK 50 vom BEV verwendet werden - dies entspricht MGI_To_WGS_1984_3 (EPSG-code 1618). Link 1 : We in Austria DO have a Datum shift in order to move from a Projected Coordinate System to Geographic Coordinate system and the two magic code numbers are in this file below (1618(the rest of us in Austria and 1194(for Steirmark)) BIG NOTE on PROJ4 taken from the homepage: OTHER PR

arcpy write a list of feature datasets from a geodatabase to a csv file

Lets be a little more specific as to what we want to do so I will reformulate the title now: How to write to a CSV file a list of ESRI ArcGIS personal geodatabase feature classes and feature sets using arcpy? As usual here is the code first since we are all impatient :) code is on Github most of it is self explanatory but who knows.  We assume you have a running copy of ArcGIS 10.2 in this case with on my machine I have ArcGIS10.2 installed and the python interpreter is located here  c:\arcgis\Python27\ArcGIS10.2\python.exe I think only a few lines might need explaining line 27   wr . writerow ( each_fs . split ( "," )) The .split(",") prevents our CSV from spitting out "f", "c", "_","n","a","m","e", "F","o","o.......   where our list is  fcList= ["fc_nameFoo","fc_nameFee"] If you want to write this all to one single line in the csv y

Geoserver SLD variable substitution based on attribute

SLD (Styled Layer Description) is a beast of XML rules, filters and other stuff with tons of power. The question at hand is how do I pass a color value to a certain attribute value in a WMS call to Geoserver? The documentation to read is lets start with the SLD Here there are two rules, the first rule sets the default color for the column "zone_name" with the value equal to "a" to a default color of "FF0000".  The second rule is defined to set the color for the column "zone_name" that is equal to value "b" and sets the default color to "0000ff". Now for the dynamic part.  In your WMS call simply add this to the url &env=a:6666ff;b:ff6666 this means  set the "a" zone to the new color "6666ff  and set the "b" zone to new color "ff6666" when the wms call is made. Now you can do whatever backen

Install pgRouting extension with postgresql 9.3

Installing cutting edge software is always fun.  So my journey was to install pgrouting with postgresql 9.3 and postgis 2.1.2 on  a Ubuntu 12.04 machine for some testing. As it looks this was not so strait forward I had to use some debian packages which are thankfully easy to install.  Visit each of theses sites then scroll WAY down to the bottom, select your system architecture then click the link to download plus: (update 20.08.2014 now using libboost-thread1.55.0 and libboost-system1.55.0) / Now how to install pgrouting begins with viewing each page and scrolling down on each page then select a server to download then simply download and you should have the following .deb install files in your downloads folder. (if you are using AMD64 archit

ogr2ogr upload shapefile to postgis

Simple quick upload a shapefile to an existing postgis database into an existing schema called "geodata" upload shapefile to postgis with ogr2ogr: # upload shapefile into postgis schema and automatically create the table named "test C:\OSGeo4W\bin\ogr2ogr.exe -lco GEOMETRY_NAME=geom -append -lco SCHEMA=geodata -f "PostgreSQL" PG:"host=domainName port=5432 user=username dbname=dbName password=secretpasswrd" -a_srs "EPSG:3785" C:/somepath/myshapefile.shp -nln NewTableName )

Why indoor maps are important.

Asking a tough question "why are indoor maps important?".  The answer is simply the same reason as to why any map is important. Maps guide us in many ways, present us huge amounts of information in a simple manner. Here is a top 5 list of why indoor maps are important: Transfer information fast Images share more information than words hands down. Complex building structures are literally a maze of ways and paths.  Indoor maps show floor plans, furniture and other features to identify your way. Allow to check our progress You can locate where you are and how much further you have to go.  Indoor floor plans with routing can show you your way from point A to B and see where you are. Ease communication Trying to explain where some thing is located is not an easy task.  Whenever you want to show someone where something is located you want a "map".  Indoor maps show you the floor plan and floors for complex buildings in a familar way. Reduce stress Do

Ubuntu Linux secure copy to / from server

This post is more of a note to my self this is all running on a Ubuntu 12.04 machine.  You can do all of this from your local Ubuntu machine and do not need to login on remote server via ssh. Copy folder FROM server TO local machine using command line  Remote folder :  /var/www/someRemoteFolderName destination folder on local machine: /var/www/localFolderName username:  bob ip or dns: mydomainName Command is : root@mdiener-VirtualBox:# scp -r  bob@mydomainName://var/www/someRemoteFolderName/  /var/www/localFolderName  then enter password at the prompt Copy folder TO server FROM local machine using command line Remote folder is :   /var/www/someRemoteFolderName destination folder  on local machine: /var/www/localFolderName username:   bob ip or dns:  mydomainName Command is : root@mdiener-VirtualBox:# scp -r /var/www/localFolderName  bob@mydomainName://var/www/someRemoteFolderName/  then enter password at the prompt This is simply the reverse of

Open Geo Data in Austria

More and more data is constantly available on the web here in Austria.  I found it now time to write a little post summarizing where you can get data about Austria from Austria.   (all of Austria) /  ( Statistic Austria ) /   (Kärnten) /  (Tirol)  (Wien) l   (Niederösterreich) /  (Steirmark) (Vorarlberg)  (Stadt Linz) (Salzburg all data in Oberösterreich  (links is really long)  (Burgenland) To round out the list of prominent open data around us   (our swiss neigbours) Bundesamt für Kartographie  (Germany) Italy  open data ( if you can read Italian) EU data ( since we