Database Reference
In-Depth Information
Layer name: cuyahoga_hydro_polygon
Geometry: Polygon
Feature Count: 6237
Extent: (1694482.287974, 552986.308029) -
(2947684.750393, 1200045.105669)
Layer SRS WKT:
PROJCS["NAD_1983_StatePlane_Ohio_North_FIPS_3401_Feet",
GEOGCS["GCS_North_American_1983",
PARAMETER["Latitude_Of_Origin",39.66666666666666],
UNIT["Foot_US",0.3048006096012192]]
Name: String (30.0)
AREA: Real (19.11)
PERIMETER: Real (19.11)
hyd_type: String (50.0)
geom_type: String (15.0)
Executingthiscommandoneachoftheshapefiles,weseethefollowingfieldsthat
are common to all the shapefiles:
•
name
•
hyd_type
•
geom_type
Itisbyunderstandingourcommonfieldsthatwecanapplyinheritancetocompletely
structure our data.
How to do it...
Nowthatweknowourcommonfields,creatinganinheritancemodeliseasy.First,
wewillcreate aparent table with the fields commonto allthe tables, usingthe fol-
lowing query:
CREATE TABLE chp02.hydrology (
gid SERIAL PRIMARY KEY,
"name" text,
