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 7,841
- Recreation/Parks District 970
- State Agency 966
- County Agency 959
- Non Profit - Land Trust 484
- Federal Agency 405
- Open Space District 391
- County Agency - Parks 203
- Water District 196
- Home Owners Association 179
- Community Services District 172
- Non Profit - Conservation 131
- Flood District 92
- Non Profit - Other 39
- Irrigation District 36
- School District 35
- Cemetery District 33
- County Agency - Other 27
- Port/Harbor District 25
- Special District - Other 15
- Commercial 14
- Joint Powers Authority 7
- Sanitation District 6
- 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 395
- Los Angeles, City of 376
- California Department of Fish and Wildlife 363
- California Department of Parks and Recreation 328
- Mountains Recreation and Conservation Authority 319
- Sacramento, City of 190
- San Jose, City of 184
- San Francisco, City and County of 158
- East Bay Regional Park District 149
- Los Angeles, County of 137
- Ventura, City of 127
- Long Beach, City of 121
- Roseville, City of 109
- San Diego, County of 100
- Santa Barbara, County of 93
- United States Bureau of Land Management 92
- Oakland, City of 91
- Consumnes Community Services District 91
- United States Forest Service 84
- Napa, City of 78
- California State Lands Commission 76
- Orange, County of 75
- United States Fish and Wildlife Service 73
- United States National Park Service 70
- Irvine, City of 69
- Hayward Area Recreation and Park District 67
- Valley-Wide Recreation and Park District 62
- Davis, City of 61
- Poway, City of 60
- Tracy, City of 60
- …
DES_TP >30
- Local Park 6,775
- Local Recreation Area 1,678
- Local Other or Unknown 1,126
- Private Conservation 507
- Local Conservation Area 410
- State Conservation Area 333
- Private Recreation or Education 232
- State Park 182
- State Resource Management Area 125
- State Recreation Area 121
- National Forest 72
- Local Historic or Cultural Area 66
- National Wildlife Refuge 66
- State Other or Unknown 61
- State Historic or Cultural Area 57
- National Public Lands 51
- Recreation Management Area 51
- Private Other or Unknown 51
- National Monument or Landmark 34
- National Recreation Area 32
- National Park 22
- Local Resource Management Area 20
- Resource Management Area 18
- Federal Other or Unknown 18
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 11,083
- Restricted Access 1,025
- No Public Access 799
- Unknown Access 352
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3810 | 3810 | 3809 | {"type": "Polygon", "coordinates": [[[-122.6307, 38.21993], [-122.63068, 38.22035], [-122.62958, 38.22036], [-122.62935, 38.22045], [-122.6293, 38.22056], [-122.62924, 38.22066], [-122.62902, 38.22065], [-122.62899, 38.22063], [-122.62886, 38.22061], [-122.62878, 38.22063], [-122.62846, 38.22063], [-122.62846, 38.21987], [-122.62849, 38.21982], [-122.62844, 38.21951], [-122.6285, 38.21947], [-122.62939, 38.21947], [-122.62953, 38.21953], [-122.62967, 38.21953], [-122.62973, 38.21975], [-122.62987, 38.21992], [-122.6307, 38.21993]]]} | Open Access 1 | 10133 | Grant Park | 19440 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 4.258 | Grant Park | 0 | Local Park 2 | 4 | |
3811 | 3811 | 3810 | {"type": "Polygon", "coordinates": [[[-122.46979, 38.29855], [-122.46968, 38.29918], [-122.46947, 38.29916], [-122.46943, 38.29938], [-122.46936, 38.29938], [-122.46939, 38.29915], [-122.46885, 38.29909], [-122.46885, 38.29895], [-122.46881, 38.29885], [-122.46889, 38.29885], [-122.46895, 38.2985], [-122.46979, 38.29855]]]} | Open Access 1 | 10145 | Olsen Park | 23138 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 1.303 | Olsen Park | 0 | Local Park 2 | 4 | |
3812 | 3812 | 3811 | {"type": "Polygon", "coordinates": [[[-117.63394, 33.60507], [-117.63391, 33.60568], [-117.63388, 33.60587], [-117.63372, 33.60642], [-117.63352, 33.60685], [-117.63333, 33.60715], [-117.63272, 33.60796], [-117.63249, 33.60773], [-117.63246, 33.60773], [-117.63237, 33.60775], [-117.63215, 33.60762], [-117.63207, 33.60754], [-117.63203, 33.60747], [-117.63202, 33.60735], [-117.63223, 33.60679], [-117.63227, 33.60664], [-117.63245, 33.60642], [-117.6325, 33.60626], [-117.63258, 33.60609], [-117.63294, 33.60565], [-117.6329, 33.60553], [-117.63296, 33.60541], [-117.63289, 33.60525], [-117.63286, 33.60503], [-117.63287, 33.60498], [-117.63281, 33.60487], [-117.63291, 33.60487], [-117.6331, 33.60488], [-117.63332, 33.60494], [-117.63357, 33.60503], [-117.63369, 33.605], [-117.63394, 33.60507]]]} | Open Access 1 | 10146 | Robert A Curtis Park | 24481 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 8.168 | Robert A Curtis Park | 0 | Local Park 2 | 4 | |
3813 | 3813 | 3812 | {"type": "Polygon", "coordinates": [[[-116.99456, 32.62803], [-116.99407, 32.62875], [-116.99394, 32.62888], [-116.99368, 32.62907], [-116.99364, 32.62907], [-116.99332, 32.62882], [-116.9933, 32.62871], [-116.99399, 32.62774], [-116.99403, 32.62773], [-116.99455, 32.62799], [-116.99456, 32.62803]]]} | Restricted Access 2 | 45186 | Oak Crest Park | 33358 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 2.168 | Oak Crest Park | 0 | Private Recreation or Education 65 | 4 | ||
3814 | 3814 | 3813 | {"type": "Polygon", "coordinates": [[[-116.96275, 32.65963], [-116.96272, 32.6598], [-116.96273, 32.65988], [-116.96252, 32.65994], [-116.96249, 32.65993], [-116.96238, 32.65998], [-116.96235, 32.65997], [-116.96224, 32.66002], [-116.96221, 32.66001], [-116.96195, 32.6601], [-116.96175, 32.66013], [-116.96165, 32.65965], [-116.96164, 32.6595], [-116.96167, 32.65933], [-116.96188, 32.65935], [-116.962, 32.6594], [-116.96203, 32.65939], [-116.96215, 32.65944], [-116.96218, 32.65943], [-116.96245, 32.65955], [-116.96275, 32.65963]]]} | Restricted Access 2 | 45187 | Madison Lane Park | 33353 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 1.505 | Madison Lane Park | 0 | Private Recreation or Education 65 | 4 | ||
3815 | 3815 | 3814 | {"type": "Polygon", "coordinates": [[[-122.64695, 41.7206], [-122.64692, 41.721], [-122.64672, 41.72116], [-122.64671, 41.72118], [-122.64664, 41.72119], [-122.64635, 41.72104], [-122.64633, 41.721], [-122.64635, 41.7209], [-122.64635, 41.72058], [-122.64695, 41.7206]]]} | Open Access 1 | 25378 | Lewis Park | 21194 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 0.701 | Lewis Park | 0 | Local Park 2 | 4 | |
3816 | 3816 | 3815 | {"type": "Polygon", "coordinates": [[[-122.64386, 41.73274], [-122.64364, 41.73323], [-122.64065, 41.73257], [-122.64096, 41.73184], [-122.64135, 41.73194], [-122.6415, 41.73169], [-122.64242, 41.73188], [-122.64237, 41.73202], [-122.64237, 41.73208], [-122.6431, 41.73226], [-122.64354, 41.73235], [-122.64343, 41.73264], [-122.64386, 41.73274]]]} | Open Access 1 | 25379 | Minor Street Park | 22270 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 5.961 | Minor Street Park | 0 | Local Park 2 | 4 | |
3817 | 3817 | 3816 | {"type": "Polygon", "coordinates": [[[-121.80256, 36.69071], [-121.80064, 36.68954], [-121.8013, 36.68878], [-121.8017, 36.68905], [-121.80185, 36.68917], [-121.80204, 36.68937], [-121.80221, 36.68959], [-121.80238, 36.6899], [-121.80249, 36.69019], [-121.80254, 36.69043], [-121.80256, 36.69071]]]} | Open Access 1 | 35194 | Monterey Peninsula Regional Park District 4 | 22427 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.919 | Monterey Peninsula RP District 4 | None 320 | |||
3818 | 3818 | 3817 | {"type": "Polygon", "coordinates": [[[-122.13417, 37.15393], [-122.13375, 37.15388], [-122.13379, 37.15364], [-122.13411, 37.15359], [-122.13417, 37.15393]]]} | Open Access 1 | 35183 | Garrahan Park | 28532 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/#!parks/ccjp | Santa Cruz 5 | 0.257 | Garrahan Park | 0 | Local Park 2 | 4 |
3819 | 3819 | 3818 | {"type": "Polygon", "coordinates": [[[-122.13458, 37.15391], [-122.13422, 37.15419], [-122.1342, 37.1541], [-122.13422, 37.15394], [-122.13417, 37.15393], [-122.13411, 37.15359], [-122.13379, 37.15364], [-122.13383, 37.15347], [-122.13395, 37.15311], [-122.13418, 37.15278], [-122.13458, 37.15237], [-122.13458, 37.15391]]]} | Open Access 1 | 35184 | Garrahan Park | 28532 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/#!parks/ccjp | Santa Cruz 5 | 1.947 | Garrahan Park | 0 | Local Park 2 | 4 |
3820 | 3820 | 3819 | {"type": "Polygon", "coordinates": [[[-117.07294, 33.13624], [-117.07138, 33.13696], [-117.07093, 33.13639], [-117.07125, 33.13623], [-117.07102, 33.13594], [-117.07231, 33.13531], [-117.07294, 33.13624]]]} | Open Access 1 | 45221 | Grove Park | 19534 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/grove-park.aspx | San Diego 4 | 4.561 | Grove Park | 0 | Local Park 2 | 4 |
3821 | 3821 | 3820 | {"type": "MultiPolygon", "coordinates": [[[[-116.37096, 33.91459], [-116.37095, 33.91825], [-116.36879, 33.91825], [-116.36881, 33.9146], [-116.37096, 33.91459]]], [[[-116.75455, 33.48392], [-116.75058, 33.48397], [-116.75043, 33.48095], [-116.75448, 33.4809], [-116.75455, 33.48392]]]]} | No Public Access 3 | 35202 | Riverside County Habitat Conservation Agency 4 | 24448 | 2122 | Riverside County Habitat Conservation Agency 570 | Special District 4 | Open Space District 6 | http://www.skrplan.org/ | Special District 4 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | Riverside 10 | 50.849 | Riverside County Habitat Conservation Agency 4 | None 321 | |||
3822 | 3822 | 3821 | {"type": "MultiPolygon", "coordinates": [[[[-117.16091, 33.13937], [-117.15846, 33.14101], [-117.15822, 33.14036], [-117.15821, 33.14035], [-117.15831, 33.14084], [-117.1584, 33.14105], [-117.15769, 33.14153], [-117.1577, 33.14159], [-117.15715, 33.14168], [-117.15661, 33.14181], [-117.15656, 33.14167], [-117.15663, 33.14161], [-117.15665, 33.14152], [-117.15663, 33.14145], [-117.15659, 33.14141], [-117.15691, 33.14112], [-117.15709, 33.14098], [-117.15796, 33.14043], [-117.16037, 33.13882], [-117.16091, 33.13937]]], [[[-117.16212, 33.13866], [-117.16175, 33.13905], [-117.16107, 33.13923], [-117.1605, 33.13865], [-117.16073, 33.13857], [-117.1615, 33.13836], [-117.16206, 33.1385], [-117.16212, 33.13866]]]]} | No Public Access 3 | 45235 | San Marcos City Open Space | 24944 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 10.993 | San Marcos City OS | 0 | Local Recreation Area 3 | 4 | |
3823 | 3823 | 3822 | {"type": "Polygon", "coordinates": [[[-119.79655, 34.42798], [-119.79651, 34.42886], [-119.79611, 34.42884], [-119.79604, 34.4287], [-119.7958, 34.4284], [-119.79655, 34.42798]]]} | Open Access 1 | 35233 | Rhoads Open Space | 28548 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.01 | Rhoads OS | 0 | Local Recreation Area 3 | 4 | |
3824 | 3824 | 3823 | {"type": "Polygon", "coordinates": [[[-121.82197, 36.58445], [-121.82053, 36.586], [-121.81948, 36.58511], [-121.81901, 36.58475], [-121.81625, 36.58287], [-121.81739, 36.58153], [-121.82197, 36.58445]]]} | Open Access 1 | 35230 | Monterey holding 1 | 22421 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 24.525 | Monterey holding 1 | 0 | Local Other or Unknown 14 | 4 | |
3825 | 3825 | 3824 | {"type": "MultiPolygon", "coordinates": [[[[-117.26084, 32.96844], [-117.26055, 32.96864], [-117.26044, 32.96852], [-117.26074, 32.96833], [-117.26084, 32.96844]]], [[[-117.26155, 32.96919], [-117.26115, 32.96945], [-117.26112, 32.96943], [-117.26088, 32.96904], [-117.26065, 32.96877], [-117.26095, 32.96856], [-117.26155, 32.96919]]]]} | Open Access 1 | 45240 | San Diequito Lagoon | 24873 | 1082 | Del Mar, City of 93 | City 2 | City Agency 2 | http://www.delmar.ca.us/203/Beaches-Parks | City 2 | 1082 | Del Mar, City of 91 | City 2 | City Agency 2 | http://www.sdrp.org/wordpress/ | San Diego 4 | 1.046 | San Diequito Lagoon | None 322 | ||
3826 | 3826 | 3825 | {"type": "Polygon", "coordinates": [[[-117.046, 33.25229], [-117.0459, 33.25362], [-117.04581, 33.25622], [-117.04584, 33.25988], [-117.04315, 33.25987], [-117.04304, 33.25622], [-117.04149, 33.2562], [-117.04135, 33.25228], [-117.046, 33.25229]]]} | No Public Access 3 | 45243 | Valley Center MWDD Open Space | 26786 | 2321 | Valley Center Water District 689 | Special District 4 | Water District 13 | http://www.vcmwd.org/ | Special District 4 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | San Diego 4 | 70.32 | Valley Ctr. MWDD OS | 0 | Local Recreation Area 3 | 4 | |
3827 | 3827 | 3826 | {"type": "Polygon", "coordinates": [[[-120.17654, 39.32492], [-120.17487, 39.32491], [-120.17493, 39.3262], [-120.17455, 39.3262], [-120.17317, 39.32605], [-120.17283, 39.32595], [-120.17234, 39.32577], [-120.1711, 39.32519], [-120.1711, 39.32516], [-120.17155, 39.32517], [-120.17157, 39.32479], [-120.17144, 39.32478], [-120.17146, 39.32437], [-120.17653, 39.32487], [-120.17654, 39.32492]]]} | Open Access 1 | 45265 | Wintercreek Wetland | 27653 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 11.926 | Wintercreek Wetland | 0 | Private Conservation 16 | 2 | |
3828 | 3828 | 3827 | {"type": "Polygon", "coordinates": [[[-121.92036, 36.5399], [-121.92029, 36.54173], [-121.91957, 36.54172], [-121.91936, 36.54168], [-121.91869, 36.54107], [-121.91884, 36.54097], [-121.91884, 36.54095], [-121.91806, 36.54023], [-121.91808, 36.5398], [-121.91905, 36.54025], [-121.91944, 36.54023], [-121.92036, 36.5399]]]} | Open Access 1 | 45290 | Rio Park | 24385 | 1046 | Carmel-by-the-Sea, City of 535 | City 2 | City Agency 2 | http://www.carmelcalifornia.com/ | City 2 | 1046 | Carmel-by-the-Sea, City of 528 | City 2 | City Agency 2 | Monterey 14 | 6.651 | Rio Park | 0 | Local Park 2 | 4 | |
3829 | 3829 | 3828 | {"type": "Polygon", "coordinates": [[[-119.64094, 36.31958], [-119.63928, 36.31958], [-119.63927, 36.31834], [-119.64092, 36.31834], [-119.64094, 36.31958]]]} | Open Access 1 | 35315 | Hanford holding 2 | 19639 | 1129 | Hanford, City of 349 | City 2 | City Agency 2 | http://www.ci.hanford.ca.us/depts/rec/default.asp | City 2 | 1129 | Hanford, City of 346 | City 2 | City Agency 2 | Kings 44 | 5.018 | Hanford holding 2 | 0 | Local Other or Unknown 14 | 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]);