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 ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, AGNCY_WEB
MNG_AGENCY 15
- Santa Barbara, City of 12
- Los Angeles, City of 3
- Carpinteria, City of 2
- San Diego, City of 1
- Fresno, City of 1
- Dana Point, City of 1
- Marina, City of 1
- Chico, City of 1
- Clovis, City of 1
- Guadalupe, City of 1
- Soledad, City of 1
- Woodland, City of 1
- Arcata, City of 1
- Rio Dell, City of 1
- Isleton, City of 1
MNG_AG_TYP 1
- City Agency · 29 ✖
ACCESS_TYP 1
- Unknown Access · 29 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11999 | 11999 | 11998 | {"type": "Polygon", "coordinates": [[[-118.47207, 33.99034], [-118.47192, 33.99044], [-118.47173, 33.99025], [-118.47189, 33.99014], [-118.47207, 33.99034]]]} | Unknown Access 4 | San Juan Garage | 28845 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.124 | San Juan Garage | ||
9291 | 9291 | 9290 | {"type": "Polygon", "coordinates": [[[-119.7228, 34.40994], [-119.7227, 34.41018], [-119.72251, 34.41013], [-119.72261, 34.40986], [-119.72277, 34.4099], [-119.7228, 34.40994]]]} | Unknown Access 4 | Santa Barbara holding 5 | 25047 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.148 | Santa Barbara holding 5 | ||
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 | ||
4792 | 4792 | 4791 | {"type": "Polygon", "coordinates": [[[-120.57752, 34.96378], [-120.57752, 34.96399], [-120.57714, 34.96399], [-120.57714, 34.96377], [-120.57752, 34.96378]]]} | Unknown Access 4 | Guadalupe holding 9 | 19554 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.205 | Guadalupe holding 9 | |||
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 | |||
9292 | 9292 | 9291 | {"type": "Polygon", "coordinates": [[[-119.72261, 34.40986], [-119.72251, 34.41013], [-119.72213, 34.41004], [-119.72223, 34.40976], [-119.72261, 34.40986]]]} | Unknown Access 4 | Santa Barbara holding 6 | 25048 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.289 | Santa Barbara holding 6 | ||
9288 | 9288 | 9287 | {"type": "Polygon", "coordinates": [[[-119.7227, 34.41018], [-119.72259, 34.41048], [-119.72256, 34.4105], [-119.72219, 34.41042], [-119.72232, 34.41009], [-119.7227, 34.41018]]]} | Unknown Access 4 | Santa Barbara holding 2 | 25044 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.342 | Santa Barbara holding 2 | ||
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 | ||
9334 | 9334 | 9333 | {"type": "Polygon", "coordinates": [[[-119.52773, 34.40703], [-119.52713, 34.40837], [-119.52698, 34.40879], [-119.52686, 34.40923], [-119.52678, 34.40968], [-119.52672, 34.40966], [-119.52675, 34.4094], [-119.52682, 34.40907], [-119.52689, 34.40883], [-119.52701, 34.40848], [-119.52766, 34.40701], [-119.52773, 34.40703]]]} | Unknown Access 4 | Santa Monica Creek | 25117 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 0.489 | Santa Monica Creek | ||
3043 | 3043 | 3042 | {"type": "Polygon", "coordinates": [[[-119.7272, 34.4336], [-119.72698, 34.43445], [-119.72664, 34.43545], [-119.72639, 34.43526], [-119.72657, 34.43483], [-119.72679, 34.43463], [-119.72695, 34.43445], [-119.72702, 34.43417], [-119.72681, 34.43413], [-119.72683, 34.43397], [-119.72706, 34.43399], [-119.72716, 34.43359], [-119.7272, 34.4336]]]} | Unknown Access 4 | El Mission Creek | 18514 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.723 | El Mission Creek | ||
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 | ||
9286 | 9286 | 9285 | {"type": "Polygon", "coordinates": [[[-119.69167, 34.45419], [-119.69138, 34.45435], [-119.691, 34.45433], [-119.69056, 34.45403], [-119.69059, 34.45371], [-119.69063, 34.45361], [-119.69071, 34.45352], [-119.69083, 34.45346], [-119.6913, 34.45343], [-119.69167, 34.45419]]]} | Unknown Access 4 | Santa Barbara holding 1 | 25042 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1.835 | Santa Barbara holding 1 | ||
2649 | 2649 | 2648 | {"type": "MultiPolygon", "coordinates": [[[[-119.50722, 34.39559], [-119.50661, 34.3957], [-119.50574, 34.39635], [-119.5055, 34.39636], [-119.50526, 34.39632], [-119.50526, 34.39623], [-119.50539, 34.39622], [-119.50563, 34.39619], [-119.50586, 34.39611], [-119.50597, 34.39606], [-119.50676, 34.39552], [-119.50722, 34.39559]]], [[[-119.51198, 34.39382], [-119.51152, 34.39386], [-119.51141, 34.39389], [-119.51064, 34.3943], [-119.51039, 34.39448], [-119.51014, 34.39416], [-119.51121, 34.39348], [-119.51144, 34.3934], [-119.51198, 34.39382]]]]} | Unknown Access 4 | Carpinteria Creek | 16897 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 2.293 | Carpinteria Creek | ||
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 | ||
11219 | 11219 | 11218 | {"type": "Polygon", "coordinates": [[[-121.80876, 39.76798], [-121.80871, 39.76806], [-121.80871, 39.76814], [-121.80873, 39.76815], [-121.80863, 39.76821], [-121.80864, 39.76851], [-121.80763, 39.76852], [-121.8071, 39.76788], [-121.80738, 39.76769], [-121.8079, 39.76741], [-121.8081, 39.76735], [-121.80827, 39.76733], [-121.80829, 39.76733], [-121.8083, 39.76746], [-121.80846, 39.76763], [-121.80856, 39.76768], [-121.80866, 39.76792], [-121.80876, 39.76798]]]} | Unknown Access 4 | Wildwood Estate Preserve | 27518 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 3.111 | Wildwood Estate Preserve | ||
7270 | 7270 | 7269 | {"type": "Polygon", "coordinates": [[[-119.79036, 36.76947], [-119.78888, 36.76947], [-119.78887, 36.7687], [-119.78891, 36.76869], [-119.78909, 36.7686], [-119.78999, 36.76854], [-119.79001, 36.76798], [-119.79035, 36.76797], [-119.79036, 36.76947]]]} | Unknown Access 4 | Ratcliffe Stadium | 24192 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 3.756 | Ratcliffe Stadium | ||
14944 | 14944 | 14943 | {"type": "Polygon", "coordinates": [[[-117.69372, 33.47577], [-117.69372, 33.47621], [-117.69164, 33.47621], [-117.69155, 33.4761], [-117.69185, 33.47517], [-117.69271, 33.47517], [-117.69279, 33.47543], [-117.69307, 33.47559], [-117.69326, 33.47577], [-117.69372, 33.47577]]]} | Unknown Access 4 | Stonehill Open Space | 25889 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 4.155 | Stonehill OS | ||
7141 | 7141 | 7140 | {"type": "Polygon", "coordinates": [[[-119.66557, 34.42181], [-119.6652, 34.42296], [-119.66446, 34.42284], [-119.66145, 34.42302], [-119.66143, 34.42284], [-119.66412, 34.42212], [-119.66557, 34.42181]]]} | Unknown Access 4 | Montecity Country Club | 22411 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 6.027 | Montecity Country Club | ||
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 | ||
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 |
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]);