getSRSbySRID()

char* getSRSbySRID	(	int	srid,
		bool	short_crs
	)

Definition at line 57 of file lwgeom_export.c.

Referenced by geography_as_geojson(), geography_as_gml(), LWGEOM_asGeoJson(), LWGEOM_asGML(), and LWGEOM_asX3D().

{
        char query[256];
        char *srs, *srscopy;
        int size, err;

        if (SPI_OK_CONNECT != SPI_connect ())
        {
                elog(NOTICE, "getSRSbySRID: could not connect to SPI manager");
                SPI_finish();
                return NULL;
        }

        if (short_crs)
                snprintf(query, 256, "SELECT auth_name||':'||auth_srid \
                        FROM spatial_ref_sys WHERE srid='%d'", srid);
        else
                snprintf(query, 256, "SELECT 'urn:ogc:def:crs:'||auth_name||'::'||auth_srid \
                        FROM spatial_ref_sys WHERE srid='%d'", srid);

        err = SPI_exec(query, 1);
        if ( err < 0 )
        {
                elog(NOTICE, "getSRSbySRID: error executing query %d", err);
                SPI_finish();
                return NULL;
        }

        /* no entry in spatial_ref_sys */
        if (SPI_processed <= 0)
        {
                SPI_finish();
                return NULL;
        }

        /* get result  */
        srs = SPI_getvalue(SPI_tuptable->vals[0], SPI_tuptable->tupdesc, 1);

        /* NULL result */
        if ( ! srs )
        {
                SPI_finish();
                return NULL;
        }

        /* copy result to upper executor context */
        size = strlen(srs)+1;
        srscopy = SPI_palloc(size);
        memcpy(srscopy, srs, size);

        /* disconnect from SPI */
        SPI_finish();

        return srscopy;
}

Here is the caller graph for this function: