Open sources for web map and geo location

Here are pure open source based web map and geo location database resources. Google map or Bing map is wonderful, but they require business contract for commercial use. It is said that Foursquare recently switched their map tool from Google map to open source based Leaflet API which looks like the picture below. This map… Continue reading Open sources for web map and geo location

Bulk data import to MSSQL

I was about to upload 2 million record of data using NHibernate’s default save method, which will transact every record independently. It estimated almost 2 days to upload all data. In this mass data upload, bulk import utility, bcp is pretty useful. It takes 10 minutes for 2 million record to import. Related well written article. http://lostechies.com/jimmybogard/2010/06/24/bulk-processing-with-nhibernate/ And… Continue reading Bulk data import to MSSQL

Published
Categorised as DB

Resources for reading and writing photo meta tag like EXIF

http://social.msdn.microsoft.com/Forums/en-US/windowswic/thread/fdbcd8f4-5d75-4c33-8bed-97ef03a65c70 http://stackoverflow.com/questions/2755000/inplacebitmapmetadatawriter-trysave-returns-true-but-does-nothing http://www.andrewdothay.net/blog/2010/08/16/HowToEditMetaDataInsideJPGFilesWithC.aspx http://www.dreamincode.net/code/snippet3144.htm http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/EXIF.html http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/XMP.html#exif    

Published
Categorised as ASP.Net Tagged