projects / busui.git / blobdiff
search:
summary | shortlog | log | commit | commitdiff | tree
unified | plain
Geocoding credits
[busui.git] / aws / transitdata.sql
blob:a/aws/transitdata.sql -> blob:b/aws/transitdata.sql
  --
  -- 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;</