units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
663 rows where DES_TP = 14 and MNG_AG_TYP = 2 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Ventura, City of 106
- Roseville, City of 46
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Napa, City of 21
- Rocklin, City of 17
- Seaside, City of 16
- Lompoc, City of 14
- Oroville, City of 12
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Santa Cruz, City of 10
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- Watsonville, City of 7
- Scotts Valley, City of 7
- Torrance, City of 7
- San Luis Obispo, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Salinas, City of 5
- Anaheim, City of 5
- Stockton, City of 5
- San Marcos, City of 4
- Marina, City of 4
- Morgan Hill, City of 4
- …
ACCESS_TYP 4
- Open Access 569
- No Public Access 52
- Unknown Access 16
- Restricted Access 6
MNG_AG_TYP 1
- City Agency · 643 ✖
DES_TP 1
- Local Other or Unknown · 643 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12986 | 12986 | 12985 | {"type": "Polygon", "coordinates": [[[-122.05824, 36.96592], [-122.05801, 36.96601], [-122.05789, 36.96585], [-122.05811, 36.96573], [-122.05824, 36.96592]]]} | Open Access 1 | 35359 | Santa Cruz holding 1 | 25064 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.127 | Santa Cruz holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13197 | 13197 | 13196 | {"type": "Polygon", "coordinates": [[[-122.00596, 37.00462], [-122.00509, 37.00463], [-122.00509, 37.00415], [-122.00596, 37.00415], [-122.00596, 37.00462]]]} | Open Access 1 | 35209 | Santa Cruz holding 5 | 28176 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 1.015 | Santa Cruz holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13199 | 13199 | 13198 | {"type": "Polygon", "coordinates": [[[-122.02701, 37.01206], [-122.02689, 37.01231], [-122.02679, 37.01235], [-122.02626, 37.01189], [-122.02641, 37.01177], [-122.02654, 37.01175], [-122.02663, 37.01179], [-122.02701, 37.01206]]]} | Open Access 1 | 35226 | Santa Cruz holding 13 | 28177 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.557 | Santa Cruz holding 13 | 0 | Local Other or Unknown 14 | 4 | |
13206 | 13206 | 13205 | {"type": "Polygon", "coordinates": [[[-122.07216, 37.00872], [-122.07141, 37.00885], [-122.07125, 37.00838], [-122.07203, 37.00825], [-122.07216, 37.00872]]]} | Open Access 1 | 35234 | Santa Cruz holding 7 | 28173 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.932 | Santa Cruz holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13207 | 13207 | 13206 | {"type": "Polygon", "coordinates": [[[-121.97361, 36.96111], [-121.97328, 36.96111], [-121.97328, 36.96082], [-121.97361, 36.96083], [-121.97361, 36.96111]]]} | Open Access 1 | 35236 | Santa Cruz holding 8 | 25078 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.232 | Santa Cruz holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13230 | 13230 | 13229 | {"type": "Polygon", "coordinates": [[[-122.01894, 36.98092], [-122.01894, 36.98092], [-122.01864, 36.98102], [-122.01878, 36.98082], [-122.01886, 36.98067], [-122.01892, 36.98061], [-122.01894, 36.98092]]]} | Open Access 1 | 35358 | Santa Cruz holding 3 | 25073 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.121 | Santa Cruz holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13235 | 13235 | 13234 | {"type": "Polygon", "coordinates": [[[-122.04834, 36.97092], [-122.04803, 36.971], [-122.04792, 36.97081], [-122.04775, 36.97056], [-122.04759, 36.97036], [-122.04739, 36.97016], [-122.04722, 36.97001], [-122.04691, 36.96978], [-122.04632, 36.96946], [-122.04639, 36.96937], [-122.04751, 36.96975], [-122.04776, 36.9702], [-122.04834, 36.97092]]]} | Open Access 1 | 35279 | Santa Cruz holding 12 | 25067 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 1.496 | Santa Cruz holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13277 | 13277 | 13276 | {"type": "Polygon", "coordinates": [[[-122.0466, 36.97904], [-122.04636, 36.97912], [-122.04618, 36.97894], [-122.0463, 36.97884], [-122.0458, 36.97834], [-122.04591, 36.97836], [-122.0466, 36.97904]]]} | Open Access 1 | 35330 | Santa Cruz holding 14 | 28172 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.279 | Santa Cruz holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13334 | 13334 | 13333 | {"type": "Polygon", "coordinates": [[[-122.03292, 36.98026], [-122.03259, 36.98011], [-122.0326, 36.97995], [-122.03254, 36.97982], [-122.03278, 36.97971], [-122.03286, 36.97973], [-122.03292, 36.98026]]]} | Open Access 1 | 35410 | Santa Cruz holding 9 | 25079 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.326 | Santa Cruz holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13942 | 13942 | 13941 | {"type": "Polygon", "coordinates": [[[-121.97198, 36.96602], [-121.97144, 36.96602], [-121.97144, 36.96579], [-121.97198, 36.96579], [-121.97198, 36.96602]]]} | Open Access 1 | 36563 | Santa Cruz holding 15 | 25070 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.306 | Santa Cruz holding 15 | 0 | Local Other or Unknown 14 | 4 | |
4376 | 4376 | 4375 | {"type": "Polygon", "coordinates": [[[-121.1454, 37.46398], [-121.14539, 37.46422], [-121.14474, 37.46421], [-121.14469, 37.46417], [-121.14469, 37.46347], [-121.1453, 37.46348], [-121.14529, 37.46374], [-121.14524, 37.46379], [-121.14522, 37.46387], [-121.14527, 37.46394], [-121.14534, 37.46398], [-121.1454, 37.46398]]]} | Open Access 1 | 48546 | Unknown Park - Patterson, City of | 33386 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.121 | 0 | Local Other or Unknown 14 | 4 | ||
13776 | 13776 | 13775 | {"type": "Polygon", "coordinates": [[[-121.15526, 37.46194], [-121.15507, 37.46228], [-121.15456, 37.46207], [-121.15465, 37.46189], [-121.15464, 37.46185], [-121.15461, 37.46182], [-121.15454, 37.46182], [-121.15434, 37.46192], [-121.15427, 37.46191], [-121.15422, 37.46189], [-121.15457, 37.46164], [-121.1549, 37.4618], [-121.15526, 37.46194]]]} | Open Access 1 | 36322 | Patterson holding 1 | 23519 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.674 | Patterson holding 1 | 0 | Local Other or Unknown 14 | 4 | |
4130 | 4130 | 4129 | {"type": "Polygon", "coordinates": [[[-121.80347, 37.04255], [-121.80296, 37.04373], [-121.80276, 37.04499], [-121.80264, 37.04534], [-121.80233, 37.04573], [-121.80235, 37.04659], [-121.80223, 37.04686], [-121.80224, 37.04701], [-121.80228, 37.04703], [-121.80228, 37.04715], [-121.80279, 37.04754], [-121.80017, 37.04746], [-121.80028, 37.04454], [-121.80045, 37.04074], [-121.80194, 37.04076], [-121.80282, 37.04139], [-121.80342, 37.04205], [-121.80347, 37.04255]]]} | Open Access 1 | 36505 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 40.881 | 0 | Local Other or Unknown 14 | 4 | ||
4671 | 4671 | 4670 | {"type": "Polygon", "coordinates": [[[-121.77531, 36.91167], [-121.77503, 36.91227], [-121.77428, 36.91196], [-121.77397, 36.91189], [-121.77363, 36.91186], [-121.77326, 36.91191], [-121.77315, 36.91171], [-121.77244, 36.91195], [-121.77201, 36.91199], [-121.77149, 36.91185], [-121.77153, 36.91119], [-121.77249, 36.91129], [-121.77282, 36.9112], [-121.77299, 36.91105], [-121.77342, 36.91099], [-121.77355, 36.91109], [-121.77531, 36.91167]]]} | Open Access 1 | 36632 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 6.263 | 0 | Local Other or Unknown 14 | 4 | ||
4676 | 4676 | 4675 | {"type": "Polygon", "coordinates": [[[-121.78001, 36.90996], [-121.7796, 36.90977], [-121.77934, 36.90977], [-121.77883, 36.90994], [-121.77805, 36.91048], [-121.77599, 36.91021], [-121.77576, 36.91069], [-121.7756, 36.91016], [-121.77561, 36.91007], [-121.77568, 36.90995], [-121.77575, 36.90988], [-121.7759, 36.90981], [-121.7764, 36.90969], [-121.77693, 36.90981], [-121.77743, 36.90968], [-121.77756, 36.90959], [-121.77779, 36.90933], [-121.77802, 36.90919], [-121.77859, 36.90875], [-121.77882, 36.90864], [-121.77931, 36.90851], [-121.77936, 36.90846], [-121.77939, 36.90841], [-121.77938, 36.90832], [-121.78001, 36.90996]]]} | Open Access 1 | 36655 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 9.393 | 0 | Local Other or Unknown 14 | 4 | ||
13303 | 13303 | 13302 | {"type": "Polygon", "coordinates": [[[-121.75571, 36.90633], [-121.75551, 36.90647], [-121.75541, 36.90638], [-121.75541, 36.90638], [-121.75571, 36.90633]]]} | Open Access 1 | 35365 | Watsonville holding 1 | 27309 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.04 | Watsonville holding 1 | 0 | Local Other or Unknown 14 | 4 | |
15475 | 15475 | 15474 | {"type": "Polygon", "coordinates": [[[-121.80045, 37.04074], [-121.80028, 37.04454], [-121.80017, 37.04746], [-121.79151, 37.04743], [-121.79167, 37.0407], [-121.797, 37.04075], [-121.80045, 37.04074]]]} | Open Access 1 | 36626 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 142.753 | 0 | Local Other or Unknown 14 | 4 | ||
15477 | 15477 | 15476 | {"type": "Polygon", "coordinates": [[[-121.79104, 37.01528], [-121.79097, 37.01543], [-121.791, 37.01553], [-121.7909, 37.01571], [-121.79074, 37.01585], [-121.79048, 37.01595], [-121.78977, 37.01601], [-121.78875, 37.01643], [-121.78822, 37.01683], [-121.78806, 37.01702], [-121.78779, 37.01739], [-121.78779, 37.01786], [-121.78794, 37.01826], [-121.78733, 37.0187], [-121.78722, 37.01886], [-121.78726, 37.019], [-121.78736, 37.01911], [-121.78433, 37.01909], [-121.78606, 37.01588], [-121.78619, 37.01552], [-121.7865, 37.01535], [-121.78714, 37.01517], [-121.78795, 37.01487], [-121.78952, 37.01435], [-121.79104, 37.01528]], [[-121.79089, 37.01556], [-121.79089, 37.01554], [-121.7903, 37.01553], [-121.79029, 37.01554], [-121.79045, 37.01588], [-121.79068, 37.01579], [-121.79083, 37.01566], [-121.79089, 37.01556]]]} | Open Access 1 | 36629 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 34.455 | 0 | Local Other or Unknown 14 | 4 | ||
15478 | 15478 | 15477 | {"type": "Polygon", "coordinates": [[[-121.79324, 36.88092], [-121.79324, 36.88092], [-121.78808, 36.88474], [-121.78767, 36.88399], [-121.79284, 36.88016], [-121.79324, 36.88092]]]} | No Public Access 3 | 36631 | Unnamed site - Watsonville, City of | 28700 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 13.356 | 0 | Local Other or Unknown 14 | 4 | ||
4807 | 4807 | 4806 | {"type": "MultiPolygon", "coordinates": [[[[-119.67174, 36.72576], [-119.66919, 36.72576], [-119.66915, 36.72573], [-119.66915, 36.72558], [-119.67174, 36.72558], [-119.67174, 36.72576]]], [[[-119.82535, 36.71988], [-119.82534, 36.72036], [-119.82506, 36.72036], [-119.82504, 36.72034], [-119.82504, 36.7199], [-119.82507, 36.71989], [-119.82535, 36.71988]]]]} | Open Access 1 | 48591 | Unknown park - Fresno, City of | 33300 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.496 | 0 | Local Other or Unknown 14 | 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]);