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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
14789 | 14789 | 14788 | {"type": "Polygon", "coordinates": [[[-116.9793, 33.00015], [-116.97875, 33.00754], [-116.96993, 33.00757], [-116.96172, 33.00767], [-116.9618, 33.00385], [-116.96605, 33.00387], [-116.9661, 33.0001], [-116.97037, 33.00014], [-116.9793, 33.00015]], [[-116.96341, 33.00537], [-116.96341, 33.00535], [-116.96301, 33.00517], [-116.96283, 33.00519], [-116.96283, 33.00535], [-116.9626, 33.00539], [-116.96258, 33.00528], [-116.96209, 33.00531], [-116.96211, 33.0057], [-116.96243, 33.0057], [-116.96285, 33.00559], [-116.96301, 33.00552], [-116.96317, 33.00548], [-116.96341, 33.00537]]]} | Unknown Access 4 | City of San Diego Open Space | 17331 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 287.287 | City of San Diego OS | ||
14637 | 14637 | 14636 | {"type": "MultiPolygon", "coordinates": [[[[-121.75791, 36.68606], [-121.75595, 36.68696], [-121.75593, 36.68608], [-121.75451, 36.68365], [-121.75257, 36.68073], [-121.75146, 36.6801], [-121.74911, 36.6779], [-121.75195, 36.67676], [-121.75214, 36.67632], [-121.75247, 36.67453], [-121.75354, 36.67429], [-121.75391, 36.67753], [-121.75535, 36.67855], [-121.75536, 36.68165], [-121.75539, 36.682], [-121.75791, 36.68606]]], [[[-121.77964, 36.68834], [-121.7669, 36.69278], [-121.76637, 36.69229], [-121.76571, 36.69188], [-121.76504, 36.69157], [-121.76357, 36.68898], [-121.76719, 36.68783], [-121.76848, 36.68844], [-121.76912, 36.68756], [-121.77161, 36.68874], [-121.77355, 36.68598], [-121.77129, 36.68474], [-121.77174, 36.68425], [-121.77964, 36.68834]]]]} | Unknown Access 4 | Fort Ord National Monument | 19010 | 1197 | Marina, City of 212 | City 2 | City Agency 2 | http://www.ci.marina.ca.us/index.aspx?NID=25 | City 2 | 205.588 | Fort Ord NM | 2012 | |
14330 | 14330 | 14329 | {"type": "Polygon", "coordinates": [[[-118.28418, 34.23377], [-118.28386, 34.23376], [-118.28045, 34.23393], [-118.27981, 34.23393], [-118.27975, 34.22908], [-118.27539, 34.22911], [-118.27538, 34.22816], [-118.28411, 34.2281], [-118.28418, 34.23377]]]} | Unknown Access 4 | Unnamed site - Los Angeles, City of | 29809 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 73.678 | |||
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 | |||
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 | ||
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 | ||
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 | ||
10409 | 10409 | 10408 | {"type": "Polygon", "coordinates": [[[-118.57142, 34.12782], [-118.57142, 34.12931], [-118.56528, 34.12931], [-118.5662, 34.12783], [-118.57142, 34.12782]]]} | Unknown Access 4 | Steers Property | 28848 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 21.35 | Steers Property | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);