view db_schema/stammdaten_data_ort_typ.sql @ 1258:cb88ab44c2be

add code to stamdaten.ort_typ
author Michael Stanko <mstanko@bfs.de>
date Wed, 25 Jan 2017 14:14:58 +0100
parents 3923b41f8783
children a4c7057cbaed
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) FROM stdin;
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
\.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)