superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_NAME = "George J. Hatfield State Recreation Area"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
144 | 144 | 143 | {"type": "Polygon", "coordinates": [[[-120.96193, 37.35067], [-120.962, 37.35072], [-120.96207, 37.3508], [-120.96213, 37.35095], [-120.96211, 37.35115], [-120.96206, 37.35124], [-120.96192, 37.35138], [-120.96152, 37.35189], [-120.9613, 37.35212], [-120.96072, 37.35283], [-120.9605, 37.35328], [-120.96046, 37.3536], [-120.9605, 37.35393], [-120.96063, 37.35428], [-120.96074, 37.35474], [-120.96081, 37.35527], [-120.96074, 37.35593], [-120.96058, 37.3567], [-120.96042, 37.35757], [-120.96034, 37.35831], [-120.96019, 37.35881], [-120.9598, 37.35945], [-120.9593, 37.36001], [-120.95894, 37.36026], [-120.95783, 37.35936], [-120.95664, 37.35954], [-120.95616, 37.35943], [-120.95548, 37.35945], [-120.95475, 37.35896], [-120.95512, 37.35769], [-120.95537, 37.35766], [-120.95565, 37.35766], [-120.956, 37.35776], [-120.95626, 37.35791], [-120.95651, 37.35809], [-120.9568, 37.35827], [-120.95711, 37.3585], [-120.9574, 37.35866], [-120.95779, 37.35872], [-120.95815, 37.35866], [-120.95839, 37.35852], [-120.95853, 37.35834], [-120.95863, 37.35812], [-120.95869, 37.35785], [-120.95861, 37.35722], [-120.95861, 37.35687], [-120.9587, 37.3566], [-120.95892, 37.3564], [-120.95933, 37.35616], [-120.95976, 37.35596], [-120.96012, 37.35574], [-120.96035, 37.35552], [-120.96046, 37.3553], [-120.9605, 37.35497], [-120.96044, 37.35471], [-120.96022, 37.35447], [-120.96009, 37.35417], [-120.95991, 37.35394], [-120.95956, 37.35359], [-120.95938, 37.35325], [-120.95911, 37.35285], [-120.9589, 37.35247], [-120.95857, 37.35224], [-120.95731, 37.35186], [-120.95657, 37.35153], [-120.95632, 37.35132], [-120.95618, 37.35112], [-120.95608, 37.35084], [-120.95606, 37.35043], [-120.95638, 37.34955], [-120.95655, 37.34925], [-120.95686, 37.34915], [-120.95735, 37.34909], [-120.95782, 37.34913], [-120.95816, 37.34927], [-120.95852, 37.34948], [-120.95876, 37.34971], [-120.95897, 37.35], [-120.9593, 37.35058], [-120.95955, 37.35088], [-120.95985, 37.35105], [-120.96017, 37.35116], [-120.96056, 37.35117], [-120.96108, 37.35109], [-120.96128, 37.35104], [-120.96173, 37.35086], [-120.96193, 37.35067]]]} | Open Access 1 | George J. Hatfield State Recreation Area | http://www.parks.ca.gov/?page_id=556 | 1547 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 61.411 | George J. Hatfield SRA | 1953 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);