units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where ACCESS_TYP = 1, DES_TP = 2 and YR_EST = 2016
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
200 | 200 | 199 | {"type": "Polygon", "coordinates": [[[-122.73156, 38.45287], [-122.73152, 38.45293], [-122.7309, 38.45305], [-122.73084, 38.45292], [-122.73075, 38.45281], [-122.73039, 38.4517], [-122.73106, 38.45137], [-122.73117, 38.4516], [-122.73156, 38.45287]]]} | Open Access 1 | 47323 | Finali Park | 31030 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | https://srcity.org/Facilities/Facility/Details/Finali-Park-66 | Sonoma 16 | 2.768 | Finali Park | 2016 | Local Park 2 | 4 |
4131 | 4131 | 4130 | {"type": "Polygon", "coordinates": [[[-118.54299, 34.19064], [-118.54284, 34.19074], [-118.54242, 34.19049], [-118.54196, 34.1903], [-118.54174, 34.19014], [-118.54291, 34.18966], [-118.54291, 34.19054], [-118.54299, 34.19064]]]} | Open Access 1 | 47400 | Los Angeles River and Aliso Creek Confluence Park | 31121 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.tpl.org/our-work/los-angeles-river-aliso-creek-confluence-project | Los Angeles 6 | 1.682 | Los Angeles River and Aliso Creek Confluence Park | 2016 | Local Park 2 | 4 |
4464 | 4464 | 4463 | {"type": "Polygon", "coordinates": [[[-118.2356, 34.04165], [-118.23514, 34.0417], [-118.23507, 34.04127], [-118.23553, 34.04121], [-118.2356, 34.04165]]]} | Open Access 1 | 46647 | Arts District Park | 32785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.514 | Arts District Park | 2016 | Local Park 2 | 4 | |
4787 | 4787 | 4786 | {"type": "Polygon", "coordinates": [[[-120.86036, 37.48086], [-120.85915, 37.48087], [-120.85916, 37.48008], [-120.86035, 37.48008], [-120.86036, 37.48086]]]} | Open Access 1 | 48062 | Montana Park | 32554 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 2.273 | Montana Park | 2016 | Local Park 2 | 4 | |
5165 | 5165 | 5164 | {"type": "Polygon", "coordinates": [[[-122.35762, 38.40022], [-122.35748, 38.40034], [-122.3573, 38.40051], [-122.35739, 38.39999], [-122.3576, 38.39989], [-122.35762, 38.40022]]]} | Open Access 1 | 47672 | Oak Circle Neighborhood Park | 31413 | 1385 | Yountville, Town of 730 | City 2 | City Agency 2 | http://www.townofyountville.com/index.aspx?page=88 | City 2 | 1385 | Yountville, Town of 714 | City 2 | City Agency 2 | Napa 11 | 0.249 | Oak Circle Neighborhood Park | 2016 | Local Park 2 | 4 | |
5626 | 5626 | 5625 | {"type": "Polygon", "coordinates": [[[-118.41054, 34.22709], [-118.4103, 34.22778], [-118.40776, 34.22897], [-118.40741, 34.22916], [-118.40705, 34.2294], [-118.407, 34.22941], [-118.40696, 34.22939], [-118.404, 34.22662], [-118.40712, 34.22434], [-118.40755, 34.22467], [-118.40844, 34.22521], [-118.40886, 34.2255], [-118.41022, 34.22678], [-118.41054, 34.22709]]]} | Open Access 1 | 45413 | Sheldon-Arleta Park | 28186 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.laparks.org/dos/parks/facility/devonshireArletaPk.htm | Los Angeles 6 | 45.127 | Sheldon-Arleta Park | 2016 | Local Park 2 | 4 |
6258 | 6258 | 6257 | {"type": "Polygon", "coordinates": [[[-119.18952, 34.19789], [-119.18952, 34.19806], [-119.18886, 34.19806], [-119.18888, 34.19845], [-119.18803, 34.19844], [-119.18803, 34.19787], [-119.18952, 34.19789]]]} | Open Access 1 | 48414 | Campus Park Dog Park | 33011 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/dog-park-opening/ | Ventura 8 | 1.496 | Campus Park Dog Park | 2016 | Local Park 2 | 4 |
8431 | 8431 | 8430 | {"type": "Polygon", "coordinates": [[[-116.11475, 33.49908], [-116.11464, 33.49907], [-116.11444, 33.49899], [-116.11438, 33.49899], [-116.11432, 33.499], [-116.11427, 33.49903], [-116.11423, 33.49911], [-116.11424, 33.49915], [-116.11428, 33.4992], [-116.11437, 33.49925], [-116.11474, 33.49925], [-116.11474, 33.50009], [-116.11268, 33.5001], [-116.11267, 33.49735], [-116.11474, 33.49735], [-116.11475, 33.49908]]]} | Open Access 1 | 48519 | Oasis Community Park | 33232 | 2216 | Desert Recreation District 286 | Special District 4 | Recreation/Parks District 4 | http://www.myrecreationdistrict.com | Special District 4 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | https://myrecreationdistrict.com/community-fun/oasis | Riverside 10 | 14.165 | Oasis Community Park | 2016 | Local Park 2 | 4 |
9629 | 9629 | 9628 | {"type": "Polygon", "coordinates": [[[-118.00178, 34.13276], [-118.00168, 34.13302], [-118.00144, 34.13297], [-118.00143, 34.13326], [-118.00096, 34.13325], [-118.00096, 34.13303], [-118.00094, 34.13296], [-118.00095, 34.13262], [-118.00102, 34.13264], [-118.00103, 34.13262], [-118.00163, 34.13273], [-118.00164, 34.13272], [-118.00178, 34.13276]]]} | Open Access 1 | 47851 | Station Square Park | 31797 | 1209 | Monrovia, City of 312 | City 2 | City Agency 2 | http://www.cityofmonrovia.org/publicworks/page/parks | City 2 | 1209 | Monrovia, City of 309 | City 2 | City Agency 2 | https://www.cityofmonrovia.org/Home/Components/FacilityDirectory/FacilityDirectory/16/787 | Los Angeles 6 | 0.95 | Station Square Park | 2016 | Local Park 2 | 4 |
15322 | 15322 | 15321 | {"type": "Polygon", "coordinates": [[[-117.84833, 33.96677], [-117.84766, 33.96715], [-117.84745, 33.96733], [-117.84713, 33.96767], [-117.84701, 33.96771], [-117.84699, 33.96774], [-117.8468, 33.96774], [-117.8468, 33.96772], [-117.84666, 33.96772], [-117.84618, 33.96778], [-117.84613, 33.96766], [-117.84619, 33.96762], [-117.8462, 33.96756], [-117.84623, 33.96755], [-117.84629, 33.96747], [-117.84634, 33.96746], [-117.84671, 33.96683], [-117.84686, 33.96663], [-117.84697, 33.96655], [-117.84715, 33.9665], [-117.84727, 33.96651], [-117.8473, 33.96648], [-117.84718, 33.96644], [-117.84698, 33.96642], [-117.84673, 33.96634], [-117.84665, 33.96633], [-117.84658, 33.96626], [-117.84648, 33.96621], [-117.84643, 33.96629], [-117.84617, 33.96619], [-117.8459, 33.96634], [-117.84585, 33.96623], [-117.8458, 33.96617], [-117.84555, 33.96607], [-117.8453, 33.96591], [-117.84508, 33.96583], [-117.84502, 33.96576], [-117.84498, 33.96566], [-117.84502, 33.9657], [-117.84507, 33.96572], [-117.84518, 33.96571], [-117.8469, 33.96621], [-117.84705, 33.96627], [-117.84764, 33.96656], [-117.8478, 33.96635], [-117.84796, 33.96641], [-117.84817, 33.96659], [-117.84814, 33.96665], [-117.84815, 33.96671], [-117.84818, 33.96673], [-117.84826, 33.96675], [-117.84831, 33.96674], [-117.84833, 33.96677]]]} | Open Access 1 | 46486 | Diamond Canyon Park | 31870 | 1085 | Diamond Bar, City of 315 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | Los Angeles 6 | 4.985 | Diamond Canyon Park | 2016 | Local Park 2 | 4 | |
16414 | 16414 | 16413 | {"type": "Polygon", "coordinates": [[[-121.96185, 37.57989], [-121.96136, 37.58008], [-121.96009, 37.58126], [-121.95896, 37.58058], [-121.95651, 37.5797], [-121.95482, 37.57916], [-121.95245, 37.5782], [-121.95134, 37.57963], [-121.9513, 37.57974], [-121.95027, 37.58068], [-121.95033, 37.58077], [-121.95032, 37.58091], [-121.95009, 37.581], [-121.94936, 37.58153], [-121.94913, 37.58161], [-121.94988, 37.58326], [-121.94994, 37.58359], [-121.95368, 37.58319], [-121.95714, 37.58286], [-121.95905, 37.58265], [-121.95888, 37.58306], [-121.95919, 37.5848], [-121.95871, 37.58618], [-121.95904, 37.58686], [-121.95896, 37.58689], [-121.95861, 37.58708], [-121.95844, 37.58734], [-121.9583, 37.58743], [-121.95817, 37.58763], [-121.95687, 37.58866], [-121.95651, 37.58876], [-121.95614, 37.58878], [-121.95596, 37.58883], [-121.95569, 37.58881], [-121.95545, 37.58884], [-121.95525, 37.58898], [-121.95474, 37.58917], [-121.95406, 37.58935], [-121.95351, 37.58957], [-121.95286, 37.58975], [-121.95253, 37.58991], [-121.95203, 37.59006], [-121.95155, 37.59016], [-121.95136, 37.59028], [-121.95105, 37.59029], [-121.95097, 37.59067], [-121.95072, 37.59077], [-121.94787, 37.59175], [-121.94787, 37.59177], [-121.94801, 37.59185], [-121.948, 37.59278], [-121.94835, 37.59315], [-121.94856, 37.59424], [-121.94881, 37.59456], [-121.94934, 37.59486], [-121.94961, 37.59494], [-121.94957, 37.59508], [-121.94868, 37.59596], [-121.94995, 37.59692], [-121.94911, 37.59716], [-121.94728, 37.59742], [-121.94711, 37.59741], [-121.94706, 37.59737], [-121.94699, 37.59717], [-121.94669, 37.59704], [-121.94594, 37.59687], [-121.94494, 37.59694], [-121.94424, 37.59694], [-121.94375, 37.59699], [-121.94289, 37.59728], [-121.94261, 37.59733], [-121.94155, 37.5977], [-121.94096, 37.59805], [-121.94051, 37.59822], [-121.94001, 37.59832], [-121.93944, 37.59839], [-121.93886, 37.59837], [-121.93856, 37.5982], [-121.93827, 37.59798], [-121.93812, 37.59779], [-121.93805, 37.59763], [-121.93803, 37.59733], [-121.93805, 37.59691], [-121.93814, 37.59689], [-121.94449, 37.5966], [-121.94453, 37.59589], [-121.93949, 37.59431], [-121.93954, 37.5932], [-121.93939, 37.59171], [-121.93776, 37.59095], [-121.93569, 37.5872], [-121.93383, 37.5841], [-121.93239, 37.58293], [-121.93293, 37.58241], [-121.93027, 37.58028], [-121.92941, 37.57875], [-121.93081, 37.57686], [-121.93131, 37.57628], [-121.93276, 37.57397], [-121.93383, 37.57506], [-121.93618, 37.57415], [-121.93661, 37.57385], [-121.93738, 37.57328], [-121.938, 37.57258], [-121.93855, 37.57206], [-121.93889, 37.57182], [-121.93938, 37.57122], [-121.93957, 37.57078], [-121.93968, 37.57071], [-121.94005, 37.57056], [-121.94039, 37.57051], [-121.94048, 37.57052], [-121.94067, 37.57049], [-121.94222, 37.57063], [-121.94283, 37.57077], [-121.94359, 37.57069], [-121.94377, 37.5705], [-121.94417, 37.57054], [-121.94422, 37.57052], [-121.94445, 37.57055], [-121.94496, 37.57023], [-121.94579, 37.57009], [-121.94644, 37.56994], [-121.94675, 37.56992], [-121.94722, 37.56996], [-121.9478, 37.56989], [-121.94801, 37.56988], [-121.94827, 37.56992], [-121.94853, 37.57001], [-121.94885, 37.57014], [-121.94932, 37.5704], [-121.94961, 37.57049], [-121.94978, 37.5705], [-121.95006, 37.57043], [-121.95033, 37.57046], [-121.95075, 37.57047], [-121.95149, 37.57059], [-121.95202, 37.57059], [-121.95235, 37.57069], [-121.95259, 37.57072], [-121.95318, 37.5706], [-121.9542, 37.5703], [-121.95482, 37.57017], [-121.95499, 37.5701], [-121.95582, 37.56967], [-121.95694, 37.57054], [-121.95788, 37.57133], [-121.95821, 37.57193], [-121.95852, 37.574], [-121.95896, 37.57507], [-121.95935, 37.57641], [-121.96086, 37.57834], [-121.96185, 37.57989]], [[-121.95724, 37.58544], [-121.95711, 37.58574], [-121.95776, 37.58592], [-121.95788, 37.58561], [-121.95724, 37.58544]]]} | Open Access 1 | 46992 | Vargas Plateau Regional Park | 30630 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1260.39 | Vargas Plateau RP | 2016 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);