~ubuntu-branches/ubuntu/oneiric/postgis/oneiric-proposed

« back to all changes in this revision

Viewing changes to postgis/lwgeom_export.c

  • Committer: Bazaar Package Importer
  • Author(s): Alan Boudreault
  • Date: 2010-09-29 09:16:10 UTC
  • mfrom: (1.1.12 upstream)
  • Revision ID: james.westby@ubuntu.com-20100929091610-vj4efw8woq34hdn7
Tags: 1.5.2-1
* New upstream release, with a few bug fixes.
* Added shp2pgsql-gui binary.
* Removed patches, applied upstream: getopt.    

Show diffs side-by-side

added added

removed removed

Lines of Context:
27
27
 * Require valid spatial_ref_sys table entry
28
28
 *
29
29
 * Could return SRS as short one (i.e EPSG:4326)
30
 
 * or as long one: (i.e urn:ogc:def:crs:EPSG:4326)
 
30
 * or as long one: (i.e urn:ogc:def:crs:EPSG::4326)
31
31
 */
32
32
char * getSRSbySRID(int SRID, bool short_crs)
33
33
{
46
46
                sprintf(query, "SELECT auth_name||':'||auth_srid \
47
47
                        FROM spatial_ref_sys WHERE srid='%d'", SRID);
48
48
        else
49
 
                sprintf(query, "SELECT 'urn:ogc:def:crs:'||auth_name||':'||auth_srid \
 
49
                sprintf(query, "SELECT 'urn:ogc:def:crs:'||auth_name||'::'||auth_srid \
50
50
                        FROM spatial_ref_sys WHERE srid='%d'", SRID);
51
51
 
52
52
        err = SPI_exec(query, 1);