units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by MNG_AGENCY descending
This data as json, copyable, CSV (advanced)
Suggested facets: LAYER
MNG_AGENCY >30
- San Diego, City of 533
- Los Angeles, City of 491
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 101
- Fresno, City of 95
- Modesto, City of 85
- Santa Rosa, City of 83
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Torrance, City of 73
- Tracy, City of 73
- Santa Cruz, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- San Luis Obispo, City of 66
- Newport Beach, City of 65
- Davis, City of 65
- Santa Barbara, City of 64
- Clovis, City of 62
- Glendale, City of 61
- Riverside, City of 61
- Bakersfield, City of 61
- …
DES_TP >30
- Local Park 7,486
- Local Recreation Area 1,440
- Local Other or Unknown 663
- Local Conservation Area 143
- Local Historic or Cultural Area 37
- Local Resource Management Area 6
- National Monument or Landmark 5
- None 1
- None 1
- National Forest 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
- …
AGNCY_TYP 21 ✖
- City Agency 10,292
- School District 123
- State Agency 16
- Flood District 15
- Water District 12
- Utility 12
- Commercial 10
- Home Owners Association 9
- County Agency 8
- Federal Agency 5
- Recreation/Parks District 4
- Other 4
- Transportation Agency 3
- Open Space District 2
- County Agency - Parks 2
- Non Profit - Other 2
- County Agency - Other 1
- Port/Harbor District 1
- Sanitation District 1
- Special District - Other 1
- Education 1
ACCESS_TYP 4
- Open Access 9,925
- Restricted Access 363
- No Public Access 207
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,524 ✖
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 | |||
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 | |||
12222 | 12222 | 12221 | {"type": "Polygon", "coordinates": [[[-120.65746, 40.41862], [-120.65737, 40.41884], [-120.65689, 40.41872], [-120.65681, 40.41889], [-120.65676, 40.41889], [-120.65671, 40.41903], [-120.65723, 40.41917], [-120.65707, 40.41957], [-120.65304, 40.41858], [-120.65356, 40.4172], [-120.65359, 40.41718], [-120.65691, 40.41799], [-120.65709, 40.41757], [-120.65715, 40.41759], [-120.65699, 40.418], [-120.65714, 40.41805], [-120.65712, 40.41811], [-120.65504, 40.41759], [-120.65487, 40.41798], [-120.65746, 40.41862]]]} | Open Access 1 | 25416 | Memorial Park | 22140 | 1437 | Susanville, City of 1013 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | Lassen 54 | 11.523 | Memorial Park | 0 | Local Park 2 | 4 | |
12223 | 12223 | 12222 | {"type": "Polygon", "coordinates": [[[-120.65267, 40.41073], [-120.6516, 40.41196], [-120.65146, 40.4118], [-120.65132, 40.41167], [-120.65058, 40.41121], [-120.65046, 40.41058], [-120.65049, 40.41027], [-120.65078, 40.40988], [-120.65179, 40.41035], [-120.65181, 40.41033], [-120.65267, 40.41073]]]} | Open Access 1 | 25417 | Riverside Park | 24458 | 1437 | Susanville, City of 1013 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | Lassen 54 | 5.83 | Riverside Park | 0 | Local Park 2 | 4 | |
12224 | 12224 | 12223 | {"type": "Polygon", "coordinates": [[[-120.65866, 40.41492], [-120.65846, 40.41525], [-120.65785, 40.41487], [-120.65713, 40.4142], [-120.65694, 40.41415], [-120.65669, 40.41415], [-120.65642, 40.41419], [-120.65538, 40.41461], [-120.65454, 40.41459], [-120.65442, 40.4145], [-120.65445, 40.41416], [-120.6546, 40.41418], [-120.65461, 40.41429], [-120.65474, 40.41429], [-120.65475, 40.41419], [-120.65542, 40.41425], [-120.65545, 40.41398], [-120.65556, 40.41398], [-120.65559, 40.41368], [-120.65758, 40.41388], [-120.65784, 40.41394], [-120.65802, 40.41405], [-120.65815, 40.41423], [-120.6582, 40.41433], [-120.65828, 40.41468], [-120.65831, 40.41475], [-120.65839, 40.4148], [-120.65866, 40.41492]]]} | Open Access 1 | 25418 | Susan River Park | 26079 | 1437 | Susanville, City of 1013 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | Lassen 54 | 5.128 | Susan River Park | 0 | Local Park 2 | 4 | |
13043 | 13043 | 13042 | {"type": "Polygon", "coordinates": [[[-120.64976, 40.41359], [-120.64933, 40.41358], [-120.64902, 40.41334], [-120.64894, 40.41443], [-120.64785, 40.41413], [-120.64787, 40.41406], [-120.64746, 40.41393], [-120.64746, 40.41391], [-120.64718, 40.41378], [-120.6472, 40.41372], [-120.64686, 40.41359], [-120.64682, 40.41365], [-120.64671, 40.41361], [-120.64675, 40.41353], [-120.64674, 40.4135], [-120.6464, 40.41308], [-120.64605, 40.41271], [-120.64614, 40.41239], [-120.64652, 40.41262], [-120.64737, 40.41246], [-120.64744, 40.41243], [-120.64902, 40.41302], [-120.64976, 40.41356], [-120.64976, 40.41359]]]} | Open Access 1 | 34885 | Little Leage Park | 21342 | 1437 | Susanville, City of 1013 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | Lassen 54 | 8.66 | Little Leage Park | 0 | Local Park 2 | 4 | |
12212 | 12212 | 12211 | {"type": "Polygon", "coordinates": [[[-124.13906, 40.59247], [-124.13676, 40.59354], [-124.13602, 40.5939], [-124.13375, 40.59256], [-124.13595, 40.59061], [-124.13772, 40.59169], [-124.13906, 40.59247]]]} | Open Access 1 | 25411 | Newburg Park | 22715 | 1434 | Fortuna, City of 1012 | City 2 | City Agency 2 | http://friendlyfortuna.com/index.aspx?nid=95 | City 2 | 1434 | Fortuna, City of 974 | City 2 | City Agency 2 | Humboldt 45 | 20.168 | Newburg 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]);