Lukket

Time Zone DB with Polygons

I need to have a MySQL table populated with POLYGONS derived from a world TimeZone map (provided as a shp file). Before importing the shp file into the data base the map needs to be simplified.

Greenland, for example has hundreds of vertices, I'd prefer if it only had 3 or 4 - all out of sea (but [url removed, login to view] won't support this). Alaska could be reduced to 4. At first glance, Queensland Australia looks like it could be reduced to 6, but where borders follow rivers, mountain ranges and are thus close to, split or separate towns or cities it's important that each town remains in the correct timezone and is not fudged into a different timezone due to the simplification.

## Deliverables

I have a very detailed TimeZone map (.shp file downloaded from [url removed, login to view]) and have had an attempt at simplifying it (at [url removed, login to view]), but it still needs more work.

Greenland, for example has hundreds of vertices, I'd prefer if it only had 3 or 4 - all out at sea (but [url removed, login to view] won't support this). Alaska could be reduced to 4. At first glance, Queensland Australia looks like it could be reduced to 6, but where borders follow rivers, mountain ranges and are thus close to, split or separate towns or cities it's important that each town remains in the correct timezone and is not fudged into a different timezone due to the simplification.

My priorities are:

1) Users in cities or large towns shall not be reported as being in an incorrect timezone

2) Speed of queries (eg WHERE [url removed, login to view] CONTAINS [url removed, login to view])

The timezone shapes will not be displayed to the public, so coast lines should be grossly simplified but by doing this neighbouring (inhabited) islands and countries which are in different timezones should not be affected.

The "name", "country_code" and "coordinates" fields shall be as per: [url removed, login to view] A script (preferably Java, Javascript, php, perl, C++ or other languages may be considered) should be used to extract data from this page and must be provided as part of the project deliverables.

I can provide the original and simplified shp files, but require the following MySQL table to be populated:

CREATE TABLE timezones {

pk INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

code VARCHAR(9) NOT NULL, /** Java TZ code, eg "PST", "GMT-10:00" */

name VARCHAR(32) NOT NULL, /** PHP TZ name, eg "America/Los_Angeles" */

country_code CHAR(2) NOT NULL, /* eg "US" */

offset INT NOT NULL, /** (ms) eg -8*60*60*1000 */

coordinates POINT NOT NULL; /** (and/or 2 Doubles?) eg "+340308 -1181434" */

bounds POLYGON NOT NULL; /** (and/or 2 Points?) eg " min: +34.0308 [url removed, login to view] max: 34.0308 [url removed, login to view]" */

shape POLYGON NOT NULL,

INDEX(code),

INDEX(name),

SPATIAL INDEX (shape)

};

Deliverables will include:

- MySQL script to populate the above table

- Final simplified shp file

- (Recommendation of free/open source) Software to display the final simplified map super-imposed over the original, or an image (png, jpg etc) of resolution suitable for verifying that the simplified map is acceptible.

- Instructions and/or software to regenerate the MySQL script from the shpfile.

- Full source code of application or script used to parse the timezone names, country codes and primary locations from the Wiki page (the manual step of cutting and pasting from a browser into a text file will be acceptible)

All of the above must be provided no later than Feb 28 2009 (would prefer earlier)

Færdigheder: CAD / CAM, Ingeniørarbejde, Geolokation, MySQL, PHP, Software Arkitektur, Software Testning

Se mere: mysql timezone polygons, work in queensland australia, work in alaska, test america, resolution engineering, reduced to the max, queensland australia, pst won't open, pst to html, php script null, out source australia, no pst file, mountain america, java sea, it support australia, int map, in queensland, glance net, free php source codes, free java codes, engineering work australia, engineering in australia, engineering australia, en engineering, eg engineering

Om arbejdsgiveren:
( 0 bedømmelser ) Sydney, Australia

Projekt-ID: #3635827