units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where ACCESS_TYP = 1, DES_TP = 2 and YR_EST = 2017
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 5
ACCESS_TYP 1
- Open Access · 20 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1432 | 1432 | 1431 | {"type": "Polygon", "coordinates": [[[-121.88594, 37.31445], [-121.88536, 37.31483], [-121.88518, 37.31455], [-121.88449, 37.31485], [-121.88433, 37.31463], [-121.88552, 37.31397], [-121.88594, 37.31445]]]} | Open Access 1 | 48980 | Tamien Park | 33676 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | https://www.mercurynews.com/2017/06/21/tamien-park-opens-after-22-years-of-planning/ | Santa Clara 19 | 1.588 | Tamien Park | 2017 | Local Park 2 | 4 |
2140 | 2140 | 2139 | {"type": "Polygon", "coordinates": [[[-118.33945, 33.91357], [-118.33843, 33.91357], [-118.33843, 33.91322], [-118.33945, 33.91321], [-118.33945, 33.91357]]]} | Open Access 1 | 6180 | Bicentennial Park | 33375 | 1130 | Hawthorne, City of 299 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 0.911 | Bicentennial Park | 2017 | Local Park 2 | 4 | |
3297 | 3297 | 3296 | {"type": "Polygon", "coordinates": [[[-119.29982, 36.32794], [-119.29965, 36.32791], [-119.2994, 36.32779], [-119.29924, 36.32763], [-119.29911, 36.32757], [-119.29892, 36.32754], [-119.29892, 36.32746], [-119.29982, 36.32746], [-119.29982, 36.32794]]]} | Open Access 1 | 48209 | Miki City Park | 32749 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 0.631 | Miki City Park | 2017 | Local Park 2 | 4 | |
3429 | 3429 | 3428 | {"type": "Polygon", "coordinates": [[[-122.28869, 37.78989], [-122.28434, 37.79], [-122.28434, 37.78999], [-122.2844, 37.78926], [-122.28472, 37.78911], [-122.28521, 37.78928], [-122.28707, 37.78929], [-122.28729, 37.78923], [-122.28753, 37.78908], [-122.28867, 37.78906], [-122.28869, 37.78989]]]} | Open Access 1 | 48739 | Estuary Park | 33465 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | https://www.alamedaca.gov/Departments/Recreation-Parks/Estuary-Park | Alameda 17 | 7.72 | Estuary Park | 2017 | Local Park 2 | 4 |
3671 | 3671 | 3670 | {"type": "Polygon", "coordinates": [[[-122.72799, 38.42185], [-122.72623, 38.4222], [-122.72621, 38.422], [-122.72615, 38.42201], [-122.72601, 38.42086], [-122.7278, 38.42042], [-122.72799, 38.42185]]]} | Open Access 1 | 29698 | Bayer Neighborhood Park and Gardens | 32509 | 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 | Sonoma 16 | 6.16 | Bayer Neighborhood Park and Gardens | 2017 | Local Park 2 | 4 | |
4369 | 4369 | 4368 | {"type": "MultiPolygon", "coordinates": [[[[-118.29951, 34.43781], [-118.29921, 34.43801], [-118.29837, 34.43863], [-118.29836, 34.4378], [-118.29951, 34.43781]]], [[[-118.30462, 34.43943], [-118.30363, 34.44069], [-118.30341, 34.44058], [-118.30258, 34.44023], [-118.30189, 34.44001], [-118.3015, 34.43992], [-118.30115, 34.43986], [-118.3008, 34.43983], [-118.30054, 34.43984], [-118.30027, 34.43988], [-118.29998, 34.43995], [-118.29965, 34.44008], [-118.29943, 34.4402], [-118.29921, 34.44035], [-118.2989, 34.44061], [-118.2984, 34.44115], [-118.29837, 34.43885], [-118.29944, 34.43806], [-118.29966, 34.43793], [-118.29989, 34.43781], [-118.30272, 34.43781], [-118.30314, 34.43802], [-118.30347, 34.43826], [-118.30377, 34.43854], [-118.30433, 34.43918], [-118.30462, 34.43943]]], [[[-118.30408, 34.44144], [-118.30007, 34.44144], [-118.29898, 34.44144], [-118.29925, 34.44119], [-118.2998, 34.44091], [-118.3001, 34.44078], [-118.30042, 34.44068], [-118.30073, 34.44061], [-118.30105, 34.44056], [-118.30153, 34.44054], [-118.30186, 34.44055], [-118.30234, 34.44062], [-118.30265, 34.4407], [-118.30281, 34.44077], [-118.30283, 34.44076], [-118.30308, 34.44084], [-118.30333, 34.44095], [-118.30357, 34.44107], [-118.30391, 34.44129], [-118.30408, 34.44144]]]]} | Open Access 1 | 48522 | Stickleback Ranch | 33235 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 41.133 | Stickleback Ranch | 2017 | Local Park 2 | 4 | |
5254 | 5254 | 5253 | {"type": "Polygon", "coordinates": [[[-119.07578, 34.22175], [-119.07584, 34.22177], [-119.07586, 34.22181], [-119.07586, 34.2234], [-119.0758, 34.22343], [-119.0747, 34.22344], [-119.07468, 34.22175], [-119.07578, 34.22175]]]} | Open Access 1 | 48373 | Mel Vincent Park | 32939 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/parks/park_list/mel_vincent_park.asp | Ventura 8 | 4.981 | Mel Vincent Park | 2017 | Local Park 2 | 4 |
6753 | 6753 | 6752 | {"type": "Polygon", "coordinates": [[[-121.21194, 37.76483], [-121.21187, 37.76508], [-121.21159, 37.76557], [-121.21149, 37.76586], [-121.21144, 37.76588], [-121.21108, 37.76588], [-121.21081, 37.76585], [-121.21064, 37.76579], [-121.21042, 37.76566], [-121.2103, 37.76555], [-121.21018, 37.76536], [-121.21014, 37.76514], [-121.21014, 37.76454], [-121.21015, 37.7644], [-121.21024, 37.7642], [-121.21033, 37.76408], [-121.21046, 37.76397], [-121.2106, 37.76389], [-121.21085, 37.76381], [-121.21153, 37.76374], [-121.21157, 37.76377], [-121.21178, 37.76409], [-121.21187, 37.76427], [-121.21194, 37.76455], [-121.21194, 37.76483]]]} | Open Access 1 | 48417 | Evans Estates Park | 33014 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 7.541 | Evans Estates Park | 2017 | Local Park 2 | 4 | |
10073 | 10073 | 10072 | {"type": "Polygon", "coordinates": [[[-121.28222, 38.81572], [-121.28171, 38.81595], [-121.28168, 38.81588], [-121.28158, 38.8158], [-121.28132, 38.81542], [-121.28105, 38.81507], [-121.28097, 38.81499], [-121.28084, 38.81488], [-121.2808, 38.81481], [-121.28072, 38.81477], [-121.28065, 38.81477], [-121.28057, 38.81481], [-121.28053, 38.81488], [-121.28047, 38.81488], [-121.28041, 38.8148], [-121.28124, 38.81442], [-121.28222, 38.81572]]]} | Open Access 1 | 49035 | Wickman Park | 33742 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.226 | Wickman Park | 2017 | Local Park 2 | 4 | |
11232 | 11232 | 11231 | {"type": "Polygon", "coordinates": [[[-118.46481, 34.02853], [-118.4639, 34.02872], [-118.46352, 34.02864], [-118.46131, 34.02909], [-118.46102, 34.02931], [-118.46054, 34.02941], [-118.46045, 34.02911], [-118.46466, 34.02825], [-118.46471, 34.02825], [-118.46473, 34.02828], [-118.46481, 34.02853]]]} | Open Access 1 | 48030 | Ishihara Park | 32517 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | https://www.smgov.net/Departments/CCS/content.aspx?id=53687098200 | Los Angeles 6 | 2.358 | Ishihara Park | 2017 | Local Park 2 | 4 |
11435 | 11435 | 11434 | {"type": "Polygon", "coordinates": [[[-117.8668, 34.11468], [-117.86563, 34.11468], [-117.86563, 34.11404], [-117.86679, 34.11404], [-117.8668, 34.11468]]]} | Open Access 1 | 48128 | Arboretum And Botanic Garden | 32644 | 1120 | Glendora, City of 76 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 1.867 | Arboretum And Botanic Garden | 2017 | Local Park 2 | 4 | |
11440 | 11440 | 11439 | {"type": "Polygon", "coordinates": [[[-118.31128, 33.78746], [-118.31096, 33.78747], [-118.31095, 33.78696], [-118.31128, 33.78696], [-118.31128, 33.78746]]]} | Open Access 1 | 48135 | Louis and William J. Teuchert Park | 32662 | 1182 | Lomita, City of 461 | City 2 | City Agency 2 | http://www.lomita.com/cityhall/government/parksrec/index.cfm | City 2 | 1182 | Lomita, City of 454 | City 2 | City Agency 2 | http://www.lomita.com/cityhall/government/parksrec/index.cfm?p=Teuchert/Teuchert.cfm&h=m | Los Angeles 6 | 0.42 | Louis and William J. Teuchert Park | 2017 | Local Park 2 | 4 |
11465 | 11465 | 11464 | {"type": "Polygon", "coordinates": [[[-117.32813, 34.76673], [-117.32803, 34.7693], [-117.32577, 34.76927], [-117.32577, 34.76773], [-117.32645, 34.76704], [-117.32646, 34.76671], [-117.32813, 34.76673]]]} | Open Access 1 | 48175 | Helendale Community Park | 32710 | 2424 | Helendale Community Services District 980 | Special District 4 | Community Services District 19 | https://www.helendalecsd.org/parks_facilities.html | Special District 4 | 2424 | Helendale Community Services District 943 | Special District 4 | Community Services District 17 | https://www.helendalecsd.org/parks_facilities.html | San Bernardino 22 | 13.717 | Helendale Community Park | 2017 | Local Park 2 | 4 |
13055 | 13055 | 13054 | {"type": "Polygon", "coordinates": [[[-116.46046, 33.95158], [-116.4604, 33.95167], [-116.45955, 33.95175], [-116.45948, 33.95163], [-116.45951, 33.95157], [-116.45952, 33.9515], [-116.4595, 33.95145], [-116.45946, 33.95142], [-116.45931, 33.95138], [-116.45924, 33.95117], [-116.45937, 33.95129], [-116.45982, 33.9515], [-116.46046, 33.95158]]]} | Open Access 1 | 34912 | Rotary Dog Park | 32625 | 1670 | Desert Hot Springs, City of 641 | City 2 | City Agency 2 | http://www.cityofdhs.org/ | City 2 | 1670 | Desert Hot Springs, City of 630 | City 2 | City Agency 2 | Riverside 10 | 0.555 | Rotary Dog Park | 2017 | Local Park 2 | 4 | |
14691 | 14691 | 14690 | {"type": "Polygon", "coordinates": [[[-122.41621, 37.76434], [-122.41587, 37.76436], [-122.41587, 37.76447], [-122.41537, 37.7645], [-122.41531, 37.76377], [-122.41615, 37.76372], [-122.41621, 37.76434]]]} | Open Access 1 | 45018 | In Chan Kaajal Park | 31768 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/project/proposed-park-site-at-17th-and-folsom/ | San Francisco 13 | 1.398 | In Chan Kaajal Park | 2017 | Local Park 2 | 4 |
14692 | 14692 | 14691 | {"type": "Polygon", "coordinates": [[[-117.29529, 34.11701], [-117.2948, 34.11701], [-117.29479, 34.11703], [-117.2943, 34.11703], [-117.2943, 34.11635], [-117.29453, 34.11634], [-117.29454, 34.11612], [-117.29467, 34.11611], [-117.29467, 34.11591], [-117.29529, 34.1159], [-117.29529, 34.11701]]]} | Open Access 1 | 45039 | Bryce Edward Hanes Park | 31758 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 2.45 | Bryce Edward Hanes Park | 2017 | Local Park 2 | 4 | |
14710 | 14710 | 14709 | {"type": "Polygon", "coordinates": [[[-119.63172, 36.30132], [-119.63125, 36.30132], [-119.63131, 36.30113], [-119.63134, 36.30093], [-119.63132, 36.29873], [-119.63169, 36.29874], [-119.63172, 36.30132]]]} | Open Access 1 | 45048 | Home Garden Community Park | 28022 | 2342 | Home Garden Community Services District 1120 | Special District 4 | Community Services District 19 | http://www.cset.org/ | Special District 4 | 2342 | Home Garden Community Services District 1075 | Special District 4 | Community Services District 17 | Kings 44 | 2.424 | Home Garden Community Park | 2017 | Local Park 2 | 4 | |
14728 | 14728 | 14727 | {"type": "Polygon", "coordinates": [[[-117.61755, 34.09674], [-117.61753, 34.09759], [-117.61599, 34.09759], [-117.61599, 34.09673], [-117.61755, 34.09674]]]} | Open Access 1 | 45080 | Los Amigos Park | 32565 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parkdev/whatsnew/southwest_cucamonga_pk.asp | San Bernardino 22 | 3.359 | Los Amigos Park | 2017 | Local Park 2 | 4 |
15206 | 15206 | 15205 | {"type": "Polygon", "coordinates": [[[-118.04141, 34.55562], [-118.04139, 34.55792], [-118.03668, 34.55791], [-118.03664, 34.55789], [-118.03665, 34.55766], [-118.03669, 34.5572], [-118.03669, 34.55572], [-118.03703, 34.55572], [-118.03704, 34.55582], [-118.03989, 34.55581], [-118.04119, 34.55562], [-118.04141, 34.55562]]]} | Open Access 1 | 46092 | Sam Yellen Community Park | 29441 | 1242 | Palmdale, City of 205 | City 2 | City Agency 2 | http://www.cityofpalmdale.org/Residents/Recreation-and-Culture | City 2 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | Los Angeles 6 | 25.456 | Sam Yellen Community Park | 2017 | Local Park 2 | 4 | |
15237 | 15237 | 15236 | {"type": "Polygon", "coordinates": [[[-118.37777, 34.01479], [-118.37753, 34.0148], [-118.37747, 34.01477], [-118.37741, 34.01476], [-118.37599, 34.0148], [-118.37598, 34.01451], [-118.37593, 34.01451], [-118.37619, 34.01404], [-118.37647, 34.01384], [-118.37662, 34.01349], [-118.37761, 34.01347], [-118.37774, 34.01366], [-118.37777, 34.01479]]]} | Open Access 1 | 46287 | Stoneview Park | 29580 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.017 | Stoneview Park | 2017 | 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]);