5f0691a5d071897ec24c79ba53fa6a70682ac1e6 Sjors sjors@sprovoost.nl http://github.com/Sjors/srtm2postgis/commit/cd0fcd71b946572390ff4bfbc260097432f09112 cd0fcd71b946572390ff4bfbc260097432f09112 2008-08-07T21:33:15-07:00 2008-08-07T21:33:15-07:00 Minor bug fixes 8a05f0d5413ffbc8a29c4c23e7616120cd02a581 Sjors sjors@sprovoost.nl 8449fdf1f1435436f9b4909c8290082198f21379 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/5f0691a5d071897ec24c79ba53fa6a70682ac1e6 5f0691a5d071897ec24c79ba53fa6a70682ac1e6 2008-07-30T23:23:40-07:00 2008-07-30T23:23:40-07:00 Shared some common functionality of Postgres and App Engine import scripts. git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@9395 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 a73a53c7e4b6b09a9fea925957619a16e90b29da sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 d93032878a6ff948b077fde4d19b25837981f2d6 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/8449fdf1f1435436f9b4909c8290082198f21379 8449fdf1f1435436f9b4909c8290082198f21379 2008-07-30T23:23:06-07:00 2008-07-30T23:23:06-07:00 Copied files to import to the Google App Engine. Source: http://github.com/Sjors/openstreetmap-route-altitude-profile/tree/master/server http://svn.openstreetmap.org/sites/other/route-altitude-profile/ I have only copied: import-google-app-engine.py insert-app-engine.sh I will not copy myloader.py; the server side of the import script remains where it is. I assume that some point myload.py will no longer be needed, once we can talk to the datastore directly. Sjors git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@9394 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 1f48211922e73ee4fb471b55353dfd25bfe40e08 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 3b5608193e6bed6f39721ee0467afa35022308e1 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/d93032878a6ff948b077fde4d19b25837981f2d6 d93032878a6ff948b077fde4d19b25837981f2d6 2008-07-30T23:22:31-07:00 2008-07-30T23:22:31-07:00 Move database activity into a seperate class. git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@9393 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 447c522c0014ea4bd39229b9f673e8c5c9f11ba4 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 3cb585dca1d7fe10791312ca26125168506b61c1 086c9164bb26cdf6e1475c90b72a6c0ee9f46e7c sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/3b5608193e6bed6f39721ee0467afa35022308e1 3b5608193e6bed6f39721ee0467afa35022308e1 2008-07-25T20:33:05-07:00 2008-07-25T20:33:05-07:00 Unzips the .hgt.zip files during the database insert and cleans up afterwards.. git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@9291 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 f0e646cda18fb8b0c0ad396ae1f80527e4dc6e51 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 b2477bf13064c619e6d6fc3cc14d95351369884e sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/086c9164bb26cdf6e1475c90b72a6c0ee9f46e7c 086c9164bb26cdf6e1475c90b72a6c0ee9f46e7c 2008-07-16T17:53:55-07:00 2008-07-16T17:53:55-07:00 And more conflicts... git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@9108 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 e153f58f658d34c776c72eeaa1f62020db906d57 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 a4f45808bb898633d5bbffc4fb0409e851e43781 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/b2477bf13064c619e6d6fc3cc14d95351369884e b2477bf13064c619e6d6fc3cc14d95351369884e 2008-07-16T17:53:06-07:00 2008-07-16T17:53:06-07:00 Solved more conflicts git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@9107 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 1e94f067d93482ef689c654d7910f9253a2c9103 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 99cbb8847326da22091af9f2d840733351216f89 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/a4f45808bb898633d5bbffc4fb0409e851e43781 a4f45808bb898633d5bbffc4fb0409e851e43781 2008-07-16T17:52:06-07:00 2008-07-16T17:52:06-07:00 Solved some conflicts git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@9106 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 25ba2fd43665d07a8456ed4c6a66e6f72cd0da4e sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 05874578b4bdd1c7d021aa4751789cd070811347 Sjors sjors@sprovoost.nl http://github.com/Sjors/srtm2postgis/commit/3cb585dca1d7fe10791312ca26125168506b61c1 3cb585dca1d7fe10791312ca26125168506b61c1 2008-07-16T06:53:16-07:00 2008-07-16T06:53:16-07:00 Unzips the .hgt.zip files during the database insert and cleans up afterwards.. f0e646cda18fb8b0c0ad396ae1f80527e4dc6e51 Sjors sjors@sprovoost.nl 79fe5a1ef08400237762d1e1143602e1ad6fe7c5 Sjors sjors@sprovoost.nl http://github.com/Sjors/srtm2postgis/commit/05874578b4bdd1c7d021aa4751789cd070811347 05874578b4bdd1c7d021aa4751789cd070811347 2008-07-16T06:24:22-07:00 2008-07-16T06:24:22-07:00 Insert data into database for all continents. 2ed039315b2da84a5ef5a0f92bd578cd0128d3af Sjors sjors@sprovoost.nl 1b02a642c23c0f25d95ac3a8f5744722232bbfa8 Sjors sjors@sprovoost.nl http://github.com/Sjors/srtm2postgis/commit/79fe5a1ef08400237762d1e1143602e1ad6fe7c5 79fe5a1ef08400237762d1e1143602e1ad6fe7c5 2008-07-16T06:24:07-07:00 2008-07-16T06:24:07-07:00 Insert data into database for all continents. 8594bfc2c9c46461e13439260782f1a185b970bc Sjors sjors@sprovoost.nl 886f442ff5fa6fa89aedf30d7bb63aee95ccea9a sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/99cbb8847326da22091af9f2d840733351216f89 99cbb8847326da22091af9f2d840733351216f89 2008-07-15T07:01:42-07:00 2008-07-15T07:01:42-07:00 Test git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@9039 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 bc235c7fa2752a15f248bd7ccfacaa1c7ee1adf4 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 eda7d059801e9bc6a21c91877dc82ac164a952e0 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/886f442ff5fa6fa89aedf30d7bb63aee95ccea9a 886f442ff5fa6fa89aedf30d7bb63aee95ccea9a 2008-07-15T07:00:00-07:00 2008-07-15T07:00:00-07:00 Conflicts git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@9038 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 4d7ae47eaec357b9af240f899c736a999360c28f sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 23bb37004394f18a4e3f895450468b92ad5e7297 Sjors Provoost sjors@Sjors.(none) http://github.com/Sjors/srtm2postgis/commit/1b02a642c23c0f25d95ac3a8f5744722232bbfa8 1b02a642c23c0f25d95ac3a8f5744722232bbfa8 2008-07-15T06:42:28-07:00 2008-07-15T06:42:28-07:00 Script can now download any of the continents. Verify script can now verify all of the continents (md5). Md5 should still be tested independantly. bc235c7fa2752a15f248bd7ccfacaa1c7ee1adf4 Sjors Provoost sjors@Sjors.(none) c1fe7be66fff55697df29e9011c3fb1d8c2521d4 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/eda7d059801e9bc6a21c91877dc82ac164a952e0 eda7d059801e9bc6a21c91877dc82ac164a952e0 2008-07-13T00:34:28-07:00 2008-07-13T00:34:28-07:00 bla git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@8964 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 6c8fbe98b742d1b89d15dff215899e6e901855ab sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 e67aec6e52ba2dfe09c0b9a3c1f76c09b170f6b8 Sjors sjors@sprovoost.nl http://github.com/Sjors/srtm2postgis/commit/23bb37004394f18a4e3f895450468b92ad5e7297 23bb37004394f18a4e3f895450468b92ad5e7297 2008-07-12T01:33:25-07:00 2008-07-12T01:33:25-07:00 Made some changes. 6c8fbe98b742d1b89d15dff215899e6e901855ab Sjors sjors@sprovoost.nl 87791c22e4c4f3b7645d1254a115e03033225d07 Sjors sjors@sprovoost.nl http://github.com/Sjors/srtm2postgis/commit/e67aec6e52ba2dfe09c0b9a3c1f76c09b170f6b8 e67aec6e52ba2dfe09c0b9a3c1f76c09b170f6b8 2008-06-30T02:29:46-07:00 2008-06-30T02:29:46-07:00 Not really MySQL related changes. Added Eclipse envirment. Added directores for more continents. Made some changes to download Germany. This commit will probably not run. 03865e917f289de6666d68826a3bf65712f1856c Sjors sjors@sprovoost.nl c1fe7be66fff55697df29e9011c3fb1d8c2521d4 56d4bca8ce66740f9449f83f203e3e852eea020e Sjors sjors@sprovoost.nl http://github.com/Sjors/srtm2postgis/commit/87791c22e4c4f3b7645d1254a115e03033225d07 87791c22e4c4f3b7645d1254a115e03033225d07 2008-06-16T01:19:27-07:00 2008-06-16T01:19:27-07:00 Merge git@github.com:Sjors/srtm2postgis 1cbe59354b5fbee8807d740b970160736553f350 Sjors sjors@sprovoost.nl aa9aa7432a5cd674384b2f2214c7e0655e3c373f sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/c1fe7be66fff55697df29e9011c3fb1d8c2521d4 c1fe7be66fff55697df29e9011c3fb1d8c2521d4 2008-06-16T01:03:25-07:00 2008-06-16T01:03:25-07:00 Resume support git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@8248 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 1cbe59354b5fbee8807d740b970160736553f350 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 88bb3c91ccbb3a83deaa87fe19695300085a688d sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/aa9aa7432a5cd674384b2f2214c7e0655e3c373f aa9aa7432a5cd674384b2f2214c7e0655e3c373f 2008-06-16T01:00:17-07:00 2008-06-16T01:00:17-07:00 Test for special value -32768. Resume function (not tested) git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@8247 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 f99665680a4b66743a9437bb80c54c128bc2ea0d sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 e530ad778148bc96ef98ccd84060adb04a25ded9 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/88bb3c91ccbb3a83deaa87fe19695300085a688d 88bb3c91ccbb3a83deaa87fe19695300085a688d 2008-06-16T00:56:54-07:00 2008-06-16T00:56:54-07:00 Fixed bug in verification. git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@8246 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 37cf5aefe3dae17d6aec1875493b17d23dc13617 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 6ef5d6ecee15e377e4d424a341095c1be0fee58d sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/e530ad778148bc96ef98ccd84060adb04a25ded9 e530ad778148bc96ef98ccd84060adb04a25ded9 2008-06-16T00:54:51-07:00 2008-06-16T00:54:51-07:00 Supports whole continent or part of it git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@8245 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 2fcca7992554ceda0f9f7cbcf12f2a233e57de5f sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 89664c9655eccd48d0df0b72b3b8d878a01b9643 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/6ef5d6ecee15e377e4d424a341095c1be0fee58d 6ef5d6ecee15e377e4d424a341095c1be0fee58d 2008-06-16T00:54:24-07:00 2008-06-16T00:54:24-07:00 Added some tests to be on the safe side. Changed index. Changed insert. * Replaced 360 by -360 in the index; file coordintes represent the lower left coordinate, not the upper left coordinate. * Although file name represents lower left coordinate, the first item in the file is actually the top left coordinate. For this reason I drop the overlapping top row and right column in stead of bottom row and left column. git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@8244 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 214cc1552e4a347ead7133e678cadff1e6c23a72 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 62cd9a6a51898a7012f06be8a34b1f78aaf7bfec Sjors sjors@sprovoost.nl http://github.com/Sjors/srtm2postgis/commit/56d4bca8ce66740f9449f83f203e3e852eea020e 56d4bca8ce66740f9449f83f203e3e852eea020e 2008-06-16T00:52:22-07:00 2008-06-16T00:52:22-07:00 Resume support 1cbe59354b5fbee8807d740b970160736553f350 Sjors sjors@sprovoost.nl 464a59e754030d3e8c4672100f60d0ea14d509c7 Sjors sjors@sprovoost.nl http://github.com/Sjors/srtm2postgis/commit/62cd9a6a51898a7012f06be8a34b1f78aaf7bfec 62cd9a6a51898a7012f06be8a34b1f78aaf7bfec 2008-06-11T07:07:38-07:00 2008-06-11T07:07:38-07:00 Test for special value -32768. Resume function (not tested) f99665680a4b66743a9437bb80c54c128bc2ea0d Sjors sjors@sprovoost.nl b75fbaace7d7f03c083b37b9acfd5588d44cfdb1 Sjors sjors@sprovoost.nl http://github.com/Sjors/srtm2postgis/commit/464a59e754030d3e8c4672100f60d0ea14d509c7 464a59e754030d3e8c4672100f60d0ea14d509c7 2008-06-10T21:35:05-07:00 2008-06-10T21:35:05-07:00 Fixed bug in verification. 37cf5aefe3dae17d6aec1875493b17d23dc13617 Sjors sjors@sprovoost.nl 210225d5f438f111a8bfad734e788f50cba5ddb4 Sjors Provoost sjors@Sjors.(none) http://github.com/Sjors/srtm2postgis/commit/b75fbaace7d7f03c083b37b9acfd5588d44cfdb1 b75fbaace7d7f03c083b37b9acfd5588d44cfdb1 2008-06-10T21:08:27-07:00 2008-06-10T21:08:27-07:00 Supports whole continent or part of it 2fcca7992554ceda0f9f7cbcf12f2a233e57de5f Sjors Provoost sjors@Sjors.(none) 89664c9655eccd48d0df0b72b3b8d878a01b9643 Sjors sjors@sprovoost.nl http://github.com/Sjors/srtm2postgis/commit/210225d5f438f111a8bfad734e788f50cba5ddb4 210225d5f438f111a8bfad734e788f50cba5ddb4 2008-06-10T07:27:28-07:00 2008-06-10T07:27:28-07:00 Added some tests to be on the safe side. Changed index. Changed insert. * Replaced 360 by -360 in the index; file coordintes represent the lower left coordinate, not the upper left coordinate. * Although file name represents lower left coordinate, the first item in the file is actually the top left coordinate. For this reason I drop the overlapping top row and right column in stead of bottom row and left column. 214cc1552e4a347ead7133e678cadff1e6c23a72 Sjors sjors@sprovoost.nl 4991478cc9e3d06f97368539a0f17842a13fd8a6 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/89664c9655eccd48d0df0b72b3b8d878a01b9643 89664c9655eccd48d0df0b72b3b8d878a01b9643 2008-06-04T22:50:55-07:00 2008-06-04T22:50:55-07:00 Space saving measures * Changed altitude from double to smallint to save space * Replace lat,lon index by a biginteger to save space. The index of a coordinate is dermined as follows: (-lat0 * 360 + lon0) * 1200 * 1200 + lat1 * 1200 * 1200 + lon1 * 1200 lat0 and lon0 are the latitude and longitude of the top left corner of a tile. lat1 and lon1 are the (decimal) relative latitude and longitude south east of that corner. 0 <= lat0 < 1 && 0 <= lon0 < 1 * Limit tiles to a smaller region: -45 < lat <= -26 and 141 <= lon < 155 or the part of Australia south east of the north eastern corner of South Australia. Basicly the southern part of Queensland, all of NSW, ACT, Victoria and Tasmania. * These 186 tiles need about 15 GB i git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@8102 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 3e1d0617cf2d4f68f37d55caee2e90c80a3a5a19 sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 29c9a98a7b430cabfdb19b9e9b9654f0bb489fac sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 http://github.com/Sjors/srtm2postgis/commit/4991478cc9e3d06f97368539a0f17842a13fd8a6 4991478cc9e3d06f97368539a0f17842a13fd8a6 2008-05-30T22:35:08-07:00 2008-05-30T22:35:08-07:00 Load all tiles in the database. Verifies that all tiles are inserted in the database in two ways. 1 : total number of records in the altitude table == 1 526 400 000: number of tiles (1060) * width of tile (1200) * height of tile (1200) 2 : top-left coordinate in file matches top-left coordinate in db I have succesfully inserted the first 3 tiles; I have not verified the full insert yet. git-svn-id: http://svn.openstreetmap.org/applications/utils/srtm2postgis/trunk@8013 b9d5c4c9-76e1-0310-9c85-f3177eceb1e4 3245fc302b4d13f6a1afe89a04e00ff2960ba1ec sjors sjors@b9d5c4c9-76e1-0310-9c85-f3177eceb1e4