superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 9 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2457 | 2457 | 2456 | {"type": "Polygon", "coordinates": [[[-118.23627, 33.89605], [-118.23616, 33.89604], [-118.23608, 33.89598], [-118.2362, 33.89598], [-118.23627, 33.89605]]]} | Open Access 1 | Compton Creek & Bike Path | 17572 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 0.02 | Compton Creek & Bike Path | ||
9196 | 9196 | 9195 | {"type": "MultiPolygon", "coordinates": [[[[-118.07211, 33.98316], [-118.0721, 33.98317], [-118.07151, 33.98276], [-118.07152, 33.98275], [-118.07211, 33.98316]]], [[[-118.07278, 33.98341], [-118.07277, 33.98343], [-118.07221, 33.98304], [-118.07222, 33.98303], [-118.07278, 33.98341]]], [[[-118.07399, 33.98445], [-118.07398, 33.98447], [-118.07355, 33.98418], [-118.07356, 33.98416], [-118.07399, 33.98445]]]]} | Open Access 1 | San Gabriel River & Bike Trail | 24897 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 0.082 | San Gabriel River & Bike Trail | ||
9283 | 9283 | 9282 | {"type": "Polygon", "coordinates": [[[-119.7122, 34.45864], [-119.71219, 34.45865], [-119.71206, 34.45871], [-119.71176, 34.45871], [-119.71175, 34.45848], [-119.71185, 34.45854], [-119.7122, 34.45864]]]} | Open Access 1 | Santa Barbara Botanic Gardens | 25037 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 0.145 | Santa Barbara Botanic Gardens | ||
3683 | 3683 | 3682 | {"type": "Polygon", "coordinates": [[[-119.73541, 34.4041], [-119.73541, 34.40426], [-119.73437, 34.40428], [-119.73407, 34.4042], [-119.73417, 34.40413], [-119.73405, 34.40365], [-119.73466, 34.40398], [-119.73541, 34.4041]]]} | Open Access 1 | Douglas Family Reserve | 18244 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 1.024 | Douglas Family Reserve | ||
11922 | 11922 | 11921 | {"type": "Polygon", "coordinates": [[[-120.44506, 34.91474], [-120.44502, 34.91664], [-120.44479, 34.91663], [-120.44483, 34.91473], [-120.44506, 34.91474]]]} | Open Access 1 | Santa Maria Valley Muli-Purpose Trail | 28709 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 1.107 | Santa Maria Valley Muli-Purpose Trail | ||
3497 | 3497 | 3496 | {"type": "Polygon", "coordinates": [[[-119.51853, 34.40523], [-119.51825, 34.40559], [-119.51773, 34.4064], [-119.51755, 34.40688], [-119.51721, 34.40679], [-119.51826, 34.40517], [-119.51853, 34.40523]]]} | Open Access 1 | Franklin Park | 19067 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 1.208 | Franklin Park | ||
13519 | 13519 | 13518 | {"type": "Polygon", "coordinates": [[[-119.90629, 36.8413], [-119.90545, 36.84133], [-119.90541, 36.84069], [-119.90626, 36.8407], [-119.90629, 36.8413]]]} | Open Access 1 | Basin EG Park | http://www.fresnofloodcontrol.org/ | 30974 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1.296 | Basin EG Park | |
7309 | 7309 | 7308 | {"type": "MultiPolygon", "coordinates": [[[[-118.38822, 33.8722], [-118.38765, 33.87247], [-118.38748, 33.87223], [-118.38807, 33.87196], [-118.38822, 33.8722]]], [[[-118.38856, 33.87271], [-118.38781, 33.87273], [-118.3877, 33.87257], [-118.38829, 33.8723], [-118.38856, 33.87271]]], [[[-118.38891, 33.87189], [-118.38834, 33.87214], [-118.38818, 33.87191], [-118.38876, 33.87164], [-118.38891, 33.87189]]]]} | Open Access 1 | Redondo Beach Open Space | 24240 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1.472 | Redondo Beach OS | ||
13176 | 13176 | 13175 | {"type": "Polygon", "coordinates": [[[-119.8233, 36.72501], [-119.82328, 36.72602], [-119.82268, 36.72602], [-119.8227, 36.72501], [-119.8233, 36.72501]]]} | Open Access 1 | Basin FF Park | http://www.fresnofloodcontrol.org/ | 30978 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1.472 | Basin FF Park | |
10395 | 10395 | 10394 | {"type": "MultiPolygon", "coordinates": [[[[-118.59921, 34.0992], [-118.59903, 34.09939], [-118.59861, 34.09959], [-118.59849, 34.0997], [-118.59839, 34.10003], [-118.59832, 34.10038], [-118.59776, 34.10077], [-118.59771, 34.10077], [-118.5977, 34.10064], [-118.59805, 34.10038], [-118.59816, 34.10024], [-118.59822, 34.10008], [-118.59827, 34.09982], [-118.59832, 34.09971], [-118.59838, 34.09965], [-118.59873, 34.09941], [-118.59894, 34.09917], [-118.59904, 34.09909], [-118.59921, 34.0992]]], [[[-118.60098, 34.097], [-118.60043, 34.09746], [-118.60002, 34.09794], [-118.59991, 34.09786], [-118.60007, 34.09761], [-118.60025, 34.09742], [-118.60077, 34.0971], [-118.60089, 34.09699], [-118.60096, 34.09691], [-118.60098, 34.097]]], [[[-118.60123, 34.09661], [-118.60104, 34.09701], [-118.60099, 34.09686], [-118.60102, 34.09679], [-118.60106, 34.0966], [-118.60103, 34.09619], [-118.60109, 34.09619], [-118.6011, 34.09645], [-118.60123, 34.09661]]]]} | Open Access 1 | Topanga Creek | 26407 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1.478 | Topanga Creek | ||
13536 | 13536 | 13535 | {"type": "Polygon", "coordinates": [[[-119.79715, 36.81648], [-119.79715, 36.81665], [-119.79656, 36.81674], [-119.79642, 36.81675], [-119.79629, 36.81674], [-119.79602, 36.81668], [-119.7959, 36.81662], [-119.79577, 36.81654], [-119.79559, 36.81636], [-119.79551, 36.81624], [-119.79546, 36.81614], [-119.79543, 36.81597], [-119.79715, 36.81648]]]} | Open Access 1 | Basin F Park | http://www.fresnofloodcontrol.org/ | 30976 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1.691 | Basin F Park | |
10475 | 10475 | 10474 | {"type": "Polygon", "coordinates": [[[-119.77525, 34.46378], [-119.77515, 34.46411], [-119.77508, 34.46423], [-119.77513, 34.46436], [-119.77498, 34.46477], [-119.77422, 34.46477], [-119.77427, 34.4643], [-119.77438, 34.46379], [-119.77525, 34.46378]]]} | Open Access 1 | Tuckers Grove Park | 26559 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2.064 | Tuckers Grove Park | ||
2340 | 2340 | 2339 | {"type": "Polygon", "coordinates": [[[-120.19548, 34.61923], [-120.19532, 34.62017], [-120.19414, 34.61966], [-120.19453, 34.61897], [-120.19477, 34.61907], [-120.19504, 34.61915], [-120.19548, 34.61923]]]} | Open Access 1 | Buellton Park | 16483 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2.399 | Buellton Park | ||
13558 | 13558 | 13557 | {"type": "Polygon", "coordinates": [[[-119.81224, 36.70994], [-119.8118, 36.70995], [-119.81185, 36.71007], [-119.81187, 36.71015], [-119.81186, 36.71035], [-119.81112, 36.71036], [-119.81112, 36.70874], [-119.81224, 36.70873], [-119.81224, 36.70994]]]} | Open Access 1 | Basin TT2 Park | http://www.fresnofloodcontrol.org/ | 30990 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 4.064 | Basin TT2 Park | |
13511 | 13511 | 13510 | {"type": "Polygon", "coordinates": [[[-119.8129, 36.79759], [-119.8129, 36.79813], [-119.80966, 36.79816], [-119.80965, 36.79807], [-119.80975, 36.79761], [-119.8129, 36.79759]]]} | Open Access 1 | Basin DD1 Park | http://www.fresnofloodcontrol.org/ | 30973 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 4.319 | Basin DD1 Park | |
14304 | 14304 | 14303 | {"type": "MultiPolygon", "coordinates": [[[[-120.45512, 34.65536], [-120.45512, 34.65556], [-120.45477, 34.65559], [-120.45508, 34.65538], [-120.45512, 34.65536]]], [[[-120.47548, 34.63445], [-120.47542, 34.63898], [-120.47512, 34.63897], [-120.47516, 34.63502], [-120.47511, 34.63485], [-120.47501, 34.63471], [-120.47493, 34.63465], [-120.47476, 34.63455], [-120.47466, 34.63452], [-120.4744, 34.6345], [-120.4744, 34.63445], [-120.47548, 34.63445]]], [[[-120.47539, 34.64089], [-120.47535, 34.64386], [-120.47512, 34.64386], [-120.47516, 34.64089], [-120.47539, 34.64089]]], [[[-120.4754, 34.63998], [-120.47539, 34.64067], [-120.47516, 34.64066], [-120.47517, 34.63998], [-120.4754, 34.63998]]]]} | Open Access 1 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28688 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 6.015 | |||
11898 | 11898 | 11897 | {"type": "Polygon", "coordinates": [[[-118.28909, 33.79761], [-118.28846, 33.79761], [-118.28848, 33.79601], [-118.28845, 33.79583], [-118.28838, 33.79573], [-118.28713, 33.79362], [-118.28712, 33.79355], [-118.28758, 33.79355], [-118.28786, 33.79404], [-118.28788, 33.79404], [-118.28789, 33.79287], [-118.28758, 33.79285], [-118.28758, 33.79272], [-118.28789, 33.79271], [-118.2879, 33.79285], [-118.28821, 33.79285], [-118.28806, 33.79287], [-118.28805, 33.79318], [-118.28805, 33.79435], [-118.2882, 33.7946], [-118.28884, 33.79461], [-118.28884, 33.79478], [-118.28832, 33.79478], [-118.28831, 33.7948], [-118.28881, 33.79566], [-118.28883, 33.79566], [-118.28884, 33.79547], [-118.289, 33.79552], [-118.28899, 33.79759], [-118.28909, 33.79761]]]} | Open Access 1 | Canada de Palos Verdes Creek | 28604 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 6.228 | Canada de Palos Verdes Creek | ||
13561 | 13561 | 13560 | {"type": "Polygon", "coordinates": [[[-119.83778, 36.76281], [-119.83769, 36.76282], [-119.83768, 36.76288], [-119.83567, 36.76288], [-119.83567, 36.76165], [-119.83777, 36.76164], [-119.83778, 36.76281]]]} | Open Access 1 | Basin XX Park | http://www.fresnofloodcontrol.org/ | 30993 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 6.358 | Basin XX Park | |
13552 | 13552 | 13551 | {"type": "Polygon", "coordinates": [[[-119.82186, 36.82104], [-119.82186, 36.82267], [-119.82071, 36.82268], [-119.82071, 36.82239], [-119.81998, 36.82168], [-119.81992, 36.8217], [-119.81966, 36.8217], [-119.81966, 36.82097], [-119.82, 36.82096], [-119.82002, 36.82105], [-119.82186, 36.82104]]]} | Open Access 1 | Basin I Park | http://www.fresnofloodcontrol.org/ | 30984 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 6.945 | Basin I Park | |
13503 | 13503 | 13502 | {"type": "Polygon", "coordinates": [[[-119.79668, 36.82475], [-119.79667, 36.82651], [-119.79493, 36.82652], [-119.79495, 36.82485], [-119.79576, 36.82483], [-119.79586, 36.8248], [-119.79593, 36.82475], [-119.79668, 36.82475]]]} | Open Access 1 | Basin H Park | http://www.fresnofloodcontrol.org/ | 30981 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 7.304 | Basin H Park |
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]);