getSRIDbySRS()

int getSRIDbySRS	(	FunctionCallInfo	fcinfo,
		const char *	SRS
	)

Definition at line 133 of file lwgeom_export.c.

{
        static const int16_t max_query_size = 512;
        char query[512];
        Oid argtypes[] = {CSTRINGOID};
        Datum values[] = {CStringGetDatum(srs)};
        int32_t srid, err;
 
        postgis_initialize_cache(fcinfo);
        snprintf(query,
                 max_query_size,
                 "SELECT srid "
                 "FROM %s, "
                 "regexp_matches($1::text, E'([a-z]+):([0-9]+)', 'gi') AS re "
                 "WHERE re[1] ILIKE auth_name AND int4(re[2]) = auth_srid",
                 postgis_spatial_ref_sys());
 
        if (!srs) return 0;
 
        if (SPI_OK_CONNECT != SPI_connect())
        {
                elog(NOTICE, "getSRIDbySRS: could not connect to SPI manager");
                return 0;
        }
 
        err = SPI_execute_with_args(query, 1, argtypes, values, NULL, true, 1);
        if (err < 0)
        {
                elog(NOTICE, "getSRIDbySRS: error executing query %d", err);
                SPI_finish();
                return 0;
        }
 
        /* no entry in spatial_ref_sys */
        if (SPI_processed <= 0)
        {
                snprintf(query,
                         max_query_size,
                         "SELECT srid "
                         "FROM %s, "
                         "regexp_matches($1::text, E'urn:ogc:def:crs:([a-z]+):.*:([0-9]+)', 'gi') AS re "
                         "WHERE re[1] ILIKE auth_name AND int4(re[2]) = auth_srid",
                         postgis_spatial_ref_sys());
 
                err = SPI_execute_with_args(query, 1, argtypes, values, NULL, true, 1);
                if (err < 0)
                {
                        elog(NOTICE, "getSRIDbySRS: error executing query %d", err);
                        SPI_finish();
                        return 0;
                }
 
                if (SPI_processed <= 0)
                {
                        SPI_finish();
                        return 0;
                }
        }
 
        srid = atoi(SPI_getvalue(SPI_tuptable->vals[0], SPI_tuptable->tupdesc, 1));
        SPI_finish();
 
        return srid;
}

Referenced by geom_from_geojson().

Here is the caller graph for this function: