gitphp 0.2.9.1 :: busui.git/blobdiff

--

-- PostgreSQL database dump

--

SET statement_timeout = 0;

SET client_encoding = 'UTF8';

SET standard_conforming_strings = on;

SET check_function_bodies = false;

SET client_min_messages = warning;

--

-- Name: topology; Type: SCHEMA; Schema: -; Owner: postgres

--

CREATE SCHEMA topology;

ALTER SCHEMA topology OWNER TO postgres;

--

-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:

--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;

--

-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:

--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';

--

-- Name: postgis; Type: EXTENSION; Schema: -; Owner:

--

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;

--

-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner:

--

COMMENT ON EXTENSION postgis IS 'postgis geometry,geography, and raster spatial types and functions';

--

-- Name: postgis_topology; Type: EXTENSION; Schema: -; Owner:

--

CREATE EXTENSION IF NOT EXISTS postgis_topology WITH SCHEMA topology;

--

-- Name: EXTENSION postgis_topology; Type: COMMENT; Schema: -; Owner:

--

COMMENT ON EXTENSION postgis_topology IS 'postgis topology spatial types and functions';

SET search_path = public, pg_catalog;

--

-- Name: linefromtext(text); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION linefromtext(text) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromText($1)) = 'LINESTRING'

THEN GeomFromText($1)

ELSE NULL END

$_$;

ALTER FUNCTION public.linefromtext(text) OWNER TO postgres;

--

-- Name: linefromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION linefromtext(text, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromText($1, $2)) = 'LINESTRING'

THEN GeomFromText($1,$2)

ELSE NULL END

$_$;

ALTER FUNCTION public.linefromtext(text, integer) OWNER TO postgres;

--

-- Name: linefromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION linefromwkb(bytea) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'LINESTRING'

THEN GeomFromWKB($1)

ELSE NULL END

$_$;

ALTER FUNCTION public.linefromwkb(bytea) OWNER TO postgres;

--

