getSRSbySRID()

char* getSRSbySRID	(	FunctionCallInfo	fcinfo,
		int	srid,
		bool	short_crs
	)

Definition at line 60 of file lwgeom_export.c.

{
        static const uint16_t max_query_size = 512;
        char query[512];
        char *srs, *srscopy;
        int size, err;
        postgis_initialize_cache(fcinfo);
 
        if (SPI_OK_CONNECT != SPI_connect ())
        {
                elog(NOTICE, "getSRSbySRID: could not connect to SPI manager");
                SPI_finish();
                return NULL;
        }
 
        if (short_crs)
                snprintf(query,
                         max_query_size,
                         "SELECT auth_name||':'||auth_srid \
                        FROM %s WHERE srid='%d'",
                         postgis_spatial_ref_sys(),
                         srid);
        else
                snprintf(query,
                         max_query_size,
                         "SELECT 'urn:ogc:def:crs:'||auth_name||'::'||auth_srid \
                        FROM %s WHERE srid='%d'",
                         postgis_spatial_ref_sys(),
                         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;
}

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

Here is the caller graph for this function: