units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 128
- Ventura, City of 97
- Los Angeles, City of 96
- Long Beach, City of 54
- Roseville, City of 47
- Poway, City of 43
- Irvine, City of 38
- San Jose, City of 31
- Torrance, City of 31
- San Ramon, City of 26
- Davis, City of 25
- Encinitas, City of 23
- Stockton, City of 23
- California City, City of 23
- San Francisco, City and County of 22
- Santa Cruz, City of 21
- Santa Clarita, City of 21
- Murrieta, City of 21
- Napa, City of 21
- Sacramento, City of 21
- Rocklin, City of 21
- Glendale, City of 20
- Seaside, City of 17
- San Jacinto, City of 17
- Eureka, City of 17
- San Luis Obispo, City of 16
- Yorba Linda, City of 16
- Azusa, City of 15
- Palmdale, City of 15
- Aliso Viejo, City of 15
- …
DES_TP >30
- Local Park 984
- Local Recreation Area 545
- Local Other or Unknown 467
- Local Conservation Area 33
- National Monument or Landmark 5
- Local Historic or Cultural Area 4
- Local Resource Management Area 2
- National Forest 1
- National Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,950
- Restricted Access 191
- No Public Access 51
- Unknown Access 10
MNG_AG_TYP 1
- City Agency · 2,202 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12745 | 12745 | 12744 | {"type": "Polygon", "coordinates": [[[-115.48238, 32.67698], [-115.48238, 32.67704], [-115.4816, 32.67704], [-115.48102, 32.67713], [-115.48102, 32.67576], [-115.48238, 32.67576], [-115.48238, 32.67698]]]} | Open Access 1 | 30420 | Villa Santa Fe Park | 27106 | 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 | 4.566 | Villa Santa Fe Park | 0 | Local Park 2 | 4 | |
12749 | 12749 | 12748 | {"type": "Polygon", "coordinates": [[[-121.64534, 37.09758], [-121.64513, 37.0978], [-121.6447, 37.09753], [-121.64468, 37.09751], [-121.64467, 37.09747], [-121.64508, 37.09703], [-121.64513, 37.09701], [-121.64518, 37.09701], [-121.64536, 37.09709], [-121.64555, 37.09721], [-121.64558, 37.09725], [-121.64557, 37.09729], [-121.64551, 37.09736], [-121.64537, 37.09739], [-121.6453, 37.09744], [-121.64528, 37.09747], [-121.64529, 37.09752], [-121.64534, 37.09758]]]} | Open Access 1 | 29872 | Hamilton Square Park | 19623 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 0.921 | Hamilton Square Park | 0 | Local Park 2 | 4 | |
12751 | 12751 | 12750 | {"type": "Polygon", "coordinates": [[[-122.28639, 38.32781], [-122.28618, 38.32824], [-122.28595, 38.32832], [-122.2858, 38.32854], [-122.28586, 38.32868], [-122.28572, 38.32875], [-122.28578, 38.32889], [-122.28586, 38.32893], [-122.28611, 38.32952], [-122.28229, 38.33143], [-122.28223, 38.33134], [-122.28218, 38.33116], [-122.28212, 38.33105], [-122.28205, 38.33067], [-122.28208, 38.33057], [-122.28221, 38.33029], [-122.28238, 38.3301], [-122.28274, 38.32963], [-122.283, 38.32938], [-122.28354, 38.32942], [-122.28357, 38.32905], [-122.28346, 38.32846], [-122.28339, 38.32831], [-122.28311, 38.32801], [-122.28299, 38.32725], [-122.28348, 38.32666], [-122.2842, 38.32623], [-122.28442, 38.32579], [-122.28415, 38.32526], [-122.28519, 38.32529], [-122.28526, 38.32548], [-122.28543, 38.32545], [-122.28553, 38.32616], [-122.28523, 38.32619], [-122.28523, 38.3262], [-122.28639, 38.32781]]]} | Open Access 1 | 29782 | Trancas Crossing Park | 26513 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 31.544 | Trancas Crossing Park | 0 | Local Park 2 | 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 | |
12754 | 12754 | 12753 | {"type": "MultiPolygon", "coordinates": [[[[-119.2706, 34.25499], [-119.27035, 34.25506], [-119.27018, 34.25466], [-119.27042, 34.25458], [-119.2706, 34.25499]]], [[[-119.27083, 34.25554], [-119.27058, 34.25561], [-119.27036, 34.25508], [-119.27061, 34.25501], [-119.27083, 34.25554]]], [[[-119.27122, 34.25601], [-119.27109, 34.25605], [-119.27045, 34.25457], [-119.27049, 34.25456], [-119.2705, 34.2546], [-119.27081, 34.25533], [-119.27117, 34.25591], [-119.27122, 34.25601]]], [[[-119.27105, 34.25606], [-119.27081, 34.25613], [-119.27059, 34.25563], [-119.27084, 34.25556], [-119.27105, 34.25606]]]]} | Open Access 1 | 46907 | City Beach | 30410 | 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.236 | City Beach | 0 | Local Park 2 | 4 | |
12755 | 12755 | 12754 | {"type": "Polygon", "coordinates": [[[-122.71212, 38.43656], [-122.7117, 38.43671], [-122.71147, 38.43682], [-122.71142, 38.43649], [-122.71151, 38.43656], [-122.71162, 38.43657], [-122.71167, 38.43655], [-122.71171, 38.43652], [-122.71173, 38.43645], [-122.71168, 38.43638], [-122.71161, 38.43636], [-122.71132, 38.43638], [-122.71122, 38.43594], [-122.71127, 38.43592], [-122.7112, 38.43553], [-122.71192, 38.43544], [-122.7121, 38.43627], [-122.71212, 38.43656]]]} | Open Access 1 | 29786 | Burbank Home & Gardens | 16508 | 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 | 2.036 | Burbank Home & Gardens | 0 | Local Park 2 | 4 | |
12756 | 12756 | 12755 | {"type": "Polygon", "coordinates": [[[-122.71297, 38.43721], [-122.7128, 38.43723], [-122.71289, 38.43736], [-122.71246, 38.4374], [-122.71245, 38.43726], [-122.71248, 38.43725], [-122.71247, 38.43715], [-122.71295, 38.43713], [-122.71297, 38.43721]]]} | Open Access 1 | 29787 | Prince Memorial Greenway | 24005 | 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 | 0.243 | Prince Memorial Greenway | 0 | Local Recreation Area 3 | 4 | |
12758 | 12758 | 12757 | {"type": "Polygon", "coordinates": [[[-121.67438, 39.26967], [-121.67598, 39.26967], [-121.67602, 39.26972], [-121.67601, 39.2704], [-121.67595, 39.27044], [-121.67435, 39.27043], [-121.67432, 39.27039], [-121.67432, 39.26972], [-121.67434, 39.26969], [-121.67438, 39.26967]]]} | Open Access 1 | 29857 | Pennington Ranch Park | 23588 | 1177 | Live Oak, City of 432 | City 2 | City Agency 2 | http://www.liveoakcity.org/index.php/departments/parks-a-recreation | City 2 | 1177 | Live Oak, City of 426 | City 2 | City Agency 2 | Sutter 47 | 3.042 | Pennington Ranch Park | 0 | Local Park 2 | 4 | |
12759 | 12759 | 12758 | {"type": "Polygon", "coordinates": [[[-121.66336, 39.27091], [-121.66206, 39.27091], [-121.66229, 39.27159], [-121.66251, 39.27216], [-121.66249, 39.27218], [-121.66279, 39.27297], [-121.66259, 39.273], [-121.66227, 39.27217], [-121.66223, 39.27217], [-121.66184, 39.27105], [-121.66174, 39.27065], [-121.66164, 39.27007], [-121.6616, 39.26953], [-121.66181, 39.26948], [-121.66184, 39.26984], [-121.66191, 39.27025], [-121.66202, 39.27079], [-121.66335, 39.27078], [-121.66336, 39.27091]]]} | Open Access 1 | 29858 | Live Oak Trail | 21377 | 1177 | Live Oak, City of 432 | City 2 | City Agency 2 | http://www.liveoakcity.org/index.php/departments/parks-a-recreation | City 2 | 1177 | Live Oak, City of 426 | City 2 | City Agency 2 | Sutter 47 | 2.401 | Live Oak Trail | 0 | Local Recreation Area 3 | 4 | |
12760 | 12760 | 12759 | {"type": "Polygon", "coordinates": [[[-121.5371, 38.58568], [-121.53598, 38.58568], [-121.53599, 38.58453], [-121.53471, 38.58454], [-121.53471, 38.58397], [-121.5371, 38.58383], [-121.5371, 38.58568]]]} | Restricted Access 2 | 29861 | Westifield School Playsite | 31656 | 1376 | West Sacramento, City of 548 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 1376 | West Sacramento, City of 541 | City 2 | City Agency 2 | Yolo 33 | 6.689 | Westifield School Playsite | None 1117 | |||
12761 | 12761 | 12760 | {"type": "MultiPolygon", "coordinates": [[[[-117.49463, 33.90092], [-117.49453, 33.901], [-117.49383, 33.90091], [-117.49395, 33.9007], [-117.49401, 33.90052], [-117.49414, 33.90042], [-117.49421, 33.90034], [-117.49424, 33.90023], [-117.49421, 33.90011], [-117.49404, 33.89988], [-117.49393, 33.89967], [-117.49386, 33.89952], [-117.49387, 33.89939], [-117.49385, 33.89936], [-117.49373, 33.89929], [-117.49363, 33.89919], [-117.49355, 33.89914], [-117.49328, 33.89906], [-117.49316, 33.89906], [-117.49304, 33.89901], [-117.49297, 33.89895], [-117.49283, 33.89878], [-117.49358, 33.89836], [-117.49418, 33.89909], [-117.49433, 33.89935], [-117.49447, 33.89966], [-117.49456, 33.89993], [-117.49462, 33.90026], [-117.49465, 33.90054], [-117.49463, 33.90092]]], [[[-117.49574, 33.90107], [-117.49564, 33.90112], [-117.49505, 33.90105], [-117.49499, 33.90098], [-117.49501, 33.90053], [-117.49494, 33.89995], [-117.49488, 33.89974], [-117.49474, 33.89939], [-117.49484, 33.89936], [-117.49538, 33.90002], [-117.49532, 33.90011], [-117.49532, 33.90021], [-117.49567, 33.90064], [-117.49573, 33.90074], [-117.49576, 33.90088], [-117.49574, 33.90107]]]]} | Open Access 1 | 30005 | Riverwalk Dog Park | 24468 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 6.013 | Riverwalk Dog Park | 0 | Local Park 2 | 4 | |
12763 | 12763 | 12762 | {"type": "Polygon", "coordinates": [[[-118.35893, 33.85167], [-118.35893, 33.85181], [-118.35772, 33.85181], [-118.35772, 33.85168], [-118.35893, 33.85167]]]} | No Public Access 3 | 35836 | Entradero Swale 6 | 29163 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.421 | Entradero Swale 6 | None 1118 | |||
12764 | 12764 | 12763 | {"type": "Polygon", "coordinates": [[[-121.64045, 37.10439], [-121.64031, 37.10449], [-121.6399, 37.1043], [-121.63994, 37.10411], [-121.63996, 37.10391], [-121.63997, 37.10388], [-121.64001, 37.10386], [-121.64056, 37.10383], [-121.64063, 37.10385], [-121.64065, 37.1039], [-121.64062, 37.10398], [-121.64056, 37.10414], [-121.64046, 37.10431], [-121.64045, 37.10439]]]} | Open Access 1 | 29866 | Mill Creek Park | 22225 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 0.854 | Mill Creek Park | 0 | Local Park 2 | 4 | |
12765 | 12765 | 12764 | {"type": "Polygon", "coordinates": [[[-121.6469, 37.13309], [-121.64667, 37.13327], [-121.64624, 37.13293], [-121.6465, 37.13273], [-121.6468, 37.13287], [-121.64679, 37.13293], [-121.6468, 37.13298], [-121.64682, 37.13303], [-121.6469, 37.13309]]]} | Open Access 1 | 29867 | Belle Estates Park | 15983 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 0.451 | Belle Estates Park | 0 | Local Park 2 | 4 | |
12766 | 12766 | 12765 | {"type": "Polygon", "coordinates": [[[-121.66244, 37.12502], [-121.66156, 37.1255], [-121.66085, 37.12469], [-121.66099, 37.12461], [-121.66139, 37.12504], [-121.66161, 37.12494], [-121.66161, 37.12492], [-121.66121, 37.12449], [-121.66172, 37.12421], [-121.66186, 37.12436], [-121.6615, 37.12455], [-121.66175, 37.12485], [-121.66211, 37.12466], [-121.66244, 37.12502]]]} | Open Access 1 | 29868 | Civic Centre/City Hall | 17371 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 1.842 | Civic Centre/City Hall | None 1119 | |||
12767 | 12767 | 12766 | {"type": "Polygon", "coordinates": [[[-121.66901, 37.14031], [-121.66901, 37.14031], [-121.66891, 37.14072], [-121.66879, 37.1406], [-121.66882, 37.14057], [-121.66865, 37.14041], [-121.66888, 37.14025], [-121.66894, 37.14029], [-121.66901, 37.14031]]]} | Open Access 1 | 29869 | Fox Hollow Park | 19033 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 0.201 | Fox Hollow Park | 0 | Local Park 2 | 4 | |
12768 | 12768 | 12767 | {"type": "Polygon", "coordinates": [[[-121.67256, 37.14164], [-121.6723, 37.14182], [-121.67205, 37.14183], [-121.67193, 37.1418], [-121.67196, 37.14175], [-121.67196, 37.14169], [-121.67191, 37.14163], [-121.67184, 37.1416], [-121.67222, 37.14133], [-121.67256, 37.14164]]]} | Open Access 1 | 29870 | Murphy Spring Park | 22610 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 0.498 | Murphy Spring Park | 0 | Local Park 2 | 4 | |
12770 | 12770 | 12769 | {"type": "Polygon", "coordinates": [[[-117.78119, 33.73044], [-117.78104, 33.7306], [-117.78064, 33.73033], [-117.78042, 33.73055], [-117.78042, 33.73057], [-117.78053, 33.73064], [-117.78014, 33.73105], [-117.78022, 33.73111], [-117.78025, 33.73115], [-117.78031, 33.73116], [-117.78044, 33.73125], [-117.7804, 33.73129], [-117.78037, 33.73128], [-117.77951, 33.73068], [-117.78034, 33.72981], [-117.78073, 33.73007], [-117.78074, 33.73012], [-117.78071, 33.7302], [-117.78071, 33.73029], [-117.78074, 33.73036], [-117.78079, 33.73042], [-117.78088, 33.73047], [-117.78098, 33.73049], [-117.78109, 33.73048], [-117.78119, 33.73044]]]} | Open Access 1 | 30202 | Homestead Park | 20063 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.07 | Homestead Park | 0 | Local Park 2 | 4 | |
12771 | 12771 | 12770 | {"type": "Polygon", "coordinates": [[[-117.99435, 33.87165], [-117.99397, 33.87165], [-117.99397, 33.87136], [-117.99435, 33.87136], [-117.99435, 33.87165]]]} | Open Access 1 | 30326 | Lindergh Mini Park | 21296 | 1037 | Buena Park, City of 136 | City 2 | City Agency 2 | http://www.buenapark.com/ | City 2 | 1037 | Buena Park, City of 133 | City 2 | City Agency 2 | Orange 3 | 0.28 | Lindergh MP | 0 | Local Park 2 | 4 | |
12772 | 12772 | 12771 | {"type": "Polygon", "coordinates": [[[-117.82719, 33.63112], [-117.82621, 33.63118], [-117.82627, 33.63102], [-117.82636, 33.63057], [-117.82638, 33.63043], [-117.82687, 33.6304], [-117.82712, 33.63051], [-117.82719, 33.63112]]]} | Open Access 1 | 30203 | Sepulveda Vista Point | 25308 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 1.538 | Sepulveda Vista Point | None 1120 |
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]);