--- a/aws/transitdata.sql +++ b/aws/transitdata.sql @@ -4,7 +4,7 @@ -- Dumped from database version 9.0.4 -- Dumped by pg_dump version 9.0.4 --- Started on 2011-10-07 22:30:10 +-- Started on 2011-10-10 16:28:13 SET statement_timeout = 0; SET client_encoding = 'UTF8'; @@ -14,7 +14,7 @@ SET escape_string_warning = off; -- --- TOC entry 2772 (class 1262 OID 18349) +-- TOC entry 2766 (class 1262 OID 18349) -- Name: transitdata; Type: DATABASE; Schema: -; Owner: postgres -- @@ -33,7 +33,7 @@ SET escape_string_warning = off; -- --- TOC entry 1170 (class 2612 OID 11574) +-- TOC entry 1167 (class 2612 OID 11574) -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres -- @@ -80,7 +80,7 @@ -- -- TOC entry 1087 (class 1247 OID 18350) --- Dependencies: 15 6 19 +-- Dependencies: 19 6 15 -- Name: box2d; Type: TYPE; Schema: public; Owner: postgres -- @@ -131,7 +131,7 @@ -- -- TOC entry 1090 (class 1247 OID 18354) --- Dependencies: 21 6 20 +-- Dependencies: 20 6 21 -- Name: box3d; Type: TYPE; Schema: public; Owner: postgres -- @@ -323,7 +323,7 @@ -- -- TOC entry 1099 (class 1247 OID 18366) --- Dependencies: 29 30 26 6 27 28 +-- Dependencies: 30 29 26 6 27 28 -- Name: geography; Type: TYPE; Schema: public; Owner: postgres -- @@ -416,7 +416,7 @@ -- -- TOC entry 1102 (class 1247 OID 18373) --- Dependencies: 35 31 32 6 33 34 +-- Dependencies: 6 31 35 34 33 32 -- Name: geometry; Type: TYPE; Schema: public; Owner: postgres -- @@ -437,7 +437,7 @@ -- -- TOC entry 1105 (class 1247 OID 18382) --- Dependencies: 6 2410 +-- Dependencies: 6 2407 -- Name: geometry_dump; Type: TYPE; Schema: public; Owner: postgres -- @@ -485,7 +485,7 @@ -- -- TOC entry 1107 (class 1247 OID 18383) --- Dependencies: 36 6 37 +-- Dependencies: 37 6 36 -- Name: gidx; Type: TYPE; Schema: public; Owner: postgres -- @@ -536,7 +536,7 @@ -- -- TOC entry 1110 (class 1247 OID 18387) --- Dependencies: 39 6 38 +-- Dependencies: 39 38 6 -- Name: pgis_abs; Type: TYPE; Schema: public; Owner: postgres -- @@ -587,7 +587,7 @@ -- -- TOC entry 1113 (class 1247 OID 18391) --- Dependencies: 6 41 40 +-- Dependencies: 41 6 40 -- Name: spheroid; Type: TYPE; Schema: public; Owner: postgres -- @@ -617,7 +617,7 @@ -- -- TOC entry 43 (class 1255 OID 18396) --- Dependencies: 1099 6 +-- Dependencies: 6 1099 -- Name: _st_asgeojson(integer, geography, integer, integer); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -643,7 +643,7 @@ -- -- TOC entry 45 (class 1255 OID 18398) --- Dependencies: 1099 6 +-- Dependencies: 6 1099 -- Name: _st_asgml(integer, geography, integer, integer); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -669,7 +669,7 @@ -- -- TOC entry 47 (class 1255 OID 18400) --- Dependencies: 1099 6 +-- Dependencies: 6 1099 -- Name: _st_askml(integer, geography, integer); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -721,7 +721,7 @@ -- -- TOC entry 51 (class 1255 OID 18404) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 6 1102 -- Name: _st_contains(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -734,7 +734,7 @@ -- -- TOC entry 52 (class 1255 OID 18405) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 6 1102 -- Name: _st_containsproperly(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -747,7 +747,7 @@ -- -- TOC entry 53 (class 1255 OID 18406) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 6 1102 -- Name: _st_coveredby(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -760,7 +760,7 @@ -- -- TOC entry 54 (class 1255 OID 18407) --- Dependencies: 1102 6 1102 +-- Dependencies: 1102 1102 6 -- Name: _st_covers(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -773,7 +773,7 @@ -- -- TOC entry 55 (class 1255 OID 18408) --- Dependencies: 1099 6 1099 +-- Dependencies: 1099 1099 6 -- Name: _st_covers(geography, geography); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -825,7 +825,7 @@ -- -- TOC entry 59 (class 1255 OID 18412) --- Dependencies: 1105 1170 6 1102 +-- Dependencies: 1102 6 1167 1105 -- Name: _st_dumppoints(geometry, integer[]); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -956,7 +956,7 @@ -- -- TOC entry 63 (class 1255 OID 18416) --- Dependencies: 1099 6 1099 +-- Dependencies: 6 1099 1099 -- Name: _st_expand(geography, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -995,7 +995,7 @@ -- -- TOC entry 66 (class 1255 OID 18419) --- Dependencies: 1102 6 1102 1102 +-- Dependencies: 1102 1102 1102 6 -- Name: _st_longestline(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1008,20 +1008,20 @@ -- -- TOC entry 67 (class 1255 OID 18420) +-- Dependencies: 6 1102 1102 +-- Name: _st_maxdistance(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION _st_maxdistance(geometry, geometry) RETURNS double precision + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_maxdistance2d_linestring'; + + +ALTER FUNCTION public._st_maxdistance(geometry, geometry) OWNER TO postgres; + +-- +-- TOC entry 68 (class 1255 OID 18421) -- Dependencies: 1102 6 1102 --- Name: _st_maxdistance(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION _st_maxdistance(geometry, geometry) RETURNS double precision - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/postgis-1.5', 'LWGEOM_maxdistance2d_linestring'; - - -ALTER FUNCTION public._st_maxdistance(geometry, geometry) OWNER TO postgres; - --- --- TOC entry 68 (class 1255 OID 18421) --- Dependencies: 6 1102 1102 -- Name: _st_orderingequals(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1034,7 +1034,7 @@ -- -- TOC entry 69 (class 1255 OID 18422) --- Dependencies: 1102 6 1102 +-- Dependencies: 1102 1102 6 -- Name: _st_overlaps(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1060,7 +1060,7 @@ -- -- TOC entry 71 (class 1255 OID 18424) --- Dependencies: 1102 6 1102 +-- Dependencies: 1102 1102 6 -- Name: _st_touches(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1073,7 +1073,7 @@ -- -- TOC entry 72 (class 1255 OID 18425) --- Dependencies: 1102 6 1102 +-- Dependencies: 6 1102 1102 -- Name: _st_within(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1086,7 +1086,7 @@ -- -- TOC entry 73 (class 1255 OID 18426) --- Dependencies: 6 1170 +-- Dependencies: 1167 6 -- Name: addauth(text); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1139,7 +1139,7 @@ -- -- TOC entry 79 (class 1255 OID 18430) --- Dependencies: 6 1170 +-- Dependencies: 1167 6 -- Name: addgeometrycolumn(character varying, character varying, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1159,7 +1159,7 @@ -- -- TOC entry 78 (class 1255 OID 18429) --- Dependencies: 6 1170 +-- Dependencies: 6 1167 -- Name: addgeometrycolumn(character varying, character varying, character varying, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1179,7 +1179,7 @@ -- -- TOC entry 77 (class 1255 OID 18428) --- Dependencies: 6 1170 +-- Dependencies: 6 1167 -- Name: addgeometrycolumn(character varying, character varying, character varying, character varying, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1393,7 +1393,7 @@ -- -- TOC entry 81 (class 1255 OID 18432) --- Dependencies: 1102 6 1102 1102 +-- Dependencies: 1102 1102 1102 6 -- Name: addpoint(geometry, geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1406,7 +1406,7 @@ -- -- TOC entry 83 (class 1255 OID 18434) --- Dependencies: 1102 6 1102 +-- Dependencies: 1102 1102 6 -- Name: affine(geometry, double precision, double precision, double precision, double precision, double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1432,7 +1432,7 @@ -- -- TOC entry 84 (class 1255 OID 18435) --- Dependencies: 6 1102 +-- Dependencies: 1102 6 -- Name: area(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1445,7 +1445,7 @@ -- -- TOC entry 85 (class 1255 OID 18436) --- Dependencies: 6 1102 +-- Dependencies: 1102 6 -- Name: area2d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1458,7 +1458,7 @@ -- -- TOC entry 86 (class 1255 OID 18437) --- Dependencies: 1102 6 +-- Dependencies: 6 1102 -- Name: asbinary(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1497,7 +1497,7 @@ -- -- TOC entry 89 (class 1255 OID 18440) --- Dependencies: 6 1102 +-- Dependencies: 1102 6 -- Name: asewkb(geometry, text); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1523,7 +1523,7 @@ -- -- TOC entry 92 (class 1255 OID 18443) --- Dependencies: 6 1102 +-- Dependencies: 1102 6 -- Name: asgml(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1536,124 +1536,124 @@ -- -- TOC entry 91 (class 1255 OID 18442) +-- Dependencies: 6 1102 +-- Name: asgml(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION asgml(geometry, integer) RETURNS text + LANGUAGE sql IMMUTABLE STRICT + AS $_$SELECT _ST_AsGML(2, $1, $2, 0)$_$; + + +ALTER FUNCTION public.asgml(geometry, integer) OWNER TO postgres; + +-- +-- TOC entry 93 (class 1255 OID 18444) +-- Dependencies: 6 1102 +-- Name: ashexewkb(geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION ashexewkb(geometry) RETURNS text + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_asHEXEWKB'; + + +ALTER FUNCTION public.ashexewkb(geometry) OWNER TO postgres; + +-- +-- TOC entry 94 (class 1255 OID 18445) +-- Dependencies: 6 1102 +-- Name: ashexewkb(geometry, text); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION ashexewkb(geometry, text) RETURNS text + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_asHEXEWKB'; + + +ALTER FUNCTION public.ashexewkb(geometry, text) OWNER TO postgres; + +-- +-- TOC entry 96 (class 1255 OID 18447) +-- Dependencies: 6 1102 +-- Name: askml(geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION askml(geometry) RETURNS text + LANGUAGE sql IMMUTABLE STRICT + AS $_$SELECT _ST_AsKML(2, transform($1,4326), 15)$_$; + + +ALTER FUNCTION public.askml(geometry) OWNER TO postgres; + +-- +-- TOC entry 95 (class 1255 OID 18446) +-- Dependencies: 6 1102 +-- Name: askml(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION askml(geometry, integer) RETURNS text + LANGUAGE sql IMMUTABLE STRICT + AS $_$SELECT _ST_AsKML(2, transform($1,4326), $2)$_$; + + +ALTER FUNCTION public.askml(geometry, integer) OWNER TO postgres; + +-- +-- TOC entry 97 (class 1255 OID 18448) +-- Dependencies: 6 1102 +-- Name: askml(integer, geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION askml(integer, geometry, integer) RETURNS text + LANGUAGE sql IMMUTABLE STRICT + AS $_$SELECT _ST_AsKML($1, transform($2,4326), $3)$_$; + + +ALTER FUNCTION public.askml(integer, geometry, integer) OWNER TO postgres; + +-- +-- TOC entry 100 (class 1255 OID 18451) +-- Dependencies: 6 1102 +-- Name: assvg(geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION assvg(geometry) RETURNS text + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'assvg_geometry'; + + +ALTER FUNCTION public.assvg(geometry) OWNER TO postgres; + +-- +-- TOC entry 99 (class 1255 OID 18450) +-- Dependencies: 6 1102 +-- Name: assvg(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION assvg(geometry, integer) RETURNS text + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'assvg_geometry'; + + +ALTER FUNCTION public.assvg(geometry, integer) OWNER TO postgres; + +-- +-- TOC entry 98 (class 1255 OID 18449) -- Dependencies: 1102 6 --- Name: asgml(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION asgml(geometry, integer) RETURNS text - LANGUAGE sql IMMUTABLE STRICT - AS $_$SELECT _ST_AsGML(2, $1, $2, 0)$_$; - - -ALTER FUNCTION public.asgml(geometry, integer) OWNER TO postgres; - --- --- TOC entry 93 (class 1255 OID 18444) +-- Name: assvg(geometry, integer, integer); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION assvg(geometry, integer, integer) RETURNS text + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'assvg_geometry'; + + +ALTER FUNCTION public.assvg(geometry, integer, integer) OWNER TO postgres; + +-- +-- TOC entry 101 (class 1255 OID 18452) -- Dependencies: 1102 6 --- Name: ashexewkb(geometry); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION ashexewkb(geometry) RETURNS text - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/postgis-1.5', 'LWGEOM_asHEXEWKB'; - - -ALTER FUNCTION public.ashexewkb(geometry) OWNER TO postgres; - --- --- TOC entry 94 (class 1255 OID 18445) --- Dependencies: 6 1102 --- Name: ashexewkb(geometry, text); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION ashexewkb(geometry, text) RETURNS text - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/postgis-1.5', 'LWGEOM_asHEXEWKB'; - - -ALTER FUNCTION public.ashexewkb(geometry, text) OWNER TO postgres; - --- --- TOC entry 96 (class 1255 OID 18447) --- Dependencies: 6 1102 --- Name: askml(geometry); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION askml(geometry) RETURNS text - LANGUAGE sql IMMUTABLE STRICT - AS $_$SELECT _ST_AsKML(2, transform($1,4326), 15)$_$; - - -ALTER FUNCTION public.askml(geometry) OWNER TO postgres; - --- --- TOC entry 95 (class 1255 OID 18446) --- Dependencies: 6 1102 --- Name: askml(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION askml(geometry, integer) RETURNS text - LANGUAGE sql IMMUTABLE STRICT - AS $_$SELECT _ST_AsKML(2, transform($1,4326), $2)$_$; - - -ALTER FUNCTION public.askml(geometry, integer) OWNER TO postgres; - --- --- TOC entry 97 (class 1255 OID 18448) --- Dependencies: 1102 6 --- Name: askml(integer, geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION askml(integer, geometry, integer) RETURNS text - LANGUAGE sql IMMUTABLE STRICT - AS $_$SELECT _ST_AsKML($1, transform($2,4326), $3)$_$; - - -ALTER FUNCTION public.askml(integer, geometry, integer) OWNER TO postgres; - --- --- TOC entry 100 (class 1255 OID 18451) --- Dependencies: 1102 6 --- Name: assvg(geometry); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION assvg(geometry) RETURNS text - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/postgis-1.5', 'assvg_geometry'; - - -ALTER FUNCTION public.assvg(geometry) OWNER TO postgres; - --- --- TOC entry 99 (class 1255 OID 18450) --- Dependencies: 6 1102 --- Name: assvg(geometry, integer); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION assvg(geometry, integer) RETURNS text - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/postgis-1.5', 'assvg_geometry'; - - -ALTER FUNCTION public.assvg(geometry, integer) OWNER TO postgres; - --- --- TOC entry 98 (class 1255 OID 18449) --- Dependencies: 6 1102 --- Name: assvg(geometry, integer, integer); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION assvg(geometry, integer, integer) RETURNS text - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/postgis-1.5', 'assvg_geometry'; - - -ALTER FUNCTION public.assvg(geometry, integer, integer) OWNER TO postgres; - --- --- TOC entry 101 (class 1255 OID 18452) --- Dependencies: 6 1102 -- Name: astext(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1666,7 +1666,7 @@ -- -- TOC entry 102 (class 1255 OID 18453) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 1102 6 -- Name: azimuth(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1679,7 +1679,7 @@ -- -- TOC entry 103 (class 1255 OID 18454) --- Dependencies: 1170 1102 6 +-- Dependencies: 1102 1167 6 -- Name: bdmpolyfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1710,7 +1710,7 @@ -- -- TOC entry 75 (class 1255 OID 18455) --- Dependencies: 1170 1102 6 +-- Dependencies: 6 1102 1167 -- Name: bdpolyfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1746,7 +1746,7 @@ -- -- TOC entry 76 (class 1255 OID 18456) --- Dependencies: 1102 6 1102 +-- Dependencies: 1102 1102 6 -- Name: boundary(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1785,7 +1785,7 @@ -- -- TOC entry 106 (class 1255 OID 18459) --- Dependencies: 1093 1087 6 +-- Dependencies: 6 1093 1087 -- Name: box2d(box3d_extent); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1798,7 +1798,7 @@ -- -- TOC entry 107 (class 1255 OID 18460) --- Dependencies: 1102 1087 6 +-- Dependencies: 1087 6 1102 -- Name: box2d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1824,7 +1824,7 @@ -- -- TOC entry 109 (class 1255 OID 18462) --- Dependencies: 6 1090 1102 +-- Dependencies: 6 1102 1090 -- Name: box3d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1837,7 +1837,7 @@ -- -- TOC entry 110 (class 1255 OID 18463) --- Dependencies: 1087 6 1090 +-- Dependencies: 1087 1090 6 -- Name: box3d(box2d); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1850,7 +1850,7 @@ -- -- TOC entry 111 (class 1255 OID 18464) --- Dependencies: 1090 6 1093 +-- Dependencies: 1093 1090 6 -- Name: box3d_extent(box3d_extent); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1863,7 +1863,7 @@ -- -- TOC entry 112 (class 1255 OID 18465) --- Dependencies: 6 1090 +-- Dependencies: 1090 6 -- Name: box3dtobox(box3d); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1889,7 +1889,7 @@ -- -- TOC entry 114 (class 1255 OID 18467) --- Dependencies: 1102 6 1102 +-- Dependencies: 6 1102 1102 -- Name: buffer(geometry, double precision, integer); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1915,7 +1915,7 @@ -- -- TOC entry 116 (class 1255 OID 18469) --- Dependencies: 6 1102 +-- Dependencies: 1102 6 -- Name: bytea(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -1954,7 +1954,7 @@ -- -- TOC entry 118 (class 1255 OID 18471) --- Dependencies: 1170 6 +-- Dependencies: 1167 6 -- Name: checkauth(text, text, text); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2003,7 +2003,7 @@ -- -- TOC entry 121 (class 1255 OID 18474) --- Dependencies: 1102 1102 6 1102 +-- Dependencies: 6 1102 1102 1102 -- Name: collect(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2016,7 +2016,7 @@ -- -- TOC entry 122 (class 1255 OID 18475) --- Dependencies: 1102 1087 1087 6 +-- Dependencies: 1087 6 1087 1102 -- Name: combine_bbox(box2d, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2029,7 +2029,7 @@ -- -- TOC entry 123 (class 1255 OID 18476) --- Dependencies: 6 1093 1102 1093 +-- Dependencies: 6 1093 1093 1102 -- Name: combine_bbox(box3d_extent, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2042,7 +2042,7 @@ -- -- TOC entry 124 (class 1255 OID 18477) --- Dependencies: 6 1102 1090 1090 +-- Dependencies: 6 1090 1090 1102 -- Name: combine_bbox(box3d, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2055,7 +2055,7 @@ -- -- TOC entry 125 (class 1255 OID 18478) --- Dependencies: 1096 6 +-- Dependencies: 6 1096 -- Name: compression(chip); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2068,7 +2068,7 @@ -- -- TOC entry 126 (class 1255 OID 18479) --- Dependencies: 1102 1102 6 +-- Dependencies: 6 1102 1102 -- Name: contains(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2107,7 +2107,7 @@ -- -- TOC entry 129 (class 1255 OID 18482) --- Dependencies: 6 1096 +-- Dependencies: 1096 6 -- Name: datatype(chip); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2120,7 +2120,7 @@ -- -- TOC entry 130 (class 1255 OID 18483) --- Dependencies: 1102 1102 6 1102 +-- Dependencies: 1102 1102 1102 6 -- Name: difference(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2146,7 +2146,7 @@ -- -- TOC entry 132 (class 1255 OID 18485) --- Dependencies: 1170 6 +-- Dependencies: 1167 6 -- Name: disablelongtransactions(); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2192,7 +2192,7 @@ -- -- TOC entry 133 (class 1255 OID 18486) --- Dependencies: 1102 6 1102 +-- Dependencies: 6 1102 1102 -- Name: disjoint(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2218,7 +2218,7 @@ -- -- TOC entry 135 (class 1255 OID 18488) --- Dependencies: 1102 6 1102 +-- Dependencies: 1102 1102 6 -- Name: distance_sphere(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2231,7 +2231,7 @@ -- -- TOC entry 136 (class 1255 OID 18489) --- Dependencies: 6 1102 1102 1113 +-- Dependencies: 1102 6 1113 1102 -- Name: distance_spheroid(geometry, geometry, spheroid); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2244,7 +2244,7 @@ -- -- TOC entry 137 (class 1255 OID 18490) --- Dependencies: 1102 6 1102 +-- Dependencies: 1102 1102 6 -- Name: dropbbox(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2257,7 +2257,7 @@ -- -- TOC entry 140 (class 1255 OID 18493) --- Dependencies: 6 1170 +-- Dependencies: 1167 6 -- Name: dropgeometrycolumn(character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2277,7 +2277,7 @@ -- -- TOC entry 139 (class 1255 OID 18492) --- Dependencies: 6 1170 +-- Dependencies: 1167 6 -- Name: dropgeometrycolumn(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2297,7 +2297,7 @@ -- -- TOC entry 138 (class 1255 OID 18491) --- Dependencies: 6 1170 +-- Dependencies: 1167 6 -- Name: dropgeometrycolumn(character varying, character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2391,7 +2391,7 @@ -- -- TOC entry 141 (class 1255 OID 18494) --- Dependencies: 1170 6 +-- Dependencies: 6 1167 -- Name: dropgeometrytable(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2435,7 +2435,7 @@ -- -- TOC entry 144 (class 1255 OID 18497) --- Dependencies: 6 1102 1105 +-- Dependencies: 1102 6 1105 -- Name: dump(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2448,7 +2448,7 @@ -- -- TOC entry 145 (class 1255 OID 18498) --- Dependencies: 1105 6 1102 +-- Dependencies: 6 1105 1102 -- Name: dumprings(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2461,7 +2461,7 @@ -- -- TOC entry 146 (class 1255 OID 18499) --- Dependencies: 1170 6 +-- Dependencies: 1167 6 -- Name: enablelongtransactions(); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2522,20 +2522,20 @@ -- -- TOC entry 147 (class 1255 OID 18500) +-- Dependencies: 1102 6 1102 +-- Name: endpoint(geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION endpoint(geometry) RETURNS geometry + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'LWGEOM_endpoint_linestring'; + + +ALTER FUNCTION public.endpoint(geometry) OWNER TO postgres; + +-- +-- TOC entry 148 (class 1255 OID 18501) -- Dependencies: 6 1102 1102 --- Name: endpoint(geometry); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION endpoint(geometry) RETURNS geometry - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/postgis-1.5', 'LWGEOM_endpoint_linestring'; - - -ALTER FUNCTION public.endpoint(geometry) OWNER TO postgres; - --- --- TOC entry 148 (class 1255 OID 18501) --- Dependencies: 1102 6 1102 -- Name: envelope(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2548,7 +2548,7 @@ -- -- TOC entry 149 (class 1255 OID 18502) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 1102 6 -- Name: equals(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2587,7 +2587,7 @@ -- -- TOC entry 152 (class 1255 OID 18505) --- Dependencies: 1090 6 1090 +-- Dependencies: 6 1090 1090 -- Name: expand(box3d, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2600,7 +2600,7 @@ -- -- TOC entry 153 (class 1255 OID 18506) --- Dependencies: 1087 1087 6 +-- Dependencies: 1087 6 1087 -- Name: expand(box2d, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2613,7 +2613,7 @@ -- -- TOC entry 154 (class 1255 OID 18507) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 6 1102 -- Name: expand(geometry, double precision); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2652,7 +2652,7 @@ -- -- TOC entry 158 (class 1255 OID 18511) --- Dependencies: 1087 6 1170 +-- Dependencies: 1087 1167 6 -- Name: find_extent(text, text); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2676,7 +2676,7 @@ -- -- TOC entry 157 (class 1255 OID 18510) --- Dependencies: 6 1170 1087 +-- Dependencies: 1087 1167 6 -- Name: find_extent(text, text, text); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2701,7 +2701,7 @@ -- -- TOC entry 159 (class 1255 OID 18512) --- Dependencies: 1170 6 +-- Dependencies: 6 1167 -- Name: find_srid(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2747,7 +2747,7 @@ -- -- TOC entry 160 (class 1255 OID 18513) --- Dependencies: 1170 6 +-- Dependencies: 6 1167 -- Name: fix_geometry_columns(); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2813,7 +2813,7 @@ -- -- TOC entry 161 (class 1255 OID 18514) --- Dependencies: 1102 1102 6 +-- Dependencies: 1102 6 1102 -- Name: force_2d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2839,7 +2839,7 @@ -- -- TOC entry 163 (class 1255 OID 18516) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 6 1102 -- Name: force_3dm(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2865,7 +2865,7 @@ -- -- TOC entry 165 (class 1255 OID 18518) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 1102 6 -- Name: force_4d(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2878,7 +2878,7 @@ -- -- TOC entry 166 (class 1255 OID 18519) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 6 1102 -- Name: force_collection(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2891,7 +2891,7 @@ -- -- TOC entry 167 (class 1255 OID 18520) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 6 1102 -- Name: forcerhr(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2904,7 +2904,7 @@ -- -- TOC entry 169 (class 1255 OID 18522) --- Dependencies: 6 1099 1102 +-- Dependencies: 6 1102 1099 -- Name: geography(geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2930,7 +2930,7 @@ -- -- TOC entry 170 (class 1255 OID 18523) --- Dependencies: 6 1099 1099 +-- Dependencies: 1099 1099 6 -- Name: geography_cmp(geography, geography); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -2943,7 +2943,7 @@ -- -- TOC entry 171 (class 1255 OID 18524) --- Dependencies: 6 1099 1099 +-- Dependencies: 1099 6 1099 -- Name: geography_eq(geography, geography); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3047,7 +3047,7 @@ -- -- TOC entry 179 (class 1255 OID 18532) --- Dependencies: 6 1087 1087 +-- Dependencies: 1087 6 1087 -- Name: geography_gist_same(box2d, box2d, internal); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3099,7 +3099,7 @@ -- -- TOC entry 183 (class 1255 OID 18536) --- Dependencies: 1099 1099 6 +-- Dependencies: 6 1099 1099 -- Name: geography_le(geography, geography); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3112,7 +3112,7 @@ -- -- TOC entry 184 (class 1255 OID 18537) --- Dependencies: 1099 1099 6 +-- Dependencies: 6 1099 1099 -- Name: geography_lt(geography, geography); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3125,7 +3125,7 @@ -- -- TOC entry 185 (class 1255 OID 18538) --- Dependencies: 1099 1099 6 +-- Dependencies: 6 1099 1099 -- Name: geography_overlaps(geography, geography); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3249,7 +3249,7 @@ -- -- TOC entry 193 (class 1255 OID 18546) --- Dependencies: 6 1093 1102 +-- Dependencies: 6 1102 1093 -- Name: geometry(box3d_extent); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3392,7 +3392,7 @@ -- -- TOC entry 204 (class 1255 OID 18557) --- Dependencies: 1102 1102 6 +-- Dependencies: 6 1102 1102 -- Name: geometry_contained(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3405,7 +3405,7 @@ -- -- TOC entry 205 (class 1255 OID 18558) --- Dependencies: 1102 1102 6 +-- Dependencies: 6 1102 1102 -- Name: geometry_eq(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3457,20 +3457,20 @@ -- -- TOC entry 209 (class 1255 OID 18562) +-- Dependencies: 6 1102 1102 +-- Name: geometry_gt(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres +-- + +CREATE FUNCTION geometry_gt(geometry, geometry) RETURNS boolean + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/postgis-1.5', 'lwgeom_gt'; + + +ALTER FUNCTION public.geometry_gt(geometry, geometry) OWNER TO postgres; + +-- +-- TOC entry 210 (class 1255 OID 18563) -- Dependencies: 1102 6 1102 --- Name: geometry_gt(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION geometry_gt(geometry, geometry) RETURNS boolean - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/postgis-1.5', 'lwgeom_gt'; - - -ALTER FUNCTION public.geometry_gt(geometry, geometry) OWNER TO postgres; - --- --- TOC entry 210 (class 1255 OID 18563) --- Dependencies: 6 1102 1102 -- Name: geometry_le(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3483,7 +3483,7 @@ -- -- TOC entry 211 (class 1255 OID 18564) --- Dependencies: 1102 1102 6 +-- Dependencies: 1102 6 1102 -- Name: geometry_left(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3496,7 +3496,7 @@ -- -- TOC entry 212 (class 1255 OID 18565) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 6 1102 -- Name: geometry_lt(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3522,7 +3522,7 @@ -- -- TOC entry 214 (class 1255 OID 18567) --- Dependencies: 1102 1102 6 +-- Dependencies: 1102 6 1102 -- Name: geometry_overbelow(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3535,7 +3535,7 @@ -- -- TOC entry 215 (class 1255 OID 18568) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 6 1102 -- Name: geometry_overlap(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3574,7 +3574,7 @@ -- -- TOC entry 218 (class 1255 OID 18571) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 6 1102 -- Name: geometry_right(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3600,7 +3600,7 @@ -- -- TOC entry 220 (class 1255 OID 18573) --- Dependencies: 6 1102 1102 +-- Dependencies: 1102 6 1102 -- Name: geometry_samebox(geometry, geometry); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3626,7 +3626,7 @@ -- -- TOC entry 222 (class 1255 OID 18575) --- Dependencies: 6 1102 +-- Dependencies: 1102 6 -- Name: geometryfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres -- @@ -3652,7 +3652,7 @@