units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP >30
- City Agency 10,511
- County Agency 1,218
- Recreation/Parks District 1,162
- State Agency 1,139
- Non Profit - Land Trust 601
- Federal Agency 516
- Open Space District 427
- Water District 238
- County Agency - Parks 236
- Home Owners Association 203
- Community Services District 196
- Non Profit - Conservation 148
- Flood District 108
- Cemetery District 62
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- County Agency - Other 35
- Port/Harbor District 33
- 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
- …
DES_TP >30
- Local Park 9,361
- Local Recreation Area 1,988
- Local Other or Unknown 1,190
- Private Conservation 629
- Local Conservation Area 485
- State Conservation Area 381
- Private Recreation or Education 268
- State Park 207
- State Resource Management Area 159
- State Recreation Area 145
- Local Historic or Cultural Area 116
- National Forest 99
- National Public Lands 75
- National Wildlife Refuge 75
- State Other or Unknown 69
- State Historic or Cultural Area 63
- Recreation Management Area 61
- Private Other or Unknown 51
- National Recreation Area 39
- National Monument or Landmark 39
- National Park 26
- Resource Management Area 26
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 14
- Private Agricultural 12
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 14,492
- Restricted Access 1,202
- No Public Access 969
- Unknown Access 385
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10835 | 10835 | 10834 | {"type": "Polygon", "coordinates": [[[-118.08808, 34.06303], [-118.08554, 34.0657], [-118.08544, 34.06568], [-118.08536, 34.06562], [-118.08532, 34.06557], [-118.08531, 34.06551], [-118.08529, 34.06486], [-118.08727, 34.06278], [-118.08747, 34.06278], [-118.08748, 34.0628], [-118.08808, 34.0628], [-118.08808, 34.06303]]]} | Open Access 1 | 20610 | Zapopan Park | 27856 | 1284 | Rosemead, City of 130 | City 2 | City Agency 2 | http://www.cityofrosemead.org/index.aspx?page=74 | City 2 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 6.761 | Zapopan Park | 0 | Local Park 2 | 4 | |
12054 | 12054 | 12053 | {"type": "Polygon", "coordinates": [[[-121.4498, 37.74505], [-121.44971, 37.74505], [-121.44874, 37.74425], [-121.44865, 37.74416], [-121.44859, 37.74406], [-121.44854, 37.74394], [-121.44853, 37.74383], [-121.44853, 37.74372], [-121.44856, 37.74363], [-121.44868, 37.74344], [-121.44885, 37.74332], [-121.44897, 37.74326], [-121.44914, 37.74321], [-121.44933, 37.7432], [-121.44948, 37.74321], [-121.44964, 37.74325], [-121.44981, 37.74334], [-121.44993, 37.74344], [-121.45002, 37.74356], [-121.45007, 37.74368], [-121.45009, 37.74379], [-121.45009, 37.74464], [-121.45005, 37.74477], [-121.45, 37.74486], [-121.44991, 37.74496], [-121.4498, 37.74505]]]} | Open Access 1 | 24748 | Zanussi Park | 27855 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 4.966 | Zanussi Park | 0 | Local Park 2 | 4 | |
4260 | 4260 | 4259 | {"type": "Polygon", "coordinates": [[[-117.16445, 32.95224], [-117.16113, 32.95233], [-117.16099, 32.94848], [-117.16432, 32.94852], [-117.16445, 32.95224]]]} | Unknown Access 4 | 45284 | Zamudio TransNet Environmental Mitigation | 27854 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 32.329 | Zamudio TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
9214 | 9214 | 9213 | {"type": "Polygon", "coordinates": [[[-122.43749, 37.6417], [-122.43708, 37.64219], [-122.43677, 37.64236], [-122.43671, 37.64168], [-122.43693, 37.64167], [-122.43694, 37.64171], [-122.43697, 37.64175], [-122.43706, 37.64178], [-122.43716, 37.64175], [-122.4372, 37.64168], [-122.43749, 37.6417]]]} | Open Access 1 | 15316 | Zamora Playlot | 27853 | 1341 | South San Francisco, City of 60 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | San Mateo 15 | 0.712 | Zamora Playlot | 0 | Local Recreation Area 3 | 4 | |
4014 | 4014 | 4013 | {"type": "Polygon", "coordinates": [[[-118.01207, 34.07165], [-118.01152, 34.07275], [-118.01061, 34.07243], [-118.01092, 34.07179], [-118.01001, 34.07147], [-118.01024, 34.071], [-118.01027, 34.07098], [-118.01031, 34.07098], [-118.01204, 34.07159], [-118.01207, 34.07161], [-118.01207, 34.07165]]]} | Open Access 1 | 20679 | Zamora Park | 27852 | 1095 | El Monte, City of 240 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | Los Angeles 6 | 4.486 | Zamora Park | 0 | Local Park 2 | 4 | |
6154 | 6154 | 6153 | {"type": "Polygon", "coordinates": [[[-119.02223, 36.0768], [-119.02221, 36.07837], [-119.02222, 36.07915], [-119.02219, 36.07954], [-119.02219, 36.08023], [-119.02126, 36.08021], [-119.02101, 36.07981], [-119.02063, 36.07909], [-119.02029, 36.07837], [-119.01969, 36.07682], [-119.0201, 36.0768], [-119.02223, 36.0768]]]} | Open Access 1 | 1229 | Zalud Park | 27851 | 1260 | Porterville, City of 139 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | Tulare 29 | 15.304 | Zalud Park | 0 | Local Park 2 | 4 | |
3000 | 3000 | 2999 | {"type": "Polygon", "coordinates": [[[-117.92179, 34.11982], [-117.92177, 34.12163], [-117.92068, 34.12164], [-117.92067, 34.12153], [-117.91871, 34.12153], [-117.91861, 34.12146], [-117.91861, 34.1209], [-117.91868, 34.12085], [-117.91899, 34.12085], [-117.91926, 34.1209], [-117.91985, 34.1209], [-117.92004, 34.12087], [-117.92028, 34.12079], [-117.92041, 34.12076], [-117.92109, 34.12076], [-117.92125, 34.12079], [-117.92137, 34.12077], [-117.92143, 34.12071], [-117.92146, 34.12063], [-117.92143, 34.12048], [-117.92143, 34.1201], [-117.92146, 34.11993], [-117.92145, 34.11987], [-117.92141, 34.11982], [-117.92179, 34.11982]]]} | Open Access 1 | 20566 | Zacatecas Park | 27850 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 6.772 | Zacatecas Park | 0 | Local Park 2 | 4 | |
3990 | 3990 | 3989 | {"type": "Polygon", "coordinates": [[[-117.10971, 32.69341], [-117.10971, 32.69341], [-117.10898, 32.69341], [-117.1097, 32.69303], [-117.10971, 32.69341]]]} | Open Access 1 | 46700 | Z Street Mini-Park | 30067 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.357 | Z Street Mini-Park | 0 | Local Park 2 | 4 | |
5563 | 5563 | 5562 | {"type": "Polygon", "coordinates": [[[-118.19116, 33.91186], [-118.18982, 33.9152], [-118.18884, 33.91486], [-118.19004, 33.91194], [-118.19054, 33.91203], [-118.19069, 33.91166], [-118.19116, 33.91186]]]} | Open Access 1 | 20598 | Yvonne Burke-John D. Ham Park | 32573 | 1191 | Lynwood, City of 258 | City 2 | City Agency 2 | http://www.lynwood.ca.us/ | City 2 | 1191 | Lynwood, City of 254 | City 2 | City Agency 2 | Los Angeles 6 | 8.907 | Yvonne Burke-John D. Ham Park | 0 | Local Park 2 | 4 | |
894 | 894 | 893 | {"type": "Polygon", "coordinates": [[[-118.45532, 33.98607], [-118.45487, 33.98636], [-118.44863, 33.98473], [-118.44775, 33.98454], [-118.44312, 33.98366], [-118.44321, 33.98333], [-118.44803, 33.98424], [-118.44917, 33.9845], [-118.45221, 33.9853], [-118.45214, 33.98546], [-118.45234, 33.98552], [-118.4525, 33.98563], [-118.45259, 33.98566], [-118.45286, 33.98571], [-118.45306, 33.98569], [-118.4532, 33.9857], [-118.45343, 33.98581], [-118.45394, 33.98591], [-118.45469, 33.98616], [-118.45488, 33.98616], [-118.45515, 33.98606], [-118.45532, 33.98607]]]} | Open Access 1 | 6328 | Yvonne B. Burke Park | 29027 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://beaches.lacounty.gov/wps/portal/dbh/!ut/p/c4/04_SB8K8xLLM9MSSzPy8xBz9CP0os3hXAwMDd3-3YCN_ExNjA09PE88w9xAPQwMTc_2CbEdFAHGUBn8!/?current=true&urile=wcm:path:/dbh+content/dbh+site/home/marina+del+rey/parks/yvonne+b.+burke+park | Los Angeles 6 | 9.459 | Yvonne B. Burke Park | 0 | Local Park 2 | 4 |
16236 | 16236 | 16235 | {"type": "Polygon", "coordinates": [[[-116.42114, 34.12538], [-116.41861, 34.12588], [-116.41816, 34.12599], [-116.41782, 34.12609], [-116.4179, 34.12605], [-116.41796, 34.12598], [-116.41798, 34.12591], [-116.41797, 34.12583], [-116.41718, 34.12477], [-116.41723, 34.12444], [-116.41739, 34.12455], [-116.41741, 34.12455], [-116.41749, 34.12374], [-116.41762, 34.12368], [-116.4181, 34.1236], [-116.41834, 34.12358], [-116.41857, 34.12361], [-116.41867, 34.12359], [-116.41874, 34.12351], [-116.41898, 34.12342], [-116.41899, 34.12345], [-116.41902, 34.12345], [-116.41917, 34.12375], [-116.42028, 34.12341], [-116.42047, 34.12338], [-116.42061, 34.12369], [-116.42069, 34.12397], [-116.42069, 34.12462], [-116.42079, 34.12462], [-116.42092, 34.12508], [-116.42105, 34.12506], [-116.42114, 34.12538]]]} | Open Access 1 | 35808 | Yucca Valley Community Center Park Complex | 33208 | 1356 | Yucca Valley, Town of 272 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | San Bernardino 22 | 18.182 | Yucca Valley Community Ctr. Park Complex | 0 | Local Recreation Area 3 | 4 | |
11617 | 11617 | 11616 | {"type": "Polygon", "coordinates": [[[-116.23029, 33.73267], [-116.22948, 33.73267], [-116.22944, 33.73266], [-116.22942, 33.73262], [-116.22942, 33.73214], [-116.22947, 33.73212], [-116.23029, 33.73211], [-116.23029, 33.73267]]]} | Open Access 1 | 24639 | Yucca Park | 27848 | 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 | 1.218 | Yucca Park | 0 | Local Park 2 | 4 | |
9306 | 9306 | 9305 | {"type": "Polygon", "coordinates": [[[-117.19678, 34.49915], [-117.19678, 34.5004], [-117.19625, 34.5004], [-117.19623, 34.50005], [-117.19617, 34.49975], [-117.19609, 34.49945], [-117.19597, 34.49916], [-117.19678, 34.49915]]]} | Open Access 1 | 15512 | Yucca Loma Park | 27847 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.976 | Yucca Loma Park | 0 | Local Park 2 | 4 | ||
14328 | 14328 | 14327 | {"type": "MultiPolygon", "coordinates": [[[[-117.09215, 34.0368], [-117.09204, 34.03679], [-117.09202, 34.0367], [-117.09198, 34.03622], [-117.09184, 34.03579], [-117.09149, 34.03486], [-117.09225, 34.03531], [-117.09239, 34.03546], [-117.09248, 34.03564], [-117.09251, 34.03583], [-117.09248, 34.03603], [-117.09221, 34.03651], [-117.09216, 34.03664], [-117.09215, 34.0368]]], [[[-117.09306, 34.0368], [-117.09235, 34.0368], [-117.09235, 34.0367], [-117.09239, 34.03659], [-117.09262, 34.03619], [-117.09268, 34.03605], [-117.09271, 34.03589], [-117.0927, 34.03571], [-117.09263, 34.0355], [-117.09251, 34.03531], [-117.09232, 34.03514], [-117.09202, 34.03497], [-117.0928, 34.03401], [-117.09291, 34.03401], [-117.09292, 34.03525], [-117.09286, 34.03526], [-117.09306, 34.0368]]]]} | Open Access 1 | 44332 | Yucaipa Skate Park | 27846 | 1387 | Yucaipa, City of 83 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | San Bernardino 22 | 5.32 | Yucaipa Skate Park | 0 | Local Recreation Area 3 | 4 | |
1439 | 1439 | 1438 | {"type": "Polygon", "coordinates": [[[-117.05558, 34.05159], [-117.05545, 34.05175], [-117.05444, 34.0525], [-117.05184, 34.05424], [-117.05145, 34.05409], [-117.05134, 34.05427], [-117.05134, 34.05498], [-117.0513, 34.05528], [-117.05108, 34.05543], [-117.0508, 34.05546], [-117.05046, 34.0553], [-117.05017, 34.05522], [-117.04994, 34.05551], [-117.04958, 34.05577], [-117.04936, 34.05601], [-117.04886, 34.0572], [-117.04871, 34.05734], [-117.04842, 34.05741], [-117.04818, 34.05735], [-117.04804, 34.05738], [-117.04789, 34.05753], [-117.04769, 34.05762], [-117.04748, 34.05764], [-117.04732, 34.05762], [-117.04713, 34.05751], [-117.04697, 34.05731], [-117.04663, 34.05717], [-117.0467, 34.05696], [-117.04647, 34.05691], [-117.04591, 34.05682], [-117.04577, 34.05674], [-117.04569, 34.05659], [-117.04538, 34.05693], [-117.04483, 34.05699], [-117.04455, 34.05717], [-117.04449, 34.05742], [-117.0447, 34.05762], [-117.04386, 34.05799], [-117.04366, 34.05721], [-117.04564, 34.05461], [-117.04584, 34.05406], [-117.04551, 34.05387], [-117.04517, 34.05357], [-117.04519, 34.05127], [-117.04077, 34.05125], [-117.04071, 34.05101], [-117.04064, 34.05078], [-117.04044, 34.05037], [-117.04033, 34.05004], [-117.04028, 34.04854], [-117.04063, 34.0485], [-117.04379, 34.04851], [-117.0438, 34.04906], [-117.04521, 34.04906], [-117.04521, 34.04884], [-117.04512, 34.0486], [-117.0491, 34.04862], [-117.04886, 34.04874], [-117.04844, 34.04904], [-117.04816, 34.04953], [-117.04817, 34.04955], [-117.0485, 34.04939], [-117.04964, 34.04906], [-117.05035, 34.04876], [-117.05074, 34.04867], [-117.0512, 34.04874], [-117.0515, 34.04885], [-117.05136, 34.04943], [-117.05254, 34.04955], [-117.05255, 34.04987], [-117.05273, 34.05013], [-117.053, 34.05018], [-117.05322, 34.05005], [-117.05421, 34.05028], [-117.05444, 34.0504], [-117.05501, 34.05105], [-117.05545, 34.05101], [-117.05558, 34.05159]], [[-117.04938, 34.05312], [-117.0481, 34.05208], [-117.04792, 34.05228], [-117.04803, 34.05297], [-117.04757, 34.05379], [-117.04726, 34.05442], [-117.04744, 34.05453], [-117.04785, 34.05438], [-117.0478, 34.0547], [-117.04726, 34.05476], [-117.04733, 34.05513], [-117.04728, 34.05535], [-117.04702, 34.05543], [-117.04661, 34.0555], [-117.04655, 34.05569], [-117.04689, 34.05589], [-117.04715, 34.05586], [-117.04751, 34.05546], [-117.04772, 34.05526], [-117.04798, 34.05513], [-117.04819, 34.05481], [-117.0484, 34.05459], [-117.04892, 34.05429], [-117.04892, 34.0537], [-117.04938, 34.05312]], [[-117.04926, 34.05164], [-117.04952, 34.05207], [-117.04972, 34.05212], [-117.04993, 34.05207], [-117.05045, 34.05144], [-117.05102, 34.04999], [-117.04996, 34.04954], [-117.0497, 34.04938], [-117.04965, 34.04987], [-117.04952, 34.05034], [-117.04959, 34.05071], [-117.04952, 34.05097], [-117.04928, 34.05144], [-117.04926, 34.05164]]]} | Open Access 1 | 6427 | Yucaipa Regional Park | 10147 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Parks/YucaipaRegionalPark.aspx | San Bernardino 22 | 172.247 | Yucaipa RP | 0 | Local Park 2 | 4 |
13179 | 13179 | 13178 | {"type": "Polygon", "coordinates": [[[-117.06064, 34.05543], [-117.05008, 34.05571], [-117.05057, 34.05535], [-117.0508, 34.05546], [-117.05108, 34.05543], [-117.05129, 34.05529], [-117.05134, 34.05498], [-117.05134, 34.05478], [-117.0542, 34.05266], [-117.05444, 34.0525], [-117.05545, 34.05175], [-117.05574, 34.05152], [-117.05554, 34.05141], [-117.05545, 34.05101], [-117.05501, 34.05105], [-117.05444, 34.05041], [-117.05421, 34.05028], [-117.05322, 34.05005], [-117.05311, 34.05012], [-117.05255, 34.04982], [-117.05253, 34.04955], [-117.05192, 34.04949], [-117.05141, 34.04922], [-117.0515, 34.04885], [-117.05121, 34.04874], [-117.05074, 34.04867], [-117.05035, 34.04876], [-117.05008, 34.04888], [-117.0485, 34.04939], [-117.04965, 34.04839], [-117.05093, 34.04832], [-117.05093, 34.0483], [-117.0506, 34.04789], [-117.05506, 34.04434], [-117.06032, 34.04116], [-117.06044, 34.04116], [-117.0605, 34.04564], [-117.06049, 34.04844], [-117.06054, 34.04845], [-117.06064, 34.05543]]]} | Open Access 1 | 35154 | Yucaipa Regional Park | 10147 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Parks/YucaipaRegionalPark.aspx | San Bernardino 22 | 241.688 | Yucaipa RP | 0 | Local Park 2 | 4 |
3026 | 3026 | 3025 | {"type": "Polygon", "coordinates": [[[-121.58366, 39.1463], [-121.58247, 39.14641], [-121.58233, 39.14532], [-121.58344, 39.14445], [-121.58352, 39.14522], [-121.58366, 39.1463]]]} | Open Access 1 | 20790 | Yuba Park | 27845 | 1199 | Marysville, City of 539 | City 2 | City Agency 2 | http://www.marysville.ca.us/index.php/city-services/parks-facilities | City 2 | 1199 | Marysville, City of 532 | City 2 | City Agency 2 | Yuba 25 | 4.217 | Yuba Park | 0 | Local Park 2 | 4 | |
13391 | 13391 | 13390 | {"type": "Polygon", "coordinates": [[[-121.2718, 39.47467], [-121.27178, 39.47519], [-121.27125, 39.47519], [-121.27123, 39.47535], [-121.27078, 39.47536], [-121.27081, 39.47451], [-121.27119, 39.47444], [-121.27138, 39.47444], [-121.27154, 39.47449], [-121.2717, 39.47457], [-121.2718, 39.47467]]]} | Unknown Access 4 | 35494 | Yuba County Water Agency 9 | 27844 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.824 | Yuba County Water Agency 9 | 0 | Local Other or Unknown 14 | 4 | |
13462 | 13462 | 13461 | {"type": "Polygon", "coordinates": [[[-121.28629, 39.49959], [-121.28524, 39.49961], [-121.28526, 39.50057], [-121.28357, 39.49813], [-121.28627, 39.49819], [-121.28629, 39.49959]]]} | Unknown Access 4 | 35682 | Yuba County Water Agency 8 | 27843 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 8.198 | Yuba County Water Agency 8 | 0 | Local Other or Unknown 14 | 4 | |
3876 | 3876 | 3875 | {"type": "Polygon", "coordinates": [[[-121.28161, 39.49241], [-121.28087, 39.49553], [-121.27866, 39.49811], [-121.27864, 39.49743], [-121.27853, 39.49685], [-121.27851, 39.49655], [-121.27854, 39.4958], [-121.27841, 39.49547], [-121.27838, 39.4953], [-121.27916, 39.49462], [-121.27937, 39.49367], [-121.27955, 39.49218], [-121.27846, 39.49076], [-121.27957, 39.49017], [-121.28161, 39.49241]]]} | Unknown Access 4 | 35684 | Yuba County Water Agency 7 | 27842 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 30.672 | Yuba County Water Agency 7 | 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]);