Processing GeoData for CEDEUS - Revision history

StefanS: /* Correcting Declared Image SRS */

2016-06-30T20:44:59Z

‎Correcting Declared Image SRS

StefanS: /* Processing Aerial Images from SECTRA */

2016-06-30T20:34:21Z

‎Processing Aerial Images from SECTRA

StefanS at 18:40, 23 July 2015

2015-07-23T18:40:31Z

StefanS: /* Converting Census data from INE */

2015-07-03T20:55:17Z

‎Converting Census data from INE

StefanS: /* Converting Census data from INE */

2015-07-03T20:55:00Z

‎Converting Census data from INE

StefanS: /* Converting Census data from INE */

2015-07-03T20:54:20Z

‎Converting Census data from INE

StefanS: /* Converting Census data from INE */

2015-07-03T19:41:01Z

‎Converting Census data from INE

StefanS: /* Converting Census data from INE */

2015-07-03T19:39:24Z

‎Converting Census data from INE

StefanS: /* Converting Census data from INE */

2015-07-03T19:35:03Z

‎Converting Census data from INE

StefanS: /* Converting Census data from INE */

2015-07-03T18:47:48Z

‎Converting Census data from INE

@@ Line 34: / Line 34: @@
   gdal_translate -a_srs EPSG:32718 Villarrica_utm18s.tif Villarrica_utm18s_corrected.tif
 => means, I am not using gdal_warp which would reproject the file, which is not what I wanted.
 === Adding the images to GeoServer ===

@@ Line 10: / Line 10: @@
   gdalwarp -cutline polygon_bbox_chile_wgs84.shp -crop_to_cutline SRTM_W_250m.tif SRTM_W_250m_chile.tif
-== Processing Aerial Images from SECTRA ==
+== Processing Aerial Images from SECTRA / CEDIZ ==
 === Pre-processing of ECW image use with GeoServer ===
 * downlading zip files with ecw images from:
@@ Line 26: / Line 26: @@
 ** the idea is to create a shapefile containing an image index, to be uploaded to GeoNode
 ** in QGIS I used the function Raster > Miscellaneous > Tile Index... which utilizes ''gdaltindex''
 === Adding the images to GeoServer ===

@@ Line 2: / Line 2: @@
 ----
-This pager provides logging info and processing instructions for CEDEUS data.
+This page provides info and processing instructions for CEDEUS data.
 == Processing Aerial Images from SECTRA ==

