units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,292 rows where AGNCY_LEV = 2 and MNG_AG_TYP = 2 sorted by AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
MNG_AGENCY >30
- San Diego, City of 525
- Los Angeles, City of 485
- San Jose, City of 253
- San Francisco, City and County of 238
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 144
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 90
- Modesto, City of 85
- Santa Rosa, City of 82
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Cruz, City of 72
- Torrance, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- Davis, City of 65
- San Luis Obispo, City of 64
- Santa Barbara, City of 64
- Newport Beach, City of 64
- Glendale, City of 61
- Bakersfield, City of 61
- Manteca, City of 61
- Riverside, City of 60
- …
ACCESS_TYP 4
- Open Access 9,819
- Restricted Access 242
- No Public Access 202
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,292 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15325 | 15325 | 15324 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19586], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | 48970 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1153 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | Los Angeles 6 | 5.621 | 0 | Local Other or Unknown 14 | 4 | ||
15299 | 15299 | 15298 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97453, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97473, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | 46437 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.341 | Lemon Trail | 0 | Local Recreation Area 3 | 4 | |
15300 | 15300 | 15299 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | 46439 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.468 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
15301 | 15301 | 15300 | {"type": "Polygon", "coordinates": [[[-117.97472, 34.14357], [-117.97464, 34.14362], [-117.96441, 34.1437], [-117.96441, 34.14354], [-117.97458, 34.14347], [-117.97472, 34.14357]]]} | Open Access 1 | 46438 | Royal Oaks Trail North | 29711 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 4.034 | Royal Oaks Trail North | None 1352 | |||
15031 | 15031 | 15030 | {"type": "Polygon", "coordinates": [[[-122.83393, 41.61987], [-122.83324, 41.62052], [-122.83325, 41.62054], [-122.83331, 41.62054], [-122.83314, 41.62075], [-122.83212, 41.62027], [-122.83205, 41.62032], [-122.83181, 41.62017], [-122.83282, 41.61921], [-122.83393, 41.61987]]]} | Open Access 1 | 45683 | Walker Field | 28497 | 1701 | Fort Jones, City of 1135 | City 2 | City Agency 2 | City 2 | 1701 | Fort Jones, City of 1090 | City 2 | City Agency 2 | Siskiyou 28 | 3.716 | Walker Field | 0 | Local Recreation Area 3 | 4 | ||
14926 | 14926 | 14925 | {"type": "Polygon", "coordinates": [[[-122.27139, 41.21224], [-122.27137, 41.21239], [-122.27096, 41.21242], [-122.27099, 41.2122], [-122.27139, 41.21224]]]} | Open Access 1 | 45500 | Children's Park | 28333 | 1700 | Dunsmuir, City of 1127 | City 2 | City Agency 2 | http://ci.dunsmuir.ca.us/ | City 2 | 1700 | Dunsmuir, City of 1082 | City 2 | City Agency 2 | Siskiyou 28 | 0.166 | Children's Park | 0 | Local Park 2 | 4 | |
14742 | 14742 | 14741 | {"type": "Polygon", "coordinates": [[[-115.61857, 33.0338], [-115.61857, 33.035], [-115.6174, 33.035], [-115.6174, 33.0338], [-115.61857, 33.0338]]]} | Open Access 1 | 45123 | Jake James Municipal Sports Park Development | 28025 | 1678 | Westmorland, City of 1121 | City 2 | City Agency 2 | http://www.cityofwestmorland.net/ | City 2 | 1678 | Westmorland, City of 1076 | City 2 | City Agency 2 | Imperial 20 | 3.592 | Jake James Municipal Sports Park Development | None 1263 | |||
13089 | 13089 | 13088 | {"type": "Polygon", "coordinates": [[[-121.05633, 39.21384], [-121.05624, 39.2148], [-121.05553, 39.21478], [-121.05558, 39.21505], [-121.05434, 39.21508], [-121.05425, 39.21443], [-121.0543, 39.21412], [-121.05428, 39.21375], [-121.05416, 39.21327], [-121.05422, 39.21324], [-121.05475, 39.21318], [-121.055, 39.21318], [-121.05574, 39.21354], [-121.05609, 39.21357], [-121.05608, 39.21382], [-121.05633, 39.21384]]]} | Open Access 1 | 35006 | Memorial Park | 22141 | 1673 | Grass Valley, City of 1042 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 7.576 | Memorial Park | 0 | Local Park 2 | 4 | |
13107 | 13107 | 13106 | {"type": "Polygon", "coordinates": [[[-121.08051, 39.21484], [-121.07948, 39.21911], [-121.079, 39.21958], [-121.07426, 39.21962], [-121.07422, 39.21856], [-121.07364, 39.2184], [-121.07337, 39.21828], [-121.07315, 39.21815], [-121.07263, 39.21792], [-121.07203, 39.21758], [-121.07158, 39.21846], [-121.07066, 39.21733], [-121.07041, 39.2173], [-121.0703, 39.21726], [-121.06975, 39.21716], [-121.06983, 39.21701], [-121.06969, 39.21698], [-121.06975, 39.21679], [-121.06907, 39.21666], [-121.06909, 39.21661], [-121.06981, 39.21672], [-121.06983, 39.21661], [-121.06921, 39.2165], [-121.06922, 39.2164], [-121.06988, 39.2165], [-121.06998, 39.21629], [-121.07018, 39.21633], [-121.07029, 39.21636], [-121.07032, 39.21621], [-121.07108, 39.2163], [-121.07093, 39.21613], [-121.07093, 39.21604], [-121.07087, 39.21589], [-121.07093, 39.21578], [-121.07093, 39.21568], [-121.07101, 39.21568], [-121.07102, 39.21567], [-121.07055, 39.21477], [-121.07074, 39.21497], [-121.07089, 39.21518], [-121.07154, 39.21486], [-121.07188, 39.21488], [-121.07218, 39.21487], [-121.07218, 39.21524], [-121.07229, 39.21523], [-121.07263, 39.21526], [-121.07305, 39.21534], [-121.073, 39.21539], [-121.07301, 39.21541], [-121.074, 39.21536], [-121.07443, 39.21526], [-121.07459, 39.21506], [-121.07525, 39.215], [-121.07581, 39.21497], [-121.07609, 39.21494], [-121.07654, 39.21495], [-121.0766, 39.21591], [-121.07869, 39.21589], [-121.07868, 39.21527], [-121.07931, 39.2153], [-121.0792, 39.21489], [-121.08051, 39.21484]]]} | Open Access 1 | 35025 | Condon Park | 17580 | 1673 | Grass Valley, City of 1042 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 83.068 | Condon Park | 0 | Local Park 2 | 4 | |
13108 | 13108 | 13107 | {"type": "Polygon", "coordinates": [[[-121.07218, 39.21473], [-121.07194, 39.21477], [-121.07179, 39.21476], [-121.07153, 39.2147], [-121.07127, 39.21456], [-121.07117, 39.21456], [-121.07145, 39.21433], [-121.07113, 39.21408], [-121.07115, 39.21401], [-121.07109, 39.21397], [-121.07094, 39.21396], [-121.07073, 39.21399], [-121.07056, 39.21411], [-121.07051, 39.21404], [-121.07053, 39.21399], [-121.07098, 39.21389], [-121.07206, 39.21396], [-121.07218, 39.21473]]]} | Open Access 1 | 35026 | Minnie Park | 22268 | 1673 | Grass Valley, City of 1042 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 1.677 | Minnie Park | 0 | Local Park 2 | 4 | |
14281 | 14281 | 14280 | {"type": "Polygon", "coordinates": [[[-121.07036, 39.22802], [-121.06963, 39.22835], [-121.07019, 39.22913], [-121.06979, 39.22933], [-121.07021, 39.22992], [-121.07021, 39.22996], [-121.0703, 39.22994], [-121.0702, 39.23017], [-121.07018, 39.23007], [-121.07008, 39.22999], [-121.06941, 39.23031], [-121.06873, 39.2306], [-121.06891, 39.23093], [-121.0685, 39.23105], [-121.06789, 39.23117], [-121.06728, 39.23008], [-121.0669, 39.22946], [-121.0669, 39.22935], [-121.0671, 39.22932], [-121.06727, 39.22922], [-121.06745, 39.22784], [-121.06751, 39.22721], [-121.06752, 39.22688], [-121.06839, 39.22691], [-121.0684, 39.22791], [-121.06981, 39.22726], [-121.07036, 39.22802]]]} | Open Access 1 | 44208 | DeVere Mautino Park | 18126 | 1673 | Grass Valley, City of 1042 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 21.376 | DeVere Mautino Park | 0 | Local Park 2 | 4 | |
14854 | 14854 | 14853 | {"type": "Polygon", "coordinates": [[[-121.05875, 39.21793], [-121.0585, 39.21826], [-121.05842, 39.21828], [-121.05813, 39.21785], [-121.0587, 39.21786], [-121.05875, 39.21793]]]} | Open Access 1 | 45357 | Dow Alexander Park | 18253 | 1673 | Grass Valley, City of 1042 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 0.356 | Dow Alexander Park | 0 | Local Park 2 | 4 | |
13052 | 13052 | 13051 | {"type": "Polygon", "coordinates": [[[-120.24958, 39.68178], [-120.24797, 39.68179], [-120.24795, 39.68118], [-120.24692, 39.68118], [-120.24691, 39.68182], [-120.24567, 39.68182], [-120.24567, 39.68073], [-120.24958, 39.68072], [-120.24958, 39.68178]]]} | Open Access 1 | 34905 | Loyalton Park | 21571 | 1669 | Loyalton, City of 1040 | City 2 | City Agency 2 | http://www.cityofloyalton.com/ | City 2 | 1669 | Loyalton, City of 1002 | City 2 | City Agency 2 | Sierra 58 | 8.349 | Loyalton Park | 0 | Local Park 2 | 4 | |
12722 | 12722 | 12721 | {"type": "MultiPolygon", "coordinates": [[[[-118.39518, 37.3677], [-118.39443, 37.36771], [-118.39444, 37.36867], [-118.39296, 37.36869], [-118.39296, 37.36913], [-118.39235, 37.36914], [-118.39235, 37.36952], [-118.39077, 37.36954], [-118.39079, 37.36747], [-118.39075, 37.36733], [-118.39065, 37.36722], [-118.39056, 37.36716], [-118.39045, 37.36712], [-118.39024, 37.36712], [-118.39011, 37.36715], [-118.38999, 37.36721], [-118.3899, 37.36729], [-118.38971, 37.3675], [-118.38957, 37.36758], [-118.38942, 37.3676], [-118.38865, 37.3676], [-118.38863, 37.36759], [-118.38861, 37.36726], [-118.38856, 37.36687], [-118.38826, 37.3655], [-118.38822, 37.36523], [-118.38821, 37.36502], [-118.39085, 37.36498], [-118.39086, 37.36628], [-118.3933, 37.36627], [-118.39331, 37.36654], [-118.39517, 37.36652], [-118.39518, 37.3677]]], [[[-118.39051, 37.36954], [-118.38862, 37.36958], [-118.3886, 37.36772], [-118.38935, 37.36771], [-118.38948, 37.36769], [-118.38959, 37.36764], [-118.38969, 37.36757], [-118.38992, 37.36732], [-118.39001, 37.36727], [-118.39012, 37.36724], [-118.39029, 37.36723], [-118.39038, 37.36727], [-118.39046, 37.36732], [-118.3905, 37.36739], [-118.39052, 37.36747], [-118.39051, 37.36954]]]]} | Open Access 1 | 29743 | Bishop Park | 16127 | 1466 | Bishop, City of 1033 | City 2 | City Agency 2 | http://www.ca-bishop.us/departments/parks-and-recreation/ | City 2 | 1466 | Bishop, City of 995 | City 2 | City Agency 2 | Inyo 43 | 50.11 | Bishop Park | 0 | Local Park 2 | 4 | |
12635 | 12635 | 12634 | {"type": "Polygon", "coordinates": [[[-117.36926, 34.42046], [-117.36922, 34.42053], [-117.36874, 34.42025], [-117.36926, 34.42025], [-117.36926, 34.42046]]]} | Open Access 1 | 48796 | Dogwood Park | 33517 | 1687 | Hesperia, City of 1032 | City 2 | City Agency 2 | http://cityofhesperia.us/ | City 2 | 1687 | Hesperia, City of 993 | City 2 | City Agency 2 | San Bernardino 22 | 0.193 | Dogwood Park | 0 | Local Park 2 | 4 | |
14569 | 14569 | 14568 | {"type": "Polygon", "coordinates": [[[-117.34807, 34.39252], [-117.34644, 34.39297], [-117.34644, 34.39241], [-117.34645, 34.3924], [-117.34645, 34.39224], [-117.34644, 34.39223], [-117.34643, 34.39087], [-117.34807, 34.39088], [-117.34807, 34.39252]]]} | Open Access 1 | 44713 | Maple Park | 21781 | 1687 | Hesperia, City of 1032 | City 2 | City Agency 2 | http://cityofhesperia.us/ | City 2 | 1687 | Hesperia, City of 993 | City 2 | City Agency 2 | San Bernardino 22 | 7.717 | Maple Park | 0 | Local Park 2 | 4 | |
12424 | 12424 | 12423 | {"type": "Polygon", "coordinates": [[[-120.46646, 39.8064], [-120.4655, 39.80642], [-120.46531, 39.80634], [-120.46485, 39.8061], [-120.46454, 39.80602], [-120.4642, 39.80597], [-120.46385, 39.80599], [-120.46339, 39.80605], [-120.46378, 39.80554], [-120.46349, 39.80538], [-120.46379, 39.80504], [-120.46357, 39.80482], [-120.46349, 39.80484], [-120.46315, 39.80507], [-120.46279, 39.80499], [-120.46276, 39.80495], [-120.46377, 39.80408], [-120.46384, 39.80406], [-120.46403, 39.80426], [-120.46435, 39.80441], [-120.46472, 39.80457], [-120.46496, 39.80483], [-120.46646, 39.8064]]]} | Open Access 1 | 27030 | Portola City Park | 23905 | 1457 | Portola, City of 1024 | City 2 | City Agency 2 | http://www.ci.portola.ca.us/parks-and-recreation.htm | City 2 | 1457 | Portola, City of 986 | City 2 | City Agency 2 | Plumas 57 | 8.545 | Portola City Park | 0 | Local Park 2 | 4 | |
12417 | 12417 | 12416 | {"type": "Polygon", "coordinates": [[[-120.95949, 39.10159], [-120.95945, 39.10173], [-120.95943, 39.1019], [-120.95944, 39.10206], [-120.95949, 39.10232], [-120.95916, 39.10231], [-120.95914, 39.10235], [-120.95906, 39.10233], [-120.95821, 39.10235], [-120.95783, 39.10232], [-120.95727, 39.10236], [-120.95718, 39.10235], [-120.95704, 39.1023], [-120.95703, 39.10213], [-120.95737, 39.10186], [-120.95798, 39.10146], [-120.9586, 39.10103], [-120.95861, 39.101], [-120.95888, 39.10096], [-120.95898, 39.10097], [-120.95907, 39.10105], [-120.95918, 39.10124], [-120.95929, 39.10124], [-120.95949, 39.10159]]]} | Open Access 1 | 27023 | Lions Children's Park | 21313 | 1455 | Colfax, City of 1023 | City 2 | City Agency 2 | http://www.colfax-ca.gov/ | City 2 | 1455 | Colfax, City of 985 | City 2 | City Agency 2 | Placer 35 | 5.339 | Lions Children's Park | 0 | Local Park 2 | 4 | |
12226 | 12226 | 12225 | {"type": "Polygon", "coordinates": [[[-122.12463, 40.02809], [-122.12351, 40.0282], [-122.12336, 40.02734], [-122.12448, 40.02722], [-122.12463, 40.02809]]]} | Open Access 1 | 25420 | Halbert Park | 19599 | 1676 | Tehama, City of 1014 | City 2 | City Agency 2 | http://www.cityoftehama.us/ | City 2 | 1676 | Tehama, City of 976 | City 2 | City Agency 2 | Tehama 18 | 2.327 | Halbert Park | 0 | Local Park 2 | 4 | |
14517 | 14517 | 14516 | {"type": "Polygon", "coordinates": [[[-122.1237, 40.02267], [-122.12257, 40.02279], [-122.12242, 40.02192], [-122.12354, 40.02181], [-122.1237, 40.02267]]]} | Open Access 1 | 45002 | Tehama City Parks | 26220 | 1676 | Tehama, City of 1014 | City 2 | City Agency 2 | http://www.cityoftehama.us/ | City 2 | 1676 | Tehama, City of 976 | City 2 | City Agency 2 | Tehama 18 | 2.327 | Tehama City Parks | None 1235 |
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]);