units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 234
- San Diego, City of 224
- Sacramento, City of 192
- San Jose, City of 135
- Consumnes Community Services District 92
- Long Beach, City of 84
- Oakland, City of 83
- San Francisco, City and County of 78
- East Bay Regional Park District 75
- Los Angeles, County of 70
- Roseville, City of 67
- Tracy, City of 66
- Modesto, City of 65
- Stockton, City of 64
- Hayward Area Recreation and Park District 59
- Mountains Recreation and Conservation Authority 57
- Valley-Wide Recreation and Park District 56
- Huntington Beach, City of 53
- San Diego, County of 52
- Fresno, City of 50
- Brentwood, City of 49
- Chula Vista, City of 47
- Manteca, City of 46
- Napa, City of 45
- Santa Rosa, City of 42
- San Ramon, City of 42
- Bakersfield, City of 41
- El Dorado, County of 41
- Riverside, City of 40
- Murrieta, City of 40
- …
MNG_AG_TYP 15
- City Agency 5,890
- Recreation/Parks District 619
- County Agency 521
- Community Services District 166
- County Agency - Parks 138
- Open Space District 62
- Water District 37
- School District 31
- Port/Harbor District 21
- Flood District 15
- Special District - Other 9
- County Agency - Other 5
- Cemetery District 1
- Irrigation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 7,239
- Restricted Access 202
- No Public Access 71
- Unknown Access 5
DES_TP 1
- Local Park · 7,517 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2556 | 2556 | 2555 | {"type": "Polygon", "coordinates": [[[-121.37991, 37.97763], [-121.37336, 37.9769], [-121.37042, 37.97837], [-121.37205, 37.97398], [-121.37356, 37.9716], [-121.37991, 37.97763]]]} | Open Access 1 | 17820 | Buckley Cove Park | 16475 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 63.792 | Buckley Cove Park | 0 | Local Park 2 | 4 | |
2557 | 2557 | 2556 | {"type": "Polygon", "coordinates": [[[-118.99239, 34.23411], [-118.99215, 34.23439], [-118.99184, 34.23465], [-118.99149, 34.23488], [-118.99113, 34.23505], [-118.99056, 34.23308], [-118.98853, 34.23322], [-118.98866, 34.23284], [-118.98886, 34.23246], [-118.98909, 34.23215], [-118.98926, 34.23197], [-118.98945, 34.23181], [-118.98975, 34.2316], [-118.99012, 34.2314], [-118.99151, 34.23088], [-118.99215, 34.23248], [-118.9921, 34.23297], [-118.99239, 34.23411]]]} | Open Access 1 | 17839 | Mission Oaks Community Park | 22303 | 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 | Ventura 8 | 19.724 | Mission Oaks Community Park | 0 | Local Park 2 | 4 | |
2558 | 2558 | 2557 | {"type": "Polygon", "coordinates": [[[-118.86313, 34.27395], [-118.86268, 34.27401], [-118.86263, 34.27389], [-118.86243, 34.27377], [-118.86231, 34.27367], [-118.86222, 34.27365], [-118.86173, 34.27375], [-118.86155, 34.27385], [-118.86157, 34.2739], [-118.86154, 34.27398], [-118.86121, 34.27422], [-118.86114, 34.27423], [-118.86108, 34.27409], [-118.86095, 34.27399], [-118.86078, 34.27394], [-118.86064, 34.27388], [-118.86054, 34.27388], [-118.86042, 34.27393], [-118.86037, 34.27389], [-118.8603, 34.2734], [-118.86042, 34.27334], [-118.8605, 34.27327], [-118.86052, 34.27313], [-118.86076, 34.27301], [-118.86124, 34.27284], [-118.86133, 34.27278], [-118.86149, 34.27265], [-118.86165, 34.27243], [-118.86173, 34.27237], [-118.86189, 34.27233], [-118.86219, 34.27234], [-118.8629, 34.27227], [-118.86283, 34.27276], [-118.86285, 34.27315], [-118.86289, 34.27336], [-118.86295, 34.27356], [-118.86303, 34.27377], [-118.86313, 34.27395]]]} | Open Access 1 | 17831 | Miller Park | 22244 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 8.208 | Miller Park | 0 | Local Park 2 | 4 | |
2559 | 2559 | 2558 | {"type": "Polygon", "coordinates": [[[-121.27796, 37.95986], [-121.27692, 37.96003], [-121.2767, 37.95923], [-121.27774, 37.95905], [-121.27796, 37.95986]]]} | Open Access 1 | 17832 | Constitution Park | 17599 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.112 | Constitution Park | 0 | Local Park 2 | 4 | |
2560 | 2560 | 2559 | {"type": "Polygon", "coordinates": [[[-121.31395, 38.01764], [-121.31393, 38.01767], [-121.31188, 38.019], [-121.31064, 38.01784], [-121.31128, 38.01783], [-121.31152, 38.01779], [-121.31174, 38.0177], [-121.31195, 38.01759], [-121.31213, 38.01746], [-121.31227, 38.0173], [-121.31238, 38.01711], [-121.31246, 38.01706], [-121.31282, 38.01707], [-121.313, 38.0171], [-121.31318, 38.01716], [-121.3134, 38.01726], [-121.31371, 38.01743], [-121.31394, 38.0176], [-121.31395, 38.01764]]]} | Open Access 1 | 17840 | Angel Cruz Park | 15490 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 7.137 | Angel Cruz Park | 0 | Local Park 2 | 4 | |
2561 | 2561 | 2560 | {"type": "Polygon", "coordinates": [[[-119.71344, 36.81389], [-119.71341, 36.8156], [-119.71337, 36.81563], [-119.71008, 36.81563], [-119.71009, 36.81479], [-119.71047, 36.81478], [-119.71048, 36.81389], [-119.71344, 36.81389]]]} | Open Access 1 | 17848 | Rotary Park | 24688 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 13.352 | Rotary Park | 0 | Local Park 2 | 4 | |
2566 | 2566 | 2565 | {"type": "Polygon", "coordinates": [[[-118.0783, 33.88585], [-118.07617, 33.88585], [-118.07614, 33.8841], [-118.07735, 33.8841], [-118.07753, 33.88415], [-118.07799, 33.88438], [-118.07814, 33.88441], [-118.07826, 33.88442], [-118.0783, 33.88585]]]} | Open Access 1 | 6762 | Hermosillo Park | 19873 | 1225 | Norwalk, City of 239 | City 2 | City Agency 2 | http://www.ci.norwalk.ca.us/city-hall/departments/recreation-park-services | City 2 | 1225 | Norwalk, City of 235 | City 2 | City Agency 2 | Los Angeles 6 | 9.05 | Hermosillo Park | 0 | Local Park 2 | 4 | |
2567 | 2567 | 2566 | {"type": "Polygon", "coordinates": [[[-121.81491, 37.31728], [-121.81229, 37.31735], [-121.81162, 37.31721], [-121.81136, 37.31723], [-121.80948, 37.31751], [-121.80948, 37.31745], [-121.80962, 37.31726], [-121.80962, 37.31714], [-121.81091, 37.31695], [-121.81093, 37.31699], [-121.812, 37.31683], [-121.81359, 37.31577], [-121.81397, 37.31591], [-121.81396, 37.31597], [-121.81399, 37.31612], [-121.81404, 37.31626], [-121.81417, 37.31643], [-121.81442, 37.31671], [-121.81474, 37.31702], [-121.81491, 37.31728]]]} | Open Access 1 | 17850 | Meadowfair Park | 22085 | 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 | Santa Clara 19 | 8.727 | Meadowfair Park | 1999 | Local Park 2 | 4 | |
2568 | 2568 | 2567 | {"type": "MultiPolygon", "coordinates": [[[[-119.71235, 34.43717], [-119.71239, 34.43727], [-119.71242, 34.43741], [-119.71236, 34.43784], [-119.71238, 34.43805], [-119.71242, 34.43818], [-119.71249, 34.43831], [-119.71277, 34.43863], [-119.71287, 34.43882], [-119.7129, 34.43896], [-119.71292, 34.4391], [-119.71289, 34.43922], [-119.71284, 34.43934], [-119.71275, 34.43944], [-119.71264, 34.43952], [-119.71251, 34.43957], [-119.71237, 34.43958], [-119.7122, 34.43955], [-119.71208, 34.43948], [-119.7116, 34.43929], [-119.71145, 34.43926], [-119.71108, 34.43926], [-119.71107, 34.43818], [-119.71119, 34.43793], [-119.71137, 34.43759], [-119.71141, 34.43755], [-119.71152, 34.4375], [-119.71158, 34.43745], [-119.71161, 34.43737], [-119.71161, 34.43726], [-119.71163, 34.4372], [-119.71188, 34.43689], [-119.71194, 34.43689], [-119.71235, 34.43717]]], [[[-119.71303, 34.43937], [-119.71304, 34.43947], [-119.71301, 34.43961], [-119.71273, 34.44012], [-119.71272, 34.44021], [-119.71228, 34.44022], [-119.71217, 34.44025], [-119.71191, 34.44045], [-119.71188, 34.44029], [-119.71184, 34.44019], [-119.71172, 34.44003], [-119.71127, 34.43969], [-119.71117, 34.43965], [-119.71108, 34.43965], [-119.71108, 34.4394], [-119.7114, 34.43941], [-119.71158, 34.43945], [-119.7122, 34.43971], [-119.71233, 34.43973], [-119.71252, 34.43973], [-119.7127, 34.43967], [-119.71282, 34.4396], [-119.71296, 34.43947], [-119.71303, 34.43937]]]]} | Open Access 1 | 17851 | Mission Park | 22305 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 10.435 | Mission Park | 0 | Local Park 2 | 4 | |
2569 | 2569 | 2568 | {"type": "Polygon", "coordinates": [[[-121.29231, 37.96254], [-121.29129, 37.96272], [-121.29107, 37.9619], [-121.29209, 37.96173], [-121.29231, 37.96254]]]} | Open Access 1 | 17852 | Eden Square | 18429 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.114 | Eden Square | 0 | Local Park 2 | 4 | |
2570 | 2570 | 2569 | {"type": "Polygon", "coordinates": [[[-121.94501, 38.34018], [-121.94498, 38.342], [-121.94481, 38.342], [-121.94475, 38.34204], [-121.94332, 38.34207], [-121.94331, 38.34156], [-121.94316, 38.34087], [-121.94291, 38.34006], [-121.944, 38.34008], [-121.94421, 38.34016], [-121.94501, 38.34018]]]} | Open Access 1 | 17854 | Meadowlands Park | 22086 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 8.404 | Meadowlands Park | 0 | Local Park 2 | 4 | |
2571 | 2571 | 2570 | {"type": "Polygon", "coordinates": [[[-119.29881, 34.2807], [-119.29868, 34.28069], [-119.29865, 34.28065], [-119.29825, 34.28064], [-119.29823, 34.28062], [-119.29798, 34.28062], [-119.29792, 34.2807], [-119.29782, 34.2807], [-119.29782, 34.28012], [-119.29826, 34.28012], [-119.29827, 34.28], [-119.29881, 34.27999], [-119.29881, 34.2807]]]} | Open Access 1 | 17855 | Mission Park | 22306 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.499 | Mission Park | 0 | Local Park 2 | 4 | |
2572 | 2572 | 2571 | {"type": "Polygon", "coordinates": [[[-121.28838, 37.95808], [-121.28734, 37.95826], [-121.28712, 37.95745], [-121.28814, 37.95727], [-121.28838, 37.95808]]]} | Open Access 1 | 17856 | Fremont Square | 19103 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.102 | Fremont Square | 0 | Local Park 2 | 4 | |
2574 | 2574 | 2573 | {"type": "Polygon", "coordinates": [[[-121.33843, 38.02211], [-121.33576, 38.02212], [-121.33575, 38.02155], [-121.33596, 38.0216], [-121.3361, 38.02161], [-121.33628, 38.02159], [-121.33665, 38.02149], [-121.33684, 38.02146], [-121.33841, 38.02147], [-121.33843, 38.02211]]]} | Open Access 1 | 17868 | Gibbons Park | 19286 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 3.95 | Gibbons Park | 0 | Local Park 2 | 4 | |
2576 | 2576 | 2575 | {"type": "Polygon", "coordinates": [[[-121.28336, 37.94962], [-121.28232, 37.9498], [-121.28209, 37.94898], [-121.28313, 37.9488], [-121.28336, 37.94962]]]} | Open Access 1 | 17871 | Gleason Park | 19312 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.173 | Gleason Park | 0 | Local Park 2 | 4 | |
2578 | 2578 | 2577 | {"type": "Polygon", "coordinates": [[[-121.27912, 37.94406], [-121.27807, 37.94424], [-121.27785, 37.94344], [-121.2789, 37.94326], [-121.27912, 37.94406]]]} | Open Access 1 | 17887 | Liberty Square | 21214 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.142 | Liberty Square | 0 | Local Park 2 | 4 | |
2579 | 2579 | 2578 | {"type": "Polygon", "coordinates": [[[-119.21107, 34.25987], [-119.20587, 34.26068], [-119.20572, 34.25995], [-119.20573, 34.25993], [-119.20576, 34.25991], [-119.20576, 34.25989], [-119.2063, 34.25985], [-119.20648, 34.25981], [-119.20662, 34.25975], [-119.20684, 34.25962], [-119.20695, 34.25952], [-119.20705, 34.2594], [-119.2071, 34.25938], [-119.20742, 34.25944], [-119.20773, 34.25943], [-119.20785, 34.25998], [-119.20801, 34.26004], [-119.21, 34.25969], [-119.21005, 34.25986], [-119.21103, 34.25971], [-119.21107, 34.25987]]]} | Open Access 1 | 17901 | Montalvo Neighborhood Park | 22383 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 6.837 | Montalvo Neighborhood Park | 0 | Local Park 2 | 4 | |
2580 | 2580 | 2579 | {"type": "Polygon", "coordinates": [[[-121.28996, 37.92752], [-121.28994, 37.92753], [-121.28844, 37.92785], [-121.2884, 37.92785], [-121.28833, 37.92758], [-121.28816, 37.92716], [-121.28809, 37.92717], [-121.28757, 37.92588], [-121.28923, 37.92551], [-121.28976, 37.92681], [-121.28969, 37.92684], [-121.28996, 37.92752]]]} | Open Access 1 | 17902 | Mattie Harrell Park | 21958 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 8.493 | Mattie Harrell Park | 0 | Local Park 2 | 4 | |
2582 | 2582 | 2581 | {"type": "Polygon", "coordinates": [[[-121.25678, 37.92133], [-121.25525, 37.92171], [-121.25505, 37.92122], [-121.25658, 37.92084], [-121.25678, 37.92133]]]} | Open Access 1 | 17914 | Reverend Holmes Park | 24304 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 1.993 | Reverend Holmes Park | 0 | Local Park 2 | 4 | |
2583 | 2583 | 2582 | {"type": "Polygon", "coordinates": [[[-121.94638, 36.98028], [-121.94534, 36.98101], [-121.94528, 36.98093], [-121.94521, 36.98071], [-121.94506, 36.98036], [-121.94494, 36.98016], [-121.94468, 36.97983], [-121.94567, 36.97911], [-121.94638, 36.98028]]]} | Open Access 1 | 17916 | Monterey Avenue Park | 22414 | 1044 | Capitola, City of 112 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | Santa Cruz 5 | 3.988 | Monterey Avenue Park | 0 | 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]);