-- -- Selected TOC Entries: -- \connect - postgres -- -- TOC Entry ID 23 (OID 19325) -- -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres -- CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/local/pgsql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C'; -- -- TOC Entry ID 24 (OID 19326) -- -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: -- CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL'; -- -- TOC Entry ID 25 (OID 19327) -- -- Name: "postgis_version" () Type: FUNCTION Owner: postgres -- CREATE FUNCTION "postgis_version" () RETURNS character AS 'select ''0.6''::char as version' LANGUAGE 'sql'; -- -- TOC Entry ID 17 (OID 19328) -- -- Name: spatial_ref_sys Type: TABLE Owner: postgres -- CREATE TABLE "spatial_ref_sys" ( "srid" integer NOT NULL, "auth_name" character varying(256), "auth_srid" integer, "srtext" character varying(2048), Constraint "spatial_ref_sys_pkey" Primary Key ("srid") ); -- -- TOC Entry ID 18 (OID 19359) -- -- Name: geometry_columns Type: TABLE Owner: postgres -- CREATE TABLE "geometry_columns" ( "f_table_catalog" character varying(256) NOT NULL, "f_table_schema" character varying(256) NOT NULL, "f_table_name" character varying(256) NOT NULL, "f_geometry_column" character varying(256) NOT NULL, "coord_dimension" integer NOT NULL, "srid" integer NOT NULL, "type" character varying(30) NOT NULL, Constraint "gc_pk" Primary Key ("f_table_catalog", "f_table_schema", "f_table_name", "f_geometry_column") ); -- -- TOC Entry ID 26 (OID 19378) -- -- Name: "find_srid" (character varying,character varying,character varying) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "find_srid" (character varying,character varying,character varying) RETURNS integer AS 'select SRID from geometry_columns where f_table_schema like $1 || ''%'' and f_table_name = $2 and f_geometry_column = $3' LANGUAGE 'sql' WITH ( iscachable, isstrict ); -- -- TOC Entry ID 27 (OID 19379) -- -- Name: "dropgeometrycolumn" (character varying,character varying,character varying) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "dropgeometrycolumn" (character varying,character varying,character varying) RETURNS text AS '\015 DECLARE\015 database_name alias for $1;\015 table_name alias for $2;\015 column_name alias for $3;\015 myrec RECORD;\015 okay boolean;\015 BEGIN\015 -- first we find out if the column is in the geometry_columns table\015 okay = ''f'';\015 FOR myrec IN SELECT * from geometry_columns where f_table_schema = database_name and f_table_name = table_name and f_geometry_column = column_name LOOP\015 okay := ''t'';\015 END LOOP; \015 IF (okay <> ''t'') THEN \015 RAISE EXCEPTION ''column not found in geometry_columns table'';\015 return ''f'';\015 END IF;\015 \015 -- ensure the geometry column does not have a NOT NULL attribute\015 EXECUTE ''update pg_attribute set attnotnull = false from pg_class where pg_attribute.attrelid = pg_class.oid and pg_class.relname = '' || quote_literal(table_name) ||'' and pg_attribute.attname = '' || quote_literal(column_name);\015 \015 -- remove ref from geometry_columns table\015 EXECUTE ''delete from geometry_columns where f_table_schema = '' || quote_literal(database_name) ||\015 '' and f_table_name = '' || quote_literal(table_name) || \015 '' and f_geometry_column = '' || quote_literal(column_name );\015 \015 -- update the given table/column so that it it all NULLS\015 \015 EXECUTE ''update ''||table_name||'' set ''||column_name||''=NULL'';\015 \015 -- add = NULL constraint to given table/column\015 \015 EXECUTE ''ALTER TABLE ''||table_name||'' ADD CHECK (''||column_name||'' = NULL)'';\015 \015 RETURN table_name || ''.'' || column_name ||'' effectively removed.'';\015 \015 END;\015 ' LANGUAGE 'plpgsql' WITH ( isstrict ); -- -- TOC Entry ID 28 (OID 19380) -- -- Name: "addgeometrycolumn" (character varying,character varying,character varying,integer,character varying,integer) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "addgeometrycolumn" (character varying,character varying,character varying,integer,character varying,integer) RETURNS text AS '\015 DECLARE\015 database_name alias for $1;\015 table_name alias for $2;\015 column_name alias for $3;\015 new_srid alias for $4;\015 new_type alias for $5;\015 new_dim alias for $6;\015 \015 real_db_name varchar;\015 db_query RECORD;\015 db_name_ok boolean;\015 \015 BEGIN\015 \015 IF (not( (new_type =''GEOMETRY'') or (new_type =''GEOMETRYCOLLECTION'') or (new_type =''POINT'')\015 or (new_type =''MULTIPOINT'') or (new_type =''POLYGON'') or (new_type =''MULTIPOLYGON'') \015 or (new_type =''LINESTRING'') or (new_type =''MULTILINESTRING'') ) ) THEN \015 RAISE EXCEPTION ''invalid type name - valid ones are: GEOMETRY, GEOMETRYCOLLECTION,POINT,MULTIPOINT,POLYGON,MULTIPOLYGON,LINESTRING, or MULTILINESTRING '';\015 return ''fail'';\015 END IF;\015 \015 IF ( (new_dim >3) or (new_dim <0) ) THEN\015 RAISE EXCEPTION ''invalid dimension'';\015 return ''fail'';\015 END IF;\015 \015 db_name_ok := ''f'';\015 \015 FOR db_query IN SELECT datname from pg_database where text(datname) = database_name LOOP\015 db_name_ok := ''t'';\015 END LOOP; \015 \015 if (db_name_ok <> ''t'') THEN\015 RAISE EXCEPTION ''invalid database name'';\015 return ''fail'';\015 end if;\015 \015 EXECUTE ''ALTER TABLE '' || table_name || '' ADD COLUMN '' || column_name || '' GEOMETRY '';\015 EXECUTE ''INSERT INTO geometry_columns VALUES ('' || quote_literal('''') || '','' ||\015 quote_literal(database_name) || '','' || quote_literal(table_name) || '','' ||\015 quote_literal(column_name) || '','' ||\015 new_dim ||'',''||new_srid||'',''||quote_literal(new_type)||'')'';\015 \015 \015 \015 EXECUTE ''ALTER TABLE '' ||table_name||'' ADD CHECK (SRID('' || column_name ||\015 '') = '' || new_srid || '')'' ;\015 \015 IF (not(new_type = ''GEOMETRY'')) THEN\015 EXECUTE ''ALTER TABLE '' ||table_name||'' ADD CHECK ( geometrytype(''||column_name||'')=''|| quote_literal(new_type)||'' OR NULL=('' ||column_name ||''))'';\015 END IF;\015 \015 return ''Geometry column '' || column_name || '' added to table ''\015 ||table_name ||'' with a SRID of ''||new_srid || '' and type ''||new_type; \015 END;\015 ' LANGUAGE 'plpgsql' WITH ( isstrict ); -- -- TOC Entry ID 8 (OID 19382) -- -- Name: "box3d_in" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "box3d_in" (opaque) RETURNS box3d AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'box3d_in' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 9 (OID 19383) -- -- Name: "box3d_out" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "box3d_out" (opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'box3d_out' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 10 (OID 19381) -- -- Name: box3d Type: TYPE Owner: postgres -- CREATE TYPE "box3d" ( internallength = 48, externallength = -1, input = "box3d_in", output = "box3d_out", send = "box3d_out", receive = "box3d_in", default = '-', alignment = double, storage = plain); -- -- TOC Entry ID 5 (OID 19385) -- -- Name: "spheroid_in" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "spheroid_in" (opaque) RETURNS spheroid AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'ellipsoid_in' LANGUAGE 'C' WITH ( iscachable, isstrict ); -- -- TOC Entry ID 6 (OID 19386) -- -- Name: "spheroid_out" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "spheroid_out" (opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'ellipsoid_out' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 7 (OID 19384) -- -- Name: spheroid Type: TYPE Owner: postgres -- CREATE TYPE "spheroid" ( internallength = 65, externallength = -1, input = "spheroid_in", output = "spheroid_out", send = "spheroid_out", receive = "spheroid_in", default = '-', alignment = double, storage = plain); -- -- TOC Entry ID 2 (OID 19390) -- -- Name: "wkb_in" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "wkb_in" (opaque) RETURNS wkb AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'WKB_in' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 3 (OID 19391) -- -- Name: "wkb_out" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "wkb_out" (opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'WKB_out' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 4 (OID 19389) -- -- Name: wkb Type: TYPE Owner: postgres -- CREATE TYPE "wkb" ( internallength = -1, externallength = -1, input = "wkb_in", output = "wkb_out", send = "wkb_out", receive = "wkb_in", default = '', alignment = int4, storage = extended); -- -- TOC Entry ID 14 (OID 19394) -- -- Name: "chip_in" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "chip_in" (opaque) RETURNS chip AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'CHIP_in' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 15 (OID 19395) -- -- Name: "chip_out" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "chip_out" (opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'CHIP_out' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 16 (OID 19393) -- -- Name: chip Type: TYPE Owner: postgres -- CREATE TYPE "chip" ( internallength = -1, externallength = -1, input = "chip_in", output = "chip_out", send = "chip_out", receive = "chip_in", default = '-', alignment = double, storage = extended); -- -- TOC Entry ID 29 (OID 19398) -- -- Name: "geometry" (chip) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry" (chip) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'CHIP_to_geom' LANGUAGE 'C' WITH ( iscachable, isstrict ); -- -- TOC Entry ID 30 (OID 19399) -- -- Name: "srid" (chip) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "srid" (chip) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'srid_chip' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 31 (OID 19400) -- -- Name: "height" (chip) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "height" (chip) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'height_chip' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 32 (OID 19401) -- -- Name: "width" (chip) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "width" (chip) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'width_chip' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 33 (OID 19402) -- -- Name: "datatype" (chip) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "datatype" (chip) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'datatype_chip' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 34 (OID 19403) -- -- Name: "compression" (chip) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "compression" (chip) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'compression_chip' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 35 (OID 19404) -- -- Name: "setsrid" (chip,integer) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "setsrid" (chip,integer) RETURNS chip AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'setsrid_chip' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 11 (OID 19405) -- -- Name: "geometry_in" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_in" (opaque) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_in' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 12 (OID 19406) -- -- Name: "geometry_out" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_out" (opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_out' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 13 (OID 19397) -- -- Name: geometry Type: TYPE Owner: postgres -- CREATE TYPE "geometry" ( internallength = -1, externallength = -1, input = "geometry_in", output = "geometry_out", send = "geometry_out", receive = "geometry_in", default = '', alignment = double, storage = main); -- -- TOC Entry ID 36 (OID 19408) -- -- Name: "box3d" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "box3d" (geometry) RETURNS box3d AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'get_bbox_of_geometry' LANGUAGE 'C' WITH ( iscachable, isstrict ); -- -- TOC Entry ID 37 (OID 19409) -- -- Name: "geometry" (box3d) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry" (box3d) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'get_geometry_of_bbox' LANGUAGE 'C' WITH ( iscachable, isstrict ); -- -- TOC Entry ID 38 (OID 19410) -- -- Name: "geometry" (text) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry" (text) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_text' LANGUAGE 'C' WITH ( iscachable, isstrict ); -- -- TOC Entry ID 39 (OID 19411) -- -- Name: "expand" (box3d,double precision) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "expand" (box3d,double precision) RETURNS box3d AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'expand_bbox' LANGUAGE 'C' WITH ( iscachable, isstrict ); -- -- TOC Entry ID 40 (OID 19412) -- -- Name: "asbinary" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "asbinary" (geometry) RETURNS wkb AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'asbinary_simple' LANGUAGE 'C' WITH ( iscachable, isstrict ); -- -- TOC Entry ID 41 (OID 19413) -- -- Name: "asbinary" (geometry,text) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "asbinary" (geometry,text) RETURNS wkb AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'asbinary_specify' LANGUAGE 'C' WITH ( iscachable, isstrict ); -- -- TOC Entry ID 42 (OID 19414) -- -- Name: "npoints" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "npoints" (geometry) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'npoints' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 43 (OID 19415) -- -- Name: "nrings" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "nrings" (geometry) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'nrings' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 44 (OID 19416) -- -- Name: "mem_size" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "mem_size" (geometry) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'mem_size' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 45 (OID 19417) -- -- Name: "numb_sub_objs" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "numb_sub_objs" (geometry) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'numb_sub_objs' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 46 (OID 19418) -- -- Name: "summary" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "summary" (geometry) RETURNS text AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'summary' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 47 (OID 19419) -- -- Name: "translate" (geometry,double precision,double precision,double precision) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "translate" (geometry,double precision,double precision,double precision) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'translate' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 48 (OID 19420) -- -- Name: "dimension" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "dimension" (geometry) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'dimension' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 49 (OID 19421) -- -- Name: "geometrytype" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometrytype" (geometry) RETURNS text AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometrytype' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 50 (OID 19422) -- -- Name: "envelope" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "envelope" (geometry) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'envelope' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 51 (OID 19423) -- -- Name: "x" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "x" (geometry) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'x_point' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 52 (OID 19424) -- -- Name: "y" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "y" (geometry) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'y_point' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 53 (OID 19425) -- -- Name: "z" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "z" (geometry) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'z_point' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 54 (OID 19426) -- -- Name: "numpoints" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "numpoints" (geometry) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'numpoints_linestring' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 55 (OID 19427) -- -- Name: "pointn" (geometry,integer) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "pointn" (geometry,integer) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'pointn_linestring' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 56 (OID 19428) -- -- Name: "exteriorring" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "exteriorring" (geometry) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'exteriorring_polygon' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 57 (OID 19429) -- -- Name: "numinteriorrings" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "numinteriorrings" (geometry) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'numinteriorrings_polygon' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 58 (OID 19430) -- -- Name: "interiorringn" (geometry,integer) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "interiorringn" (geometry,integer) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'interiorringn_polygon' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 59 (OID 19431) -- -- Name: "numgeometries" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "numgeometries" (geometry) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'numgeometries_collection' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 60 (OID 19432) -- -- Name: "geometryn" (geometry,integer) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometryn" (geometry,integer) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometryn_collection' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 61 (OID 19433) -- -- Name: "distance" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "distance" (geometry,geometry) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'distance' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 62 (OID 19434) -- -- Name: "astext" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "astext" (geometry) RETURNS text AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'astext_geometry' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 63 (OID 19435) -- -- Name: "srid" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "srid" (geometry) RETURNS integer AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'srid_geom' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 64 (OID 19436) -- -- Name: "geometryfromtext" (geometry,integer) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometryfromtext" (geometry,integer) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_from_text' LANGUAGE 'C' WITH ( iscachable, isstrict ); -- -- TOC Entry ID 65 (OID 19437) -- -- Name: "setsrid" (geometry,integer) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "setsrid" (geometry,integer) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_from_text' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 66 (OID 19438) -- -- Name: "length_spheroid" (geometry,spheroid) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "length_spheroid" (geometry,spheroid) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'length_ellipsoid' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 67 (OID 19439) -- -- Name: "length3d_spheroid" (geometry,spheroid) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "length3d_spheroid" (geometry,spheroid) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'length3d_ellipsoid' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 68 (OID 19440) -- -- Name: "length3d" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "length3d" (geometry) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'length3d' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 69 (OID 19441) -- -- Name: "length" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "length" (geometry) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'length2d' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 70 (OID 19442) -- -- Name: "area2d" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "area2d" (geometry) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'area2d' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 71 (OID 19443) -- -- Name: "perimeter3d" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "perimeter3d" (geometry) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'perimeter3d' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 72 (OID 19444) -- -- Name: "perimeter" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "perimeter" (geometry) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'perimeter2d' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 73 (OID 19445) -- -- Name: "truly_inside" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "truly_inside" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'truly_inside' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 74 (OID 19446) -- -- Name: "point_inside_circle" (geometry,double precision,double precision,double precision) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "point_inside_circle" (geometry,double precision,double precision,double precision) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'point_inside_circle' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 75 (OID 19447) -- -- Name: "startpoint" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "startpoint" (geometry) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'startpoint' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 76 (OID 19448) -- -- Name: "endpoint" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "endpoint" (geometry) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'endpoint' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 77 (OID 19449) -- -- Name: "isclosed" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "isclosed" (geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'isclosed' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 78 (OID 19450) -- -- Name: "centroid" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "centroid" (geometry) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'centroid' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 79 (OID 19451) -- -- Name: "combine_bbox" (box3d,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "combine_bbox" (box3d,geometry) RETURNS box3d AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'combine_bbox' LANGUAGE 'C'; -- -- TOC Entry ID 105 (OID 19452) -- -- Name: extent(geometry) Type: AGGREGATE Owner: postgres -- CREATE AGGREGATE extent ( BASETYPE = geometry, SFUNC = combine_bbox, STYPE = box3d, INITCOND = '' ); -- -- TOC Entry ID 80 (OID 19453) -- -- Name: "geometry_overleft" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_overleft" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_overleft' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 81 (OID 19454) -- -- Name: "geometry_overright" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_overright" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_overright' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 82 (OID 19455) -- -- Name: "geometry_left" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_left" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_left' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 83 (OID 19456) -- -- Name: "geometry_right" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_right" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_right' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 84 (OID 19457) -- -- Name: "geometry_contain" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_contain" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_contain' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 85 (OID 19458) -- -- Name: "geometry_contained" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_contained" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_contained' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 86 (OID 19459) -- -- Name: "geometry_overlap" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_overlap" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_overlap' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 87 (OID 19460) -- -- Name: "geometry_same" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_same" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_same' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 88 (OID 19461) -- -- Name: "geometry_lt" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_lt" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_lt' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 89 (OID 19462) -- -- Name: "geometry_gt" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_gt" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_gt' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 90 (OID 19463) -- -- Name: "geometry_eq" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_eq" (geometry,geometry) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_eq' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 91 (OID 19464) -- -- Name: "force_2d" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "force_2d" (geometry) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'force_2d' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 92 (OID 19465) -- -- Name: "force_3d" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "force_3d" (geometry) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'force_3d' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 93 (OID 19466) -- -- Name: "force_collection" (geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "force_collection" (geometry) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'force_collection' LANGUAGE 'C' WITH ( isstrict ); -- -- TOC Entry ID 94 (OID 19467) -- -- Name: "ggeometry_consistent" (opaque,geometry,integer) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "ggeometry_consistent" (opaque,geometry,integer) RETURNS boolean AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'ggeometry_consistent' LANGUAGE 'C'; -- -- TOC Entry ID 95 (OID 19468) -- -- Name: "ggeometry_compress" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "ggeometry_compress" (opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'ggeometry_compress' LANGUAGE 'C'; -- -- TOC Entry ID 96 (OID 19469) -- -- Name: "ggeometry_penalty" (opaque,opaque,opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "ggeometry_penalty" (opaque,opaque,opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'ggeometry_penalty' LANGUAGE 'C'; -- -- TOC Entry ID 97 (OID 19470) -- -- Name: "ggeometry_picksplit" (opaque,opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "ggeometry_picksplit" (opaque,opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'ggeometry_picksplit' LANGUAGE 'C'; -- -- TOC Entry ID 98 (OID 19471) -- -- Name: "ggeometry_union" (bytea,opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "ggeometry_union" (bytea,opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'ggeometry_union' LANGUAGE 'C'; -- -- TOC Entry ID 99 (OID 19472) -- -- Name: "ggeometry_same" (opaque,opaque,opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "ggeometry_same" (opaque,opaque,opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'ggeometry_same' LANGUAGE 'C'; -- -- TOC Entry ID 100 (OID 19473) -- -- Name: "rtree_decompress" (opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "rtree_decompress" (opaque) RETURNS opaque AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'rtree_decompress' LANGUAGE 'C'; -- -- TOC Entry ID 101 (OID 19474) -- -- Name: "postgis_gist_sel" (oid,oid,smallint,opaque,integer) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "postgis_gist_sel" (oid,oid,smallint,opaque,integer) RETURNS double precision AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'postgis_gist_sel' LANGUAGE 'C'; -- -- TOC Entry ID 102 (OID 19475) -- -- Name: "geometry_union" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_union" (geometry,geometry) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_union' LANGUAGE 'C'; -- -- TOC Entry ID 103 (OID 19476) -- -- Name: "geometry_inter" (geometry,geometry) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_inter" (geometry,geometry) RETURNS geometry AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_inter' LANGUAGE 'C'; -- -- TOC Entry ID 104 (OID 19477) -- -- Name: "geometry_size" (geometry,opaque) Type: FUNCTION Owner: postgres -- CREATE FUNCTION "geometry_size" (geometry,opaque) RETURNS real AS '/usr/local/pgsql/lib/contrib/libpostgis.so.0.6', 'geometry_size' LANGUAGE 'C'; -- -- TOC Entry ID 110 (OID 19478) -- -- Name: >> Type: OPERATOR Owner: postgres -- CREATE OPERATOR >> (PROCEDURE = geometry_right , LEFTARG = geometry , RIGHTARG = geometry , COMMUTATOR = << , RESTRICT = positionsel , JOIN = positionjoinsel ); -- -- TOC Entry ID 106 (OID 19479) -- -- Name: << Type: OPERATOR Owner: postgres -- CREATE OPERATOR << (PROCEDURE = geometry_left , LEFTARG = geometry , RIGHTARG = geometry , COMMUTATOR = >> , RESTRICT = positionsel , JOIN = positionjoinsel ); -- -- TOC Entry ID 109 (OID 19480) -- -- Name: &> Type: OPERATOR Owner: postgres -- CREATE OPERATOR &> (PROCEDURE = geometry_overright , LEFTARG = geometry , RIGHTARG = geometry , COMMUTATOR = &< , RESTRICT = positionsel , JOIN = positionjoinsel ); -- -- TOC Entry ID 107 (OID 19481) -- -- Name: &< Type: OPERATOR Owner: postgres -- CREATE OPERATOR &< (PROCEDURE = geometry_overleft , LEFTARG = geometry , RIGHTARG = geometry , COMMUTATOR = &> , RESTRICT = positionsel , JOIN = positionjoinsel ); -- -- TOC Entry ID 108 (OID 19482) -- -- Name: && Type: OPERATOR Owner: postgres -- CREATE OPERATOR && (PROCEDURE = geometry_overlap , LEFTARG = geometry , RIGHTARG = geometry , COMMUTATOR = && , RESTRICT = postgis_gist_sel , JOIN = positionjoinsel ); -- -- TOC Entry ID 114 (OID 19483) -- -- Name: = Type: OPERATOR Owner: postgres -- CREATE OPERATOR = (PROCEDURE = geometry_eq , LEFTARG = geometry , RIGHTARG = geometry , COMMUTATOR = = , RESTRICT = contsel , JOIN = contjoinsel ); -- -- TOC Entry ID 111 (OID 19484) -- -- Name: ~= Type: OPERATOR Owner: postgres -- CREATE OPERATOR ~= (PROCEDURE = geometry_same , LEFTARG = geometry , RIGHTARG = geometry , COMMUTATOR = = , RESTRICT = eqsel , JOIN = eqjoinsel ); -- -- TOC Entry ID 112 (OID 19485) -- -- Name: @ Type: OPERATOR Owner: postgres -- CREATE OPERATOR @ (PROCEDURE = geometry_contain , LEFTARG = geometry , RIGHTARG = geometry , COMMUTATOR = @ , RESTRICT = contsel , JOIN = contjoinsel ); -- -- TOC Entry ID 113 (OID 19486) -- -- Name: ~ Type: OPERATOR Owner: postgres -- CREATE OPERATOR ~ (PROCEDURE = geometry_contained , LEFTARG = geometry , RIGHTARG = geometry , COMMUTATOR = @ , RESTRICT = contsel , JOIN = contjoinsel ); -- -- TOC Entry ID 115 (OID 19487) -- -- Name: < Type: OPERATOR Owner: postgres -- CREATE OPERATOR < (PROCEDURE = geometry_lt , LEFTARG = geometry , RIGHTARG = geometry , COMMUTATOR = < , RESTRICT = contsel , JOIN = contjoinsel ); -- -- TOC Entry ID 116 (OID 19488) -- -- Name: > Type: OPERATOR Owner: postgres -- CREATE OPERATOR > (PROCEDURE = geometry_gt , LEFTARG = geometry , RIGHTARG = geometry , COMMUTATOR = > , RESTRICT = contsel , JOIN = contjoinsel ); -- -- TOC Entry ID 19 (OID 19527) -- -- Name: streets Type: TABLE Owner: postgres -- CREATE TABLE "streets" ( "gid" integer, "link_id" integer, "st_name" character varying, "st_langcd" character varying, "num_stnmes" integer, "st_nm_pref" character varying, "st_nm_base" character varying, "st_typ_bef" character varying, "st_nm_suff" character varying, "st_typ_aft" character varying, "st_typ_att" character varying, "addr_type" character varying, "l_refaddr" character varying, "l_nrefaddr" character varying, "l_addrsch" character varying, "l_addrform" character varying, "r_refaddr" character varying, "r_nrefaddr" character varying, "r_addrsch" character varying, "r_addrform" character varying, "ref_in_id" integer, "nref_in_id" integer, "n_shapepnt" integer, "func_class" character varying, "speed_cat" character varying, "lane_cat" character varying, "divider" character varying, "dir_travel" character varying, "l_area_id" integer, "r_area_id" integer, "l_postcode" character varying, "r_postcode" character varying, "l_numzones" integer, "r_numzones" integer, "num_ad_rng" integer, "ar_auto" character varying, "ar_bus" character varying, "ar_taxis" character varying, "ar_carpool" character varying, "ar_pedest" character varying, "ar_trucks" character varying, "ar_traff" character varying, "ar_deliv" character varying, "ar_emerveh" character varying, "paved" character varying, "private" character varying, "frontage" character varying, "bridge" character varying, "tunnel" character varying, "ramp" character varying, "tollway" character varying, "poiaccess" character varying, "contracc" character varying, "roundabout" character varying, "interinter" character varying, "undeftraff" character varying, "ferry_type" character varying, "multidigit" character varying, "maxattr" character varying, "spectrfig" character varying, "indescrib" character varying, "manoeuvre" character varying, "dividerleg" character varying, "inprocdata" character varying, "urban" character varying, "route_type" character varying, "dironsign" character varying, "explicatbl" character varying, "nameonrdsn" character varying, "postalname" character varying, "stalename" character varying, "vanityname" character varying, "junctionnm" character varying, "exitname" character varying, "the_geom" geometry, CHECK ((srid(the_geom) = -1)), CHECK (((geometrytype(the_geom) = 'MULTILINESTRING'::text) OR (the_geom ISNULL))) ); -- -- TOC Entry ID 20 (OID 19527) -- -- Name: "streets_oid_index" Type: INDEX Owner: postgres -- CREATE INDEX "streets_oid_index" on "streets" using btree ( "oid" "oid_ops" ); -- -- TOC Entry ID 21 (OID 19527) -- -- Name: "streets_index" Type: INDEX Owner: postgres -- CREATE INDEX "streets_index" on "streets" using btree ( "st_nm_base" "varchar_ops", "l_area_id" "int4_ops" ); -- -- TOC Entry ID 22 (OID 19527) -- -- Name: "gist_index" Type: INDEX Owner: postgres -- CREATE INDEX "gist_index" on "streets" using gist ( "the_geom" "gist_geometry_ops" );