superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where ACCESS_TYP = 4 and MNG_AG_LEV = 3 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10121 | 10121 | 10120 | {"type": "Polygon", "coordinates": [[[-117.96399, 33.63508], [-117.96237, 33.63687], [-117.96074, 33.63584], [-117.95743, 33.63372], [-117.958, 33.63182], [-117.96399, 33.63508]]]} | Unknown Access 4 | Talbert Marsh | 26170 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 34.688 | Talbert Marsh | ||
12025 | 12025 | 12024 | {"type": "Polygon", "coordinates": [[[-118.19408, 33.89118], [-118.19324, 33.89119], [-118.19323, 33.89102], [-118.19407, 33.89102], [-118.19408, 33.89118]]]} | Unknown Access 4 | Washington Ave Park | 28912 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.359 | Washington Ave Park | ||
12028 | 12028 | 12027 | {"type": "Polygon", "coordinates": [[[-118.59334, 34.29692], [-118.59288, 34.29636], [-118.59275, 34.29613], [-118.59187, 34.29638], [-118.5913, 34.29686], [-118.59115, 34.29672], [-118.5903, 34.29651], [-118.58963, 34.29617], [-118.59055, 34.2929], [-118.59249, 34.29293], [-118.59294, 34.2935], [-118.593, 34.29362], [-118.59302, 34.29375], [-118.59298, 34.29407], [-118.59299, 34.29418], [-118.59309, 34.29447], [-118.59311, 34.29458], [-118.5931, 34.29469], [-118.59292, 34.29524], [-118.59332, 34.29526], [-118.59334, 34.29692]]]} | Unknown Access 4 | Browns Canyon | 28917 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 27.202 | Browns Canyon | ||
4862 | 4862 | 4861 | {"type": "Polygon", "coordinates": [[[-119.63709, 34.41583], [-119.63704, 34.41641], [-119.63642, 34.41654], [-119.63646, 34.41695], [-119.63641, 34.41723], [-119.63631, 34.41757], [-119.63611, 34.41758], [-119.63581, 34.41763], [-119.63571, 34.41761], [-119.63562, 34.41754], [-119.6355, 34.41737], [-119.6354, 34.4173], [-119.63519, 34.41724], [-119.63496, 34.41724], [-119.63485, 34.41687], [-119.6343, 34.41697], [-119.6338, 34.41711], [-119.63385, 34.41696], [-119.63423, 34.41679], [-119.635, 34.41663], [-119.63563, 34.41644], [-119.63623, 34.4162], [-119.6365, 34.41604], [-119.63678, 34.4159], [-119.63709, 34.41583]]]} | Unknown Access 4 | Hammond's Meadow | 19627 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 5.374 | Hammond's Meadow | ||
9284 | 9284 | 9283 | {"type": "Polygon", "coordinates": [[[-119.69543, 34.43397], [-119.69509, 34.43541], [-119.69424, 34.43537], [-119.69419, 34.43629], [-119.69257, 34.4363], [-119.69256, 34.43377], [-119.69278, 34.43351], [-119.6928, 34.43343], [-119.69302, 34.43324], [-119.69368, 34.43246], [-119.69391, 34.43263], [-119.69364, 34.43294], [-119.69351, 34.43319], [-119.69331, 34.43329], [-119.69335, 34.43335], [-119.69344, 34.43332], [-119.69346, 34.43333], [-119.69365, 34.43368], [-119.69373, 34.43372], [-119.69382, 34.43371], [-119.69383, 34.43374], [-119.69527, 34.43376], [-119.69516, 34.43396], [-119.69543, 34.43397]]]} | Unknown Access 4 | Santa Barbara Bowl | 25038 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 16.563 | Santa Barbara Bowl | ||
9256 | 9256 | 9255 | {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} | Unknown Access 4 | San Roque Creek | 24990 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.477 | San Roque Creek | ||
9287 | 9287 | 9286 | {"type": "Polygon", "coordinates": [[[-120.45861, 34.63105], [-120.4586, 34.6313], [-120.45841, 34.63139], [-120.45828, 34.63142], [-120.45798, 34.63146], [-120.45797, 34.63153], [-120.45768, 34.63151], [-120.45734, 34.63146], [-120.45735, 34.63104], [-120.45861, 34.63105]]]} | Unknown Access 4 | Santa Barbara holding 11 | 25043 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.308 | Santa Barbara holding 11 | ||
7950 | 7950 | 7949 | {"type": "Polygon", "coordinates": [[[-120.49458, 34.67098], [-120.49431, 34.67124], [-120.49306, 34.67174], [-120.493, 34.6711], [-120.49457, 34.67081], [-120.49458, 34.67098]]]} | Unknown Access 4 | Santa Ynez River | 25145 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.883 | Santa Ynez River | ||
8530 | 8530 | 8529 | {"type": "Polygon", "coordinates": [[[-121.06665, 38.48801], [-121.0665, 38.48804], [-121.06649, 38.48829], [-121.06662, 38.48833], [-121.0666, 38.48893], [-121.06601, 38.48906], [-121.06516, 38.48893], [-121.0642, 38.48821], [-121.06273, 38.4882], [-121.06281, 38.48584], [-121.06337, 38.48587], [-121.06379, 38.48587], [-121.06455, 38.48582], [-121.06477, 38.48646], [-121.06523, 38.48658], [-121.06538, 38.4864], [-121.06538, 38.48637], [-121.06576, 38.48631], [-121.06577, 38.48628], [-121.06593, 38.48617], [-121.06631, 38.48611], [-121.06638, 38.48641], [-121.06637, 38.48651], [-121.06643, 38.48659], [-121.06639, 38.48664], [-121.06635, 38.48686], [-121.06632, 38.48713], [-121.06624, 38.48716], [-121.06619, 38.48722], [-121.06619, 38.48727], [-121.06624, 38.48732], [-121.0662, 38.48737], [-121.06622, 38.48761], [-121.06642, 38.48761], [-121.06645, 38.48781], [-121.06663, 38.4878], [-121.06665, 38.48801]]]} | Unknown Access 4 | Rancho Murieta Association | 24158 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 21.809 | Rancho Murieta Association | ||
6016 | 6016 | 6015 | {"type": "Polygon", "coordinates": [[[-121.08537, 37.50062], [-121.08475, 37.50123], [-121.08407, 37.50118], [-121.08416, 37.50091], [-121.0842, 37.50073], [-121.08421, 37.50005], [-121.0838, 37.49907], [-121.08359, 37.4984], [-121.08321, 37.49772], [-121.08342, 37.49748], [-121.08455, 37.49999], [-121.08535, 37.50032], [-121.08537, 37.50062]]]} | Unknown Access 4 | Las Palmas Fishing Access | 21059 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 4.585 | Las Palmas FA | ||
4922 | 4922 | 4921 | {"type": "Polygon", "coordinates": [[[-121.23657, 38.39513], [-121.23642, 38.3951], [-121.23642, 38.39505], [-121.23657, 38.39498], [-121.23657, 38.39513]]]} | Unknown Access 4 | Harrison Larry L/Tonya A | 19699 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.035 | Harrison Larry L/Tonya A | ||
9393 | 9393 | 9392 | {"type": "Polygon", "coordinates": [[[-121.25202, 38.40904], [-121.25157, 38.40901], [-121.25157, 38.40891], [-121.25154, 38.40884], [-121.25164, 38.40866], [-121.25175, 38.40863], [-121.25192, 38.40869], [-121.25202, 38.40883], [-121.25202, 38.40904]]]} | Unknown Access 4 | Schnabel Tentative Parcel Map | 25185 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.365 | Schnabel Tentative Parcel Map | ||
4721 | 4721 | 4720 | {"type": "Polygon", "coordinates": [[[-121.26584, 38.41176], [-121.26406, 38.41179], [-121.26392, 38.41155], [-121.26373, 38.41107], [-121.26365, 38.41082], [-121.2645, 38.41003], [-121.26465, 38.41], [-121.26491, 38.41005], [-121.26516, 38.4102], [-121.26531, 38.41033], [-121.2654, 38.41046], [-121.26549, 38.41072], [-121.26554, 38.41094], [-121.26582, 38.41152], [-121.26584, 38.41165], [-121.26584, 38.41176]]]} | Unknown Access 4 | Green Rd Subdivision Map | 19466 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 6.619 | Green Rd Subdivision Map | ||
14636 | 14636 | 14635 | {"type": "Polygon", "coordinates": [[[-121.75829, 36.65049], [-121.75826, 36.65096], [-121.75819, 36.65109], [-121.75816, 36.6512], [-121.75807, 36.65183], [-121.75806, 36.65201], [-121.75811, 36.65229], [-121.75831, 36.65285], [-121.75843, 36.65362], [-121.75848, 36.65401], [-121.75847, 36.65412], [-121.75819, 36.65486], [-121.75817, 36.65494], [-121.7579, 36.65558], [-121.75703, 36.65555], [-121.75709, 36.65542], [-121.75708, 36.6554], [-121.75624, 36.65543], [-121.74772, 36.65543], [-121.74657, 36.6554], [-121.74183, 36.65517], [-121.74167, 36.65507], [-121.74157, 36.65493], [-121.74153, 36.6547], [-121.74153, 36.65457], [-121.74156, 36.65448], [-121.74185, 36.65405], [-121.74188, 36.65398], [-121.74188, 36.65391], [-121.74182, 36.6538], [-121.74175, 36.65374], [-121.7415, 36.65361], [-121.74136, 36.65358], [-121.7414, 36.65302], [-121.74138, 36.65188], [-121.7413, 36.6513], [-121.74126, 36.65109], [-121.7412, 36.65089], [-121.73931, 36.65132], [-121.73901, 36.65136], [-121.7388, 36.65134], [-121.73865, 36.65131], [-121.73791, 36.65105], [-121.73768, 36.65101], [-121.73745, 36.651], [-121.73629, 36.64792], [-121.73691, 36.64783], [-121.73739, 36.64771], [-121.73761, 36.64764], [-121.73828, 36.64735], [-121.73875, 36.64718], [-121.73943, 36.64698], [-121.73976, 36.64691], [-121.73998, 36.64689], [-121.74017, 36.6469], [-121.74104, 36.64702], [-121.74115, 36.64706], [-121.74168, 36.64713], [-121.74321, 36.64687], [-121.74484, 36.64683], [-121.74556, 36.64678], [-121.74671, 36.6468], [-121.74782, 36.64724], [-121.74861, 36.64695], [-121.74939, 36.64676], [-121.75021, 36.64666], [-121.75056, 36.64656], [-121.75106, 36.64636], [-121.75164, 36.64623], [-121.75173, 36.6462], [-121.75216, 36.64585], [-121.75221, 36.64584], [-121.75256, 36.64579], [-121.75285, 36.6457], [-121.75302, 36.64571], [-121.75319, 36.64569], [-121.75354, 36.64548], [-121.754, 36.64537], [-121.75433, 36.64539], [-121.75485, 36.64523], [-121.75516, 36.64547], [-121.75558, 36.64614], [-121.75605, 36.6466], [-121.75639, 36.64713], [-121.75641, 36.64713], [-121.75651, 36.64702], [-121.75654, 36.64705], [-121.75668, 36.64717], [-121.75683, 36.64733], [-121.75708, 36.64767], [-121.75727, 36.64819], [-121.75747, 36.64839], [-121.75753, 36.64849], [-121.75766, 36.64884], [-121.75789, 36.64906], [-121.75795, 36.64914], [-121.75795, 36.64921], [-121.75785, 36.64936], [-121.75786, 36.64948], [-121.75811, 36.64986], [-121.75814, 36.64996], [-121.75815, 36.6501], [-121.75825, 36.65034], [-121.75826, 36.65042], [-121.75829, 36.65049]]]} | Unknown Access 4 | Fort Ord National Monument | 19009 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 401.41 | Fort Ord NM | 2012 | |
4238 | 4238 | 4237 | {"type": "Polygon", "coordinates": [[[-121.76487, 36.22671], [-121.76455, 36.22693], [-121.76407, 36.227], [-121.76385, 36.22719], [-121.76369, 36.22707], [-121.76348, 36.22697], [-121.76368, 36.22607], [-121.76441, 36.22592], [-121.76478, 36.22637], [-121.76487, 36.22671]]]} | Unknown Access 4 | First Growth | 18915 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 2.843 | First Growth | ||
4174 | 4174 | 4173 | {"type": "Polygon", "coordinates": [[[-121.81231, 36.23946], [-121.8123, 36.24002], [-121.81077, 36.23999], [-121.81078, 36.23944], [-121.81113, 36.23944], [-121.81114, 36.23898], [-121.81198, 36.23899], [-121.81198, 36.23945], [-121.81231, 36.23946]]]} | Unknown Access 4 | Falotico | 18839 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 3.056 | Falotico | ||
5687 | 5687 | 5686 | {"type": "Polygon", "coordinates": [[[-124.21314, 41.8682], [-124.213, 41.86893], [-124.21297, 41.86902], [-124.21287, 41.86916], [-124.21219, 41.86918], [-124.21116, 41.86925], [-124.21155, 41.8682], [-124.21314, 41.86807], [-124.21314, 41.8682]]]} | Unknown Access 4 | Kellogg Beach | 20579 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 4.007 | Kellogg Beach |
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]);