SFS Test Suite - Test 1 of 52

================================
 Conformance Item T1	
 GEOMETRY_COLUMNS table/view is created/updated properly	
 For this test we will check to see that all of the feature tables are 
 represented by entries in the GEOMETRY_COLUMNS table/view

 ANSWER: lakes, road_segments, divided_routes, buildings, forests, bridges,
         named_places, streams, ponds, map_neatlines
 *** ADAPTATION ALERT ***	
 Since there are no quotes around the table names in the CREATE TABLEs,
 they will be converted to upper case in many DBMSs, and therefore, the 
 answer to this query may be:
 ANSWER: LAKES, ROAD_SEGMENTS, DIVIDED_ROUTES, BUILDINGS, FORESTS, BRIDGES,
         NAMED_PLACES, STREAMS, PONDS, MAP_NEATLINES
 *** ADAPTATION ALERT ***	
 If the implementer made the adaptation concerning the buildings table
 in sqltsch.sql, then the answer here may differ slightly.
	

================================
QUERY: SELECT f_table_name FROM geometry_columns
RESULT: lakes 
road_segments 
divided_routes 
forests 
bridges 
streams 
buildings 
buildings 
ponds 
named_places 
map_neatlines 
inwatera 
watercl 
builtupa 
builtupp 
aerofacp 
roadl 
railrdl

Visual presentation

Technical setup

  • Linux Debian
  • PostgreSQL 7.4 - PostGIS-0.8.0 - Geos-1.0.0
  • SQL-Schema adapted from postgis/examples/ogc_test_suite/