-- -- PostgreSQL database dump -- SET client_encoding = 'LATIN1'; SET check_function_bodies = false; SET client_min_messages = warning; -- -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema'; -- -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -- CREATE PROCEDURAL LANGUAGE plpgsql; SET search_path = public, pg_catalog; -- -- Name: box2d_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d_in(cstring) RETURNS box2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2DFLOAT4_in' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d_in(cstring) OWNER TO postgres; -- -- Name: box2d_out(box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d_out(box2d) RETURNS cstring AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2DFLOAT4_out' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d_out(box2d) OWNER TO postgres; -- -- Name: box2d; Type: TYPE; Schema: public; Owner: postgres -- CREATE TYPE box2d ( INTERNALLENGTH = 16, INPUT = box2d_in, OUTPUT = box2d_out, ALIGNMENT = int4, STORAGE = plain ); ALTER TYPE public.box2d OWNER TO postgres; -- -- Name: box3d_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box3d_in(cstring) RETURNS box3d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX3D_in' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box3d_in(cstring) OWNER TO postgres; -- -- Name: box3d_out(box3d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box3d_out(box3d) RETURNS cstring AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX3D_out' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box3d_out(box3d) OWNER TO postgres; -- -- Name: box3d; Type: TYPE; Schema: public; Owner: postgres -- CREATE TYPE box3d ( INTERNALLENGTH = 48, INPUT = box3d_in, OUTPUT = box3d_out, ALIGNMENT = double, STORAGE = plain ); ALTER TYPE public.box3d OWNER TO postgres; -- -- Name: chip_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION chip_in(cstring) RETURNS chip AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'CHIP_in' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.chip_in(cstring) OWNER TO postgres; -- -- Name: chip_out(chip); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION chip_out(chip) RETURNS cstring AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'CHIP_out' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.chip_out(chip) OWNER TO postgres; -- -- Name: chip; Type: TYPE; Schema: public; Owner: postgres -- CREATE TYPE chip ( INTERNALLENGTH = variable, INPUT = chip_in, OUTPUT = chip_out, ALIGNMENT = double, STORAGE = extended ); ALTER TYPE public.chip OWNER TO postgres; -- -- Name: geometry_analyze(internal); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_analyze(internal) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_analyze' LANGUAGE c STRICT; ALTER FUNCTION public.geometry_analyze(internal) OWNER TO postgres; -- -- Name: geometry_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_in(cstring) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_in' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_in(cstring) OWNER TO postgres; -- -- Name: geometry_out(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_out(geometry) RETURNS cstring AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_out' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_out(geometry) OWNER TO postgres; -- -- Name: geometry_recv(internal); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_recv(internal) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_recv' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_recv(internal) OWNER TO postgres; -- -- Name: geometry_send(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_send(geometry) RETURNS bytea AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_send' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_send(geometry) OWNER TO postgres; -- -- Name: geometry; Type: TYPE; Schema: public; Owner: postgres -- CREATE TYPE geometry ( INTERNALLENGTH = variable, INPUT = geometry_in, OUTPUT = geometry_out, RECEIVE = geometry_recv, SEND = geometry_send, ANALYZE = geometry_analyze, DELIMITER = ':', ALIGNMENT = int4, STORAGE = main ); ALTER TYPE public.geometry OWNER TO postgres; -- -- Name: histogram2d_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION histogram2d_in(cstring) RETURNS histogram2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'lwhistogram2d_in' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.histogram2d_in(cstring) OWNER TO postgres; -- -- Name: histogram2d_out(histogram2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION histogram2d_out(histogram2d) RETURNS cstring AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'lwhistogram2d_out' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.histogram2d_out(histogram2d) OWNER TO postgres; -- -- Name: histogram2d; Type: TYPE; Schema: public; Owner: postgres -- CREATE TYPE histogram2d ( INTERNALLENGTH = variable, INPUT = histogram2d_in, OUTPUT = histogram2d_out, ALIGNMENT = double, STORAGE = main ); ALTER TYPE public.histogram2d OWNER TO postgres; -- -- Name: spheroid_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION spheroid_in(cstring) RETURNS spheroid AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'ellipsoid_in' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.spheroid_in(cstring) OWNER TO postgres; -- -- Name: spheroid_out(spheroid); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION spheroid_out(spheroid) RETURNS cstring AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'ellipsoid_out' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.spheroid_out(spheroid) OWNER TO postgres; -- -- Name: spheroid; Type: TYPE; Schema: public; Owner: postgres -- CREATE TYPE spheroid ( INTERNALLENGTH = 65, INPUT = spheroid_in, OUTPUT = spheroid_out, ALIGNMENT = double, STORAGE = plain ); ALTER TYPE public.spheroid OWNER TO postgres; -- -- Name: geometry_dump; Type: TYPE; Schema: public; Owner: postgres -- CREATE TYPE geometry_dump AS ( path integer[], geom geometry ); ALTER TYPE public.geometry_dump OWNER TO postgres; -- -- Name: addauth(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION addauth(text) RETURNS boolean AS $_$ DECLARE lockid alias for $1; okay boolean; myrec record; BEGIN -- check to see if table exists -- if not, CREATE TEMP TABLE mylock (transid xid, lockcode text) okay := 'f'; FOR myrec IN SELECT * FROM pg_class WHERE relname = 'temp_lock_have_table' LOOP okay := 't'; END LOOP; IF (okay <> 't') THEN CREATE TEMP TABLE temp_lock_have_table (transid xid, lockcode text); -- this will only work from pgsql7.4 up -- ON COMMIT DELETE ROWS; END IF; -- INSERT INTO mylock VALUES ( $1) -- EXECUTE 'INSERT INTO temp_lock_have_table VALUES ( '|| -- quote_literal(getTransactionID()) || ',' || -- quote_literal(lockid) ||')'; INSERT INTO temp_lock_have_table VALUES (getTransactionID(), lockid); RETURN true::boolean; END; $_$ LANGUAGE plpgsql; ALTER FUNCTION public.addauth(text) OWNER TO postgres; -- -- Name: addbbox(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION addbbox(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_addBBOX' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.addbbox(geometry) OWNER TO postgres; -- -- Name: addgeometrycolumn(character varying, character varying, character varying, character varying, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION addgeometrycolumn(character varying, character varying, character varying, character varying, integer, character varying, integer) RETURNS text AS $_$ DECLARE catalog_name alias for $1; schema_name alias for $2; table_name alias for $3; column_name alias for $4; new_srid alias for $5; new_type alias for $6; new_dim alias for $7; rec RECORD; schema_ok bool; real_schema name; BEGIN IF ( not ( (new_type ='GEOMETRY') or (new_type ='GEOMETRYCOLLECTION') or (new_type ='POINT') or (new_type ='MULTIPOINT') or (new_type ='POLYGON') or (new_type ='MULTIPOLYGON') or (new_type ='LINESTRING') or (new_type ='MULTILINESTRING') or (new_type ='GEOMETRYCOLLECTIONM') or (new_type ='POINTM') or (new_type ='MULTIPOINTM') or (new_type ='POLYGONM') or (new_type ='MULTIPOLYGONM') or (new_type ='LINESTRINGM') or (new_type ='MULTILINESTRINGM')) ) THEN RAISE EXCEPTION 'Invalid type name - valid ones are: GEOMETRY, GEOMETRYCOLLECTION, POINT, MULTIPOINT, POLYGON, MULTIPOLYGON, LINESTRING, MULTILINESTRING, GEOMETRYCOLLECTIONM, POINTM, MULTIPOINTM, POLYGONM, MULTIPOLYGONM, LINESTRINGM, or MULTILINESTRINGM '; return 'fail'; END IF; IF ( (new_dim >4) or (new_dim <0) ) THEN RAISE EXCEPTION 'invalid dimension'; return 'fail'; END IF; IF ( (new_type LIKE '%M') and (new_dim!=3) ) THEN RAISE EXCEPTION 'TypeM needs 3 dimensions'; return 'fail'; END IF; IF ( schema_name != '' ) THEN schema_ok = 'f'; FOR rec IN SELECT nspname FROM pg_namespace WHERE text(nspname) = schema_name LOOP schema_ok := 't'; END LOOP; if ( schema_ok <> 't' ) THEN RAISE NOTICE 'Invalid schema name - using current_schema()'; SELECT current_schema() into real_schema; ELSE real_schema = schema_name; END IF; ELSE SELECT current_schema() into real_schema; END IF; -- Add geometry column EXECUTE 'ALTER TABLE ' || quote_ident(real_schema) || '.' || quote_ident(table_name) || ' ADD COLUMN ' || quote_ident(column_name) || ' geometry '; -- Delete stale record in geometry_column (if any) EXECUTE 'DELETE FROM geometry_columns WHERE f_table_catalog = ' || quote_literal('') || ' AND f_table_schema = ' || quote_literal(real_schema) || ' AND f_table_name = ' || quote_literal(table_name) || ' AND f_geometry_column = ' || quote_literal(column_name); -- Add record in geometry_column EXECUTE 'INSERT INTO geometry_columns VALUES (' || quote_literal('') || ',' || quote_literal(real_schema) || ',' || quote_literal(table_name) || ',' || quote_literal(column_name) || ',' || new_dim || ',' || new_srid || ',' || quote_literal(new_type) || ')'; -- Add table checks EXECUTE 'ALTER TABLE ' || quote_ident(real_schema) || '.' || quote_ident(table_name) || ' ADD CONSTRAINT ' || quote_ident('enforce_srid_' || column_name) || ' CHECK (SRID(' || quote_ident(column_name) || ') = ' || new_srid || ')' ; EXECUTE 'ALTER TABLE ' || quote_ident(real_schema) || '.' || quote_ident(table_name) || ' ADD CONSTRAINT ' || quote_ident('enforce_dims_' || column_name) || ' CHECK (ndims(' || quote_ident(column_name) || ') = ' || new_dim || ')' ; IF (not(new_type = 'GEOMETRY')) THEN EXECUTE 'ALTER TABLE ' || quote_ident(real_schema) || '.' || quote_ident(table_name) || ' ADD CONSTRAINT ' || quote_ident('enforce_geotype_' || column_name) || ' CHECK (geometrytype(' || quote_ident(column_name) || ')=' || quote_literal(new_type) || ' OR (' || quote_ident(column_name) || ') is null)'; END IF; return real_schema || '.' || table_name || '.' || column_name || ' SRID:' || new_srid || ' TYPE:' || new_type || ' DIMS:' || new_dim || chr(10) || ' '; END; $_$ LANGUAGE plpgsql STRICT; ALTER FUNCTION public.addgeometrycolumn(character varying, character varying, character varying, character varying, integer, character varying, integer) OWNER TO postgres; -- -- Name: addgeometrycolumn(character varying, character varying, character varying, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION addgeometrycolumn(character varying, character varying, character varying, integer, character varying, integer) RETURNS text AS $_$ DECLARE ret text; BEGIN SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6) into ret; RETURN ret; END; $_$ LANGUAGE plpgsql STABLE STRICT; ALTER FUNCTION public.addgeometrycolumn(character varying, character varying, character varying, integer, character varying, integer) OWNER TO postgres; -- -- Name: addgeometrycolumn(character varying, character varying, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION addgeometrycolumn(character varying, character varying, integer, character varying, integer) RETURNS text AS $_$ DECLARE ret text; BEGIN SELECT AddGeometryColumn('','',$1,$2,$3,$4,$5) into ret; RETURN ret; END; $_$ LANGUAGE plpgsql STRICT; ALTER FUNCTION public.addgeometrycolumn(character varying, character varying, integer, character varying, integer) OWNER TO postgres; -- -- Name: addpoint(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION addpoint(geometry, geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_addpoint' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.addpoint(geometry, geometry) OWNER TO postgres; -- -- Name: addpoint(geometry, geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION addpoint(geometry, geometry, integer) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_addpoint' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.addpoint(geometry, geometry, integer) OWNER TO postgres; -- -- Name: affine(geometry, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION affine(geometry, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_affine' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.affine(geometry, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision) OWNER TO postgres; -- -- Name: affine(geometry, double precision, double precision, double precision, double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION affine(geometry, double precision, double precision, double precision, double precision, double precision, double precision) RETURNS geometry AS $_$SELECT affine($1, $2, $3, 0, $4, $5, 0, 0, 0, 1, $6, $7, 0)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.affine(geometry, double precision, double precision, double precision, double precision, double precision, double precision) OWNER TO postgres; -- -- Name: area(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION area(geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_area_polygon' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.area(geometry) OWNER TO postgres; -- -- Name: area2d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION area2d(geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_area_polygon' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.area2d(geometry) OWNER TO postgres; -- -- Name: asbinary(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION asbinary(geometry) RETURNS bytea AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_asBinary' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.asbinary(geometry) OWNER TO postgres; -- -- Name: asbinary(geometry, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION asbinary(geometry, text) RETURNS bytea AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_asBinary' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.asbinary(geometry, text) OWNER TO postgres; -- -- Name: asewkb(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION asewkb(geometry) RETURNS bytea AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'WKBFromLWGEOM' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.asewkb(geometry) OWNER TO postgres; -- -- Name: asewkb(geometry, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION asewkb(geometry, text) RETURNS bytea AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'WKBFromLWGEOM' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.asewkb(geometry, text) OWNER TO postgres; -- -- Name: asewkt(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION asewkt(geometry) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_asEWKT' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.asewkt(geometry) OWNER TO postgres; -- -- Name: asgml(geometry, integer, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION asgml(geometry, integer, integer) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_asGML' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.asgml(geometry, integer, integer) OWNER TO postgres; -- -- Name: asgml(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION asgml(geometry, integer) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_asGML' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.asgml(geometry, integer) OWNER TO postgres; -- -- Name: asgml(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION asgml(geometry) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_asGML' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.asgml(geometry) OWNER TO postgres; -- -- Name: ashexewkb(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION ashexewkb(geometry) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_asHEXEWKB' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.ashexewkb(geometry) OWNER TO postgres; -- -- Name: ashexewkb(geometry, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION ashexewkb(geometry, text) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_asHEXEWKB' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.ashexewkb(geometry, text) OWNER TO postgres; -- -- Name: assvg(geometry, integer, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION assvg(geometry, integer, integer) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'assvg_geometry' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.assvg(geometry, integer, integer) OWNER TO postgres; -- -- Name: assvg(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION assvg(geometry, integer) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'assvg_geometry' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.assvg(geometry, integer) OWNER TO postgres; -- -- Name: assvg(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION assvg(geometry) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'assvg_geometry' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.assvg(geometry) OWNER TO postgres; -- -- Name: astext(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION astext(geometry) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_asText' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.astext(geometry) OWNER TO postgres; -- -- Name: azimuth(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION azimuth(geometry, geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_azimuth' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.azimuth(geometry, geometry) OWNER TO postgres; -- -- Name: bdmpolyfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION bdmpolyfromtext(text, integer) RETURNS geometry AS $_$ DECLARE geomtext alias for $1; srid alias for $2; mline geometry; geom geometry; BEGIN mline := MultiLineStringFromText(geomtext, srid); IF mline IS NULL THEN RAISE EXCEPTION 'Input is not a MultiLinestring'; END IF; geom := multi(BuildArea(mline)); RETURN geom; END; $_$ LANGUAGE plpgsql IMMUTABLE STRICT; ALTER FUNCTION public.bdmpolyfromtext(text, integer) OWNER TO postgres; -- -- Name: bdpolyfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION bdpolyfromtext(text, integer) RETURNS geometry AS $_$ DECLARE geomtext alias for $1; srid alias for $2; mline geometry; geom geometry; BEGIN mline := MultiLineStringFromText(geomtext, srid); IF mline IS NULL THEN RAISE EXCEPTION 'Input is not a MultiLinestring'; END IF; geom := BuildArea(mline); IF GeometryType(geom) != 'POLYGON' THEN RAISE EXCEPTION 'Input returns more then a single polygon, try using BdMPolyFromText instead'; END IF; RETURN geom; END; $_$ LANGUAGE plpgsql IMMUTABLE STRICT; ALTER FUNCTION public.bdpolyfromtext(text, integer) OWNER TO postgres; -- -- Name: boundary(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION boundary(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'boundary' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.boundary(geometry) OWNER TO postgres; -- -- Name: box(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box(geometry) RETURNS box AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_to_BOX' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box(geometry) OWNER TO postgres; -- -- Name: box(box3d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box(box3d) RETURNS box AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX3D_to_BOX' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box(box3d) OWNER TO postgres; -- -- Name: box2d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d(geometry) RETURNS box2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_to_BOX2DFLOAT4' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d(geometry) OWNER TO postgres; -- -- Name: box2d(box3d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d(box3d) RETURNS box2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX3D_to_BOX2DFLOAT4' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d(box3d) OWNER TO postgres; -- -- Name: box2d_contain(box2d, box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d_contain(box2d, box2d) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2D_contain' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d_contain(box2d, box2d) OWNER TO postgres; -- -- Name: box2d_contained(box2d, box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d_contained(box2d, box2d) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2D_contained' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d_contained(box2d, box2d) OWNER TO postgres; -- -- Name: box2d_intersects(box2d, box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d_intersects(box2d, box2d) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2D_intersects' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d_intersects(box2d, box2d) OWNER TO postgres; -- -- Name: box2d_left(box2d, box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d_left(box2d, box2d) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2D_left' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d_left(box2d, box2d) OWNER TO postgres; -- -- Name: box2d_overlap(box2d, box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d_overlap(box2d, box2d) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2D_overlap' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d_overlap(box2d, box2d) OWNER TO postgres; -- -- Name: box2d_overleft(box2d, box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d_overleft(box2d, box2d) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2D_overleft' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d_overleft(box2d, box2d) OWNER TO postgres; -- -- Name: box2d_overright(box2d, box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d_overright(box2d, box2d) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2D_overright' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d_overright(box2d, box2d) OWNER TO postgres; -- -- Name: box2d_right(box2d, box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d_right(box2d, box2d) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2D_right' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d_right(box2d, box2d) OWNER TO postgres; -- -- Name: box2d_same(box2d, box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box2d_same(box2d, box2d) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2D_same' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box2d_same(box2d, box2d) OWNER TO postgres; -- -- Name: box3d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box3d(geometry) RETURNS box3d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_to_BOX3D' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box3d(geometry) OWNER TO postgres; -- -- Name: box3d(box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box3d(box2d) RETURNS box3d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2DFLOAT4_to_BOX3D' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.box3d(box2d) OWNER TO postgres; -- -- Name: box3dtobox(box3d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION box3dtobox(box3d) RETURNS box AS $_$SELECT box($1)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.box3dtobox(box3d) OWNER TO postgres; -- -- Name: buffer(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION buffer(geometry, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'buffer' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.buffer(geometry, double precision) OWNER TO postgres; -- -- Name: buffer(geometry, double precision, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION buffer(geometry, double precision, integer) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'buffer' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.buffer(geometry, double precision, integer) OWNER TO postgres; -- -- Name: build_histogram2d(histogram2d, text, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION build_histogram2d(histogram2d, text, text) RETURNS histogram2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'build_lwhistogram2d' LANGUAGE c STABLE STRICT; ALTER FUNCTION public.build_histogram2d(histogram2d, text, text) OWNER TO postgres; -- -- Name: build_histogram2d(histogram2d, text, text, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION build_histogram2d(histogram2d, text, text, text) RETURNS histogram2d AS $_$ BEGIN EXECUTE 'SET local search_path = '||$2||',public'; RETURN public.build_histogram2d($1,$3,$4); END $_$ LANGUAGE plpgsql STABLE STRICT; ALTER FUNCTION public.build_histogram2d(histogram2d, text, text, text) OWNER TO postgres; -- -- Name: buildarea(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION buildarea(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_buildarea' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.buildarea(geometry) OWNER TO postgres; -- -- Name: bytea(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION bytea(geometry) RETURNS bytea AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_to_bytea' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.bytea(geometry) OWNER TO postgres; -- -- Name: cache_bbox(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION cache_bbox() RETURNS "trigger" AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'cache_bbox' LANGUAGE c; ALTER FUNCTION public.cache_bbox() OWNER TO postgres; -- -- Name: centroid(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION centroid(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'centroid' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.centroid(geometry) OWNER TO postgres; -- -- Name: checkauth(text, text, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION checkauth(text, text, text) RETURNS integer AS $_$ DECLARE schema text; BEGIN IF NOT LongTransactionsEnabled() THEN RAISE EXCEPTION 'Long transaction support disabled, use EnableLongTransaction() to enable.'; END IF; if ( $1 != '' ) THEN schema = $1; ELSE SELECT current_schema() into schema; END IF; -- TODO: check for an already existing trigger ? EXECUTE 'CREATE TRIGGER check_auth BEFORE UPDATE OR DELETE ON ' || quote_ident(schema) || '.' || quote_ident($2) ||' FOR EACH ROW EXECUTE PROCEDURE CheckAuthTrigger(' || quote_literal($3) || ')'; RETURN 0; END; $_$ LANGUAGE plpgsql; ALTER FUNCTION public.checkauth(text, text, text) OWNER TO postgres; -- -- Name: checkauth(text, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION checkauth(text, text) RETURNS integer AS $_$SELECT CheckAuth('', $1, $2)$_$ LANGUAGE sql; ALTER FUNCTION public.checkauth(text, text) OWNER TO postgres; -- -- Name: checkauthtrigger(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION checkauthtrigger() RETURNS "trigger" AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'check_authorization' LANGUAGE c; ALTER FUNCTION public.checkauthtrigger() OWNER TO postgres; -- -- Name: collect(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION collect(geometry, geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_collect' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.collect(geometry, geometry) OWNER TO postgres; -- -- Name: collect_garray(geometry[]); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION collect_garray(geometry[]) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_collect_garray' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.collect_garray(geometry[]) OWNER TO postgres; -- -- Name: collector(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION collector(geometry, geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_collect' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.collector(geometry, geometry) OWNER TO postgres; -- -- Name: combine_bbox(box2d, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION combine_bbox(box2d, geometry) RETURNS box2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2DFLOAT4_combine' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.combine_bbox(box2d, geometry) OWNER TO postgres; -- -- Name: combine_bbox(box3d, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION combine_bbox(box3d, geometry) RETURNS box3d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX3D_combine' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.combine_bbox(box3d, geometry) OWNER TO postgres; -- -- Name: compression(chip); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION compression(chip) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'CHIP_getCompression' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.compression(chip) OWNER TO postgres; -- -- Name: contains(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION contains(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'contains' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.contains(geometry, geometry) OWNER TO postgres; -- -- Name: convexhull(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION convexhull(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'convexhull' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.convexhull(geometry) OWNER TO postgres; -- -- Name: create_histogram2d(box2d, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION create_histogram2d(box2d, integer) RETURNS histogram2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'create_lwhistogram2d' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.create_histogram2d(box2d, integer) OWNER TO postgres; -- -- Name: crosses(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION crosses(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'crosses' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.crosses(geometry, geometry) OWNER TO postgres; -- -- Name: datatype(chip); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION datatype(chip) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'CHIP_getDatatype' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.datatype(chip) OWNER TO postgres; -- -- Name: difference(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION difference(geometry, geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'difference' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.difference(geometry, geometry) OWNER TO postgres; -- -- Name: dimension(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dimension(geometry) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_dimension' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.dimension(geometry) OWNER TO postgres; -- -- Name: disablelongtransactions(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION disablelongtransactions() RETURNS text AS $$ DECLARE query text; exists bool; rec RECORD; BEGIN -- -- Drop all triggers applied by CheckAuth() -- FOR rec IN SELECT c.relname, t.tgname, t.tgargs FROM pg_trigger t, pg_class c, pg_proc p WHERE p.proname = 'checkauthtrigger' and t.tgfoid = p.oid and t.tgrelid = c.oid LOOP EXECUTE 'DROP TRIGGER ' || quote_ident(rec.tgname) || ' ON ' || quote_ident(rec.relname); END LOOP; -- -- Drop the authorization_table table -- FOR rec IN SELECT * FROM pg_class WHERE relname = 'authorization_table' LOOP DROP TABLE authorization_table; END LOOP; -- -- Drop the authorized_tables view -- FOR rec IN SELECT * FROM pg_class WHERE relname = 'authorized_tables' LOOP DROP VIEW authorized_tables; END LOOP; RETURN 'Long transactions support disabled'; END; $$ LANGUAGE plpgsql; ALTER FUNCTION public.disablelongtransactions() OWNER TO postgres; -- -- Name: disjoint(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION disjoint(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'disjoint' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.disjoint(geometry, geometry) OWNER TO postgres; -- -- Name: distance(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION distance(geometry, geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_mindistance2d' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.distance(geometry, geometry) OWNER TO postgres; -- -- Name: distance_sphere(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION distance_sphere(geometry, geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_distance_sphere' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.distance_sphere(geometry, geometry) OWNER TO postgres; -- -- Name: distance_spheroid(geometry, geometry, spheroid); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION distance_spheroid(geometry, geometry, spheroid) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_distance_ellipsoid_point' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.distance_spheroid(geometry, geometry, spheroid) OWNER TO postgres; -- -- Name: dropbbox(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dropbbox(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_dropBBOX' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.dropbbox(geometry) OWNER TO postgres; -- -- Name: dropgeometrycolumn(character varying, character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dropgeometrycolumn(character varying, character varying, character varying, character varying) RETURNS text AS $_$ DECLARE catalog_name alias for $1; schema_name alias for $2; table_name alias for $3; column_name alias for $4; myrec RECORD; okay boolean; real_schema name; BEGIN -- Find, check or fix schema_name IF ( schema_name != '' ) THEN okay = 'f'; FOR myrec IN SELECT nspname FROM pg_namespace WHERE text(nspname) = schema_name LOOP okay := 't'; END LOOP; IF ( okay <> 't' ) THEN RAISE NOTICE 'Invalid schema name - using current_schema()'; SELECT current_schema() into real_schema; ELSE real_schema = schema_name; END IF; ELSE SELECT current_schema() into real_schema; END IF; -- Find out if the column is in the geometry_columns table okay = 'f'; FOR myrec IN SELECT * from geometry_columns where f_table_schema = text(real_schema) and f_table_name = table_name and f_geometry_column = column_name LOOP okay := 't'; END LOOP; IF (okay <> 't') THEN RAISE EXCEPTION 'column not found in geometry_columns table'; RETURN 'f'; END IF; -- Remove ref from geometry_columns table EXECUTE 'delete from geometry_columns where f_table_schema = ' || quote_literal(real_schema) || ' and f_table_name = ' || quote_literal(table_name) || ' and f_geometry_column = ' || quote_literal(column_name); -- Remove table column EXECUTE 'ALTER TABLE ' || quote_ident(real_schema) || '.' || quote_ident(table_name) || ' DROP COLUMN ' || quote_ident(column_name); RETURN real_schema || '.' || table_name || '.' || column_name ||' effectively removed.'; END; $_$ LANGUAGE plpgsql STRICT; ALTER FUNCTION public.dropgeometrycolumn(character varying, character varying, character varying, character varying) OWNER TO postgres; -- -- Name: dropgeometrycolumn(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dropgeometrycolumn(character varying, character varying, character varying) RETURNS text AS $_$ DECLARE ret text; BEGIN SELECT DropGeometryColumn('',$1,$2,$3) into ret; RETURN ret; END; $_$ LANGUAGE plpgsql STRICT; ALTER FUNCTION public.dropgeometrycolumn(character varying, character varying, character varying) OWNER TO postgres; -- -- Name: dropgeometrycolumn(character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dropgeometrycolumn(character varying, character varying) RETURNS text AS $_$ DECLARE ret text; BEGIN SELECT DropGeometryColumn('','',$1,$2) into ret; RETURN ret; END; $_$ LANGUAGE plpgsql STRICT; ALTER FUNCTION public.dropgeometrycolumn(character varying, character varying) OWNER TO postgres; -- -- Name: dropgeometrytable(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dropgeometrytable(character varying, character varying, character varying) RETURNS text AS $_$ DECLARE catalog_name alias for $1; schema_name alias for $2; table_name alias for $3; real_schema name; BEGIN IF ( schema_name = '' ) THEN SELECT current_schema() into real_schema; ELSE real_schema = schema_name; END IF; -- Remove refs from geometry_columns table EXECUTE 'DELETE FROM geometry_columns WHERE ' || 'f_table_schema = ' || quote_literal(real_schema) || ' AND ' || ' f_table_name = ' || quote_literal(table_name); -- Remove table EXECUTE 'DROP TABLE ' || quote_ident(real_schema) || '.' || quote_ident(table_name); RETURN real_schema || '.' || table_name ||' dropped.'; END; $_$ LANGUAGE plpgsql STRICT; ALTER FUNCTION public.dropgeometrytable(character varying, character varying, character varying) OWNER TO postgres; -- -- Name: dropgeometrytable(character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dropgeometrytable(character varying, character varying) RETURNS text AS $_$SELECT DropGeometryTable('',$1,$2)$_$ LANGUAGE sql STRICT; ALTER FUNCTION public.dropgeometrytable(character varying, character varying) OWNER TO postgres; -- -- Name: dropgeometrytable(character varying); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dropgeometrytable(character varying) RETURNS text AS $_$SELECT DropGeometryTable('','',$1)$_$ LANGUAGE sql STRICT; ALTER FUNCTION public.dropgeometrytable(character varying) OWNER TO postgres; -- -- Name: dump(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dump(geometry) RETURNS SETOF geometry_dump AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_dump' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.dump(geometry) OWNER TO postgres; -- -- Name: dumprings(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dumprings(geometry) RETURNS SETOF geometry_dump AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_dump_rings' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.dumprings(geometry) OWNER TO postgres; -- -- Name: enablelongtransactions(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION enablelongtransactions() RETURNS text AS $$ DECLARE query text; exists bool; rec RECORD; BEGIN exists = 'f'; FOR rec IN SELECT * FROM pg_class WHERE relname = 'authorization_table' LOOP exists = 't'; END LOOP; IF NOT exists THEN query = 'CREATE TABLE authorization_table ( toid oid, -- table oid rid text, -- row id expires timestamp, authid text )'; EXECUTE query; END IF; exists = 'f'; FOR rec IN SELECT * FROM pg_class WHERE relname = 'authorized_tables' LOOP exists = 't'; END LOOP; IF NOT exists THEN query = 'CREATE VIEW authorized_tables AS ' || 'SELECT ' || 'n.nspname as schema, ' || 'c.relname as table, trim(' || quote_literal(chr(92) || '000') || ' from t.tgargs) as id_column ' || 'FROM pg_trigger t, pg_class c, pg_proc p ' || ', pg_namespace n ' || 'WHERE p.proname = ' || quote_literal('checkauthtrigger') || ' AND c.relnamespace = n.oid' || ' AND t.tgfoid = p.oid and t.tgrelid = c.oid'; EXECUTE query; END IF; RETURN 'Long transactions support enabled'; END; $$ LANGUAGE plpgsql; ALTER FUNCTION public.enablelongtransactions() OWNER TO postgres; -- -- Name: endpoint(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION endpoint(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_endpoint_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.endpoint(geometry) OWNER TO postgres; -- -- Name: envelope(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION envelope(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_envelope' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.envelope(geometry) OWNER TO postgres; -- -- Name: equals(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION equals(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'geomequals' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.equals(geometry, geometry) OWNER TO postgres; -- -- Name: estimate_histogram2d(histogram2d, box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION estimate_histogram2d(histogram2d, box2d) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'estimate_lwhistogram2d' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.estimate_histogram2d(histogram2d, box2d) OWNER TO postgres; -- -- Name: estimated_extent(text, text, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION estimated_extent(text, text, text) RETURNS box2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_estimated_extent' LANGUAGE c IMMUTABLE STRICT SECURITY DEFINER; ALTER FUNCTION public.estimated_extent(text, text, text) OWNER TO postgres; -- -- Name: estimated_extent(text, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION estimated_extent(text, text) RETURNS box2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_estimated_extent' LANGUAGE c IMMUTABLE STRICT SECURITY DEFINER; ALTER FUNCTION public.estimated_extent(text, text) OWNER TO postgres; -- -- Name: expand(box3d, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION expand(box3d, double precision) RETURNS box3d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX3D_expand' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.expand(box3d, double precision) OWNER TO postgres; -- -- Name: expand(box2d, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION expand(box2d, double precision) RETURNS box2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2DFLOAT4_expand' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.expand(box2d, double precision) OWNER TO postgres; -- -- Name: expand(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION expand(geometry, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_expand' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.expand(geometry, double precision) OWNER TO postgres; -- -- Name: explode_histogram2d(histogram2d, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION explode_histogram2d(histogram2d, text) RETURNS histogram2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'explode_lwhistogram2d' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.explode_histogram2d(histogram2d, text) OWNER TO postgres; -- -- Name: exteriorring(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION exteriorring(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_exteriorring_polygon' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.exteriorring(geometry) OWNER TO postgres; -- -- Name: factor(chip); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION factor(chip) RETURNS real AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'CHIP_getFactor' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.factor(chip) OWNER TO postgres; -- -- Name: find_extent(text, text, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION find_extent(text, text, text) RETURNS box2d AS $_$ DECLARE schemaname alias for $1; tablename alias for $2; columnname alias for $3; myrec RECORD; BEGIN FOR myrec IN EXECUTE 'SELECT extent("'||columnname||'") FROM "'||schemaname||'"."'||tablename||'"' LOOP return myrec.extent; END LOOP; END; $_$ LANGUAGE plpgsql IMMUTABLE STRICT; ALTER FUNCTION public.find_extent(text, text, text) OWNER TO postgres; -- -- Name: find_extent(text, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION find_extent(text, text) RETURNS box2d AS $_$ DECLARE tablename alias for $1; columnname alias for $2; myrec RECORD; BEGIN FOR myrec IN EXECUTE 'SELECT extent("'||columnname||'") FROM "'||tablename||'"' LOOP return myrec.extent; END LOOP; END; $_$ LANGUAGE plpgsql IMMUTABLE STRICT; ALTER FUNCTION public.find_extent(text, text) OWNER TO postgres; -- -- Name: find_srid(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION find_srid(character varying, character varying, character varying) RETURNS integer AS $_$DECLARE schem text; tabl text; sr int4; BEGIN IF $1 IS NULL THEN RAISE EXCEPTION 'find_srid() - schema is NULL!'; END IF; IF $2 IS NULL THEN RAISE EXCEPTION 'find_srid() - table name is NULL!'; END IF; IF $3 IS NULL THEN RAISE EXCEPTION 'find_srid() - column name is NULL!'; END IF; schem = $1; tabl = $2; -- if the table contains a . and the schema is empty -- split the table into a schema and a table -- otherwise drop through to default behavior IF ( schem = '' and tabl LIKE '%.%' ) THEN schem = substr(tabl,1,strpos(tabl,'.')-1); tabl = substr(tabl,length(schem)+2); ELSE schem = schem || '%'; END IF; select SRID into sr from geometry_columns where f_table_schema like schem and f_table_name = tabl and f_geometry_column = $3; IF NOT FOUND THEN RAISE EXCEPTION 'find_srid() - couldnt find the corresponding SRID - is the geometry registered in the GEOMETRY_COLUMNS table? Is there an uppercase/lowercase missmatch?'; END IF; return sr; END; $_$ LANGUAGE plpgsql IMMUTABLE STRICT; ALTER FUNCTION public.find_srid(character varying, character varying, character varying) OWNER TO postgres; -- -- Name: fix_geometry_columns(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION fix_geometry_columns() RETURNS text AS $$ DECLARE mislinked record; result text; linked integer; deleted integer; foundschema integer; BEGIN -- Since 7.3 schema support has been added. -- Previous postgis versions used to put the database name in -- the schema column. This needs to be fixed, so we try to -- set the correct schema for each geometry_colums record -- looking at table, column, type and srid. UPDATE geometry_columns SET f_table_schema = n.nspname FROM pg_namespace n, pg_class c, pg_attribute a, pg_constraint sridcheck, pg_constraint typecheck WHERE ( f_table_schema is NULL OR f_table_schema = '' OR f_table_schema NOT IN ( SELECT nspname::varchar FROM pg_namespace nn, pg_class cc, pg_attribute aa WHERE cc.relnamespace = nn.oid AND cc.relname = f_table_name::name AND aa.attrelid = cc.oid AND aa.attname = f_geometry_column::name)) AND f_table_name::name = c.relname AND c.oid = a.attrelid AND c.relnamespace = n.oid AND f_geometry_column::name = a.attname AND sridcheck.conrelid = c.oid AND sridcheck.consrc LIKE '(srid(% = %)' AND sridcheck.consrc ~ textcat(' = ', srid::text) AND typecheck.conrelid = c.oid AND typecheck.consrc LIKE '((geometrytype(%) = ''%''::text) OR (% IS NULL))' AND typecheck.consrc ~ textcat(' = ''', type::text) AND NOT EXISTS ( SELECT oid FROM geometry_columns gc WHERE c.relname::varchar = gc.f_table_name AND n.nspname::varchar = gc.f_table_schema AND a.attname::varchar = gc.f_geometry_column ); GET DIAGNOSTICS foundschema = ROW_COUNT; -- no linkage to system table needed return 'fixed:'||foundschema::text; -- fix linking to system tables SELECT 0 INTO linked; FOR mislinked in SELECT gc.oid as gcrec, a.attrelid as attrelid, a.attnum as attnum FROM geometry_columns gc, pg_class c, pg_namespace n, pg_attribute a WHERE ( gc.attrelid IS NULL OR gc.attrelid != a.attrelid OR gc.varattnum IS NULL OR gc.varattnum != a.attnum) AND n.nspname = gc.f_table_schema::name AND c.relnamespace = n.oid AND c.relname = gc.f_table_name::name AND a.attname = f_geometry_column::name AND a.attrelid = c.oid LOOP UPDATE geometry_columns SET attrelid = mislinked.attrelid, varattnum = mislinked.attnum, stats = NULL WHERE geometry_columns.oid = mislinked.gcrec; SELECT linked+1 INTO linked; END LOOP; -- remove stale records DELETE FROM geometry_columns WHERE attrelid IS NULL; GET DIAGNOSTICS deleted = ROW_COUNT; result = 'fixed:' || foundschema::text || ' linked:' || linked::text || ' deleted:' || deleted::text; return result; END; $$ LANGUAGE plpgsql; ALTER FUNCTION public.fix_geometry_columns() OWNER TO postgres; -- -- Name: force_2d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION force_2d(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_force_2d' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.force_2d(geometry) OWNER TO postgres; -- -- Name: force_3d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION force_3d(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_force_3dz' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.force_3d(geometry) OWNER TO postgres; -- -- Name: force_3dm(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION force_3dm(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_force_3dm' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.force_3dm(geometry) OWNER TO postgres; -- -- Name: force_3dz(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION force_3dz(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_force_3dz' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.force_3dz(geometry) OWNER TO postgres; -- -- Name: force_4d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION force_4d(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_force_4d' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.force_4d(geometry) OWNER TO postgres; -- -- Name: force_collection(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION force_collection(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_force_collection' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.force_collection(geometry) OWNER TO postgres; -- -- Name: forcerhr(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION forcerhr(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_forceRHR_poly' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.forcerhr(geometry) OWNER TO postgres; -- -- Name: geom_accum(geometry[], geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geom_accum(geometry[], geometry) RETURNS geometry[] AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_accum' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.geom_accum(geometry[], geometry) OWNER TO postgres; -- -- Name: geomcollfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geomcollfromtext(text, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1, $2)) = 'GEOMETRYCOLLECTION' THEN GeomFromText($1,$2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.geomcollfromtext(text, integer) OWNER TO postgres; -- -- Name: geomcollfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geomcollfromtext(text) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1)) = 'GEOMETRYCOLLECTION' THEN GeomFromText($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.geomcollfromtext(text) OWNER TO postgres; -- -- Name: geomcollfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geomcollfromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'GEOMETRYCOLLECTION' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.geomcollfromwkb(bytea, integer) OWNER TO postgres; -- -- Name: geomcollfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geomcollfromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'GEOMETRYCOLLECTION' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.geomcollfromwkb(bytea) OWNER TO postgres; -- -- Name: geometry(box2d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry(box2d) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2DFLOAT4_to_LWGEOM' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry(box2d) OWNER TO postgres; -- -- Name: geometry(box3d); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry(box3d) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX3D_to_LWGEOM' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry(box3d) OWNER TO postgres; -- -- Name: geometry(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry(text) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'parse_WKT_lwgeom' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry(text) OWNER TO postgres; -- -- Name: geometry(chip); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry(chip) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'CHIP_to_LWGEOM' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry(chip) OWNER TO postgres; -- -- Name: geometry(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry(bytea) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_from_bytea' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry(bytea) OWNER TO postgres; -- -- Name: geometry_above(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_above(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_above' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_above(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_below(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_below(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_below' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_below(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_cmp(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_cmp(geometry, geometry) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'lwgeom_cmp' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_cmp(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_contain(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_contain(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_contain' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_contain(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_contained(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_contained(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_contained' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_contained(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_eq(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_eq(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'lwgeom_eq' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_eq(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_ge(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_ge(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'lwgeom_ge' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_ge(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_gt(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_gt(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'lwgeom_gt' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_gt(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_le(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_le(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'lwgeom_le' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_le(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_left(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_left(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_left' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_left(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_lt(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_lt(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'lwgeom_lt' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_lt(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_overabove(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_overabove(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_overabove' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_overabove(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_overbelow(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_overbelow(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_overbelow' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_overbelow(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_overlap(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_overlap(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_overlap' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_overlap(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_overleft(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_overleft(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_overleft' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_overleft(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_overright(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_overright(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_overright' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_overright(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_right(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_right(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_right' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_right(geometry, geometry) OWNER TO postgres; -- -- Name: geometry_same(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometry_same(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_same' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometry_same(geometry, geometry) OWNER TO postgres; -- -- Name: geometryfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometryfromtext(text) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_from_text' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometryfromtext(text) OWNER TO postgres; -- -- Name: geometryfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometryfromtext(text, integer) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_from_text' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometryfromtext(text, integer) OWNER TO postgres; -- -- Name: geometryn(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometryn(geometry, integer) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_geometryn_collection' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometryn(geometry, integer) OWNER TO postgres; -- -- Name: geometrytype(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geometrytype(geometry) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_getTYPE' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geometrytype(geometry) OWNER TO postgres; -- -- Name: geomfromewkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geomfromewkb(bytea) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOMFromWKB' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geomfromewkb(bytea) OWNER TO postgres; -- -- Name: geomfromewkt(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geomfromewkt(text) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'parse_WKT_lwgeom' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geomfromewkt(text) OWNER TO postgres; -- -- Name: geomfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geomfromtext(text) RETURNS geometry AS $_$SELECT geometryfromtext($1)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.geomfromtext(text) OWNER TO postgres; -- -- Name: geomfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geomfromtext(text, integer) RETURNS geometry AS $_$SELECT geometryfromtext($1, $2)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.geomfromtext(text, integer) OWNER TO postgres; -- -- Name: geomfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geomfromwkb(bytea) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_from_WKB' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geomfromwkb(bytea) OWNER TO postgres; -- -- Name: geomfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geomfromwkb(bytea, integer) RETURNS geometry AS $_$SELECT setSRID(GeomFromWKB($1), $2)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.geomfromwkb(bytea, integer) OWNER TO postgres; -- -- Name: geomunion(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geomunion(geometry, geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'geomunion' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.geomunion(geometry, geometry) OWNER TO postgres; -- -- Name: geosnoop(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION geosnoop(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'GEOSnoop' LANGUAGE c STRICT; ALTER FUNCTION public.geosnoop(geometry) OWNER TO postgres; -- -- Name: get_proj4_from_srid(integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION get_proj4_from_srid(integer) RETURNS text AS $_$ BEGIN RETURN proj4text::text FROM spatial_ref_sys WHERE srid= $1; END; $_$ LANGUAGE plpgsql IMMUTABLE STRICT; ALTER FUNCTION public.get_proj4_from_srid(integer) OWNER TO postgres; -- -- Name: getbbox(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION getbbox(geometry) RETURNS box2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_to_BOX2DFLOAT4' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.getbbox(geometry) OWNER TO postgres; -- -- Name: getsrid(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION getsrid(geometry) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_getSRID' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.getsrid(geometry) OWNER TO postgres; -- -- Name: gettransactionid(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION gettransactionid() RETURNS xid AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'getTransactionID' LANGUAGE c; ALTER FUNCTION public.gettransactionid() OWNER TO postgres; -- -- Name: hasbbox(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION hasbbox(geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_hasBBOX' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.hasbbox(geometry) OWNER TO postgres; -- -- Name: height(chip); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION height(chip) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'CHIP_getHeight' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.height(chip) OWNER TO postgres; -- -- Name: interiorringn(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION interiorringn(geometry, integer) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_interiorringn_polygon' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.interiorringn(geometry, integer) OWNER TO postgres; -- -- Name: intersection(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION intersection(geometry, geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'intersection' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.intersection(geometry, geometry) OWNER TO postgres; -- -- Name: intersects(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION intersects(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'intersects' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.intersects(geometry, geometry) OWNER TO postgres; -- -- Name: isclosed(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION isclosed(geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_isclosed_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.isclosed(geometry) OWNER TO postgres; -- -- Name: isempty(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION isempty(geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_isempty' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.isempty(geometry) OWNER TO postgres; -- -- Name: isring(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION isring(geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'isring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.isring(geometry) OWNER TO postgres; -- -- Name: issimple(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION issimple(geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'issimple' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.issimple(geometry) OWNER TO postgres; -- -- Name: isvalid(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION isvalid(geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'isvalid' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.isvalid(geometry) OWNER TO postgres; -- -- Name: jtsnoop(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION jtsnoop(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'JTSnoop' LANGUAGE c STRICT; ALTER FUNCTION public.jtsnoop(geometry) OWNER TO postgres; -- -- Name: length(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION length(geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_length_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.length(geometry) OWNER TO postgres; -- -- Name: length2d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION length2d(geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_length2d_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.length2d(geometry) OWNER TO postgres; -- -- Name: length2d_spheroid(geometry, spheroid); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION length2d_spheroid(geometry, spheroid) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_length2d_ellipsoid_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.length2d_spheroid(geometry, spheroid) OWNER TO postgres; -- -- Name: length3d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION length3d(geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_length_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.length3d(geometry) OWNER TO postgres; -- -- Name: length3d_spheroid(geometry, spheroid); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION length3d_spheroid(geometry, spheroid) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_length_ellipsoid_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.length3d_spheroid(geometry, spheroid) OWNER TO postgres; -- -- Name: length_spheroid(geometry, spheroid); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION length_spheroid(geometry, spheroid) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_length_ellipsoid_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.length_spheroid(geometry, spheroid) OWNER TO postgres; -- -- Name: line_interpolate_point(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION line_interpolate_point(geometry, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_line_interpolate_point' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.line_interpolate_point(geometry, double precision) OWNER TO postgres; -- -- Name: line_locate_point(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION line_locate_point(geometry, geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_line_locate_point' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.line_locate_point(geometry, geometry) OWNER TO postgres; -- -- Name: line_substring(geometry, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION line_substring(geometry, double precision, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_line_substring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.line_substring(geometry, double precision, double precision) OWNER TO postgres; -- -- Name: linefrommultipoint(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION linefrommultipoint(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_line_from_mpoint' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.linefrommultipoint(geometry) OWNER TO postgres; -- -- Name: linefromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION linefromtext(text) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1)) = 'LINESTRING' THEN GeomFromText($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.linefromtext(text) OWNER TO postgres; -- -- Name: linefromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION linefromtext(text, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1, $2)) = 'LINESTRING' THEN GeomFromText($1,$2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.linefromtext(text, integer) OWNER TO postgres; -- -- Name: linefromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION linefromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'LINESTRING' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.linefromwkb(bytea, integer) OWNER TO postgres; -- -- Name: linefromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION linefromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'LINESTRING' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.linefromwkb(bytea) OWNER TO postgres; -- -- Name: linemerge(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION linemerge(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'linemerge' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.linemerge(geometry) OWNER TO postgres; -- -- Name: linestringfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION linestringfromtext(text) RETURNS geometry AS $_$SELECT LineFromText($1)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.linestringfromtext(text) OWNER TO postgres; -- -- Name: linestringfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION linestringfromtext(text, integer) RETURNS geometry AS $_$SELECT LineFromText($1, $2)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.linestringfromtext(text, integer) OWNER TO postgres; -- -- Name: linestringfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION linestringfromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'LINESTRING' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.linestringfromwkb(bytea, integer) OWNER TO postgres; -- -- Name: linestringfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION linestringfromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'LINESTRING' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.linestringfromwkb(bytea) OWNER TO postgres; -- -- Name: locate_along_measure(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION locate_along_measure(geometry, double precision) RETURNS geometry AS $_$SELECT locate_between_measures($1, $2, $2)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.locate_along_measure(geometry, double precision) OWNER TO postgres; -- -- Name: locate_between_measures(geometry, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION locate_between_measures(geometry, double precision, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_locate_between_m' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.locate_between_measures(geometry, double precision, double precision) OWNER TO postgres; -- -- Name: lockrow(text, text, text, text, timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION lockrow(text, text, text, text, timestamp without time zone) RETURNS integer AS $_$ DECLARE myschema alias for $1; mytable alias for $2; myrid alias for $3; authid alias for $4; expires alias for $5; ret int; mytoid oid; myrec RECORD; BEGIN IF NOT LongTransactionsEnabled() THEN RAISE EXCEPTION 'Long transaction support disabled, use EnableLongTransaction() to enable.'; END IF; EXECUTE 'DELETE FROM authorization_table WHERE expires < now()'; SELECT c.oid INTO mytoid FROM pg_class c, pg_namespace n WHERE c.relname = mytable AND c.relnamespace = n.oid AND n.nspname = myschema; -- RAISE NOTICE 'toid: %', mytoid; FOR myrec IN SELECT * FROM authorization_table WHERE toid = mytoid AND rid = myrid LOOP IF myrec.authid != authid THEN RETURN 0; ELSE RETURN 1; END IF; END LOOP; EXECUTE 'INSERT INTO authorization_table VALUES ('|| quote_literal(mytoid)||','||quote_literal(myrid)|| ','||quote_literal(expires)|| ','||quote_literal(authid) ||')'; GET DIAGNOSTICS ret = ROW_COUNT; RETURN ret; END;$_$ LANGUAGE plpgsql STRICT; ALTER FUNCTION public.lockrow(text, text, text, text, timestamp without time zone) OWNER TO postgres; -- -- Name: lockrow(text, text, text, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION lockrow(text, text, text, text) RETURNS integer AS $_$SELECT LockRow($1, $2, $3, $4, now()::timestamp+'1:00');$_$ LANGUAGE sql STRICT; ALTER FUNCTION public.lockrow(text, text, text, text) OWNER TO postgres; -- -- Name: lockrow(text, text, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION lockrow(text, text, text) RETURNS integer AS $_$SELECT LockRow(current_schema(), $1, $2, $3, now()::timestamp+'1:00');$_$ LANGUAGE sql STRICT; ALTER FUNCTION public.lockrow(text, text, text) OWNER TO postgres; -- -- Name: lockrow(text, text, text, timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION lockrow(text, text, text, timestamp without time zone) RETURNS integer AS $_$SELECT LockRow(current_schema(), $1, $2, $3, $4);$_$ LANGUAGE sql STRICT; ALTER FUNCTION public.lockrow(text, text, text, timestamp without time zone) OWNER TO postgres; -- -- Name: longtransactionsenabled(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION longtransactionsenabled() RETURNS boolean AS $$ DECLARE rec RECORD; BEGIN FOR rec IN SELECT oid FROM pg_class WHERE relname = 'authorized_tables' LOOP return 't'; END LOOP; return 'f'; END; $$ LANGUAGE plpgsql; ALTER FUNCTION public.longtransactionsenabled() OWNER TO postgres; -- -- Name: lwgeom_gist_compress(internal); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION lwgeom_gist_compress(internal) RETURNS internal AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_gist_compress' LANGUAGE c; ALTER FUNCTION public.lwgeom_gist_compress(internal) OWNER TO postgres; -- -- Name: lwgeom_gist_consistent(internal, geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION lwgeom_gist_consistent(internal, geometry, integer) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_gist_consistent' LANGUAGE c; ALTER FUNCTION public.lwgeom_gist_consistent(internal, geometry, integer) OWNER TO postgres; -- -- Name: lwgeom_gist_decompress(internal); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION lwgeom_gist_decompress(internal) RETURNS internal AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_gist_decompress' LANGUAGE c; ALTER FUNCTION public.lwgeom_gist_decompress(internal) OWNER TO postgres; -- -- Name: lwgeom_gist_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION lwgeom_gist_penalty(internal, internal, internal) RETURNS internal AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_gist_penalty' LANGUAGE c; ALTER FUNCTION public.lwgeom_gist_penalty(internal, internal, internal) OWNER TO postgres; -- -- Name: lwgeom_gist_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION lwgeom_gist_picksplit(internal, internal) RETURNS internal AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_gist_picksplit' LANGUAGE c; ALTER FUNCTION public.lwgeom_gist_picksplit(internal, internal) OWNER TO postgres; -- -- Name: lwgeom_gist_same(box2d, box2d, internal); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION lwgeom_gist_same(box2d, box2d, internal) RETURNS internal AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_gist_same' LANGUAGE c; ALTER FUNCTION public.lwgeom_gist_same(box2d, box2d, internal) OWNER TO postgres; -- -- Name: lwgeom_gist_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION lwgeom_gist_union(bytea, internal) RETURNS internal AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_gist_union' LANGUAGE c; ALTER FUNCTION public.lwgeom_gist_union(bytea, internal) OWNER TO postgres; -- -- Name: m(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION m(geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_m_point' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.m(geometry) OWNER TO postgres; -- -- Name: makebox2d(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION makebox2d(geometry, geometry) RETURNS box2d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2DFLOAT4_construct' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.makebox2d(geometry, geometry) OWNER TO postgres; -- -- Name: makebox3d(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION makebox3d(geometry, geometry) RETURNS box3d AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX3D_construct' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.makebox3d(geometry, geometry) OWNER TO postgres; -- -- Name: makeline(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION makeline(geometry, geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_makeline' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.makeline(geometry, geometry) OWNER TO postgres; -- -- Name: makeline_garray(geometry[]); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION makeline_garray(geometry[]) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_makeline_garray' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.makeline_garray(geometry[]) OWNER TO postgres; -- -- Name: makepoint(double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION makepoint(double precision, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_makepoint' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.makepoint(double precision, double precision) OWNER TO postgres; -- -- Name: makepoint(double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION makepoint(double precision, double precision, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_makepoint' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.makepoint(double precision, double precision, double precision) OWNER TO postgres; -- -- Name: makepoint(double precision, double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION makepoint(double precision, double precision, double precision, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_makepoint' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.makepoint(double precision, double precision, double precision, double precision) OWNER TO postgres; -- -- Name: makepointm(double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION makepointm(double precision, double precision, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_makepoint3dm' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.makepointm(double precision, double precision, double precision) OWNER TO postgres; -- -- Name: makepolygon(geometry, geometry[]); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION makepolygon(geometry, geometry[]) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_makepoly' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.makepolygon(geometry, geometry[]) OWNER TO postgres; -- -- Name: makepolygon(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION makepolygon(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_makepoly' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.makepolygon(geometry) OWNER TO postgres; -- -- Name: max_distance(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION max_distance(geometry, geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_maxdistance2d_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.max_distance(geometry, geometry) OWNER TO postgres; -- -- Name: mem_size(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mem_size(geometry) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_mem_size' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.mem_size(geometry) OWNER TO postgres; -- -- Name: mlinefromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mlinefromtext(text, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1, $2)) = 'MULTILINESTRING' THEN GeomFromText($1,$2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mlinefromtext(text, integer) OWNER TO postgres; -- -- Name: mlinefromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mlinefromtext(text) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1)) = 'MULTILINESTRING' THEN GeomFromText($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mlinefromtext(text) OWNER TO postgres; -- -- Name: mlinefromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mlinefromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'MULTILINESTRING' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mlinefromwkb(bytea, integer) OWNER TO postgres; -- -- Name: mlinefromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mlinefromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'MULTILINESTRING' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mlinefromwkb(bytea) OWNER TO postgres; -- -- Name: mpointfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mpointfromtext(text, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1,$2)) = 'MULTIPOINT' THEN GeomFromText($1,$2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mpointfromtext(text, integer) OWNER TO postgres; -- -- Name: mpointfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mpointfromtext(text) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1)) = 'MULTIPOINT' THEN GeomFromText($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mpointfromtext(text) OWNER TO postgres; -- -- Name: mpointfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mpointfromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1,$2)) = 'MULTIPOINT' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mpointfromwkb(bytea, integer) OWNER TO postgres; -- -- Name: mpointfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mpointfromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'MULTIPOINT' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mpointfromwkb(bytea) OWNER TO postgres; -- -- Name: mpolyfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mpolyfromtext(text, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1, $2)) = 'MULTIPOLYGON' THEN GeomFromText($1,$2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mpolyfromtext(text, integer) OWNER TO postgres; -- -- Name: mpolyfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mpolyfromtext(text) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1)) = 'MULTIPOLYGON' THEN GeomFromText($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mpolyfromtext(text) OWNER TO postgres; -- -- Name: mpolyfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mpolyfromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'MULTIPOLYGON' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mpolyfromwkb(bytea, integer) OWNER TO postgres; -- -- Name: mpolyfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION mpolyfromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'MULTIPOLYGON' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.mpolyfromwkb(bytea) OWNER TO postgres; -- -- Name: multi(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multi(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_force_multi' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.multi(geometry) OWNER TO postgres; -- -- Name: multilinefromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multilinefromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'MULTILINESTRING' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multilinefromwkb(bytea, integer) OWNER TO postgres; -- -- Name: multilinefromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multilinefromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'MULTILINESTRING' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multilinefromwkb(bytea) OWNER TO postgres; -- -- Name: multilinestringfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multilinestringfromtext(text) RETURNS geometry AS $_$SELECT MLineFromText($1)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multilinestringfromtext(text) OWNER TO postgres; -- -- Name: multilinestringfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multilinestringfromtext(text, integer) RETURNS geometry AS $_$SELECT MLineFromText($1, $2)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multilinestringfromtext(text, integer) OWNER TO postgres; -- -- Name: multipointfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multipointfromtext(text, integer) RETURNS geometry AS $_$SELECT MPointFromText($1, $2)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multipointfromtext(text, integer) OWNER TO postgres; -- -- Name: multipointfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multipointfromtext(text) RETURNS geometry AS $_$SELECT MPointFromText($1)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multipointfromtext(text) OWNER TO postgres; -- -- Name: multipointfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multipointfromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1,$2)) = 'MULTIPOINT' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multipointfromwkb(bytea, integer) OWNER TO postgres; -- -- Name: multipointfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multipointfromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'MULTIPOINT' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multipointfromwkb(bytea) OWNER TO postgres; -- -- Name: multipolyfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multipolyfromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'MULTIPOLYGON' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multipolyfromwkb(bytea, integer) OWNER TO postgres; -- -- Name: multipolyfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multipolyfromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'MULTIPOLYGON' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multipolyfromwkb(bytea) OWNER TO postgres; -- -- Name: multipolygonfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multipolygonfromtext(text, integer) RETURNS geometry AS $_$SELECT MPolyFromText($1, $2)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multipolygonfromtext(text, integer) OWNER TO postgres; -- -- Name: multipolygonfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION multipolygonfromtext(text) RETURNS geometry AS $_$SELECT MPolyFromText($1)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.multipolygonfromtext(text) OWNER TO postgres; -- -- Name: ndims(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION ndims(geometry) RETURNS smallint AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_ndims' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.ndims(geometry) OWNER TO postgres; -- -- Name: noop(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION noop(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_noop' LANGUAGE c STRICT; ALTER FUNCTION public.noop(geometry) OWNER TO postgres; -- -- Name: npoints(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION npoints(geometry) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_npoints' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.npoints(geometry) OWNER TO postgres; -- -- Name: nrings(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION nrings(geometry) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_nrings' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.nrings(geometry) OWNER TO postgres; -- -- Name: numgeometries(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION numgeometries(geometry) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_numgeometries_collection' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.numgeometries(geometry) OWNER TO postgres; -- -- Name: numinteriorring(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION numinteriorring(geometry) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_numinteriorrings_polygon' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.numinteriorring(geometry) OWNER TO postgres; -- -- Name: numinteriorrings(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION numinteriorrings(geometry) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_numinteriorrings_polygon' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.numinteriorrings(geometry) OWNER TO postgres; -- -- Name: numpoints(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION numpoints(geometry) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_numpoints_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.numpoints(geometry) OWNER TO postgres; -- -- Name: overlaps(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION "overlaps"(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'overlaps' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public."overlaps"(geometry, geometry) OWNER TO postgres; -- -- Name: perimeter(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION perimeter(geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_perimeter_poly' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.perimeter(geometry) OWNER TO postgres; -- -- Name: perimeter2d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION perimeter2d(geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_perimeter2d_poly' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.perimeter2d(geometry) OWNER TO postgres; -- -- Name: perimeter3d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION perimeter3d(geometry) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_perimeter_poly' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.perimeter3d(geometry) OWNER TO postgres; -- -- Name: point_inside_circle(geometry, double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION point_inside_circle(geometry, double precision, double precision, double precision) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_inside_circle_point' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.point_inside_circle(geometry, double precision, double precision, double precision) OWNER TO postgres; -- -- Name: pointfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION pointfromtext(text) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1)) = 'POINT' THEN GeomFromText($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.pointfromtext(text) OWNER TO postgres; -- -- Name: pointfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION pointfromtext(text, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1, $2)) = 'POINT' THEN GeomFromText($1,$2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.pointfromtext(text, integer) OWNER TO postgres; -- -- Name: pointfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION pointfromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'POINT' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.pointfromwkb(bytea, integer) OWNER TO postgres; -- -- Name: pointfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION pointfromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'POINT' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.pointfromwkb(bytea) OWNER TO postgres; -- -- Name: pointn(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION pointn(geometry, integer) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_pointn_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.pointn(geometry, integer) OWNER TO postgres; -- -- Name: pointonsurface(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION pointonsurface(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'pointonsurface' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.pointonsurface(geometry) OWNER TO postgres; -- -- Name: polyfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION polyfromtext(text) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1)) = 'POLYGON' THEN GeomFromText($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.polyfromtext(text) OWNER TO postgres; -- -- Name: polyfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION polyfromtext(text, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromText($1, $2)) = 'POLYGON' THEN GeomFromText($1,$2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.polyfromtext(text, integer) OWNER TO postgres; -- -- Name: polyfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION polyfromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'POLYGON' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.polyfromwkb(bytea, integer) OWNER TO postgres; -- -- Name: polyfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION polyfromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'POLYGON' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.polyfromwkb(bytea) OWNER TO postgres; -- -- Name: polygonfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION polygonfromtext(text, integer) RETURNS geometry AS $_$SELECT PolyFromText($1, $2)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.polygonfromtext(text, integer) OWNER TO postgres; -- -- Name: polygonfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION polygonfromtext(text) RETURNS geometry AS $_$SELECT PolyFromText($1)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.polygonfromtext(text) OWNER TO postgres; -- -- Name: polygonfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION polygonfromwkb(bytea, integer) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1,$2)) = 'POLYGON' THEN GeomFromWKB($1, $2) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.polygonfromwkb(bytea, integer) OWNER TO postgres; -- -- Name: polygonfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION polygonfromwkb(bytea) RETURNS geometry AS $_$ SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'POLYGON' THEN GeomFromWKB($1) ELSE NULL END $_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.polygonfromwkb(bytea) OWNER TO postgres; -- -- Name: polygonize_garray(geometry[]); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION polygonize_garray(geometry[]) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'polygonize_garray' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.polygonize_garray(geometry[]) OWNER TO postgres; -- -- Name: postgis_full_version(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_full_version() RETURNS text AS $$ DECLARE libver text; projver text; geosver text; jtsver text; usestats bool; dbproc text; relproc text; fullver text; BEGIN SELECT postgis_lib_version() INTO libver; SELECT postgis_proj_version() INTO projver; SELECT postgis_geos_version() INTO geosver; SELECT postgis_jts_version() INTO jtsver; SELECT postgis_uses_stats() INTO usestats; SELECT postgis_scripts_installed() INTO dbproc; SELECT postgis_scripts_released() INTO relproc; fullver = 'POSTGIS="' || libver || '"'; IF geosver IS NOT NULL THEN fullver = fullver || ' GEOS="' || geosver || '"'; END IF; IF jtsver IS NOT NULL THEN fullver = fullver || ' JTS="' || jtsver || '"'; END IF; IF projver IS NOT NULL THEN fullver = fullver || ' PROJ="' || projver || '"'; END IF; IF usestats THEN fullver = fullver || ' USE_STATS'; END IF; -- fullver = fullver || ' DBPROC="' || dbproc || '"'; -- fullver = fullver || ' RELPROC="' || relproc || '"'; IF dbproc != relproc THEN fullver = fullver || ' (procs from ' || dbproc || ' need upgrade)'; END IF; RETURN fullver; END $$ LANGUAGE plpgsql IMMUTABLE; ALTER FUNCTION public.postgis_full_version() OWNER TO postgres; -- -- Name: postgis_geos_version(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_geos_version() RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'postgis_geos_version' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.postgis_geos_version() OWNER TO postgres; -- -- Name: postgis_gist_joinsel(internal, oid, internal, smallint); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_gist_joinsel(internal, oid, internal, smallint) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_gist_joinsel' LANGUAGE c; ALTER FUNCTION public.postgis_gist_joinsel(internal, oid, internal, smallint) OWNER TO postgres; -- -- Name: postgis_gist_sel(internal, oid, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_gist_sel(internal, oid, internal, integer) RETURNS double precision AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_gist_sel' LANGUAGE c; ALTER FUNCTION public.postgis_gist_sel(internal, oid, internal, integer) OWNER TO postgres; -- -- Name: postgis_jts_version(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_jts_version() RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'postgis_jts_version' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.postgis_jts_version() OWNER TO postgres; -- -- Name: postgis_lib_build_date(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_lib_build_date() RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'postgis_lib_build_date' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.postgis_lib_build_date() OWNER TO postgres; -- -- Name: postgis_lib_version(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_lib_version() RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'postgis_lib_version' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.postgis_lib_version() OWNER TO postgres; -- -- Name: postgis_proj_version(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_proj_version() RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'postgis_proj_version' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.postgis_proj_version() OWNER TO postgres; -- -- Name: postgis_scripts_build_date(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_scripts_build_date() RETURNS text AS $$SELECT '2006-12-18 16:23:51'::text AS version$$ LANGUAGE sql IMMUTABLE; ALTER FUNCTION public.postgis_scripts_build_date() OWNER TO postgres; -- -- Name: postgis_scripts_installed(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_scripts_installed() RETURNS text AS $$SELECT '1.1.6'::text AS version$$ LANGUAGE sql IMMUTABLE; ALTER FUNCTION public.postgis_scripts_installed() OWNER TO postgres; -- -- Name: postgis_scripts_released(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_scripts_released() RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'postgis_scripts_released' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.postgis_scripts_released() OWNER TO postgres; -- -- Name: postgis_uses_stats(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_uses_stats() RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'postgis_uses_stats' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.postgis_uses_stats() OWNER TO postgres; -- -- Name: postgis_version(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION postgis_version() RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'postgis_version' LANGUAGE c IMMUTABLE; ALTER FUNCTION public.postgis_version() OWNER TO postgres; -- -- Name: probe_geometry_columns(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION probe_geometry_columns() RETURNS text AS $$ DECLARE inserted integer; oldcount integer; probed integer; stale integer; BEGIN SELECT count(*) INTO oldcount FROM geometry_columns; SELECT count(*) INTO probed FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n, pg_constraint sridcheck, pg_constraint typecheck WHERE t.typname = 'geometry' AND a.atttypid = t.oid AND a.attrelid = c.oid AND c.relnamespace = n.oid AND sridcheck.connamespace = n.oid AND typecheck.connamespace = n.oid AND sridcheck.conrelid = c.oid AND sridcheck.consrc LIKE '(srid('||a.attname||') = %)' AND typecheck.conrelid = c.oid AND typecheck.consrc LIKE '((geometrytype('||a.attname||') = ''%''::text) OR (% IS NULL))' ; INSERT INTO geometry_columns SELECT ''::varchar as f_table_catalogue, n.nspname::varchar as f_table_schema, c.relname::varchar as f_table_name, a.attname::varchar as f_geometry_column, 2 as coord_dimension, trim(both ' =)' from substr(sridcheck.consrc, strpos(sridcheck.consrc, '=')))::integer as srid, trim(both ' =)''' from substr(typecheck.consrc, strpos(typecheck.consrc, '='), strpos(typecheck.consrc, '::')- strpos(typecheck.consrc, '=') ))::varchar as type FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n, pg_constraint sridcheck, pg_constraint typecheck WHERE t.typname = 'geometry' AND a.atttypid = t.oid AND a.attrelid = c.oid AND c.relnamespace = n.oid AND sridcheck.connamespace = n.oid AND typecheck.connamespace = n.oid AND sridcheck.conrelid = c.oid AND sridcheck.consrc LIKE '(srid('||a.attname||') = %)' AND typecheck.conrelid = c.oid AND typecheck.consrc LIKE '((geometrytype('||a.attname||') = ''%''::text) OR (% IS NULL))' AND NOT EXISTS ( SELECT oid FROM geometry_columns gc WHERE c.relname::varchar = gc.f_table_name AND n.nspname::varchar = gc.f_table_schema AND a.attname::varchar = gc.f_geometry_column ); GET DIAGNOSTICS inserted = ROW_COUNT; IF oldcount > probed THEN stale = oldcount-probed; ELSE stale = 0; END IF; RETURN 'probed:'||probed|| ' inserted:'||inserted|| ' conflicts:'||probed-inserted|| ' stale:'||stale; END $$ LANGUAGE plpgsql; ALTER FUNCTION public.probe_geometry_columns() OWNER TO postgres; -- -- Name: relate(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION relate(geometry, geometry) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'relate_full' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.relate(geometry, geometry) OWNER TO postgres; -- -- Name: relate(geometry, geometry, text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION relate(geometry, geometry, text) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'relate_pattern' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.relate(geometry, geometry, text) OWNER TO postgres; -- -- Name: removepoint(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION removepoint(geometry, integer) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_removepoint' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.removepoint(geometry, integer) OWNER TO postgres; -- -- Name: rename_geometry_table_constraints(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION rename_geometry_table_constraints() RETURNS text AS $$ SELECT 'rename_geometry_table_constraint() is obsoleted'::text $$ LANGUAGE sql IMMUTABLE; ALTER FUNCTION public.rename_geometry_table_constraints() OWNER TO postgres; -- -- Name: reverse(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION reverse(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_reverse' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.reverse(geometry) OWNER TO postgres; -- -- Name: rotate(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION rotate(geometry, double precision) RETURNS geometry AS $_$SELECT rotateZ($1, $2)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.rotate(geometry, double precision) OWNER TO postgres; -- -- Name: rotatex(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION rotatex(geometry, double precision) RETURNS geometry AS $_$SELECT affine($1, 1, 0, 0, 0, cos($2), -sin($2), 0, sin($2), cos($2), 0, 0, 0)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.rotatex(geometry, double precision) OWNER TO postgres; -- -- Name: rotatey(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION rotatey(geometry, double precision) RETURNS geometry AS $_$SELECT affine($1, cos($2), 0, sin($2), 0, 1, 0, -sin($2), 0, cos($2), 0, 0, 0)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.rotatey(geometry, double precision) OWNER TO postgres; -- -- Name: rotatez(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION rotatez(geometry, double precision) RETURNS geometry AS $_$SELECT affine($1, cos($2), -sin($2), 0, sin($2), cos($2), 0, 0, 0, 1, 0, 0, 0)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.rotatez(geometry, double precision) OWNER TO postgres; -- -- Name: scale(geometry, double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION scale(geometry, double precision, double precision, double precision) RETURNS geometry AS $_$SELECT affine($1, $2, 0, 0, 0, $3, 0, 0, 0, $4, 0, 0, 0)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.scale(geometry, double precision, double precision, double precision) OWNER TO postgres; -- -- Name: scale(geometry, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION scale(geometry, double precision, double precision) RETURNS geometry AS $_$SELECT scale($1, $2, $3, 1)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.scale(geometry, double precision, double precision) OWNER TO postgres; -- -- Name: segmentize(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION segmentize(geometry, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_segmentize2d' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.segmentize(geometry, double precision) OWNER TO postgres; -- -- Name: setfactor(chip, real); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION setfactor(chip, real) RETURNS chip AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'CHIP_setFactor' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.setfactor(chip, real) OWNER TO postgres; -- -- Name: setpoint(geometry, integer, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION setpoint(geometry, integer, geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_setpoint_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.setpoint(geometry, integer, geometry) OWNER TO postgres; -- -- Name: setsrid(chip, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION setsrid(chip, integer) RETURNS chip AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'CHIP_setSRID' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.setsrid(chip, integer) OWNER TO postgres; -- -- Name: setsrid(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION setsrid(geometry, integer) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_setSRID' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.setsrid(geometry, integer) OWNER TO postgres; -- -- Name: shift_longitude(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION shift_longitude(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_longitude_shift' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.shift_longitude(geometry) OWNER TO postgres; -- -- Name: simplify(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION simplify(geometry, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_simplify2d' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.simplify(geometry, double precision) OWNER TO postgres; -- -- Name: snaptogrid(geometry, double precision, double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION snaptogrid(geometry, double precision, double precision, double precision, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_snaptogrid' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.snaptogrid(geometry, double precision, double precision, double precision, double precision) OWNER TO postgres; -- -- Name: snaptogrid(geometry, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION snaptogrid(geometry, double precision, double precision) RETURNS geometry AS $_$SELECT SnapToGrid($1, 0, 0, $2, $3)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.snaptogrid(geometry, double precision, double precision) OWNER TO postgres; -- -- Name: snaptogrid(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION snaptogrid(geometry, double precision) RETURNS geometry AS $_$SELECT SnapToGrid($1, 0, 0, $2, $2)$_$ LANGUAGE sql IMMUTABLE STRICT; ALTER FUNCTION public.snaptogrid(geometry, double precision) OWNER TO postgres; -- -- Name: snaptogrid(geometry, geometry, double precision, double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION snaptogrid(geometry, geometry, double precision, double precision, double precision, double precision) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_snaptogrid_pointoff' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.snaptogrid(geometry, geometry, double precision, double precision, double precision, double precision) OWNER TO postgres; -- -- Name: srid(chip); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION srid(chip) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'CHIP_getSRID' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.srid(chip) OWNER TO postgres; -- -- Name: srid(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION srid(geometry) RETURNS integer AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_getSRID' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.srid(geometry) OWNER TO postgres; -- -- Name: startpoint(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION startpoint(geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_startpoint_linestring' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.startpoint(geometry) OWNER TO postgres; -- -- Name: summary(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION summary(geometry) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_summary' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.summary(geometry) OWNER TO postgres; -- -- Name: symdifference(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION symdifference(geometry, geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'symdifference' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.symdifference(geometry, geometry) OWNER TO postgres; -- -- Name: symmetricdifference(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION symmetricdifference(geometry, geometry) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'symdifference' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.symmetricdifference(geometry, geometry) OWNER TO postgres; -- -- Name: text(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION text(geometry) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'LWGEOM_to_text' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.text(geometry) OWNER TO postgres; -- -- Name: text(boolean); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION text(boolean) RETURNS text AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOOL_to_text' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.text(boolean) OWNER TO postgres; -- -- Name: touches(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION touches(geometry, geometry) RETURNS boolean AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'touches' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.touches(geometry, geometry) OWNER TO postgres; -- -- Name: transform(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION transform(geometry, integer) RETURNS geometry AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'transform' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.transform(geometry, integer) OWNER TO postgres; -- -- Name: transform_geometry(geometry, text, text, integer); Type: FUNCTION; Schema: pu