units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,001
- County Agency 1,162
- Recreation/Parks District 1,131
- State Agency 1,120
- Non Profit - Land Trust 579
- Federal Agency 498
- Open Space District 421
- Water District 237
- County Agency - Parks 231
- Home Owners Association 201
- Community Services District 198
- Non Profit - Conservation 147
- Flood District 105
- Irrigation District 49
- Cemetery District 48
- Non Profit - Other 45
- School District 38
- County Agency - Other 32
- Port/Harbor District 31
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 481
- Los Angeles, City of 471
- California Department of Fish and Wildlife 431
- California Department of Parks and Recreation 379
- Mountains Recreation and Conservation Authority 345
- San Jose, City of 240
- San Francisco, City and County of 238
- Sacramento, City of 220
- Los Angeles, County of 170
- East Bay Regional Park District 165
- Long Beach, City of 148
- Ventura, City of 145
- Roseville, City of 130
- Oakland, City of 120
- United States Bureau of Land Management 117
- San Diego, County of 115
- Santa Barbara, County of 109
- United States Forest Service 105
- Irvine, City of 101
- Consumnes Community Services District 94
- Orange, County of 88
- United States National Park Service 85
- Modesto, City of 85
- Hayward Area Recreation and Park District 84
- California State Lands Commission 83
- United States Fish and Wildlife Service 81
- Stockton, City of 81
- Napa, City of 81
- Santa Rosa, City of 79
- Torrance, City of 73
- …
DES_TP >30
- Local Park 8,856
- Local Recreation Area 1,941
- Local Other or Unknown 1,177
- Private Conservation 606
- Local Conservation Area 473
- State Conservation Area 372
- Private Recreation or Education 267
- State Park 207
- State Resource Management Area 158
- State Recreation Area 143
- Local Historic or Cultural Area 99
- National Forest 93
- National Wildlife Refuge 75
- National Public Lands 72
- State Other or Unknown 70
- State Historic or Cultural Area 63
- Recreation Management Area 60
- Private Other or Unknown 51
- National Monument or Landmark 39
- National Recreation Area 38
- Resource Management Area 26
- National Park 24
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 6
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 13,845
- Restricted Access 1,176
- No Public Access 955
- Unknown Access 380
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
713 | 713 | 712 | {"type": "Polygon", "coordinates": [[[-120.37829, 36.76067], [-120.37707, 36.76066], [-120.37707, 36.76016], [-120.37826, 36.76016], [-120.37829, 36.76067]]]} | Open Access 1 | 4089 | Veterans Park | 27047 | 1201 | Mendota, City of 243 | City 2 | City Agency 2 | http://www.thecityofmendota.com/ | City 2 | 1201 | Mendota, City of 239 | City 2 | City Agency 2 | Fresno 9 | 1.495 | Veterans Park | 0 | Local Park 2 | 4 | |
714 | 714 | 713 | {"type": "Polygon", "coordinates": [[[-122.43637, 37.77699], [-122.43332, 37.77738], [-122.43298, 37.7757], [-122.43603, 37.77532], [-122.43637, 37.77699]]]} | Open Access 1 | 4091 | Alamo Square | 15322 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 12.698 | Alamo Square | 2000 | Local Park 2 | 4 | |
715 | 715 | 714 | {"type": "Polygon", "coordinates": [[[-116.22695, 33.72294], [-116.22567, 33.72294], [-116.22566, 33.72343], [-116.2256, 33.72344], [-116.2256, 33.72375], [-116.22473, 33.72375], [-116.22472, 33.72386], [-116.22348, 33.72385], [-116.2235, 33.72127], [-116.22693, 33.72129], [-116.22696, 33.72135], [-116.22695, 33.72294]]]} | Open Access 1 | 5359 | Miles Avenue Park | 22218 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | Riverside 10 | 19.373 | Miles Avenue Park | 0 | Local Park 2 | 4 | |
716 | 716 | 715 | {"type": "Polygon", "coordinates": [[[-117.27592, 34.08551], [-117.27587, 34.08551], [-117.27587, 34.08575], [-117.27585, 34.08578], [-117.27582, 34.0858], [-117.27321, 34.0858], [-117.2732, 34.0828], [-117.27456, 34.08281], [-117.27456, 34.08462], [-117.27592, 34.08464], [-117.27592, 34.08551]]]} | Open Access 1 | 5364 | Mill Park | 22229 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 14.282 | Mill Park | 0 | Local Park 2 | 4 | |
717 | 717 | 716 | {"type": "Polygon", "coordinates": [[[-117.92419, 33.88391], [-117.92408, 33.88412], [-117.92397, 33.88429], [-117.92354, 33.88397], [-117.92333, 33.88404], [-117.92297, 33.88442], [-117.92231, 33.88498], [-117.92231, 33.88499], [-117.92279, 33.88538], [-117.92229, 33.8858], [-117.92197, 33.88601], [-117.92171, 33.88614], [-117.92123, 33.88634], [-117.92078, 33.8865], [-117.92073, 33.8865], [-117.92066, 33.88644], [-117.9205, 33.88616], [-117.92054, 33.88613], [-117.92028, 33.88566], [-117.92023, 33.88566], [-117.92021, 33.88554], [-117.92022, 33.88548], [-117.92027, 33.88542], [-117.9204, 33.88533], [-117.92058, 33.88525], [-117.92067, 33.88517], [-117.92073, 33.88504], [-117.92073, 33.88495], [-117.92071, 33.88487], [-117.92063, 33.88477], [-117.91997, 33.88433], [-117.91994, 33.8843], [-117.91993, 33.88424], [-117.92209, 33.88471], [-117.92255, 33.88401], [-117.9228, 33.8839], [-117.92419, 33.88391]]]} | Open Access 1 | 4247 | Lions Field | 21314 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 10.364 | Lions Field | 0 | Local Recreation Area 3 | 4 | |
718 | 718 | 717 | {"type": "Polygon", "coordinates": [[[-117.60541, 34.12], [-117.6054, 34.12133], [-117.60539, 34.12135], [-117.60535, 34.12137], [-117.60497, 34.12137], [-117.60497, 34.12048], [-117.60414, 34.12048], [-117.60415, 34.11982], [-117.6046, 34.11982], [-117.60461, 34.12], [-117.60541, 34.12]]]} | Open Access 1 | 4256 | Lions Park | 21322 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 2.725 | Lions Park | 0 | Local Park 2 | 4 | |
719 | 719 | 718 | {"type": "Polygon", "coordinates": [[[-117.43128, 34.09033], [-117.43029, 34.09034], [-117.43029, 34.09206], [-117.42712, 34.09208], [-117.42712, 34.09035], [-117.42919, 34.09034], [-117.42919, 34.08853], [-117.43127, 34.08852], [-117.43128, 34.09033]]]} | Open Access 1 | 4257 | Veteran's Park | 27018 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 23.464 | Veteran's Park | 0 | Local Park 2 | 4 | |
720 | 720 | 719 | {"type": "Polygon", "coordinates": [[[-117.64606, 33.71715], [-117.64569, 33.71705], [-117.6455, 33.71693], [-117.64478, 33.71604], [-117.64591, 33.71499], [-117.64598, 33.71518], [-117.64608, 33.71555], [-117.64612, 33.7158], [-117.64612, 33.71618], [-117.64606, 33.71715]]]} | Open Access 1 | 5401 | Modjeska Home and Garden | 22342 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 4.245 | Modjeska Home and Garden | 0 | Local Park 2 | 4 | |
721 | 721 | 720 | {"type": "Polygon", "coordinates": [[[-122.4813, 37.73044], [-122.48094, 37.73047], [-122.48094, 37.73108], [-122.47952, 37.73106], [-122.47952, 37.73057], [-122.47963, 37.73056], [-122.47999, 37.73047], [-122.48041, 37.73011], [-122.48105, 37.72997], [-122.48129, 37.73025], [-122.4813, 37.73044]]]} | Open Access 1 | 5402 | Rolph-Nicole Park | 24585 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 3.048 | Rolph-Nicole Park | 0 | Local Park 2 | 4 | |
722 | 722 | 721 | {"type": "Polygon", "coordinates": [[[-122.83574, 38.70857], [-122.83404, 38.71439], [-122.83246, 38.71428], [-122.83195, 38.71361], [-122.83141, 38.71316], [-122.83003, 38.71381], [-122.82919, 38.71302], [-122.82746, 38.71228], [-122.83039, 38.70765], [-122.83203, 38.70502], [-122.83218, 38.70502], [-122.83233, 38.70496], [-122.8323, 38.70537], [-122.83227, 38.70615], [-122.8323, 38.7063], [-122.83238, 38.70645], [-122.83245, 38.70654], [-122.83257, 38.70664], [-122.83314, 38.70693], [-122.83334, 38.70706], [-122.83352, 38.70722], [-122.83367, 38.70739], [-122.83381, 38.7076], [-122.83389, 38.70777], [-122.83393, 38.70792], [-122.83402, 38.7081], [-122.83426, 38.70838], [-122.83441, 38.7085], [-122.83459, 38.7086], [-122.83473, 38.70865], [-122.83492, 38.70869], [-122.83514, 38.70871], [-122.83533, 38.7087], [-122.83555, 38.70865], [-122.83574, 38.70857]]]} | No Public Access 3 | 4458 | White Rock Preserve | 27465 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 96.596 | White Rock Preserve | 0 | Private Conservation 16 | 2 | |
723 | 723 | 722 | {"type": "Polygon", "coordinates": [[[-122.8297, 38.43042], [-122.82526, 38.43042], [-122.82525, 38.42579], [-122.8253, 38.42547], [-122.82624, 38.42547], [-122.82716, 38.42577], [-122.82941, 38.42635], [-122.82931, 38.42976], [-122.82941, 38.43012], [-122.8297, 38.43042]]]} | No Public Access 3 | 4499 | Stone Farm | 25869 | 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 | 45.409 | Stone Farm | None 67 | |||
724 | 724 | 723 | {"type": "Polygon", "coordinates": [[[-118.39535, 33.84489], [-118.3944, 33.84514], [-118.39429, 33.8451], [-118.3941, 33.84517], [-118.39403, 33.84513], [-118.39382, 33.84468], [-118.39327, 33.84426], [-118.39374, 33.84384], [-118.39428, 33.84415], [-118.39471, 33.84423], [-118.39513, 33.84427], [-118.39535, 33.84489]]]} | Open Access 1 | 5468 | Seaside Lagoon Park | 32657 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 3.802 | Seaside Lagoon Park | 0 | Local Park 2 | 4 | |
725 | 725 | 724 | {"type": "Polygon", "coordinates": [[[-117.85796, 33.75435], [-117.85756, 33.75436], [-117.85755, 33.75394], [-117.85795, 33.75394], [-117.85796, 33.75435]]]} | Open Access 1 | 4606 | Chepa's Park | 17163 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 0.418 | Chepa's Park | 0 | Local Park 2 | 4 | |
726 | 726 | 725 | {"type": "Polygon", "coordinates": [[[-117.26211, 34.05606], [-117.26193, 34.05614], [-117.26175, 34.05656], [-117.2615, 34.05766], [-117.26131, 34.05825], [-117.26131, 34.05699], [-117.26104, 34.05699], [-117.26103, 34.05709], [-117.26056, 34.05708], [-117.26055, 34.05687], [-117.26008, 34.05687], [-117.26008, 34.05587], [-117.2613, 34.05605], [-117.26131, 34.05604], [-117.26131, 34.05594], [-117.26211, 34.05606]]]} | Open Access 1 | 4615 | Elmer Digneo Park | 18597 | 1181 | Loma Linda, City of 185 | City 2 | City Agency 2 | http://www.lomalinda-ca.gov/ | City 2 | 1181 | Loma Linda, City of 181 | City 2 | City Agency 2 | San Bernardino 22 | 5.034 | Elmer Digneo Park | 0 | Local Park 2 | 4 | |
727 | 727 | 726 | {"type": "Polygon", "coordinates": [[[-118.06818, 33.87234], [-118.06786, 33.87234], [-118.06784, 33.8714], [-118.06785, 33.87137], [-118.06787, 33.87135], [-118.06817, 33.87135], [-118.06818, 33.87234]]]} | Open Access 1 | 4620 | Loma Park | 21407 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 0.82 | Loma Park | 0 | Local Park 2 | 4 | |
728 | 728 | 727 | {"type": "Polygon", "coordinates": [[[-117.05141, 32.60343], [-117.04613, 32.60495], [-117.04584, 32.60422], [-117.05134, 32.60267], [-117.05136, 32.60308], [-117.05141, 32.60343]]]} | Open Access 1 | 4622 | San Diego Gas & Electric Park East | 24854 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sdg-e-park | San Diego 4 | 11.083 | San Diego Gas & Electric Park East | 0 | Local Park 2 | 4 |
729 | 729 | 728 | {"type": "Polygon", "coordinates": [[[-118.08352, 33.95516], [-118.0835, 33.95524], [-118.08384, 33.95536], [-118.08386, 33.95541], [-118.08331, 33.9568], [-118.08322, 33.95695], [-118.0832, 33.95709], [-118.08316, 33.95714], [-118.08313, 33.95714], [-118.08301, 33.95709], [-118.08276, 33.95706], [-118.0811, 33.95651], [-118.08192, 33.9546], [-118.08352, 33.95516]]]} | Open Access 1 | 4769 | Los Nietos Park | 21520 | 1321 | Santa Fe Springs, City of 211 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | Los Angeles 6 | 10.998 | Los Nietos Park | 0 | Local Park 2 | 4 | |
730 | 730 | 729 | {"type": "Polygon", "coordinates": [[[-118.33247, 34.0566], [-118.33202, 34.05756], [-118.33104, 34.05732], [-118.33138, 34.05632], [-118.33247, 34.0566]]]} | Open Access 1 | 4724 | Los Angeles High Memorial Park | 21483 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.835 | Los Angeles High Memorial Park | 0 | Local Park 2 | 4 | |
731 | 731 | 730 | {"type": "Polygon", "coordinates": [[[-117.67158, 33.93436], [-117.67145, 33.93446], [-117.67128, 33.93452], [-117.67111, 33.93454], [-117.67088, 33.9345], [-117.67099, 33.93433], [-117.66977, 33.93373], [-117.66924, 33.93354], [-117.66901, 33.93344], [-117.6685, 33.9331], [-117.66796, 33.93279], [-117.66758, 33.93247], [-117.66707, 33.93212], [-117.66681, 33.93198], [-117.66665, 33.93192], [-117.66633, 33.93186], [-117.66334, 33.93185], [-117.66334, 33.93144], [-117.66617, 33.93145], [-117.66637, 33.93126], [-117.66814, 33.9325], [-117.66858, 33.93279], [-117.66919, 33.93312], [-117.67155, 33.93429], [-117.67158, 33.93432], [-117.67158, 33.93436]]]} | Open Access 1 | 4742 | Meadows Park | 22096 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 8.121 | Meadows Park | 0 | Local Park 2 | 4 | |
732 | 732 | 731 | {"type": "Polygon", "coordinates": [[[-117.73548, 33.96926], [-117.73534, 33.96932], [-117.73492, 33.96967], [-117.73479, 33.96981], [-117.73471, 33.96993], [-117.73464, 33.97009], [-117.73461, 33.97027], [-117.73461, 33.97041], [-117.73464, 33.97058], [-117.73467, 33.97066], [-117.73473, 33.97071], [-117.73486, 33.97073], [-117.73496, 33.9707], [-117.73497, 33.97073], [-117.73465, 33.97086], [-117.7346, 33.97084], [-117.73376, 33.96937], [-117.7336, 33.96922], [-117.73359, 33.96916], [-117.73368, 33.969], [-117.73372, 33.96887], [-117.73375, 33.96888], [-117.7338, 33.96897], [-117.73412, 33.96907], [-117.73414, 33.96905], [-117.73439, 33.96914], [-117.73501, 33.96925], [-117.73512, 33.96925], [-117.73547, 33.96921], [-117.73548, 33.96926]]]} | Open Access 1 | 4749 | Valle Vista Park | 26772 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 3.295 | Valle Vista 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]);