FOSS4G2007 IntegrationShowcase

From OSGeo

Revision as of 08:49, 5 September 2007 by Wiki-Ww (talk | contribs) (→‎Tables)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Back to FOSS4G2007...

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 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, 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 wiki page.

PostGIS Database : Refractions Research

NTDB/StatsCan/NRN

Database Connection Information

host	office.refractions.net
port	20543
database	foss
user	foss
password	foss4g07

Tables

delme

stray table?

border

Attribute	Description
geometry	feature geometry; LINESTRING

Spatial Reference System: EPSG:3005

ntdb_road_50: Canadian National Topographic Database (NTDB) roads at 1:50,000

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

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

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

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

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

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)

National Topographic Database Reference Documentation

statscan_roads: Statistics Canada road network

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

Statistics Candada Road Network File Reference

nrn_blkpassage: National Road Network Blocked Passages

Attribute	Description
geometry	feature geometry; POINT
blkpassty	blocked passage type; "Unknown","Permanently Fixed", "Removable"

Spatial Reference System: EPSG:4326

National Road Network Feature Catalogue

nrn_ferryseg: National Road Network Ferry Connection Segments

Attribute	Description
geometry	feature geometry; LINESTRING
roadclass	road type; "Arterial", "Collector", "Local / Street", "Local / Unknown"

Spatial Reference System: EPSG:4326

National Road Network Feature Catalogue

nrn_junction: National Road Network Junctions

Attribute	Description
geometry	feature geometry; POINT
junctype	junction type; "Intersection", "Dead End", "Ferry", "NatProvTer"

Spatial Reference System: EPSG:4326

National Road Network Feature Catalogue

nrn_roadseg: National Road Network Road Segments

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

National Road Network Feature Catalogue

Kamloops

Database Connection Information

host	office.refractions.net
port	80543
database	kamloops
user	foss
password	foss4g07

Tables

addresspoint_point: Kamloops Addresses

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

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

Attribute	Description
geometry	feature geometry; GEOMETRY (LINESTRING/MULTILINESTRING)
name	creek name

Spatial Reference System: EPSG:26910

waterbody_poly: Kamloops Waterbodies

Attribute	Description
geometry	feature geometry; POLYGON
name	waterbody name

Spatial Reference System: EPSG:26910

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 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 Refractions Research for use by the Integration Showcase participants.

Contact: Paul Ramsey <pramsey@refractions.net>

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.

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 here. Data can furthermore exported to KML for (Google Earth or NASA/WorldWind) and more.

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

Retrieved from "http://wiki.osgeo.org/w/index.php?title=FOSS4G2007_IntegrationShowcase&oldid=17801"