units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,414 rows where AGNCY_LEV = 2 and DES_TP = 3 sorted by AGNCY_ID descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 209
- Los Angeles, City of 115
- San Francisco, City and County of 80
- San Luis Obispo, City of 24
- Glendale, City of 24
- Davis, City of 23
- Long Beach, City of 23
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Santa Clarita, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Santa Cruz, City of 14
- San Marcos, City of 14
- Tiburon, Town of 13
- Poway, City of 12
- San Bernardino, City of 12
- Carlsbad, City of 11
- Mission Viejo, City of 11
- Fresno, City of 10
- Oceanside, City of 10
- Riverside, City of 9
- Irvine, City of 9
- Roseville, City of 9
- Santa Barbara, City of 8
- South San Francisco, City of 8
- Escondido, City of 8
- Chico, City of 8
- …
MNG_AG_TYP 7
ACCESS_TYP 4
- Open Access 1,229
- Restricted Access 140
- No Public Access 39
- Unknown Access 6
DES_TP 1
- Local Recreation Area · 1,414 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16895 | 16895 | 16894 | {"type": "Polygon", "coordinates": [[[-118.244, 33.99945], [-118.244, 34.00174], [-118.24354, 34.00179], [-118.24362, 33.99941], [-118.244, 33.99945]]]} | Open Access 1 | 10195 | Fred Roberts Recreation Center | 29143 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | Los Angeles 6 | 2.495 | Fred Roberts Rec. Ctr. | 0 | Local Recreation Area 3 | 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 | |
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 | ||
11412 | 11412 | 11411 | {"type": "Polygon", "coordinates": [[[-123.69388, 38.91003], [-123.69342, 38.91022], [-123.69342, 38.91022], [-123.69342, 38.90992], [-123.69374, 38.90991], [-123.69388, 38.91003]]]} | Open Access 1 | 48101 | Fisherman's Playground | 32606 | 1697 | Point Arena, City of 781 | City 2 | City Agency 2 | http://www.cityofpointarena.com/ | City 2 | 1697 | Point Arena, City of 761 | City 2 | City Agency 2 | https://pointarena.ca.gov/government/departments/parks-streets/ | Mendocino 24 | 0.214 | Fisherman's Playground | 0 | Local Recreation Area 3 | 4 |
3764 | 3764 | 3763 | {"type": "Polygon", "coordinates": [[[-121.30488, 38.5734], [-121.30175, 38.57341], [-121.30099, 38.57293], [-121.29923, 38.57175], [-121.29896, 38.57152], [-121.29829, 38.57106], [-121.29822, 38.57096], [-121.29824, 38.57085], [-121.29831, 38.57076], [-121.2984, 38.57069], [-121.301, 38.56951], [-121.30107, 38.56951], [-121.30111, 38.56954], [-121.30269, 38.57164], [-121.30277, 38.57172], [-121.30297, 38.57181], [-121.30301, 38.57185], [-121.30301, 38.57187], [-121.303, 38.57191], [-121.30287, 38.57198], [-121.30339, 38.57275], [-121.30414, 38.5724], [-121.30488, 38.5734]]]} | Open Access 1 | 34931 | Mather Sports Center | 21951 | 1671 | Rancho Cordova, City of 679 | City 2 | City Agency 2 | http://www.cityofranchocordova.org/ | City 2 | 1671 | Rancho Cordova, City of 669 | City 2 | City Agency 2 | Sacramento 41 | 27.915 | Mather Sports Ctr. | 0 | Local Recreation Area 3 | 4 | |
14959 | 14959 | 14958 | {"type": "Polygon", "coordinates": [[[-116.51081, 33.96249], [-116.51064, 33.96265], [-116.51039, 33.96264], [-116.51038, 33.96261], [-116.51024, 33.96261], [-116.51024, 33.96232], [-116.51076, 33.96232], [-116.5108, 33.96236], [-116.51081, 33.96249]]]} | Open Access 1 | 45567 | Frank Hodge Skate Park | 28395 | 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.428 | Frank Hodge Skate Park | 0 | Local Recreation Area 3 | 4 | |
11106 | 11106 | 11105 | {"type": "Polygon", "coordinates": [[[-121.76346, 38.66679], [-121.76344, 38.66826], [-121.76095, 38.66821], [-121.76099, 38.66679], [-121.76346, 38.66679]]]} | Open Access 1 | 21383 | Buchignani Field | 16471 | 1665 | Woodland, City of 547 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | Yolo 33 | 8.604 | Buchignani Field | 0 | Local Recreation Area 3 | 4 | |
11116 | 11116 | 11115 | {"type": "Polygon", "coordinates": [[[-121.78266, 38.68358], [-121.78268, 38.68384], [-121.78274, 38.68426], [-121.78275, 38.68463], [-121.78272, 38.68467], [-121.78268, 38.68468], [-121.78134, 38.68468], [-121.78135, 38.68377], [-121.78159, 38.68358], [-121.78266, 38.68358]]]} | Open Access 1 | 21380 | Clark Field | 17387 | 1665 | Woodland, City of 547 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | Yolo 33 | 3.522 | Clark Field | 0 | Local Recreation Area 3 | 4 | |
11117 | 11117 | 11116 | {"type": "Polygon", "coordinates": [[[-121.78147, 38.68367], [-121.78135, 38.68377], [-121.78134, 38.68468], [-121.77826, 38.68466], [-121.77822, 38.68465], [-121.7782, 38.68462], [-121.77821, 38.68357], [-121.77863, 38.68357], [-121.77864, 38.68366], [-121.78147, 38.68367]]]} | Open Access 1 | 21381 | Camarena Fields | 16746 | 1665 | Woodland, City of 547 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | Yolo 33 | 7.648 | Camarena Fields | 0 | Local Recreation Area 3 | 4 | |
11219 | 11219 | 11218 | {"type": "Polygon", "coordinates": [[[-122.46232, 37.68283], [-122.46232, 37.68287], [-122.46158, 37.68288], [-122.46158, 37.6826], [-122.46219, 37.68257], [-122.46219, 37.68283], [-122.46232, 37.68283]]]} | Open Access 1 | 48022 | Sterling Park Community Center | 32453 | 1456 | Colma, City of 968 | City 2 | City Agency 2 | http://www.colma.ca.gov/ | City 2 | 1456 | Colma, City of 934 | City 2 | City Agency 2 | https://www.colma.ca.gov/index.php?option=com_content&view=article&id=65&Itemid=82 | San Mateo 15 | 0.438 | Sterling Park Community Ctr. | 0 | Local Recreation Area 3 | 4 |
3534 | 3534 | 3533 | {"type": "Polygon", "coordinates": [[[-120.60822, 35.11477], [-120.60789, 35.11477], [-120.60766, 35.11474], [-120.60738, 35.11468], [-120.60693, 35.11464], [-120.6007, 35.11463], [-120.60066, 35.1146], [-120.60065, 35.11457], [-120.60063, 35.1127], [-120.60796, 35.11271], [-120.60821, 35.11292], [-120.60822, 35.11477]]]} | Open Access 1 | 28101 | Soto Sports Complex | 33130 | 1454 | Arroyo Grande, City of 611 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | San Luis Obispo 1 | 36.63 | Soto Sports Complex | 0 | Local Recreation Area 3 | 4 | |
12383 | 12383 | 12382 | {"type": "Polygon", "coordinates": [[[-120.61031, 35.12154], [-120.61029, 35.12194], [-120.60969, 35.12191], [-120.60971, 35.12151], [-120.61031, 35.12154]]]} | Open Access 1 | 26519 | South County Skate Park | 25645 | 1452 | Grover Beach, City of 654 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.608 | South County Skate Park | 0 | Local Recreation Area 3 | 4 | |
3253 | 3253 | 3252 | {"type": "Polygon", "coordinates": [[[-115.50404, 32.66996], [-115.50403, 32.67085], [-115.50251, 32.67088], [-115.50227, 32.67028], [-115.50227, 32.66996], [-115.50404, 32.66996]]]} | Open Access 1 | 29193 | American Legion Softball Field | 15453 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 3.933 | American Legion Softball Field | 0 | Local Recreation Area 3 | 4 | |
7056 | 7056 | 7055 | {"type": "Polygon", "coordinates": [[[-115.48239, 32.66837], [-115.48238, 32.66977], [-115.48154, 32.66977], [-115.48155, 32.66838], [-115.48239, 32.66837]]]} | Open Access 1 | 30417 | Rancho Elegante Field | 24144 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 3.013 | Rancho Elegante Field | 0 | Local Recreation Area 3 | 4 | |
12753 | 12753 | 12752 | {"type": "Polygon", "coordinates": [[[-115.4824, 32.68317], [-115.4824, 32.68418], [-115.48237, 32.68422], [-115.48019, 32.68423], [-115.4802, 32.68316], [-115.4824, 32.68317]]]} | Open Access 1 | 30421 | Joel Riesen Field | 20424 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 6.015 | Joel Riesen Field | 0 | Local Recreation Area 3 | 4 | |
13044 | 13044 | 13043 | {"type": "Polygon", "coordinates": [[[-115.49511, 32.6772], [-115.49465, 32.6772], [-115.49464, 32.67736], [-115.49442, 32.67736], [-115.49442, 32.67694], [-115.49436, 32.67693], [-115.49428, 32.67703], [-115.49416, 32.67713], [-115.49403, 32.6772], [-115.49382, 32.67724], [-115.49353, 32.67723], [-115.49353, 32.67649], [-115.49511, 32.67649], [-115.49511, 32.6772]]]} | Open Access 1 | 34886 | Emerson Field | 18621 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 2.892 | Emerson Field | 0 | Local Recreation Area 3 | 4 | |
14417 | 14417 | 14416 | {"type": "Polygon", "coordinates": [[[-123.9855, 40.88189], [-123.98541, 40.88195], [-123.98525, 40.88184], [-123.98534, 40.88177], [-123.9855, 40.88189]]]} | Open Access 1 | 47033 | City of Blue Lake Tot Lot | 30684 | 1443 | Blue Lake, City of 716 | City 2 | City Agency 2 | http://bluelake.ca.gov/ | City 2 | 1443 | Blue Lake, City of 699 | City 2 | City Agency 2 | Humboldt 45 | 0.047 | City of Blue Lake Tot Lot | 0 | Local Recreation Area 3 | 4 | |
11197 | 11197 | 11196 | {"type": "Polygon", "coordinates": [[[-122.19227, 39.92342], [-122.1916, 39.92338], [-122.19062, 39.92338], [-122.19061, 39.9235], [-122.1901, 39.9235], [-122.1901, 39.92247], [-122.19055, 39.92246], [-122.19054, 39.9208], [-122.19226, 39.9208], [-122.19227, 39.92342]]]} | Open Access 1 | 48028 | Corning Community Park and Skate Park | 32513 | 1440 | Corning, City of 644 | City 2 | City Agency 2 | http://www.corning.org/ | City 2 | 1440 | Corning, City of 634 | City 2 | City Agency 2 | Tehama 18 | 11.57 | Corning Community Park and Skate Park | 2013 | Local Recreation Area 3 | 4 | |
4428 | 4428 | 4427 | {"type": "Polygon", "coordinates": [[[-122.36952, 40.67363], [-122.36948, 40.67469], [-122.36818, 40.67463], [-122.36816, 40.6744], [-122.36828, 40.67405], [-122.36842, 40.67378], [-122.3686, 40.67367], [-122.36884, 40.67359], [-122.36924, 40.67359], [-122.36952, 40.67363]]]} | Open Access 1 | 48847 | Wynne Price Park and Baseball Field | 33567 | 1438 | Shasta Lake, City of 324 | City 2 | City Agency 2 | http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 | City 2 | 1438 | Shasta Lake, City of 321 | City 2 | City Agency 2 | https://cityofshastalake.org/553/Parks | Shasta 27 | 2.932 | Wynne Price Park and Baseball Field | 0 | Local Recreation Area 3 | 4 |
7301 | 7301 | 7300 | {"type": "Polygon", "coordinates": [[[-122.39795, 40.68894], [-122.39783, 40.69056], [-122.3966, 40.69054], [-122.39628, 40.69051], [-122.39582, 40.69042], [-122.39538, 40.69028], [-122.39545, 40.68923], [-122.39693, 40.68922], [-122.39713, 40.68908], [-122.39766, 40.68891], [-122.39795, 40.68894]]]} | Open Access 1 | 48427 | Bizz Johnson Ball Park | 33124 | 1438 | Shasta Lake, City of 324 | City 2 | City Agency 2 | http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 | City 2 | 1438 | Shasta Lake, City of 321 | City 2 | City Agency 2 | https://cityofshastalake.org/553/Parks | Shasta 27 | 7.801 | Bizz Johnson Ball Park | 0 | Local Recreation Area 3 | 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]);