https://kvwmap.de/wiki/index.php?action=history&feed=atom&title=GLE-Postgis-Strassen 2026-05-12T22:02:12Z Versionsgeschichte dieser Seite in kvwmap MediaWiki 1.23.1 https://kvwmap.de/wiki/index.php?title=GLE-Postgis-Strassen&diff=6241&oldid=prev 2011-09-12T08:35:24Z

<p></p> <p><b>Neue Seite</b></p><div>&lt;pre&gt;<br /> CREATE TABLE gd_lk_kreisstrassen<br /> (<br /> ogc_fid serial NOT NULL,<br /> the_geom geometry,<br /> abs character(16),<br /> strassenname character(12),<br /> anfangsnetzknoten character(8),<br /> endnetzknoten character(8),<br /> strassenart character(1),<br /> strassennummer character(5),<br /> abschnittsnummer character(4),<br /> abschnittslaenge integer,<br /> bemerkung character(25),<br /> datum date,<br /> ui_k character(1),<br /> vonnp character(1),<br /> nachnp character(1),<br /> CONSTRAINT gd_lk_kreisstrassen_pk PRIMARY KEY (ogc_fid),<br /> CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),<br /> CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'LINESTRING'::text OR the_geom IS NULL),<br /> CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 25833)<br /> )<br /> WITH (OIDS=TRUE);<br /> SELECT AddGeometryColumn('', 'gd_lk_kreisstrassen','the_geom',25833,'LINESTRING', 2);<br /> <br /> CREATE INDEX gd_lk_kreisstrassen_geom_idx<br /> ON gd_lk_kreisstrassen<br /> USING gist<br /> (the_geom);<br /> <br /> <br /> CREATE TABLE gd_netzknoten<br /> (<br /> ogc_fid serial NOT NULL,<br /> the_geom geometry,<br /> nk integer NOT NULL,<br /> bereich integer,<br /> bindung integer,<br /> netzknoten character(8),<br /> &quot;name&quot; character(40),<br /> kreisverkehr character(1),<br /> fiktiv character(1),<br /> planum character(12),<br /> bw character(7),<br /> rechtswert double precision,<br /> hochwert double precision,<br /> hoehe double precision,<br /> datum date,<br /> bemerkung character(30),<br /> CONSTRAINT gd_netzknoten_pk PRIMARY KEY (nk),<br /> CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),<br /> CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL),<br /> CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 25833)<br /> )<br /> WITH (OIDS=TRUE);<br /> SELECT AddGeometryColumn('', 'gd_netzknoten','the_geom',25833,'POINT', 2);<br /> <br /> CREATE INDEX gd_netzknoten_geom_idx<br /> ON gd_netzknoten<br /> USING gist<br /> (the_geom);<br /> <br /> <br /> CREATE TABLE gd_netzknoten_bilder<br /> (<br /> id serial NOT NULL,<br /> nk integer,<br /> subnr integer,<br /> datei character(120),<br /> datum date,<br /> CONSTRAINT gd_netzknoten_bilder_pk PRIMARY KEY (id)<br /> )<br /> WITH (OIDS=TRUE);<br /> <br /> &lt;/pre&gt;</div>

Wirsi