Difference between revisions of "FOSS4G2008 IntegrationShowcase"

From OSGeo
Jump to navigation Jump to search
(created)
 
('deleted')
Line 1: Line 1:
 
Back to [[FOSS4G2008]]...
 
Back to [[FOSS4G2008]]...
  
NB: Gavin copied this from 2007's on 15 July 2008 - it needs drastic editing by the 2008 organisers - pls remove this line when it's updated for 2008.
+
An Integration Showcase didn't happen in 2008. Great idea but needs LOTS of time and resources to pull off. An ongoing one is planned from 2009 onwards.
 
 
= Introduction =
 
 
 
The Integration Showcase will highlight the open source spirit of "coopetition" (cooperative competition) amongst the sponsors and exhibitors of the FOSS4G2007 conference.
 
 
 
In order to ensure everything works "as planned" on the show floor, the Integration Showcase will be set up and running live on the Internet well in advance of the conference.  As each Integration Showcase participant goes "live" with their component, they must register it on this page, so that other participants can hook it into their own demonstrations.  Low-level components, such as databases and mapping services, must go live first. 
 
 
 
The coordinator for the Integration Showcase is '''[[User:Jdeolive|Justin Deoliveira]]''', of the Open Planning Project.  He will be contacting exhibitors and sponsors to make them aware of the showcase and how to participate.
 
 
 
= Status =
 
* 2007/07/10 Refractions Research PostGIS database Internet connection enabled
 
* 2007/07/09 Canadian NTDB vector data loaded into PostGIS database
 
 
 
= Data =
 
 
 
The goal for this conference is to utilize only publicly available geodata for the Integration Showcase.
 
 
 
Initiated by the OSgeo [[Public_Geospatial_Data_Committee|Public Geospatial Data Committee]], there is an effort underway to obtain copies of public datasets that are 'local' to Victoria, B.C. (the FOSS4G2007 conference location), and to load that data onto the server that will be used for the Integration Showcase.
 
 
 
The tracking of the public datasets is being done via the [[Canadian_Geodata|Canadian Geodata]] wiki page.
 
 
 
== PostGIS Database : Refractions Research ==
 
 
 
=== NTDB/StatsCan/NRN ===
 
 
 
==== Database Connection Information ====
 
{| border="1"
 
|host
 
|office.refractions.net
 
|-
 
|port
 
|20543
 
|-
 
|database
 
|foss
 
|-
 
|user
 
|foss
 
|-
 
|password
 
|foss4g07
 
|-
 
|}
 
 
 
==== Tables ====
 
 
 
; delme
 
stray table?
 
 
 
; border
 
{|border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; LINESTRING
 
|-
 
|}
 
Spatial Reference System: EPSG:3005
 
 
 
; ntdb_road_50 : Canadian National Topographic Database (NTDB) roads at 1:50,000
 
{|border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; LINESTRING
 
|-
 
|classifica
 
|road classification; 0=unknown, 1=highway, 2=main, 3=secondary, 4=street, 5=rapid transit
 
|-
 
|}
 
Spatial Reference System: EPSG:3005
 
 
 
 
 
; ntdb_railway_50 : NTDB railways at 1:50,000
 
{| border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; LINESTRING
 
|-
 
|type
 
|railway type; 0=unknown, 1=multiple, 2=side track, 3=single
 
|-
 
|}
 
Spatial Reference System: EPSG:3005
 
 
 
 
 
; ntdb_toponym_50 : NTDB topographic feature names at 1:50,000
 
{| border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; POINT
 
|-
 
|type
 
|topographic feature type; 0=unknown, 1=place 2=hydrography, 3=shoreline, 4=relief, 5=transport
 
|-
 
|name
 
|topographic feature name
 
|-
 
|}
 
Spatial Reference System: EPSG:3005
 
 
 
 
 
; ntdb_contour_50 : NTDB contour lines at 1:50,000
 
{| border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; LINESTRING
 
|-
 
|type
 
|contour type; 1=depression, 2=other
 
|-
 
|name
 
|topographic feature name
 
|-
 
|}
 
Spatial Reference System: EPSG:3005
 
 
 
 
 
; ntdb_waterbody_50 : NTDB water bodies (including rivers) at 1:50,000
 
{| border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; POLYGON
 
|-
 
|type
 
|water body type; 0=unknown; 1=intermittent, 2=other, 3=irrigation canal, 4=flooded area
 
|-
 
|}
 
