--- a/aws/transitdata.sql +++ b/aws/transitdata.sql @@ -1,1 +1,13780 @@ - +-- +-- PostgreSQL database dump +-- + +-- Dumped from database version 9.0.4 +-- Dumped by pg_dump version 9.0.4 +-- Started on 2011-10-07 22:30:10 + +SET statement_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = off; +SET check_function_bodies = false; +SET client_min_messages = warning; +SET escape_string_warning = off; + +-- +-- TOC entry 2772 (class 1262 OID 18349) +-- Name: transitdata; Type: DATABASE; Schema: -; Owner: postgres +-- + +CREATE DATABASE transitdata WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'English_Australia.1252' LC_CTYPE = 'English_Australia.1252'; + + +ALTER DATABASE transitdata OWNER TO postgres; + +\connect transitdata + +SET statement_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = off; +SET check_function_bodies = false; +SET client_min_messages = warning; +SET escape_string_warning = off; + +-- +-- TOC entry 1170 (class 2612 OID 11574) +-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres +-- + +CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql; + + +ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres; + +SET search_path = public, pg_catalog; + +-- +-- TOC entry 1088 (class 0 OID 0) +-- Name: box2d; Type: SHELL TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE box2d; + + +-- +-- TOC entry 15 (class 1255 OID 18351) +-- Dependencies: 6 1088 +-- Name: box2d_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION box2d_in(cstring) RETURNS box2d + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'BOX2DFLOAT4_in'; + + +ALTER FUNCTION public.box2d_in(cstring) OWNER TO postgres; + +-- +-- TOC entry 19 (class 1255 OID 18352) +-- Dependencies: 6 1088 +-- Name: box2d_out(box2d); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION box2d_out(box2d) RETURNS cstring + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'BOX2DFLOAT4_out'; + + +ALTER FUNCTION public.box2d_out(box2d) OWNER TO postgres; + +-- +-- TOC entry 1087 (class 1247 OID 18350) +-- Dependencies: 15 6 19 +-- 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; + +-- +-- TOC entry 1091 (class 0 OID 0) +-- Name: box3d; Type: SHELL TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE box3d; + + +-- +-- TOC entry 20 (class 1255 OID 18355) +-- Dependencies: 6 1091 +-- Name: box3d_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION box3d_in(cstring) RETURNS box3d + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'BOX3D_in'; + + +ALTER FUNCTION public.box3d_in(cstring) OWNER TO postgres; + +-- +-- TOC entry 21 (class 1255 OID 18356) +-- Dependencies: 6 1091 +-- Name: box3d_out(box3d); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION box3d_out(box3d) RETURNS cstring + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'BOX3D_out'; + + +ALTER FUNCTION public.box3d_out(box3d) OWNER TO postgres; + +-- +-- TOC entry 1090 (class 1247 OID 18354) +-- Dependencies: 21 6 20 +-- 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; + +-- +-- TOC entry 1094 (class 0 OID 0) +-- Name: box3d_extent; Type: SHELL TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE box3d_extent; + + +-- +-- TOC entry 22 (class 1255 OID 18359) +-- Dependencies: 6 1094 +-- Name: box3d_extent_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION box3d_extent_in(cstring) RETURNS box3d_extent + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'BOX3D_in'; + + +ALTER FUNCTION public.box3d_extent_in(cstring) OWNER TO postgres; + +-- +-- TOC entry 23 (class 1255 OID 18360) +-- Dependencies: 6 1094 +-- Name: box3d_extent_out(box3d_extent); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION box3d_extent_out(box3d_extent) RETURNS cstring + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'BOX3D_extent_out'; + + +ALTER FUNCTION public.box3d_extent_out(box3d_extent) OWNER TO postgres; + +-- +-- TOC entry 1093 (class 1247 OID 18358) +-- Dependencies: 6 22 23 +-- Name: box3d_extent; Type: TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE box3d_extent ( + INTERNALLENGTH = 48, + INPUT = box3d_extent_in, + OUTPUT = box3d_extent_out, + ALIGNMENT = double, + STORAGE = plain +); + + +ALTER TYPE public.box3d_extent OWNER TO postgres; + +-- +-- TOC entry 1097 (class 0 OID 0) +-- Name: chip; Type: SHELL TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE chip; + + +-- +-- TOC entry 24 (class 1255 OID 18363) +-- Dependencies: 6 1097 +-- Name: chip_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION chip_in(cstring) RETURNS chip + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'CHIP_in'; + + +ALTER FUNCTION public.chip_in(cstring) OWNER TO postgres; + +-- +-- TOC entry 25 (class 1255 OID 18364) +-- Dependencies: 6 1097 +-- Name: chip_out(chip); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION chip_out(chip) RETURNS cstring + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'CHIP_out'; + + +ALTER FUNCTION public.chip_out(chip) OWNER TO postgres; + +-- +-- TOC entry 1096 (class 1247 OID 18362) +-- Dependencies: 6 25 24 +-- 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; + +-- +-- TOC entry 1100 (class 0 OID 0) +-- Name: geography; Type: SHELL TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE geography; + + +-- +-- TOC entry 26 (class 1255 OID 18367) +-- Dependencies: 6 +-- Name: geography_analyze(internal); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION geography_analyze(internal) RETURNS boolean + LANGUAGE c STRICT + AS '$libdir/postgis-1.5', 'geography_analyze'; + + +ALTER FUNCTION public.geography_analyze(internal) OWNER TO postgres; + +-- +-- TOC entry 27 (class 1255 OID 18368) +-- Dependencies: 6 1100 +-- Name: geography_in(cstring, oid, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION geography_in(cstring, oid, integer) RETURNS geography + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'geography_in'; + + +ALTER FUNCTION public.geography_in(cstring, oid, integer) OWNER TO postgres; + +-- +-- TOC entry 28 (class 1255 OID 18369) +-- Dependencies: 6 1100 +-- Name: geography_out(geography); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION geography_out(geography) RETURNS cstring + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'geography_out'; + + +ALTER FUNCTION public.geography_out(geography) OWNER TO postgres; + +-- +-- TOC entry 29 (class 1255 OID 18370) +-- Dependencies: 6 +-- Name: geography_typmod_in(cstring[]); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION geography_typmod_in(cstring[]) RETURNS integer + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'geography_typmod_in'; + + +ALTER FUNCTION public.geography_typmod_in(cstring[]) OWNER TO postgres; + +-- +-- TOC entry 30 (class 1255 OID 18371) +-- Dependencies: 6 +-- Name: geography_typmod_out(integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION geography_typmod_out(integer) RETURNS cstring + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'geography_typmod_out'; + + +ALTER FUNCTION public.geography_typmod_out(integer) OWNER TO postgres; + +-- +-- TOC entry 1099 (class 1247 OID 18366) +-- Dependencies: 29 30 26 6 27 28 +-- Name: geography; Type: TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE geography ( + INTERNALLENGTH = variable, + INPUT = geography_in, + OUTPUT = geography_out, + TYPMOD_IN = geography_typmod_in, + TYPMOD_OUT = geography_typmod_out, + ANALYZE = geography_analyze, + ALIGNMENT = double, + STORAGE = main +); + + +ALTER TYPE public.geography OWNER TO postgres; + +-- +-- TOC entry 1103 (class 0 OID 0) +-- Name: geometry; Type: SHELL TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE geometry; + + +-- +-- TOC entry 31 (class 1255 OID 18374) +-- Dependencies: 6 +-- Name: geometry_analyze(internal); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION geometry_analyze(internal) RETURNS boolean + LANGUAGE c STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_analyze'; + + +ALTER FUNCTION public.geometry_analyze(internal) OWNER TO postgres; + +-- +-- TOC entry 32 (class 1255 OID 18375) +-- Dependencies: 6 1103 +-- Name: geometry_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION geometry_in(cstring) RETURNS geometry + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_in'; + + +ALTER FUNCTION public.geometry_in(cstring) OWNER TO postgres; + +-- +-- TOC entry 33 (class 1255 OID 18376) +-- Dependencies: 6 1103 +-- Name: geometry_out(geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION geometry_out(geometry) RETURNS cstring + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_out'; + + +ALTER FUNCTION public.geometry_out(geometry) OWNER TO postgres; + +-- +-- TOC entry 34 (class 1255 OID 18377) +-- Dependencies: 6 1103 +-- Name: geometry_recv(internal); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION geometry_recv(internal) RETURNS geometry + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_recv'; + + +ALTER FUNCTION public.geometry_recv(internal) OWNER TO postgres; + +-- +-- TOC entry 35 (class 1255 OID 18378) +-- Dependencies: 6 1103 +-- Name: geometry_send(geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION geometry_send(geometry) RETURNS bytea + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_send'; + + +ALTER FUNCTION public.geometry_send(geometry) OWNER TO postgres; + +-- +-- TOC entry 1102 (class 1247 OID 18373) +-- Dependencies: 35 31 32 6 33 34 +-- 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; + +-- +-- TOC entry 1105 (class 1247 OID 18382) +-- Dependencies: 6 2410 +-- 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; + +-- +-- TOC entry 1108 (class 0 OID 0) +-- Name: gidx; Type: SHELL TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE gidx; + + +-- +-- TOC entry 36 (class 1255 OID 18384) +-- Dependencies: 6 1108 +-- Name: gidx_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION gidx_in(cstring) RETURNS gidx + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'gidx_in'; + + +ALTER FUNCTION public.gidx_in(cstring) OWNER TO postgres; + +-- +-- TOC entry 37 (class 1255 OID 18385) +-- Dependencies: 6 1108 +-- Name: gidx_out(gidx); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION gidx_out(gidx) RETURNS cstring + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'gidx_out'; + + +ALTER FUNCTION public.gidx_out(gidx) OWNER TO postgres; + +-- +-- TOC entry 1107 (class 1247 OID 18383) +-- Dependencies: 36 6 37 +-- Name: gidx; Type: TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE gidx ( + INTERNALLENGTH = variable, + INPUT = gidx_in, + OUTPUT = gidx_out, + ALIGNMENT = double, + STORAGE = plain +); + + +ALTER TYPE public.gidx OWNER TO postgres; + +-- +-- TOC entry 1111 (class 0 OID 0) +-- Name: pgis_abs; Type: SHELL TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE pgis_abs; + + +-- +-- TOC entry 38 (class 1255 OID 18388) +-- Dependencies: 6 1111 +-- Name: pgis_abs_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION pgis_abs_in(cstring) RETURNS pgis_abs + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'pgis_abs_in'; + + +ALTER FUNCTION public.pgis_abs_in(cstring) OWNER TO postgres; + +-- +-- TOC entry 39 (class 1255 OID 18389) +-- Dependencies: 6 1111 +-- Name: pgis_abs_out(pgis_abs); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION pgis_abs_out(pgis_abs) RETURNS cstring + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'pgis_abs_out'; + + +ALTER FUNCTION public.pgis_abs_out(pgis_abs) OWNER TO postgres; + +-- +-- TOC entry 1110 (class 1247 OID 18387) +-- Dependencies: 39 6 38 +-- Name: pgis_abs; Type: TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE pgis_abs ( + INTERNALLENGTH = 8, + INPUT = pgis_abs_in, + OUTPUT = pgis_abs_out, + ALIGNMENT = double, + STORAGE = plain +); + + +ALTER TYPE public.pgis_abs OWNER TO postgres; + +-- +-- TOC entry 1114 (class 0 OID 0) +-- Name: spheroid; Type: SHELL TYPE; Schema: public; Owner: postgres +-- + +CREATE TYPE spheroid; + + +-- +-- TOC entry 40 (class 1255 OID 18392) +-- Dependencies: 6 1114 +-- Name: spheroid_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION spheroid_in(cstring) RETURNS spheroid + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'ellipsoid_in'; + + +ALTER FUNCTION public.spheroid_in(cstring) OWNER TO postgres; + +-- +-- TOC entry 41 (class 1255 OID 18393) +-- Dependencies: 6 1114 +-- Name: spheroid_out(spheroid); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION spheroid_out(spheroid) RETURNS cstring + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'ellipsoid_out'; + + +ALTER FUNCTION public.spheroid_out(spheroid) OWNER TO postgres; + +-- +-- TOC entry 1113 (class 1247 OID 18391) +-- Dependencies: 6 41 40 +-- 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; + +-- +-- TOC entry 42 (class 1255 OID 18395) +-- Dependencies: 6 1102 +-- Name: _st_asgeojson(integer, geometry, integer, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_asgeojson(integer, geometry, integer, integer) RETURNS text + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_asGeoJson'; + + +ALTER FUNCTION public._st_asgeojson(integer, geometry, integer, integer) OWNER TO postgres; + +-- +-- TOC entry 43 (class 1255 OID 18396) +-- Dependencies: 1099 6 +-- Name: _st_asgeojson(integer, geography, integer, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_asgeojson(integer, geography, integer, integer) RETURNS text + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'geography_as_geojson'; + + +ALTER FUNCTION public._st_asgeojson(integer, geography, integer, integer) OWNER TO postgres; + +-- +-- TOC entry 44 (class 1255 OID 18397) +-- Dependencies: 1102 6 +-- Name: _st_asgml(integer, geometry, integer, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_asgml(integer, geometry, integer, integer) RETURNS text + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_asGML'; + + +ALTER FUNCTION public._st_asgml(integer, geometry, integer, integer) OWNER TO postgres; + +-- +-- TOC entry 45 (class 1255 OID 18398) +-- Dependencies: 1099 6 +-- Name: _st_asgml(integer, geography, integer, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_asgml(integer, geography, integer, integer) RETURNS text + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'geography_as_gml'; + + +ALTER FUNCTION public._st_asgml(integer, geography, integer, integer) OWNER TO postgres; + +-- +-- TOC entry 46 (class 1255 OID 18399) +-- Dependencies: 6 1102 +-- Name: _st_askml(integer, geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_askml(integer, geometry, integer) RETURNS text + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_asKML'; + + +ALTER FUNCTION public._st_askml(integer, geometry, integer) OWNER TO postgres; + +-- +-- TOC entry 47 (class 1255 OID 18400) +-- Dependencies: 1099 6 +-- Name: _st_askml(integer, geography, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_askml(integer, geography, integer) RETURNS text + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'geography_as_kml'; + + +ALTER FUNCTION public._st_askml(integer, geography, integer) OWNER TO postgres; + +-- +-- TOC entry 49 (class 1255 OID 18402) +-- Dependencies: 6 1099 +-- Name: _st_bestsrid(geography); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_bestsrid(geography) RETURNS integer + LANGUAGE sql IMMUTABLE STRICT + AS $_$SELECT _ST_BestSRID($1,$1)$_$; + + +ALTER FUNCTION public._st_bestsrid(geography) OWNER TO postgres; + +-- +-- TOC entry 48 (class 1255 OID 18401) +-- Dependencies: 1099 6 1099 +-- Name: _st_bestsrid(geography, geography); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_bestsrid(geography, geography) RETURNS integer + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'geography_bestsrid'; + + +ALTER FUNCTION public._st_bestsrid(geography, geography) OWNER TO postgres; + +-- +-- TOC entry 50 (class 1255 OID 18403) +-- Dependencies: 1102 6 1102 +-- Name: _st_buffer(geometry, double precision, cstring); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_buffer(geometry, double precision, cstring) RETURNS geometry + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'buffer'; + + +ALTER FUNCTION public._st_buffer(geometry, double precision, cstring) OWNER TO postgres; + +-- +-- TOC entry 51 (class 1255 OID 18404) +-- Dependencies: 6 1102 1102 +-- Name: _st_contains(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_contains(geometry, geometry) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'contains'; + + +ALTER FUNCTION public._st_contains(geometry, geometry) OWNER TO postgres; + +-- +-- TOC entry 52 (class 1255 OID 18405) +-- Dependencies: 6 1102 1102 +-- Name: _st_containsproperly(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_containsproperly(geometry, geometry) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'containsproperly'; + + +ALTER FUNCTION public._st_containsproperly(geometry, geometry) OWNER TO postgres; + +-- +-- TOC entry 53 (class 1255 OID 18406) +-- Dependencies: 6 1102 1102 +-- Name: _st_coveredby(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_coveredby(geometry, geometry) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'coveredby'; + + +ALTER FUNCTION public._st_coveredby(geometry, geometry) OWNER TO postgres; + +-- +-- TOC entry 54 (class 1255 OID 18407) +-- Dependencies: 1102 6 1102 +-- Name: _st_covers(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_covers(geometry, geometry) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'covers'; + + +ALTER FUNCTION public._st_covers(geometry, geometry) OWNER TO postgres; + +-- +-- TOC entry 55 (class 1255 OID 18408) +-- Dependencies: 1099 6 1099 +-- Name: _st_covers(geography, geography); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_covers(geography, geography) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'geography_covers'; + + +ALTER FUNCTION public._st_covers(geography, geography) OWNER TO postgres; + +-- +-- TOC entry 56 (class 1255 OID 18409) +-- Dependencies: 1102 6 1102 +-- Name: _st_crosses(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_crosses(geometry, geometry) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'crosses'; + + +ALTER FUNCTION public._st_crosses(geometry, geometry) OWNER TO postgres; + +-- +-- TOC entry 57 (class 1255 OID 18410) +-- Dependencies: 1102 6 1102 +-- Name: _st_dfullywithin(geometry, geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_dfullywithin(geometry, geometry, double precision) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_dfullywithin'; + + +ALTER FUNCTION public._st_dfullywithin(geometry, geometry, double precision) OWNER TO postgres; + +-- +-- TOC entry 58 (class 1255 OID 18411) +-- Dependencies: 1099 1099 6 +-- Name: _st_distance(geography, geography, double precision, boolean); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_distance(geography, geography, double precision, boolean) RETURNS double precision + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'geography_distance'; + + +ALTER FUNCTION public._st_distance(geography, geography, double precision, boolean) OWNER TO postgres; + +-- +-- TOC entry 59 (class 1255 OID 18412) +-- Dependencies: 1105 1170 6 1102 +-- Name: _st_dumppoints(geometry, integer[]); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_dumppoints(the_geom geometry, cur_path integer[]) RETURNS SETOF geometry_dump + LANGUAGE plpgsql + AS $$ +DECLARE + tmp geometry_dump; + tmp2 geometry_dump; + nb_points integer; + nb_geom integer; + i integer; + j integer; + g geometry; + +BEGIN + + RAISE DEBUG '%,%', cur_path, ST_GeometryType(the_geom); + + -- Special case (MULTI* OR GEOMETRYCOLLECTION) : iterate and return the DumpPoints of the geometries + SELECT ST_NumGeometries(the_geom) INTO nb_geom; + + IF (nb_geom IS NOT NULL) THEN + + i = 1; + FOR tmp2 IN SELECT (ST_Dump(the_geom)).* LOOP + + FOR tmp IN SELECT * FROM _ST_DumpPoints(tmp2.geom, cur_path || tmp2.path) LOOP + RETURN NEXT tmp; + END LOOP; + i = i + 1; + + END LOOP; + + RETURN; + END IF; + + + -- Special case (POLYGON) : return the points of the rings of a polygon + IF (ST_GeometryType(the_geom) = 'ST_Polygon') THEN + + FOR tmp IN SELECT * FROM _ST_DumpPoints(ST_ExteriorRing(the_geom), cur_path || ARRAY[1]) LOOP + RETURN NEXT tmp; + END LOOP; + + j := ST_NumInteriorRings(the_geom); + FOR i IN 1..j LOOP + FOR tmp IN SELECT * FROM _ST_DumpPoints(ST_InteriorRingN(the_geom, i), cur_path || ARRAY[i+1]) LOOP + RETURN NEXT tmp; + END LOOP; + END LOOP; + + RETURN; + END IF; + + + -- Special case (POINT) : return the point + IF (ST_GeometryType(the_geom) = 'ST_Point') THEN + + tmp.path = cur_path || ARRAY[1]; + tmp.geom = the_geom; + + RETURN NEXT tmp; + RETURN; + + END IF; + + + -- Use ST_NumPoints rather than ST_NPoints to have a NULL value if the_geom isn't + -- a LINESTRING or CIRCULARSTRING. + SELECT ST_NumPoints(the_geom) INTO nb_points; + + -- This should never happen + IF (nb_points IS NULL) THEN + RAISE EXCEPTION 'Unexpected error while dumping geometry %', ST_AsText(the_geom); + END IF; + + FOR i IN 1..nb_points LOOP + tmp.path = cur_path || ARRAY[i]; + tmp.geom := ST_PointN(the_geom, i); + RETURN NEXT tmp; + END LOOP; + +END +$$; + + +ALTER FUNCTION public._st_dumppoints(the_geom geometry, cur_path integer[]) OWNER TO postgres; + +-- +-- TOC entry 60 (class 1255 OID 18413) +-- Dependencies: 1102 6 1102 +-- Name: _st_dwithin(geometry, geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_dwithin(geometry, geometry, double precision) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'LWGEOM_dwithin'; + + +ALTER FUNCTION public._st_dwithin(geometry, geometry, double precision) OWNER TO postgres; + +-- +-- TOC entry 61 (class 1255 OID 18414) +-- Dependencies: 1099 6 1099 +-- Name: _st_dwithin(geography, geography, double precision, boolean); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_dwithin(geography, geography, double precision, boolean) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'geography_dwithin'; + + +ALTER FUNCTION public._st_dwithin(geography, geography, double precision, boolean) OWNER TO postgres; + +-- +-- TOC entry 62 (class 1255 OID 18415) +-- Dependencies: 1102 6 1102 +-- Name: _st_equals(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_equals(geometry, geometry) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'geomequals'; + + +ALTER FUNCTION public._st_equals(geometry, geometry) OWNER TO postgres; + +-- +-- TOC entry 63 (class 1255 OID 18416) +-- Dependencies: 1099 6 1099 +-- Name: _st_expand(geography, double precision); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_expand(geography, double precision) RETURNS geography + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'geography_expand'; + + +ALTER FUNCTION public._st_expand(geography, double precision) OWNER TO postgres; + +-- +-- TOC entry 64 (class 1255 OID 18417) +-- Dependencies: 1102 6 1102 +-- Name: _st_intersects(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_intersects(geometry, geometry) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'intersects'; + + +ALTER FUNCTION public._st_intersects(geometry, geometry) OWNER TO postgres; + +-- +-- TOC entry 65 (class 1255 OID 18418) +-- Dependencies: 1102 6 1102 +-- Name: _st_linecrossingdirection(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_linecrossingdirection(geometry, geometry) RETURNS integer + LANGUAGE c IMMUTABLE STRICT COST 100 + AS '$libdir/postgis-1.5', 'ST_LineCrossingDirection'; + + +ALTER FUNCTION public._st_linecrossingdirection(geometry, geometry) OWNER TO postgres; + +-- +-- TOC entry 66 (class 1255 OID 18419) +-- Dependencies: 1102 6 1102 1102 +-- Name: _st_longestline(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_longestline(geometry, geometry) RETURNS geometry + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_longestline2d'; + + +ALTER FUNCTION public._st_longestline(geometry, geometry) OWNER TO postgres; + +-- +-- TOC entry 67 (class 1255 OID 18420) +-- Dependencies: 110