@@ Line 57: / Line 57: @@
 * and then I followed this tutorial for restoring the DB  - choosing "Device" in the Restore Dialog to select the *.bak file:  https://msdn.microsoft.com/en-us/library/ms177429%28v=sql.120%29.aspx
 * how to export the single DB tables to csv is described [http://bpmdeveloper.com/sql-server-export-wizard-csv/ here].
-: -> Thanks to Chile having only 17 Million people, I have been able to export all 7 Censo 2012 tables to csv files! *yay* The "poblacion" table was the biggest with 16.x million records and about 3.2 GB size.
+=> Thanks to Chile having only 17 Million people, I have been able to export all 7 Censo 2012 tables to csv files! *yay* The "poblacion" table was the biggest with 16.x million records and about 3.2 GB size.

@@ Line 57: / Line 57: @@
 * and then I followed this tutorial for restoring the DB  - choosing "Device" in the Restore Dialog to select the *.bak file:  https://msdn.microsoft.com/en-us/library/ms177429%28v=sql.120%29.aspx
 * how to export the single DB tables to csv is described [http://bpmdeveloper.com/sql-server-export-wizard-csv/ here].
-=> Thanks to Chile having only 17 Million people, I have been able to export all tables to csv files! *yay* The "poblacion" table was the biggest with 16.x million records and about 3.2 GB size.
+: -> Thanks to Chile having only 17 Million people, I have been able to export all 7 Censo 2012 tables to csv files! *yay* The "poblacion" table was the biggest with 16.x million records and about 3.2 GB size.

← Older revision		Revision as of 20:54, 3 July 2015
Line 56:		Line 56:
	* then I tried following this tutorial: https://msdn.microsoft.com/en-us/library/ms345332.aspx		* then I tried following this tutorial: https://msdn.microsoft.com/en-us/library/ms345332.aspx
	* and then I followed this tutorial for restoring the DB - choosing "Device" in the Restore Dialog to select the *.bak file: https://msdn.microsoft.com/en-us/library/ms177429%28v=sql.120%29.aspx		* and then I followed this tutorial for restoring the DB - choosing "Device" in the Restore Dialog to select the *.bak file: https://msdn.microsoft.com/en-us/library/ms177429%28v=sql.120%29.aspx
		+	* how to export the single DB tables to csv is described [http://bpmdeveloper.com/sql-server-export-wizard-csv/ here].
		+	=> Thanks to Chile having only 17 Million people, I have been able to export all tables to csv files! yay The "poblacion" table was the biggest with 16.x million records and about 3.2 GB size.

@@ Line 55: / Line 55: @@
 * downloaded also SQL Server 2014 Express with Tools 64 Bit : file name "SQLEXPRWT_x64_ENU" (or SQLEXPRADV_x64_ENU.exe as outlined [here http://stackoverflow.com/questions/28127673/microsoft-sql-server-2012-no-database-engines]) as the above contains only the Studio, not the Server
 * then I tried following this tutorial: https://msdn.microsoft.com/en-us/library/ms345332.aspx
-* and then I followed this tutorial for restoring the DB from the *.bak file: https://msdn.microsoft.com/en-us/library/ms177429%28v=sql.120%29.aspx
+* and then I followed this tutorial for restoring the DB  - choosing "Device" in the Restore Dialog to select the *.bak file:  https://msdn.microsoft.com/en-us/library/ms177429%28v=sql.120%29.aspx

@@ Line 53: / Line 53: @@
 * downloaded "SQL Server 2014 Management Studio Express 64 Bit" from Microsoft webpage (Sa...u) : http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx
-* downloaded also SQL Server 2014 Express with Tools 64 Bit (or SQLEXPRADV_x64_ENU.exe as outlined [here http://stackoverflow.com/questions/28127673/microsoft-sql-server-2012-no-database-engines]) as the above contains only the Studio, not the Server
+* downloaded also SQL Server 2014 Express with Tools 64 Bit : file name "SQLEXPRWT_x64_ENU" (or SQLEXPRADV_x64_ENU.exe as outlined [here http://stackoverflow.com/questions/28127673/microsoft-sql-server-2012-no-database-engines]) as the above contains only the Studio, not the Server
 * then I tried following this tutorial: https://msdn.microsoft.com/en-us/library/ms345332.aspx
-* and this tutorial for restoring the DB from the bak file: https://msdn.microsoft.com/en-us/library/ms177429%28v=sql.120%29.aspx
+* and then I followed this tutorial for restoring the DB from the *.bak file: https://msdn.microsoft.com/en-us/library/ms177429%28v=sql.120%29.aspx

← Older revision		Revision as of 19:35, 3 July 2015
Line 55:		Line 55:
	* downloaded also SQL Server 2014 Express with Tools 64 Bit (or SQLEXPRADV_x64_ENU.exe as outlined [here http://stackoverflow.com/questions/28127673/microsoft-sql-server-2012-no-database-engines]) as the above contains only the Studio, not the Server		* downloaded also SQL Server 2014 Express with Tools 64 Bit (or SQLEXPRADV_x64_ENU.exe as outlined [here http://stackoverflow.com/questions/28127673/microsoft-sql-server-2012-no-database-engines]) as the above contains only the Studio, not the Server
	* then I tried following this tutorial: https://msdn.microsoft.com/en-us/library/ms345332.aspx		* then I tried following this tutorial: https://msdn.microsoft.com/en-us/library/ms345332.aspx
		+	* and this tutorial for restoring the DB from the bak file: https://msdn.microsoft.com/en-us/library/ms177429%28v=sql.120%29.aspx

← Older revision		Revision as of 18:47, 3 July 2015
Line 53:		Line 53:

	* downloaded "SQL Server 2014 Management Studio Express 64 Bit" from Microsoft webpage (Sa...u) : http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx		* downloaded "SQL Server 2014 Management Studio Express 64 Bit" from Microsoft webpage (Sa...u) : http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx
−	* downloaded also ~~first "~~SQL Server 2014 ~~LocalDB~~ Express 64 Bit", ~~but~~ I ~~think~~ this ~~was a mistake as I didn't get anything to see~~	+	* downloaded also SQL Server 2014 Express with Tools 64 Bit (or SQLEXPRADV_x64_ENU.exe as outlined [here http://stackoverflow.com/questions/28127673/microsoft-sql-server-2012-no-database-engines]) as the above contains only the Studio, not the Server
		+	* then I tried following this tutorial: https://msdn.microsoft.com/en-us/library/ms345332.aspx