Spatial Reference System: EPSG:3005
 
 
 
 
 
; ntdb_watercourse_50 : NTDB water courses (rivers,streams,brooks,creeks) at 1:50,000
 
{| border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; LINESTRING
 
|-
 
|}
 
Spatial Reference System: EPSG:3005
 
 
 
 
 
; ntdb_road_250 : NTDB roads at 1:250,000 (see ntdb_road_50 for schema/attribute information)
 
; ntdb_railway_250 : NTDB roads at 1:250,000 (see ntdb_railway_50 for schema/attribute information)
 
; ntdb_contour_250 : NTDB contour lines at 1:250,000 (see ntdb_contour_50 for schema/attribute information)
 
; ntdb_toponym_250 : NTDB toponyms at 1:250,000 (see ntdb_toponym_50 for schema/attribute information)
 
; ntdb_waterbody_250 : NTDB water bodies at 1:250,000 (see ntdb_waterbody_50 for schema/attribute information)
 
; ntdb_watercourse_250 : NTDB water courses at 1:250,000 (see ntdb_watercourse_50 for schema/attribute information)
 
 
 
[http://geogratis.cgdi.gc.ca/geogratis/en/collection/8147.html National Topographic Database Reference Documentation]
 
 
 
 
; statscan_roads : Statistics Canada road network
 
{| border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; LINESTRING
 
|-
 
|class
 
|road classification; UR=unclassified, UTR=utility road, CON=connector road, BT=bridges and tunnels, ST=street (addressable), HI=highway (addressable)
 
|-
 
|name
 
|street name
 
|-
 
|type
 
|street type; see reference documentation for description of values
 
|-
 
|direction
 
|street direction; null=none, N=north, S=south, E=east, W=west, NW=northwest, NE=northeast, SW=southwest, SE=southeast
 
|-
 
|addr_fm_le
 
|the civic address found on the left hand side at the FROM node
 
|-
 
|addr_to_le
 
|the civic address found on the left hand side at the TO node
 
|-
 
|addr_fm_rg
 
|the civic address found on the right hand side at the FROM node
 
|-
 
|addr_to_rg
 
|the civic address found on the right hand side at the TO node
 
|-
 
|}
 
Spatial Reference System: EPSG:3005
 
 
 
[http://geodepot.statcan.ca/Diss2006/Reference/ReferenceGuides/92-500-GWE2006001.jsp Statistics Candada Road Network File Reference]
 
 
 
 
 
; nrn_blkpassage : National Road Network Blocked Passages
 
{| border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; POINT
 
|-
 
|blkpassty
 
|blocked passage type; "Unknown","Permanently Fixed", "Removable"
 
|-
 
|}
 
Spatial Reference System: EPSG:4326
 
 
 
[http://www.geobase.ca/doc/specs/pdf/GeoBase_FeatureCatalogue_SegmentedView_NRN_2_0_EN.pdf National Road Network Feature Catalogue]
 
 
 
; nrn_ferryseg : National Road Network Ferry Connection Segments
 
{| border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; LINESTRING
 
|-
 
|roadclass
 
|road type; "Arterial", "Collector", "Local / Street", "Local / Unknown"
 
|-
 
|}
 
Spatial Reference System: EPSG:4326
 
 
 
[http://www.geobase.ca/doc/specs/pdf/GeoBase_FeatureCatalogue_SegmentedView_NRN_2_0_EN.pdf National Road Network Feature Catalogue]
 
 
 
 
 
; nrn_junction : National Road Network Junctions
 
{| border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; POINT
 
|-
 
|junctype
 
|junction type; "Intersection", "Dead End", "Ferry", "NatProvTer"
 
|-
 
|}
 
Spatial Reference System: EPSG:4326
 
 
 
[http://www.geobase.ca/doc/specs/pdf/GeoBase_FeatureCatalogue_SegmentedView_NRN_2_0_EN.pdf National Road Network Feature Catalogue]
 
 
 
 
 
; nrn_roadseg : National Road Network Road Segments
 
{| border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; LINESTRING
 
|-
 
|roadclass
 
|road type; "Alleyway / Lane", "Arterial", "Collector", "Expressway / Highway", "Freeway", "Local / Strata", "Local / Street", "Local / Unknown", "Ramp", "Resource / Recreation", "Service Lane"
 
|-
 
|-
 
|rte1nameen
 
|route name
 
|-
 
|-
 
|rtnumber1
 
|route number
 
|-
 
|}
 
Spatial Reference System: EPSG:4326
 
 
 
[http://www.geobase.ca/doc/specs/pdf/GeoBase_FeatureCatalogue_SegmentedView_NRN_2_0_EN.pdf National Road Network Feature Catalogue]
 
 
 
=== Kamloops ===
 
 
 
==== Database Connection Information ====
 
{| border="1"
 
|host
 
|office.refractions.net
 
|-
 
|port
 
|80543
 
|-
 
|database
 
|kamloops
 
|-
 
|user
 
|foss
 
|-
 
|password
 
|foss4g07
 
|-
 
|}
 
 
 
 
 
==== Tables ====
 
 
 
; addresspoint_point : Kamloops Addresses
 
{|border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; POINT
 
|-
 
|address
 
|address label, number + name
 
|-
 
|rotation
 
|angle of rotation of the address label specifies in degrees
 
|-
 
|}
 
Spatial Reference System: EPSG:26910
 
 
 
 
 
 
 
; street_line : Kamloops Streets
 
{|border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; GEOMETRY (LINESTRING/MULTILINESTRING)
 
|-
 
|name
 
|street name
 
|-
 
|classif2
 
|street classification; 'ARTERIAL DIVIDED','ARTERIAL UNDIVIDED','COLLECTOR','HIGHWAY','LOCAL','RURAL MINOR','UNKNOWN','URBAN MINOR'
 
|-
 
|}
 
Spatial Reference System: EPSG:26910
 
 
 
 
 
; majorcreek_line : Kamloops Major Creeks
 
{|border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; GEOMETRY (LINESTRING/MULTILINESTRING)
 
|-
 
|name
 
|creek name
 
|-
 
|}
 
Spatial Reference System: EPSG:26910
 
 
 
 
 
; waterbody_poly : Kamloops Waterbodies
 
{|border="1"
 
!Attribute
 
!Description
 
|-
 
|geometry
 
|feature geometry; POLYGON
 
|-
 
|name
 
|waterbody name
 
|-
 
|}
 
Spatial Reference System: EPSG:26910
 
 
 
== MapServer WMS : Refractions Research ==
 
 
 
http://office.refractions.net:20080/wms?request=getcapabilities
 
 
 
http://office.refractions.net:20080/tilecache/tilecache.py
 
 
 
=== Layers ===
 
 
 
==== Kamloops ====
 
 
 
; kamloops_ortho : 20cm ortho photos of the Kamloops area.
 
 
 
[ http://webserver.kamloops.ca/imf/sites/DataDownload/disclaimer.html Geographic Data Download Service Disclaimer]
 
 
 
== PostGIS Database : Telascience - FlightGear Landcover-DB Mapserver ==
 
 
 
=== Access ===
 
 
 
* [http://mapserver.flightgear.org/ Graphical MapServer interface]
 
* [http://mapserver.flightgear.org/download.psp Download Shapefiles] '''NEW'''
 
* [http://mapserver.flightgear.org/cgi-bin/landcover?Service=WMS&Version=1.1.1&request=GetCapabilities WMS GetCapabilities]
 
* [http://mapserver.flightgear.org/cgi-bin/landcover?Service=WFS&Version=1.0.0&request=GetCapabilities WFS GetCapabilities]
 
* [http://mapserver.flightgear.org/tilecache/tilecache.py Enjoy TileCache] !
 
 
 
We regret that, due to technical reasons, direct PostGIS database access is currently unavailable.
 
 
 
=== Layers ===
 
 
 
Over 140 Vector layers from approx. 12 different sources available. Please see further explanations and layer descriptions (behind the "DETAILS" link of every respective section) at the [[Geodata_Repository#On_Offer_.21|Landcover-DB]] pages.
 
The colour schema has been applied in accordance with the [http://terrestrial.eionet.europa.eu/CLC2000/ Corine Land Cover] project.
 
 
 
Available datasets include detailed landuse polygon data at - yet - selected areas [http://mapserver.flightgear.org/openlayers_eddi.html (example)]. This data has been automatically aquired from Landsat7 images at the [http://www.custom-scenery.org/Research-Deve.274.0.html World Custom Scenery Project].
 
 
 
= Services =
 
This section will contain information about services to access the above Data, such as WMS.
 
 
 
Find out how to access [[Canadian Geodata]] via WMS and WFS.
 
 
 
= Participants =
 
Integration Showcase participants must 'register' themselves in this section.
 
When your part of the showcase is ready for use by other participants:
 
* let [[User:Jdeolive|Justin Deoliveira]] know
 
* provide the necessary information in the Data and/or Services sections
 
* update the Status
 
 
 
== PostGIS Database : Refractions Research ==
 
Status: '''Live'''
 
 
 
A PostGIS database containing vector data is being made available by [http://www.refractions.net Refractions Research] for use by the Integration Showcase participants.
 
 
 
Contact: Paul Ramsey <pramsey@refractions.net>
 
 
 
== PostGIS Database : Telascience - FlightGear Landcover-DB Mapserver ==
 
Status: '''Live'''
 
 
 
A Mapserver/TileCache frontend to a PostGIS database which contains vector data from approx [[Geodata_Repository#On_Offer_.21|a dozend different sources]].
 
 
 
Contact: [[User:Mspott|Martin Spott]]
 
 
 
== Mapbender : The WhereGroup ==
 
Status: Live
 
 
 
The WhereGroup uses the online OSGeo Mapbender instance at http://wms1.ccgis.de/mapbender_dev/ This URL will probably change to http://mapbender.telascience.org before the conference starts. This Mapbender instance is then used to build a catalog, interface, OGC capabilities cache, security proxy and web mapping interfaces. All IntegrationShowcase components that can be accessed via WMS or WFS through the global spatial data infrastructure (also known as "The Internet") can be used to showcase in Mapbender. The data served by [[Canadian Geodata]] will be accessed using OGC WMS and (potentially) WFS services.
 
 
 
A GeoServer has been installed and configured as OGC WFS-T and WMS to add places for after hours and meeting outside business hours. The OGC WFS-T can be accessed either directly at: (URL will be added on the first conference day) or through the Mapbender application (URL follows) or through a KML file (URL follows).
 
 
 
Contact: arnulf.christl@wheregroup.com
 
 
 
== MapGuide Open Source : Autodesk / DM Solutions ==
 
Status: Planned
 
 
 
Autodesk will host a MapGuide Open Source application featuring a FUSION based web interface created by DM Solutions. This will showcase the web-based GIS capabilities of MapGuide with a FUSION interface, MapGuide's direct support for Google Earth, and OGC WMS and WFS web services.
 
 
 
Contact: robert.bray@autodesk.com
 
 
 
== GRASS GIS ==
 
Status: Planned
 
 
 
GRASS folks at FOSS4G2007 might be willing to showcase the capabilities of GRASS to import, analyze and visualize the data set. Initial screenshots are available [http://grass.gdf-hannover.de/wiki/FOSS4G2007_IntegrationShowcase here]. Data can furthermore exported to KML for (Google Earth or NASA/WorldWind) and more.
 
  
 
[[Category:FOSS4G2008]]
 
[[Category:FOSS4G2008]]
 
[[Category:FOSS4G]]
 
[[Category:FOSS4G]]
 
== GeoServer ==
 
Status: '''Live'''
 
 
GeoServer providing read/write access via WFS-T. Showcase attendees are encouraged to edit data and have it visualized by other showcase components.
 
 
http://office.refractions.net:20880/geoserver/wfs?request=getcapabilities.
 
 
Contact: jdeolive@openplans.org
 
 
 
== ETL Server: Safe Software Inc. ==
 
Status: '''Planned'''
 
 
A service that reads data from multiple sources including data
 
from a PostGIS database and a GeoRSS web service of earthquakes,
 
buffer the earthquakes proportionally to magnitude, intersect this
 
with the coastal zones and then generate a new layer that shows
 
populated areas at low elevation within range of recent earthquakes
 
(last 24 hours) that might be at risk for tsunami. The result will
 
be served up for general consumption as WFS, WMS, KML and/or GeoRSS.
 
 
Contact: dean.hintz@safe.com
 

Revision as of 02:20, 10 November 2008

Back to FOSS4G2008...

An Integration Showcase didn't happen in 2008. Great idea but needs LOTS of time and resources to pull off. An ongoing one is planned from 2009 onwards.