view db_schema/stammdaten_data_ort_typ.sql @ 1335:b9eb9229df21

Accept values for 'umweltbereich' with length of 1 - 3 characters.
author Raimund Renkert <raimund.renkert@intevation.de>
date Thu, 06 Apr 2017 10:08:47 +0200
parents 3ac30d816c9a
children
line wrap: on
line source
\set ON_ERROR_STOP on

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.1
-- Dumped by pg_dump version 9.5.0

-- Started on 2016-03-31 11:38:13

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = stammdaten, pg_catalog;


--
-- TOC entry 4706 (class 0 OID 535799)
-- Dependencies: 272
-- Data for Name: ort_typ; Type: TABLE DATA; Schema: stammdaten; Owner: lada
--

COPY ort_typ (id, ort_typ, code) FROM stdin;
1	dynamischer Messpunkt (nicht vordefiniert)	DYN
2	vordefinierter Messpunkt	GP
3	REI-Messpunkit	REI
4	Verwaltungseinheit	VE
5	Staat	ST
6	Fluss	FL
7	See	SEE
8	Wasserwerk	WW
9	Kläranlage	KA
10	Deponie	DEP
11	Müllverbrennungsanlage	MVA
12	Messstation	MST
13	KTA	KTA
14	Fanggebiet	FG
15	Sonstiger Ortszusatz	So
\.
--
-- PostgreSQL database dump complete
--
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)