Mmmm... GIS Extensions

Friday, March 03, 2006, at 05:59AM

By Eric Richardson

This may make no sense to you, but just know that it's cool:

houston=# select AsText(the_geom) from buildings where id = 10;

MULTIPOLYGON(((
    3118897.96530012 13838758.1691906,
    3118951.74016637 13838841.8891787,
    3118993.06800402 13838848.7768498,
    3119057.74463768 13838808.25588,
    3119076.59247451 13838796.0172187,
    3119025.06695632 13838713.7759229,
    3118980.06661619 13838703.7761855,
    3118897.96530012 13838758.1691906
)))

houston=# select AsText(transform(the_geom,4326)) 
    from buildings where id = 10;

MULTIPOLYGON(((
    -95.3738909490995 29.7518641865238,
    -95.3737133770184 29.7520897224611,
    -95.3735825199263 29.7521051310476,
    -95.3733827457042 29.7519882370035,
    -95.3733245703251 29.7519529896557,
    -95.3734949130464 29.7517313269132,
    -95.3736376422065 29.7517076774085,
    -95.3738909490995 29.7518641865238
)))

Top data is in the NAD-83 Texas South Central coordinate system. Bottom data is your standard WGS-84 lon/lat. Using PostGIS.