FSFE Fellowship Meeting 25.03.2015 Düsseldorf

Referent:
Harald Schwenk
agentur geoinfo

OSGeo Foundation http://www.osgeo.org/
FOSSGIS eV http://www.fossgis.de/ (UMN MapServer)

Was sind Geodaten?
Vektordaten: Geometrie (Punkt, Linie, Fläche) + SRID + Attribut(e)
Rasterdaten: RGB + Infrarot + ...
Punktwolken/LiDAR: Laserscann, ...


OSM?

Standard:
OpenGIS Implementation Standard for Geographic information - Simple feature access - Part 1: Common architecture
http://www.opengeospatial.org/standards/sfa
OpenGIS Implementation Standard for Geographic information - Simple feature access - Part 2: SQL option
http://www.opengeospatial.org/standards/sfs


implementiert in PostgreSQL/PostGIS http://postgis.net/docs/manual-2.1/reference.html
analog: SpatiaLite
Geography Markup Language > GML

SELECT ST_GeomFromText('POINT(5 5)',0);
SELECT ST_GeomFromText('LINESTRING(0 0,10 0,10 10,0 10,0 0)',0);
SELECT ST_GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0))',0);
SELECT ST_GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0),(3 3,7 3,7 7,3 7,3 3))',0);

ST_AsText(), ST_SRID(), ST_GeometryType(), >> ST_AsGML(), ST_AsKML()
ST_NumInteriorRings()

SELECT the_geom FROM multipolygons LIMIT 10;
SELECT * FROM geometry_columns;

ST_IsRing()
ST_IsClosed()
ST_NumGeometries()
ST_NumInteriorRings()

SELECT ST_NumGeometries(ST_GeomFromText('MULTIPOINT((5 5),(15 15),(25 25))',0));
SELECT ST_NumGeometries(ST_GeomFromText('MULTILINESTRING((0 0,10 0,10 10,0 10,0 0),(5 5,15 15))',0));
SELECT ST_NumGeometries(ST_GeomFromText('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(3 3,7 3,7 7,3 7,3 3)),((15 0,25 0,25 10,15 10,15 0)))',0));


SELECT ST_NumGeometries(the_geom), name FROM admin_boundary WHERE name in('Roetgen','Simmerath','Monschau');

Kurven?

EPSG Geodetic Parameter Registry http://www.epsg-registry.org/
SELECT ST_AsText(ST_Transform((ST_GeometryFromText('POINT (354144 5676733)',25832)),4326));
SELECT * FROM spatial_ref_sys;



Anwendungsfälle:
Wohnungsbau agentur geoinfo http://maps.agentur-geoinfo.de/wohnen/wohnungsbau.html
Geschäftsstraßenbesatz agentur geoinfo http://maps.agentur-geoinfo.de/eh_dssd/kaiserswerth.html
hier WMS http://maps.agentur-geoinfo.de/cgi-bin/mapserv?service=WMS&map=../httpdocs/eh_dssd/kaiserswerth.map&VERSION=1.0.0&REQUEST=getMap&LAYERS=Kaiserswerth&SRS=EPSG:25832&BBOX=342000,5685500,342600,5686100&WIDTH=2048&HEIGHT=2048&FORMAT=png
Routing VRR http://efa.vrr.de/vrrstd/XSLT_TRIP_REQUEST2?language=de&itdLPxx_transpCompany=vrr