-- Name: linefromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION linefromwkb(bytea, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'LINESTRING'

THEN GeomFromWKB($1, $2)

ELSE NULL END

$_$;

ALTER FUNCTION public.linefromwkb(bytea, integer) OWNER TO postgres;

--

-- Name: linestringfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION linestringfromtext(text) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$SELECT LineFromText($1)$_$;

ALTER FUNCTION public.linestringfromtext(text) OWNER TO postgres;

--

-- Name: linestringfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION linestringfromtext(text, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$SELECT LineFromText($1, $2)$_$;

ALTER FUNCTION public.linestringfromtext(text, integer) OWNER TO postgres;

--

-- Name: linestringfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION linestringfromwkb(bytea) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'LINESTRING'

THEN GeomFromWKB($1)

ELSE NULL END

$_$;

ALTER FUNCTION public.linestringfromwkb(bytea) OWNER TO postgres;

--

-- Name: linestringfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION linestringfromwkb(bytea, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'LINESTRING'

THEN GeomFromWKB($1, $2)

ELSE NULL END

$_$;

ALTER FUNCTION public.linestringfromwkb(bytea, integer) OWNER TO postgres;

--

-- Name: mlinefromtext(text); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION mlinefromtext(text) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromText($1)) = 'MULTILINESTRING'

THEN GeomFromText($1)

ELSE NULL END

$_$;

ALTER FUNCTION public.mlinefromtext(text) OWNER TO postgres;

--

-- Name: mlinefromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION mlinefromtext(text, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE

WHEN geometrytype(GeomFromText($1, $2)) = 'MULTILINESTRING'

THEN GeomFromText($1,$2)

ELSE NULL END

$_$;

ALTER FUNCTION public.mlinefromtext(text, integer) OWNER TO postgres;

--

-- Name: mlinefromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION mlinefromwkb(bytea) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'MULTILINESTRING'

THEN GeomFromWKB($1)

ELSE NULL END

$_$;

ALTER FUNCTION public.mlinefromwkb(bytea) OWNER TO postgres;

--

-- Name: mlinefromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION mlinefromwkb(bytea, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'MULTILINESTRING'

THEN GeomFromWKB($1, $2)

ELSE NULL END

$_$;

ALTER FUNCTION public.mlinefromwkb(bytea, integer) OWNER TO postgres;

--

-- Name: mpointfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION mpointfromtext(text) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromText($1)) = 'MULTIPOINT'

THEN GeomFromText($1)

ELSE NULL END

$_$;

ALTER FUNCTION public.mpointfromtext(text) OWNER TO postgres;

--

-- Name: mpointfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION mpointfromtext(text, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromText($1,$2)) = 'MULTIPOINT'

THEN GeomFromText($1,$2)

ELSE NULL END

$_$;

ALTER FUNCTION public.mpointfromtext(text, integer) OWNER TO postgres;

--

-- Name: mpointfromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION mpointfromwkb(bytea) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'MULTIPOINT'

THEN GeomFromWKB($1)

ELSE NULL END

$_$;

ALTER FUNCTION public.mpointfromwkb(bytea) OWNER TO postgres;

--

-- Name: mpointfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION mpointfromwkb(bytea, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromWKB($1,$2)) = 'MULTIPOINT'

THEN GeomFromWKB($1, $2)

ELSE NULL END

$_$;

ALTER FUNCTION public.mpointfromwkb(bytea, integer) OWNER TO postgres;

--

-- Name: mpolyfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION mpolyfromtext(text) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromText($1)) = 'MULTIPOLYGON'

THEN GeomFromText($1)

ELSE NULL END

$_$;

ALTER FUNCTION public.mpolyfromtext(text) OWNER TO postgres;

--

-- Name: mpolyfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION mpolyfromtext(text, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromText($1, $2)) = 'MULTIPOLYGON'

THEN GeomFromText($1,$2)

ELSE NULL END

$_$;

ALTER FUNCTION public.mpolyfromtext(text, integer) OWNER TO postgres;

--

-- Name: mpolyfromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION mpolyfromwkb(bytea, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'MULTIPOLYGON'

THEN GeomFromWKB($1, $2)

ELSE NULL END

$_$;

ALTER FUNCTION public.mpolyfromwkb(bytea, integer) OWNER TO postgres;

--

-- Name: multilinefromwkb(bytea); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION multilinefromwkb(bytea) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromWKB($1)) = 'MULTILINESTRING'

THEN GeomFromWKB($1)

ELSE NULL END

$_$;

ALTER FUNCTION public.multilinefromwkb(bytea) OWNER TO postgres;

--

-- Name: multilinefromwkb(bytea, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION multilinefromwkb(bytea, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$

SELECT CASE WHEN geometrytype(GeomFromWKB($1, $2)) = 'MULTILINESTRING'

THEN GeomFromWKB($1, $2)

ELSE NULL END

$_$;

ALTER FUNCTION public.multilinefromwkb(bytea, integer) OWNER TO postgres;

--

-- Name: multilinestringfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION multilinestringfromtext(text) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$SELECT ST_MLineFromText($1)$_$;

ALTER FUNCTION public.multilinestringfromtext(text) OWNER TO postgres;

--

-- Name: multilinestringfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION multilinestringfromtext(text, integer) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$SELECT MLineFromText($1, $2)$_$;

ALTER FUNCTION public.multilinestringfromtext(text, integer) OWNER TO postgres;

--

-- Name: multipointfromtext(text); Type: FUNCTION; Schema: public; Owner: postgres

--

CREATE FUNCTION multipointfromtext(text) RETURNS geometry

LANGUAGE sql IMMUTABLE STRICT

AS $_$SELECT MPointFromText($1)$_$;

ALTER FUNCTION public.multipointfromtext(text) OWNER TO postgres;

--

-- Name: multipointfromtext(text, integer); Type: FUNCTION; Schema: public; Owner: postgres

--