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,058
- County Agency 1,165
- Recreation/Parks District 1,131
- State Agency 1,122
- Non Profit - Land Trust 581
- Federal Agency 501
- Open Space District 422
- Water District 237
- County Agency - Parks 231
- Home Owners Association 202
- Community Services District 198
- Non Profit - Conservation 147
- Flood District 105
- Irrigation District 50
- 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 482
- Los Angeles, City of 476
- California Department of Fish and Wildlife 432
- California Department of Parks and Recreation 379
- Mountains Recreation and Conservation Authority 346
- San Jose, City of 241
- San Francisco, City and County of 238
- Sacramento, City of 220
- Los Angeles, County of 171
- East Bay Regional Park District 165
- Long Beach, City of 148
- Ventura, City of 145
- Roseville, City of 130
- Oakland, City of 121
- United States Bureau of Land Management 118
- San Diego, County of 116
- 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,912
- Local Recreation Area 1,943
- Local Other or Unknown 1,177
- Private Conservation 608
- Local Conservation Area 474
- State Conservation Area 373
- Private Recreation or Education 268
- State Park 207
- State Resource Management Area 158
- State Recreation Area 144
- Local Historic or Cultural Area 99
- National Forest 93
- National Wildlife Refuge 75
- National Public Lands 73
- 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 13
- 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,911
- Restricted Access 1,179
- No Public Access 956
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
643 | 643 | 642 | {"type": "Polygon", "coordinates": [[[-120.18928, 36.60636], [-120.18924, 36.60649], [-120.1888, 36.60706], [-120.18792, 36.60637], [-120.18801, 36.6062], [-120.18809, 36.60602], [-120.18814, 36.60558], [-120.18928, 36.60636]]]} | Open Access 1 | 4963 | San Joaquin Community Park | 24907 | 1302 | San Joaquin, City of 229 | City 2 | City Agency 2 | http://www.cityofsanjoaquin.org/ | City 2 | 1302 | San Joaquin, City of 225 | City 2 | City Agency 2 | Fresno 9 | 2.472 | San Joaquin Community Park | 0 | Local Park 2 | 4 | |
644 | 644 | 643 | {"type": "Polygon", "coordinates": [[[-118.48487, 34.00002], [-118.48431, 34.00041], [-118.48432, 34.00043], [-118.48362, 34.00092], [-118.48361, 34.00091], [-118.48427, 34.00043], [-118.48255, 33.99872], [-118.48188, 33.99919], [-118.48168, 33.99899], [-118.48193, 33.99882], [-118.48199, 33.99882], [-118.48202, 33.9988], [-118.48202, 33.99875], [-118.48244, 33.99846], [-118.4818, 33.99782], [-118.48189, 33.99776], [-118.4827, 33.99855], [-118.4832, 33.99821], [-118.48338, 33.99844], [-118.48487, 34.00002]]]} | Open Access 1 | 2850 | Ocean View Park | 23062 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 5.802 | Ocean View Park | 0 | Local Park 2 | 4 | |
645 | 645 | 644 | {"type": "Polygon", "coordinates": [[[-117.68405, 34.06496], [-117.68405, 34.06668], [-117.68301, 34.06668], [-117.68301, 34.06496], [-117.68405, 34.06496]]]} | Open Access 1 | 2904 | Kingsley Park | 20671 | 1210 | Montclair, City of 55 | City 2 | City Agency 2 | http://www.ci.montclair.ca.us/ | City 2 | 1210 | Montclair, City of 53 | City 2 | City Agency 2 | San Bernardino 22 | 4.538 | Kingsley Park | 0 | Local Park 2 | 4 | |
646 | 646 | 645 | {"type": "Polygon", "coordinates": [[[-117.92364, 33.84736], [-117.92392, 33.8483], [-117.92397, 33.84862], [-117.924, 33.84983], [-117.92398, 33.84989], [-117.92393, 33.84991], [-117.92388, 33.8499], [-117.92081, 33.84838], [-117.9201, 33.84805], [-117.91997, 33.84795], [-117.91993, 33.84787], [-117.91994, 33.84743], [-117.91996, 33.84738], [-117.92002, 33.84735], [-117.92356, 33.84733], [-117.92364, 33.84736]]]} | Open Access 1 | 3194 | La Palma Park | 20780 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 16.03 | La Palma Park | 0 | Local Park 2 | 4 | |
647 | 647 | 646 | {"type": "MultiPolygon", "coordinates": [[[[-118.5911, 34.50001], [-118.59098, 34.50376], [-118.58666, 34.50402], [-118.5862, 34.50368], [-118.58664, 34.50367], [-118.58676, 34.50002], [-118.5911, 34.50001]]], [[[-118.62547, 34.5734], [-118.62517, 34.57353], [-118.60777, 34.57354], [-118.60804, 34.55913], [-118.60807, 34.5591], [-118.60808, 34.55918], [-118.61235, 34.55918], [-118.61239, 34.56278], [-118.61669, 34.5628], [-118.61674, 34.56652], [-118.61624, 34.56657], [-118.61561, 34.56775], [-118.61729, 34.56888], [-118.62417, 34.56898], [-118.62413, 34.57], [-118.62547, 34.57], [-118.62547, 34.5734]]], [[[-118.64743, 34.58835], [-118.64714, 34.58846], [-118.64261, 34.58842], [-118.64262, 34.581], [-118.64292, 34.58085], [-118.64292, 34.58113], [-118.64738, 34.58119], [-118.64743, 34.58835]]], [[[-118.65621, 34.55926], [-118.64305, 34.55924], [-118.64294, 34.54747], [-118.64732, 34.54747], [-118.64741, 34.55475], [-118.65178, 34.55475], [-118.65182, 34.55839], [-118.6562, 34.55839], [-118.65621, 34.55926]]]]} | Open Access 1 | 3268 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 692.902 | BLM | 1899 | National Public Lands 1 | 3 | |
648 | 648 | 647 | {"type": "Polygon", "coordinates": [[[-117.69816, 33.60027], [-117.69806, 33.60032], [-117.69672, 33.60105], [-117.69676, 33.60074], [-117.69676, 33.60055], [-117.69669, 33.60034], [-117.69656, 33.60015], [-117.69658, 33.6001], [-117.69681, 33.59993], [-117.69693, 33.59979], [-117.69701, 33.59965], [-117.69706, 33.59965], [-117.69727, 33.59972], [-117.69816, 33.60027]]]} | Open Access 1 | 3079 | Beckenham Park | 15945 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 2.791 | Beckenham Park | 0 | Local Park 2 | 4 | |
649 | 649 | 648 | {"type": "Polygon", "coordinates": [[[-118.11732, 34.04134], [-118.1173, 34.04236], [-118.11727, 34.04249], [-118.11474, 34.04187], [-118.11626, 34.04052], [-118.11732, 34.04134]]]} | Open Access 1 | 3140 | La Loma Park | 20771 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 7.134 | La Loma Park | 0 | Local Park 2 | 4 | |
650 | 650 | 649 | {"type": "Polygon", "coordinates": [[[-119.55793, 36.70659], [-119.55742, 36.70665], [-119.55736, 36.70639], [-119.55787, 36.70633], [-119.55793, 36.70659]]]} | Open Access 1 | 5005 | Brehler Square | 16348 | 1315 | Sanger, City of 231 | City 2 | City Agency 2 | http://www.ci.sanger.ca.us/parks-rec.asp | City 2 | 1315 | Sanger, City of 227 | City 2 | City Agency 2 | Fresno 9 | 0.342 | Brehler Square | 0 | Local Park 2 | 4 | |
651 | 651 | 650 | {"type": "Polygon", "coordinates": [[[-121.83147, 36.60522], [-121.83145, 36.60586], [-121.83095, 36.60585], [-121.83097, 36.60522], [-121.83147, 36.60522]]]} | Open Access 1 | 3181 | Capra Park | 16842 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.791 | Capra Park | 0 | Local Park 2 | 4 | |
652 | 652 | 651 | {"type": "Polygon", "coordinates": [[[-117.31369, 34.11112], [-117.31368, 34.11194], [-117.31272, 34.11194], [-117.31272, 34.11112], [-117.31369, 34.11112]]]} | Open Access 1 | 3196 | La Plaza Park | 20794 | 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 | 2.026 | La Plaza Park | 0 | Local Park 2 | 4 | |
653 | 653 | 652 | {"type": "Polygon", "coordinates": [[[-118.76961, 34.09844], [-118.76746, 34.09841], [-118.76746, 34.09748], [-118.76959, 34.09752], [-118.76961, 34.09844]]]} | Open Access 1 | 5014 | Malibu Creek State Park - Randa House | 29629 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.parks.ca.gov/?page_id=614 | Los Angeles 6 | 5.064 | Malibu Creek SP - Randa House | None 62 | ||
654 | 654 | 653 | {"type": "Polygon", "coordinates": [[[-120.06046, 36.72073], [-120.06043, 36.72244], [-120.06028, 36.72262], [-120.0601, 36.72247], [-120.06012, 36.72077], [-120.06031, 36.72063], [-120.06046, 36.72073]]]} | Open Access 1 | 3218 | Plaza Park | 23786 | 1151 | Kerman, City of 212 | City 2 | City Agency 2 | http://cityofkerman.net/parks-and-recreation-department/ | City 2 | 1151 | Kerman, City of 208 | City 2 | City Agency 2 | Fresno 9 | 1.535 | Plaza Park | 0 | Local Park 2 | 4 | |
655 | 655 | 654 | {"type": "Polygon", "coordinates": [[[-122.60188, 38.34223], [-122.60099, 38.34219], [-122.59824, 38.34219], [-122.59784, 38.34221], [-122.59674, 38.34238], [-122.59579, 38.34284], [-122.59514, 38.34423], [-122.59427, 38.34493], [-122.59333, 38.34522], [-122.59334, 38.34582], [-122.59113, 38.34633], [-122.5913, 38.34768], [-122.59135, 38.34828], [-122.5912, 38.3487], [-122.59122, 38.34925], [-122.59128, 38.34926], [-122.5913, 38.34965], [-122.59261, 38.35027], [-122.59275, 38.35752], [-122.58592, 38.35768], [-122.58582, 38.35554], [-122.5836, 38.35559], [-122.58354, 38.34758], [-122.58768, 38.34758], [-122.58754, 38.34322], [-122.5927, 38.34315], [-122.59271, 38.33808], [-122.59176, 38.33786], [-122.59079, 38.33744], [-122.58972, 38.33705], [-122.58885, 38.33685], [-122.588, 38.3368], [-122.58729, 38.33644], [-122.5869, 38.33609], [-122.58626, 38.33575], [-122.58571, 38.33561], [-122.58518, 38.33551], [-122.58545, 38.33521], [-122.58614, 38.33528], [-122.58697, 38.33561], [-122.58767, 38.33622], [-122.58824, 38.33643], [-122.58911, 38.33648], [-122.58974, 38.33662], [-122.5905, 38.33687], [-122.59169, 38.33743], [-122.5927, 38.33768], [-122.59271, 38.33767], [-122.59272, 38.33589], [-122.60179, 38.33588], [-122.60186, 38.34013], [-122.60188, 38.34223]], [[-122.5906, 38.3493], [-122.59059, 38.34928], [-122.59046, 38.34931], [-122.59053, 38.34931], [-122.5906, 38.3493]]]} | Restricted Access 2 | 3269 | Fairfield Osborn Preserve | 18798 | 211 | California State University Sonoma 232 | State 5 | State Agency 5 | http://www.sonoma.edu/ | Other State 5 | 211 | California State University Sonoma 228 | State 5 | State Agency 5 | Sonoma 16 | 414.364 | Fairfield Osborn Preserve | 2004 | State Conservation Area 8 | 2 | |
656 | 656 | 655 | {"type": "Polygon", "coordinates": [[[-122.01041, 38.35673], [-122.00892, 38.35725], [-122.00846, 38.35701], [-122.00814, 38.35671], [-122.00769, 38.35685], [-122.0075, 38.35677], [-122.00736, 38.35667], [-122.00728, 38.35618], [-122.00767, 38.35609], [-122.00751, 38.35562], [-122.00947, 38.35527], [-122.01041, 38.35673]]]} | Open Access 1 | 3220 | Alamo Creek Park | 15317 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 9.429 | Alamo Creek Park | 2000 | Local Park 2 | 4 | |
657 | 657 | 656 | {"type": "Polygon", "coordinates": [[[-120.14287, 34.588], [-120.1423, 34.58955], [-120.14208, 34.58947], [-120.14139, 34.58931], [-120.14146, 34.58926], [-120.14226, 34.58911], [-120.14247, 34.58854], [-120.14266, 34.58832], [-120.14287, 34.588]]]} | Open Access 1 | 3221 | Alisal Commons Park | 15367 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 1.023 | Alisal Commons Park | 0 | Local Park 2 | 4 | |
658 | 658 | 657 | {"type": "Polygon", "coordinates": [[[-122.1718, 37.99251], [-122.16269, 37.99253], [-122.16267, 37.98898], [-122.16654, 37.98899], [-122.16655, 37.98895], [-122.17178, 37.98893], [-122.1718, 37.99251]]]} | Open Access 1 | 3251 | Gustin | 19572 | 3045 | John Muir Land Trust 108 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jmlt.org/ | Non Governmental Organization 10 | 3045 | John Muir Land Trust 105 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 78.179 | Gustin | 2000 | Private Conservation 16 | 2 | |
659 | 659 | 658 | {"type": "MultiPolygon", "coordinates": [[[[-118.28551, 34.06276], [-118.28488, 34.06277], [-118.28427, 34.06357], [-118.28256, 34.0628], [-118.28336, 34.06157], [-118.28425, 34.06197], [-118.2855, 34.06197], [-118.28551, 34.06276]]], [[[-118.28408, 34.06152], [-118.28355, 34.06128], [-118.28407, 34.06049], [-118.28408, 34.06152], [-118.28408, 34.06152]]]]} | Open Access 1 | 3260 | Lafayette Park | 20832 | 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 | 9.08 | Lafayette Park | 0 | Local Park 2 | 4 | |
660 | 660 | 659 | {"type": "MultiPolygon", "coordinates": [[[[-118.47757, 34.17694], [-118.47653, 34.17753], [-118.47638, 34.17727], [-118.47491, 34.17726], [-118.47488, 34.17866], [-118.47404, 34.17875], [-118.4726, 34.17833], [-118.47255, 34.17833], [-118.47049, 34.17932], [-118.46982, 34.17835], [-118.46942, 34.17769], [-118.46908, 34.17704], [-118.46886, 34.17653], [-118.46876, 34.17623], [-118.46858, 34.17554], [-118.46851, 34.17511], [-118.46844, 34.1746], [-118.46841, 34.17384], [-118.46841, 34.17257], [-118.46879, 34.17257], [-118.46895, 34.17247], [-118.47109, 34.17243], [-118.4711, 34.1725], [-118.47273, 34.1725], [-118.47327, 34.17247], [-118.47381, 34.17242], [-118.47429, 34.17235], [-118.4747, 34.17228], [-118.4754, 34.17212], [-118.47554, 34.17212], [-118.47694, 34.17548], [-118.47723, 34.17608], [-118.47722, 34.17631], [-118.4774, 34.17666], [-118.47757, 34.17694]]], [[[-118.47739, 34.17084], [-118.4769, 34.17105], [-118.47556, 34.17153], [-118.47499, 34.17158], [-118.47358, 34.17183], [-118.47208, 34.17194], [-118.46878, 34.17196], [-118.46878, 34.17102], [-118.46911, 34.17021], [-118.46977, 34.16964], [-118.47092, 34.16895], [-118.4726, 34.16817], [-118.47276, 34.16826], [-118.47323, 34.1681], [-118.47413, 34.16763], [-118.47438, 34.16819], [-118.47571, 34.16965], [-118.47622, 34.1701], [-118.47659, 34.17037], [-118.47706, 34.17067], [-118.47739, 34.17084]]], [[[-118.48363, 34.18069], [-118.48361, 34.18069], [-118.4834, 34.1804], [-118.48315, 34.18014], [-118.47855, 34.17705], [-118.47836, 34.1769], [-118.47815, 34.17669], [-118.47799, 34.17649], [-118.47783, 34.1762], [-118.47595, 34.17177], [-118.47741, 34.17146], [-118.478, 34.17119], [-118.48123, 34.17251], [-118.48092, 34.17304], [-118.48094, 34.17432], [-118.48076, 34.17439], [-118.48075, 34.1744], [-118.48207, 34.1758], [-118.48338, 34.17578], [-118.48342, 34.17774], [-118.48359, 34.17867], [-118.48363, 34.18069]]], [[[-118.50099, 34.18172], [-118.50099, 34.18456], [-118.50095, 34.1855], [-118.50094, 34.18587], [-118.49857, 34.18587], [-118.49856, 34.18608], [-118.49253, 34.18608], [-118.49254, 34.18527], [-118.49305, 34.18528], [-118.49331, 34.18519], [-118.49344, 34.18507], [-118.49351, 34.18486], [-118.49351, 34.18461], [-118.49346, 34.18436], [-118.49679, 34.18321], [-118.49715, 34.18293], [-118.49763, 34.18229], [-118.49761, 34.18051], [-118.49826, 34.18052], [-118.49842, 34.18053], [-118.49856, 34.18058], [-118.49941, 34.18129], [-118.49962, 34.18137], [-118.50004, 34.18139], [-118.50016, 34.18144], [-118.50064, 34.18171], [-118.50079, 34.18175], [-118.50093, 34.18174], [-118.50099, 34.18172]]]]} | Open Access 1 | 3261 | Sepulveda Basin Wildlife Reserve | 13591 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://sepulvedabasinwildlife.org/ | Los Angeles 6 | 327.332 | Sepulveda Basin Wildlife Reserve | 0 | Conservation Area 13 | 2 |
661 | 661 | 660 | {"type": "Polygon", "coordinates": [[[-117.97795, 33.6865], [-117.97735, 33.6865], [-117.97731, 33.68648], [-117.97729, 33.68645], [-117.97724, 33.68366], [-117.97155, 33.68368], [-117.97154, 33.68313], [-117.97593, 33.68312], [-117.97593, 33.6831], [-117.97577, 33.68279], [-117.9757, 33.68275], [-117.97574, 33.68269], [-117.97575, 33.68258], [-117.9758, 33.68254], [-117.97637, 33.68253], [-117.97645, 33.68251], [-117.97653, 33.68245], [-117.97691, 33.68242], [-117.9778, 33.68241], [-117.9778, 33.68269], [-117.97786, 33.68274], [-117.97784, 33.68279], [-117.97784, 33.68285], [-117.9779, 33.68311], [-117.97795, 33.6865]]]} | Open Access 1 | 3264 | Lagenbeck Park | 20838 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lagenbeck-park.cfm | Orange 3 | 17.016 | Lagenbeck Park | 0 | Local Park 2 | 4 |
662 | 662 | 661 | {"type": "Polygon", "coordinates": [[[-117.89727, 33.91708], [-117.89707, 33.91745], [-117.89698, 33.9175], [-117.89608, 33.91752], [-117.89608, 33.91692], [-117.89678, 33.91691], [-117.89679, 33.91708], [-117.89727, 33.91708]]]} | Open Access 1 | 3273 | Lagos De Moreno Park | 20844 | 1033 | Brea, City of 233 | City 2 | City Agency 2 | http://www.ci.brea.ca.us/index.aspx?NID=439 | City 2 | 1033 | Brea, City of 229 | City 2 | City Agency 2 | Orange 3 | 1.461 | Lagos De Moreno 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]);