getSRIDbySRS()

int getSRIDbySRS

(

const char *

SRS

)

Definition at line 119 of file lwgeom_export.c.

References LWGEOM_asGML(), and PG_FUNCTION_INFO_V1().

Referenced by geom_from_geojson().

{
        char *query =
            "SELECT srid "
            "FROM spatial_ref_sys, "
            "regexp_matches($1::text, E'([a-z]+):([0-9]+)', 'gi') AS re "
            "WHERE re[1] ILIKE auth_name AND int4(re[2]) = auth_srid";
        Oid argtypes[] = {CSTRINGOID};
        Datum values[] = {CStringGetDatum(srs)};
        int32_t srid, err;

        if (srs == NULL)
                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)
        {
                query =
                    "SELECT srid "
                    "FROM spatial_ref_sys, "
                    "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";

                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));
        if ( ! srs )
        {
                SPI_finish();
                return 0;
        }

        SPI_finish();

        return srid;
}

Here is the call graph for this function:

Here is the caller graph for this function: