superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AG_LEV = 3 and YR_EST = 1951 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_WEB
MNG_AG_TYP 2
MNG_AGENCY 2
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6550 | 6550 | 6549 | {"type": "MultiPolygon", "coordinates": [[[[-118.67646, 34.03707], [-118.67629, 34.03715], [-118.67638, 34.03729], [-118.67622, 34.03728], [-118.6754, 34.0376], [-118.67481, 34.0378], [-118.67474, 34.03767], [-118.67555, 34.03741], [-118.6763, 34.03706], [-118.67642, 34.03702], [-118.67646, 34.03707]]], [[[-118.68069, 34.03475], [-118.68034, 34.03486], [-118.67997, 34.03502], [-118.67962, 34.0352], [-118.6793, 34.03539], [-118.67884, 34.03574], [-118.67771, 34.0367], [-118.67744, 34.03647], [-118.67726, 34.03661], [-118.67677, 34.03691], [-118.67665, 34.03693], [-118.67654, 34.03698], [-118.67647, 34.03688], [-118.67663, 34.03681], [-118.67677, 34.03672], [-118.67699, 34.03656], [-118.67734, 34.03625], [-118.6779, 34.03553], [-118.67822, 34.03495], [-118.67858, 34.0341], [-118.67889, 34.03394], [-118.67915, 34.03376], [-118.67926, 34.03353], [-118.67958, 34.03389], [-118.67912, 34.03417], [-118.67883, 34.03473], [-118.67917, 34.03516], [-118.67947, 34.03501], [-118.67978, 34.03488], [-118.67983, 34.03492], [-118.6801, 34.03483], [-118.68027, 34.0348], [-118.68066, 34.03468], [-118.68069, 34.03475]]], [[[-118.68268, 34.03131], [-118.682, 34.03166], [-118.68189, 34.0319], [-118.68113, 34.03114], [-118.68152, 34.03111], [-118.68266, 34.03076], [-118.68268, 34.03131]]]]} | Open Access 1 | Malibu Lagoon State Beach | http://www.parks.ca.gov/?page_id=835 | 21710 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 9.808 | Malibu Lagoon SB | 1951 |
5718 | 5718 | 5717 | {"type": "Polygon", "coordinates": [[[-122.54867, 38.41193], [-122.54776, 38.4126], [-122.54691, 38.41186], [-122.54758, 38.41137], [-122.54782, 38.41122], [-122.54824, 38.41153], [-122.54867, 38.41193]]]} | Open Access 1 | Kenwood Plaza Park | 20624 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 2.981 | Kenwood Plaza Park | 1951 | |
9579 | 9579 | 9578 | {"type": "Polygon", "coordinates": [[[-122.55176, 38.41643], [-122.55043, 38.4173], [-122.54968, 38.41667], [-122.55088, 38.41584], [-122.55139, 38.41623], [-122.55147, 38.4162], [-122.55176, 38.41643]]]} | Open Access 1 | Shaw Park | 25376 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 3.508 | Shaw Park | 1951 |
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]);