[postgis-users] Importing timezone shape files - newbie
lr at pcorp.us
Thu Apr 5 14:17:20 PDT 2012
It's greyed out if you don't have a database selected. As long as your
has postgis installed, it should work fine.
Regarding world files as I recall, I think the 394 one has one record per
TZ, and the other has further broken out.
I usually use the 28,000 one for spatial queries since its a bit more
efficient because it has smaller polygons.
Good luck :)
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On
> Behalf Of Scott Chapman
> Sent: Wednesday, April 04, 2012 6:07 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Importing timezone shape files - newbie
> Hi all,
> I'm using PG 9.1.3 with pgAdmin 1.14.2 on Windows 7 Home
> Edition to get familiar with PostGIS and TimeZone data.
> PostGIS 1.5.3 is installed and the postgis database was
> created by the installer.
> My immediate end goal is to be able to take a Lat/Lon and
> query PG to find the correct time zone for the location.
> I installed the "PostGIS Shapefile and DBF loader" plugin in
> pgAdmin but it is greyed out in the Plugins menu.
> I found this site with the shape files:
> It has two shape files:
> "The tz_world shapefile captures the boundaries of the TZ
> timezones across the world, as of TZ 2011b. The geometries
> are all POLYGONs, and a TZ timezone will sometimes have
> multiple polygons. There are about 28,000 rows.
> The tz_world_mp shapefile captures the same boundaries. The
> geometries are either POLYGONs or MULTIPOLYGONs, and there is
> a single geometry for each TZ timezone. There are 394 rows."
> First question is, Which shape file to use. I don't
> understand the difference between the two and the merits of each.
> Secondly, clues on how to import this data correctly.
> Any other pointers are welcome! I'm not sure yet, how to do
> the SQL to make the query.
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users