superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 7 and PARK_URL = "http://parks.lacounty.gov/santa-fe-dam-recreational-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15398 | 15398 | 15397 | {"type": "Polygon", "coordinates": [[[-117.95999, 34.10704], [-117.9599, 34.11834], [-117.95943, 34.11891], [-117.95858, 34.11969], [-117.95755, 34.12058], [-117.95639, 34.12138], [-117.95542, 34.12235], [-117.95497, 34.12298], [-117.95388, 34.12367], [-117.95313, 34.12443], [-117.95266, 34.1252], [-117.9525, 34.12614], [-117.95195, 34.12642], [-117.95133, 34.12694], [-117.95091, 34.12769], [-117.95066, 34.12822], [-117.95053, 34.12906], [-117.95015, 34.13], [-117.94872, 34.13114], [-117.94844, 34.13138], [-117.94805, 34.1319], [-117.94765, 34.13216], [-117.94567, 34.13364], [-117.94402, 34.13482], [-117.94341, 34.13538], [-117.94279, 34.13606], [-117.94249, 34.13642], [-117.93974, 34.13462], [-117.94295, 34.13132], [-117.94585, 34.12985], [-117.94689, 34.12888], [-117.94687, 34.12162], [-117.94251, 34.12163], [-117.94262, 34.118], [-117.93819, 34.11798], [-117.93817, 34.11927], [-117.93609, 34.11925], [-117.93609, 34.11897], [-117.93615, 34.11857], [-117.93688, 34.11521], [-117.93703, 34.11478], [-117.93726, 34.11441], [-117.94023, 34.11089], [-117.9404, 34.11063], [-117.94096, 34.11063], [-117.94293, 34.10827], [-117.94297, 34.1072], [-117.95999, 34.10704]]]} | Open Access 1 | Santa Fe Dam Recreation Area | http://parks.lacounty.gov/santa-fe-dam-recreational-area/ | 32698 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 912.62 | Santa Fe Dam Rec. Area |
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]);