superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where ACCESS_TYP = 4 and MNG_AG_TYP = 2 sorted by MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9293 | 9293 | 9292 | {"type": "Polygon", "coordinates": [[[-119.72232, 34.41009], [-119.72219, 34.41042], [-119.722, 34.41037], [-119.72213, 34.41004], [-119.72232, 34.41009]]]} | Unknown Access 4 | Santa Barbara holding 7 | 25049 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.176 | Santa Barbara holding 7 | ||
9294 | 9294 | 9293 | {"type": "Polygon", "coordinates": [[[-119.67454, 34.43385], [-119.6741, 34.43428], [-119.67275, 34.43326], [-119.67318, 34.43286], [-119.67454, 34.43385]]]} | Unknown Access 4 | Santa Barbara holding 8 | 25050 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 2.519 | Santa Barbara holding 8 | ||
9295 | 9295 | 9294 | {"type": "Polygon", "coordinates": [[[-119.67034, 34.43903], [-119.67034, 34.4395], [-119.66917, 34.4395], [-119.66941, 34.43903], [-119.67034, 34.43903]]]} | Unknown Access 4 | Santa Barbara holding 9 | 25051 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1.233 | Santa Barbara holding 9 | ||
9563 | 9563 | 9562 | {"type": "MultiPolygon", "coordinates": [[[[-119.69069, 34.44329], [-119.69064, 34.4434], [-119.69065, 34.44355], [-119.69068, 34.44362], [-119.69097, 34.44402], [-119.69099, 34.44413], [-119.69098, 34.44422], [-119.69094, 34.4443], [-119.69087, 34.44436], [-119.69029, 34.44464], [-119.69015, 34.44481], [-119.69014, 34.44384], [-119.68972, 34.44402], [-119.68956, 34.44406], [-119.68939, 34.44408], [-119.68783, 34.44396], [-119.68772, 34.44393], [-119.6876, 34.44389], [-119.68726, 34.44363], [-119.68703, 34.44354], [-119.68683, 34.44349], [-119.68629, 34.44347], [-119.68596, 34.4434], [-119.68596, 34.44324], [-119.68632, 34.44331], [-119.6869, 34.44334], [-119.6871, 34.44338], [-119.6873, 34.44346], [-119.68745, 34.44355], [-119.68767, 34.44372], [-119.68782, 34.44378], [-119.68937, 34.44392], [-119.68964, 34.44387], [-119.69015, 34.44364], [-119.69013, 34.44286], [-119.69069, 34.44329]]], [[[-119.69482, 34.44571], [-119.69452, 34.44628], [-119.69438, 34.44643], [-119.69253, 34.44663], [-119.69154, 34.4466], [-119.69056, 34.44614], [-119.69014, 34.44596], [-119.69015, 34.44498], [-119.69037, 34.44471], [-119.69094, 34.44446], [-119.69102, 34.4444], [-119.69109, 34.44429], [-119.69113, 34.44416], [-119.6911, 34.444], [-119.6908, 34.44353], [-119.69078, 34.44345], [-119.6908, 34.44337], [-119.69144, 34.44386], [-119.69193, 34.44417], [-119.69239, 34.44438], [-119.6932, 34.44461], [-119.69391, 34.4449], [-119.69482, 34.44571]]]]} | Unknown Access 4 | Sheffield Reservoir | 25382 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 26.257 | Sheffield Reservoir | ||
10172 | 10172 | 10171 | {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} | Unknown Access 4 | Sycamore Creek | 26121 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.446 | Sycamore Creek | ||
5357 | 5357 | 5356 | {"type": "Polygon", "coordinates": [[[-121.32208, 36.402], [-121.32178, 36.40221], [-121.32097, 36.40256], [-121.31938, 36.40316], [-121.31871, 36.40382], [-121.31838, 36.40545], [-121.318, 36.40469], [-121.31752, 36.40383], [-121.31755, 36.40364], [-121.31762, 36.40347], [-121.31775, 36.40326], [-121.31788, 36.40313], [-121.3181, 36.40297], [-121.31862, 36.40285], [-121.31927, 36.40262], [-121.31975, 36.40242], [-121.32168, 36.40147], [-121.32188, 36.40139], [-121.32208, 36.402]]]} | Unknown Access 4 | Los Coches Adobe | 21512 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 10.358 | Los Coches Adobe | ||
11551 | 11551 | 11550 | {"type": "Polygon", "coordinates": [[[-124.06854, 40.86404], [-124.0684, 40.86406], [-124.06846, 40.86466], [-124.06734, 40.86467], [-124.06703, 40.86377], [-124.06672, 40.86309], [-124.06685, 40.86302], [-124.06697, 40.86298], [-124.06725, 40.86295], [-124.06737, 40.86291], [-124.06748, 40.86283], [-124.06753, 40.86276], [-124.06754, 40.86269], [-124.06804, 40.86252], [-124.06795, 40.8623], [-124.0683, 40.86229], [-124.06839, 40.86331], [-124.06844, 40.86361], [-124.06854, 40.86404]]]} | Unknown Access 4 | Arcata Ridge Trail | 30248 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 6.435 | Arcata Ridge Trail | ||
12087 | 12087 | 12086 | {"type": "Polygon", "coordinates": [[[-124.10344, 40.4928], [-124.10326, 40.49301], [-124.10325, 40.49313], [-124.10297, 40.49313], [-124.10296, 40.49296], [-124.103, 40.49297], [-124.10313, 40.4928], [-124.10344, 40.4928]]]} | Unknown Access 4 | Unnamed site - Rio Dell, City of | 30545 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 0.236 | |||
9869 | 9869 | 9868 | {"type": "Polygon", "coordinates": [[[-121.72875, 38.64797], [-121.72864, 38.65335], [-121.72639, 38.65334], [-121.72638, 38.65153], [-121.71966, 38.65152], [-121.71964, 38.65159], [-121.7104, 38.65156], [-121.7105, 38.64787], [-121.72282, 38.64792], [-121.72283, 38.649], [-121.72589, 38.649], [-121.72593, 38.64795], [-121.72875, 38.64797]]]} | Unknown Access 4 | Spring Lake | 25739 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 160.736 | Spring Lake |
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]);