Created
July 24, 2013 13:25
-
-
Save johnjreiser/6070547 to your computer and use it in GitHub Desktop.
PostgreSQL of the Land Use crosswalk table. Useful if you need a complete list of all of the Anderson Level 4 codes and their descriptions used in the State of New Jersey land use data.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE lucode_crosswalk ( | |
| lucode integer NOT NULL PRIMARY KEY, | |
| ludesc varchar(100) NOT NULL, | |
| hltype varchar(30) NOT NULL | |
| ); | |
| COMMENT ON TABLE lucode_crosswalk IS 'All available Land Use/Land Cover codes used in the NJ LULC data.'; | |
| COMMENT ON COLUMN lucode_crosswalk.lucode IS 'Anderson Level IV Code'; | |
| COMMENT ON COLUMN lucode_crosswalk.ludesc IS 'Land use type description'; | |
| COMMENT ON COLUMN lucode_crosswalk.hltype IS 'Hasse-Lathrop code classification'; | |
| COPY lucode_crosswalk FROM STDIN WITH DELIMITER E'\t'; | |
| 1100 RESIDENTIAL URBAN | |
| 1110 RESIDENTIAL, HIGH DENSITY OR MULTIPLE DWELLING URBAN | |
| 1120 RESIDENTIAL, SINGLE UNIT, MEDIUM DENSITY URBAN | |
| 1130 RESIDENTIAL, SINGLE UNIT, LOW DENSITY URBAN | |
| 1140 RESIDENTIAL, RURAL, SINGLE UNIT URBAN | |
| 1150 MIXED RESIDENTIAL URBAN | |
| 1200 COMMERCIAL/SERVICES URBAN | |
| 1211 MILITARY INSTALLATIONS URBAN | |
| 1214 FORMER MILITARY, INDETERMINATE USE/NO LONGER MILITARY URBAN | |
| 1300 INDUSTRIAL URBAN | |
| 1400 TRANSPORTATION/COMMUNICATION/UTILITIES URBAN | |
| 1410 MAJOR ROADWAY URBAN | |
| 1411 MIXED TRANSPORTATION CORRIDOR OVERLAP AREA URBAN | |
| 1419 BRIDGE OVER WATER URBAN | |
| 1420 RAILROADS URBAN | |
| 1440 AIRPORT FACILITIES URBAN | |
| 1461 WETLAND RIGHTS-OF-WAY WETURB | |
| 1462 UPLAND RIGHTS-OF-WAY DEVELOPED URBAN | |
| 1463 UPLAND RIGHTS-OF-WAY UNDEVELOPED URBAN | |
| 1499 STORMWATER BASIN URBAN | |
| 1500 INDUSTRIAL AND COMMERCIAL COMPLEXES URBAN | |
| 1600 MIXED URBAN OR BUILT-UP LAND URBAN | |
| 1700 OTHER URBAN OR BUILT-UP LAND URBAN | |
| 1710 CEMETERY URBAN | |
| 1711 CEMETERY ON WETLAND WETURB | |
| 1741 PHRAGMITES DOMINATE URBAN AREA URBAN | |
| 1750 MANAGED WETLAND IN MAINTAINED LAWN GREENSPACE WETURB | |
| 1800 RECREATIONAL LAND URBAN | |
| 1804 ATHLETIC FIELDS (SCHOOLS) URBAN | |
| 1810 STADIUM, THEATERS, CULTURAL CENTERS AND ZOOS URBAN | |
| 1850 MANAGED WETLAND IN BUILT-UP MAINTAINED REC AREA WETURB | |
| 2100 CROPLAND AND PASTURELAND AGRICULTURE | |
| 2140 AGRICULTURAL WETLANDS (MODIFIED) WETAGR | |
| 2150 FORMER AGRICULTURAL WETLAND (BECOMING SHRUBBY, NOT BUILT-UP) WETAGR | |
| 2200 ORCHARDS/VINEYARDS/NURSERIES/HORTICULTURAL AREAS AGRICULTURE | |
| 2300 CONFINED FEEDING OPERATIONS AGRICULTURE | |
| 2400 OTHER AGRICULTURE AGRICULTURE | |
| 4100 DECIDUOUS FOREST FOREST | |
| 4110 DECIDUOUS FOREST (10-50% CROWN CLOSURE) FOREST | |
| 4120 DECIDUOUS FOREST (>50% CROWN CLOSURE) FOREST | |
| 4200 CONIFEROUS FOREST FOREST | |
| 4210 CONIFEROUS FOREST (10-50% CROWN CLOSURE) FOREST | |
| 4220 CONIFEROUS FOREST (>50% CROWN CLOSURE) FOREST | |
| 4230 PLANTATION FOREST | |
| 4310 CONIFEROUS/DECIDUOUS FOREST FOREST | |
| 4311 MIXED FOREST (>50% CONIFEROUS WITH 10-50% CROWN CLOSURE) FOREST | |
| 4312 MIXED FOREST (>50% CONIFEROUS WITH >50% CROWN CLOSURE) FOREST | |
| 4320 DECIDUOUS/CONIFEROUS FOREST FOREST | |
| 4321 MIXED FOREST (>50% DECIDUOUS WITH 10-50% CROWN CLOSURE) FOREST | |
| 4322 MIXED FOREST (>50% DECIDUOUS WITH >50% CROWN CLOSURE) FOREST | |
| 4400 BRUSHLAND/SHRUBLAND FOREST | |
| 4410 OLD FIELD (< 25% BRUSH COVERED) FOREST | |
| 4411 PHRAGMITES DOMINATE OLD FIELD FOREST | |
| 4420 DECIDUOUS BRUSH/SHRUBLAND FOREST | |
| 4430 CONIFEROUS BRUSH/SHRUBLAND FOREST | |
| 4440 MIXED DECIDUOUS/CONIFEROUS BRUSH/SHRUBLAND FOREST | |
| 4500 SEVERE BURNED UPLAND VEGETATION FOREST | |
| 5100 STREAMS AND CANALS WATER | |
| 5190 EXPOSED FLATS WATER | |
| 5200 NATURAL LAKES WATER | |
| 5300 ARTIFICIAL LAKES WATER | |
| 5410 TIDAL RIVERS, INLAND BAYS, AND OTHER TIDAL WATERS WATER | |
| 5411 OPEN TIDAL BAYS WATER | |
| 5420 DREDGED LAGOON WATER | |
| 5430 ATLANTIC OCEAN WATER | |
| 6110 SALINE MARSHES WETCOAST | |
| 6111 SALINE MARSH (LOW MARSH) WETCOAST | |
| 6112 SALINE MARSH (HIGH MARSH) WETCOAST | |
| 6120 FRESHWATER TIDAL MARSHES WETCOAST | |
| 6130 VEGETATED DUNE COMMUNITIES WETCOAST | |
| 6141 PHRAGMITES DOMINATE COASTAL WETLANDS WETCOAST | |
| 6210 DECIDUOUS WOODED WETLANDS WETFOREST | |
| 6220 CONIFEROUS WOODED WETLANDS WETFOREST | |
| 6221 ATLANTIC WHITE CEDAR WETLANDS WETFOREST | |
| 6230 SCRUB/SHRUB WETLANDS WETEMERG | |
| 6231 DECIDUOUS SCRUB/SHRUB WETLANDS WETEMERG | |
| 6232 CONIFEROUS SCRUB/SHRUB WETLANDS WETEMERG | |
| 6233 MIXED SCRUB/SHRUB WETLANDS (DECIDUOUS DOM.) WETEMERG | |
| 6234 MIXED SCRUB/SHRUB WETLANDS (CONIFEROUS DOM.) WETEMERG | |
| 6240 HERBACEOUS WETLANDS WETEMERG | |
| 6241 PHRAGMITES DOMINATE INTERIOR WETLANDS WETEMERG | |
| 6250 MIXED WOODED WETLANDS WETFOREST | |
| 6251 MIXED WOODED WETLANDS (DECIDUOUS DOM.) WETFOREST | |
| 6252 MIXED WOODED WETLANDS (CONIFEROUS DOM.) WETFOREST | |
| 6290 UNVEGETATED FLATS WETEMERG | |
| 6500 SEVERE BURNED WETLAND VEGETATION WETDIST | |
| 7100 BEACHES BARREN | |
| 7200 BARE EXPOSED ROCK, ROCK SLIDES, ETC BARREN | |
| 7300 EXTRACTIVE MINING BARREN | |
| 7400 ALTERED LANDS BARREN | |
| 7430 DISTURBED WETLANDS (MODIFIED) WETDIST | |
| 7500 TRANSITIONAL AREAS BARREN | |
| 7600 UNDIFFERENTIATED BARREN LANDS BARREN | |
| 8000 MANAGED WETLANDS (MODIFIED) WETDIST |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment