superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,194
- County Agency 1,101
- Recreation/Parks District 1,090
- State Agency 871
- Non Profit - Land Trust 511
- Federal Agency 289
- Open Space District 241
- County Agency - Parks 217
- Home Owners Association 200
- Community Services District 193
- Water District 187
- Non Profit - Conservation 119
- Flood District 94
- Cemetery District 61
- Non Profit - Other 44
- School District 38
- County Agency - Other 32
- Port/Harbor District 32
- Irrigation District 24
- Special District - Other 15
- Commercial 14
- Sanitation District 9
- Joint Powers Authority 8
- 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
- Los Angeles, City of 459
- San Diego, City of 433
- California Department of Fish and Wildlife 394
- California Department of Parks and Recreation 276
- San Jose, City of 246
- San Francisco, City and County of 240
- Sacramento, City of 218
- Mountains Recreation and Conservation Authority 181
- Los Angeles, County of 170
- Ventura, City of 151
- Long Beach, City of 148
- East Bay Regional Park District 132
- Roseville, City of 124
- Oakland, City of 122
- San Diego, County of 120
- Irvine, City of 98
- Fresno, City of 94
- Consumnes Community Services District 92
- Santa Barbara, County of 89
- Hayward Area Recreation and Park District 84
- Modesto, City of 84
- Orange, County of 82
- Stockton, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 69
- Chula Vista, City of 69
- Brentwood, City of 68
- …
MNG_AG_LEV 8 ✖
- City 10,194
- Special District 1,999
- County 1,350
- State 871
- Non Profit 682
- Federal 289
- Private 226
- Joint 7
ACCESS_TYP 4
- Open Access 13,493
- Restricted Access 1,117
- No Public Access 754
- Unknown Access 254
Link | rowid ▲ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15618 | 15618 | 15617 | {"type": "Polygon", "coordinates": [[[-118.2263, 34.08911], [-118.22518, 34.08976], [-118.22487, 34.08994], [-118.22508, 34.08832], [-118.22601, 34.0884], [-118.2263, 34.08911]]]} | Open Access 1 | Cypress Recreation Center | http://www.laparks.org/dos/reccenter/facility/cypressRC.htm | 28725 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.501 | Cypress Rec. Ctr. | |
15617 | 15617 | 15616 | {"type": "Polygon", "coordinates": [[[-121.62355, 39.75978], [-121.62353, 39.75986], [-121.62305, 39.7606], [-121.62223, 39.76218], [-121.62185, 39.76218], [-121.62186, 39.76168], [-121.62184, 39.75954], [-121.62328, 39.75953], [-121.62339, 39.75956], [-121.62347, 39.75962], [-121.62353, 39.7597], [-121.62355, 39.75978]]]} | Open Access 1 | Terry Ashe Recreation Center | 26267 | 2250 | Paradise Recreation and Park District 572 | Special District 4 | Recreation/Parks District 4 | http://www.paradiseprpd.com/ | Special District 4 | 6.683 | Terry Ashe Rec. Ctr. | ||
15616 | 15616 | 15615 | {"type": "MultiPolygon", "coordinates": [[[[-117.04446, 32.557], [-117.04413, 32.55699], [-117.04415, 32.5563], [-117.04445, 32.55646], [-117.04446, 32.557]]], [[[-117.04445, 32.55613], [-117.04415, 32.55597], [-117.04415, 32.55467], [-117.04444, 32.55467], [-117.04445, 32.55613]]], [[[-117.04445, 32.55264], [-117.04444, 32.55455], [-117.04415, 32.55456], [-117.04416, 32.55236], [-117.04445, 32.5524], [-117.04445, 32.55264]]]]} | Open Access 1 | San Ysidro Community Park and Recreation Center | 25001 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 3.149 | San Ysidro Community Park and Rec. Ctr. | ||
15615 | 15615 | 15614 | {"type": "Polygon", "coordinates": [[[-118.19124, 34.08545], [-118.19087, 34.08586], [-118.18962, 34.08586], [-118.19055, 34.08484], [-118.19095, 34.08509], [-118.19086, 34.0852], [-118.19124, 34.08545]]]} | Open Access 1 | Rose Hill Recreation Center | 24611 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.266 | Rose Hill Rec. Ctr. | ||
15614 | 15614 | 15613 | {"type": "Polygon", "coordinates": [[[-122.88243, 38.14605], [-122.8785, 38.1477], [-122.87424, 38.14422], [-122.87493, 38.14233], [-122.87508, 38.14199], [-122.87589, 38.14244], [-122.87666, 38.14294], [-122.87699, 38.14308], [-122.87729, 38.14316], [-122.87758, 38.14321], [-122.8796, 38.14365], [-122.8806, 38.14385], [-122.88076, 38.1439], [-122.88091, 38.14397], [-122.88105, 38.14406], [-122.88115, 38.14416], [-122.88178, 38.14495], [-122.88212, 38.14545], [-122.88243, 38.14605]]]} | Restricted Access 2 | Marconi Conference Center State Historic Park | 21798 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 57.36 | Marconi Conference Ctr. SHP | 1989 | |
15613 | 15613 | 15612 | {"type": "Polygon", "coordinates": [[[-116.71662, 33.74341], [-116.71529, 33.74392], [-116.71542, 33.7442], [-116.71505, 33.74429], [-116.71457, 33.7435], [-116.71464, 33.7433], [-116.71463, 33.7428], [-116.71464, 33.74276], [-116.71524, 33.74258], [-116.71632, 33.74263], [-116.71628, 33.74276], [-116.71662, 33.74341]]]} | Open Access 1 | Idyllwild Community Center | https://www.idyllwildcommunitycenter.org/faq | 33128 | 3387 | San Jacinto Mountain Community Center 831 | Non Profit 6 | Non Profit - Other 20 | https://www.idyllwildcommunitycenter.org/faq | Non Governmental Organization 10 | 5.567 | Idyllwild Community Ctr. | 2019 |
15612 | 15612 | 15611 | {"type": "Polygon", "coordinates": [[[-117.04676, 32.56542], [-117.04503, 32.56542], [-117.04504, 32.56485], [-117.04551, 32.56485], [-117.04578, 32.5649], [-117.0459, 32.56494], [-117.04676, 32.56542]]]} | Open Access 1 | Colonel Irving Salomon San Ysidro Community Activity Center | https://www.sandiego.gov/park-and-recreation/centers/recctr/colonel | 31314 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1.766 | Colonel Irving Salomon San Ysidro Community Activity Ctr. | |
15611 | 15611 | 15610 | {"type": "MultiPolygon", "coordinates": [[[[-117.87072, 33.61203], [-117.86969, 33.61297], [-117.86943, 33.61322], [-117.8692, 33.61349], [-117.86893, 33.61389], [-117.86882, 33.6139], [-117.86845, 33.61374], [-117.86875, 33.61344], [-117.86902, 33.61312], [-117.86938, 33.61262], [-117.86949, 33.61244], [-117.86946, 33.61223], [-117.8698, 33.61162], [-117.86988, 33.6116], [-117.87012, 33.61165], [-117.87035, 33.61172], [-117.87057, 33.61181], [-117.87059, 33.61193], [-117.87072, 33.61203]], [[-117.86977, 33.61244], [-117.86973, 33.61238], [-117.8696, 33.61245], [-117.86957, 33.6125], [-117.86957, 33.61257], [-117.86951, 33.6127], [-117.86945, 33.61277], [-117.86927, 33.61293], [-117.86916, 33.6131], [-117.86909, 33.61318], [-117.86899, 33.61325], [-117.86895, 33.61331], [-117.86896, 33.61336], [-117.86901, 33.61339], [-117.86907, 33.61336], [-117.86915, 33.61328], [-117.86918, 33.6132], [-117.86932, 33.61303], [-117.86936, 33.61299], [-117.86956, 33.61288], [-117.86967, 33.61278], [-117.86973, 33.61271], [-117.86975, 33.61264], [-117.86977, 33.61252], [-117.86979, 33.61246], [-117.86977, 33.61244]]], [[[-117.87349, 33.60827], [-117.87244, 33.60984], [-117.87214, 33.61027], [-117.87164, 33.61089], [-117.87109, 33.61149], [-117.87106, 33.61148], [-117.87097, 33.61156], [-117.87087, 33.61158], [-117.87063, 33.61147], [-117.87025, 33.61134], [-117.87021, 33.61125], [-117.87084, 33.6101], [-117.87188, 33.60836], [-117.87236, 33.60747], [-117.87279, 33.60778], [-117.87278, 33.60781], [-117.87298, 33.60796], [-117.87303, 33.60794], [-117.87349, 33.60827]]]]} | Open Access 1 | Civic Center Park | 31128 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 16.289 | Civic Ctr. Park | ||
15610 | 15610 | 15609 | {"type": "Polygon", "coordinates": [[[-117.86524, 33.60879], [-117.86483, 33.60907], [-117.86416, 33.6095], [-117.86411, 33.60951], [-117.86405, 33.60949], [-117.86372, 33.60917], [-117.86319, 33.60873], [-117.86378, 33.60813], [-117.86428, 33.60812], [-117.86524, 33.60879]]]} | Open Access 1 | San Joaquin Hills Park and Lawn Bowling Center | 31139 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 4.07 | San Joaquin Hills Park and Lawn Bowling Ctr. | ||
15609 | 15609 | 15608 | {"type": "Polygon", "coordinates": [[[-117.32246, 33.95383], [-117.32245, 33.95457], [-117.32188, 33.95454], [-117.32113, 33.95458], [-117.32047, 33.95466], [-117.31985, 33.95479], [-117.31984, 33.95381], [-117.32246, 33.95383]]]} | Open Access 1 | Ameal Moore Nature Center | 30760 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 5.254 | Ameal Moore Nature Ctr. | ||
15608 | 15608 | 15607 | {"type": "MultiPolygon", "coordinates": [[[[-117.21283, 32.73108], [-117.21277, 32.73129], [-117.21258, 32.73155], [-117.21181, 32.73227], [-117.21177, 32.73235], [-117.20889, 32.7351], [-117.20853, 32.73504], [-117.21123, 32.73238], [-117.21132, 32.73232], [-117.21139, 32.73225], [-117.21155, 32.73226], [-117.21207, 32.73166], [-117.2122, 32.73103], [-117.21236, 32.73103], [-117.21283, 32.73108]]], [[[-117.2167, 32.7323], [-117.21669, 32.73233], [-117.21639, 32.73268], [-117.21602, 32.73307], [-117.21274, 32.73623], [-117.21266, 32.7362], [-117.21261, 32.73622], [-117.21171, 32.73709], [-117.21171, 32.73715], [-117.21175, 32.73718], [-117.21007, 32.73879], [-117.20993, 32.73891], [-117.20989, 32.73885], [-117.20979, 32.73876], [-117.20951, 32.73854], [-117.20948, 32.73854], [-117.2092, 32.73833], [-117.20891, 32.73808], [-117.20878, 32.73793], [-117.20869, 32.7378], [-117.20868, 32.73771], [-117.20871, 32.73754], [-117.20875, 32.73746], [-117.20897, 32.7373], [-117.20917, 32.73711], [-117.20928, 32.73704], [-117.20936, 32.73696], [-117.20938, 32.7369], [-117.20987, 32.73643], [-117.21032, 32.73603], [-117.21092, 32.73543], [-117.21183, 32.73457], [-117.21208, 32.73436], [-117.21279, 32.73362], [-117.21325, 32.73316], [-117.21343, 32.73297], [-117.21354, 32.73293], [-117.21374, 32.7327], [-117.21377, 32.73265], [-117.21386, 32.73261], [-117.21408, 32.73242], [-117.21439, 32.73202], [-117.21449, 32.73179], [-117.21457, 32.73155], [-117.2146, 32.73129], [-117.21468, 32.73108], [-117.21493, 32.73112], [-117.21561, 32.73153], [-117.21552, 32.73159], [-117.21548, 32.73167], [-117.21549, 32.73176], [-117.21552, 32.73181], [-117.21557, 32.73185], [-117.21567, 32.73188], [-117.21588, 32.73184], [-117.21598, 32.73186], [-117.2167, 32.7323]]]]} | Open Access 1 | Naval Training Center Park | 30054 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 49.054 | Naval Training Ctr. Park | ||
15607 | 15607 | 15606 | {"type": "Polygon", "coordinates": [[[-122.08599, 37.95319], [-122.0867, 37.95368], [-122.08695, 37.95388], [-122.08706, 37.95399], [-122.0871, 37.95408], [-122.08712, 37.95418], [-122.08711, 37.95427], [-122.08708, 37.95436], [-122.08703, 37.95444], [-122.08696, 37.95451], [-122.08668, 37.95472], [-122.08599, 37.95516], [-122.08599, 37.95319]]]} | Open Access 1 | Winslow Center | 27650 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 3.264 | Winslow Ctr. | ||
15606 | 15606 | 15605 | {"type": "Polygon", "coordinates": [[[-122.08731, 37.40986], [-122.08686, 37.41101], [-122.0861, 37.41091], [-122.08569, 37.41023], [-122.08531, 37.41036], [-122.08529, 37.41034], [-122.08535, 37.4103], [-122.08532, 37.41023], [-122.08534, 37.41015], [-122.08529, 37.41012], [-122.08517, 37.41022], [-122.08503, 37.41031], [-122.08487, 37.41037], [-122.0847, 37.4104], [-122.08444, 37.4104], [-122.08428, 37.41036], [-122.08412, 37.4103], [-122.08387, 37.4103], [-122.08393, 37.40924], [-122.08429, 37.40937], [-122.08472, 37.40949], [-122.0854, 37.40963], [-122.08587, 37.4097], [-122.08688, 37.40978], [-122.08731, 37.40986]]]} | Open Access 1 | Whisman Sports Center | 27457 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 7.391 | Whisman Sports Ctr. | ||
15605 | 15605 | 15604 | {"type": "Polygon", "coordinates": [[[-121.29458, 37.95402], [-121.29455, 37.95407], [-121.29456, 37.95412], [-121.29396, 37.95531], [-121.29388, 37.95538], [-121.29374, 37.95544], [-121.29362, 37.95545], [-121.29272, 37.95541], [-121.2927, 37.95547], [-121.29271, 37.95549], [-121.29374, 37.95554], [-121.29215, 37.95577], [-121.29166, 37.95409], [-121.29334, 37.9539], [-121.2945, 37.95393], [-121.29454, 37.95394], [-121.29458, 37.95402]]]} | Open Access 1 | Weber Point Event Center | 27326 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 9.256 | Weber Point Event Ctr. | ||
15604 | 15604 | 15603 | {"type": "Polygon", "coordinates": [[[-122.85063, 38.62187], [-122.85033, 38.62203], [-122.85026, 38.62196], [-122.85035, 38.62188], [-122.85022, 38.62174], [-122.85001, 38.62187], [-122.85036, 38.62223], [-122.84998, 38.62226], [-122.84941, 38.62224], [-122.84941, 38.62281], [-122.84722, 38.62334], [-122.8473, 38.62058], [-122.85008, 38.62055], [-122.85049, 38.62114], [-122.85063, 38.62187]]]} | Open Access 1 | Villag Chanticleer Conference Center | 27108 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 16.795 | Villag Chanticleer Conference Ctr. | ||
15603 | 15603 | 15602 | {"type": "Polygon", "coordinates": [[[-123.01796, 38.80475], [-123.01776, 38.80483], [-123.01761, 38.80461], [-123.01762, 38.80459], [-123.01759, 38.80453], [-123.01776, 38.80445], [-123.01796, 38.80475]]]} | Open Access 1 | Veterans Memorial Center | 27022 | 1059 | Cloverdale, City of 404 | City 2 | City Agency 2 | http://www.cloverdale.net/index.aspx?nid=152 | City 2 | 0.172 | Veterans Memorial Ctr. | ||
15602 | 15602 | 15601 | {"type": "Polygon", "coordinates": [[[-121.076, 38.68331], [-121.07338, 38.68435], [-121.07326, 38.68359], [-121.07237, 38.68276], [-121.072, 38.68255], [-121.07182, 38.68187], [-121.07311, 38.68189], [-121.07452, 38.68212], [-121.075, 38.68217], [-121.07565, 38.68221], [-121.0757, 38.68245], [-121.07588, 38.68303], [-121.07583, 38.68311], [-121.07589, 38.68329], [-121.076, 38.68331]]]} | Open Access 1 | Teen Center & Skate Park | 26216 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 14.34 | Teen Ctr. & Skate Park | ||
15601 | 15601 | 15600 | {"type": "Polygon", "coordinates": [[[-118.00187, 33.80691], [-118.00101, 33.80692], [-118.00099, 33.80705], [-118.00023, 33.80706], [-118.00023, 33.80672], [-118.00187, 33.80671], [-118.00187, 33.80691]]]} | Open Access 1 | Stanton Municipal Tennis Center | 25795 | 1342 | Stanton, City of 731 | City 2 | City Agency 2 | http://www.ci.stanton.ca.us/Departments/Parks-and-Recreation | City 2 | 1.129 | Stanton Municipal Tennis Ctr. | ||
15600 | 15600 | 15599 | {"type": "Polygon", "coordinates": [[[-121.3338, 39.23349], [-121.33372, 39.23727], [-121.3243, 39.23737], [-121.32429, 39.23738], [-121.32453, 39.24449], [-121.33368, 39.24449], [-121.33366, 39.24792], [-121.32917, 39.24797], [-121.32919, 39.25147], [-121.32924, 39.25512], [-121.33372, 39.25512], [-121.33371, 39.26605], [-121.31481, 39.26614], [-121.30732, 39.2662], [-121.30748, 39.27044], [-121.31484, 39.27044], [-121.31493, 39.2805], [-121.30539, 39.28061], [-121.30542, 39.28434], [-121.30106, 39.28441], [-121.301, 39.29498], [-121.30318, 39.295], [-121.30147, 39.29639], [-121.30123, 39.29679], [-121.30095, 39.29746], [-121.30085, 39.29796], [-121.30099, 39.29839], [-121.30121, 39.29871], [-121.30158, 39.29893], [-121.30153, 39.29925], [-121.30093, 39.29934], [-121.30101, 39.30572], [-121.29676, 39.30573], [-121.29669, 39.30303], [-121.28711, 39.30295], [-121.28689, 39.29513], [-121.28248, 39.29517], [-121.28234, 39.2807], [-121.28741, 39.2807], [-121.2873, 39.27731], [-121.29637, 39.27716], [-121.29623, 39.26629], [-121.30109, 39.26623], [-121.30092, 39.26083], [-121.30093, 39.25142], [-121.29619, 39.25136], [-121.29139, 39.25136], [-121.29148, 39.25507], [-121.28722, 39.2551], [-121.28722, 39.25573], [-121.28718, 39.25571], [-121.2868, 39.25585], [-121.28659, 39.25617], [-121.28643, 39.25645], [-121.28622, 39.25661], [-121.28578, 39.25669], [-121.28505, 39.25674], [-121.28474, 39.25696], [-121.28466, 39.25718], [-121.28448, 39.25737], [-121.28427, 39.2575], [-121.28398, 39.25754], [-121.28378, 39.25754], [-121.28316, 39.2576], [-121.28261, 39.25767], [-121.28241, 39.25761], [-121.28191, 39.25751], [-121.28135, 39.25708], [-121.28104, 39.25682], [-121.28063, 39.25662], [-121.28032, 39.25643], [-121.27993, 39.25627], [-121.27955, 39.25596], [-121.27899, 39.25524], [-121.27852, 39.25483], [-121.27772, 39.25438], [-121.277, 39.25428], [-121.27645, 39.25429], [-121.27583, 39.25439], [-121.27541, 39.25453], [-121.2751, 39.25473], [-121.27493, 39.25496], [-121.27223, 39.25492], [-121.27226, 39.25134], [-121.27005, 39.25133], [-121.26974, 39.25132], [-121.26978, 39.25105], [-121.26978, 39.25075], [-121.26949, 39.25002], [-121.26946, 39.24989], [-121.26952, 39.24989], [-121.26953, 39.24988], [-121.26939, 39.24965], [-121.26923, 39.24933], [-121.26916, 39.24918], [-121.26909, 39.24896], [-121.26878, 39.24763], [-121.26876, 39.24718], [-121.26882, 39.24667], [-121.26904, 39.24527], [-121.26905, 39.2448], [-121.26891, 39.24278], [-121.26889, 39.24173], [-121.2689, 39.24109], [-121.27324, 39.24133], [-121.27327, 39.23722], [-121.27748, 39.23723], [-121.27788, 39.23052], [-121.27806, 39.23032], [-121.2796, 39.2303], [-121.28206, 39.23057], [-121.283, 39.23055], [-121.28773, 39.2288], [-121.28769, 39.23273], [-121.29249, 39.23272], [-121.29248, 39.22873], [-121.29618, 39.22869], [-121.29612, 39.22304], [-121.30887, 39.22298], [-121.30758, 39.22803], [-121.30814, 39.22973], [-121.3148, 39.23303], [-121.31623, 39.23359], [-121.32226, 39.23519], [-121.32623, 39.23328], [-121.3269, 39.23267], [-121.3279, 39.23237], [-121.32841, 39.23194], [-121.32872, 39.23012], [-121.32905, 39.23011], [-121.32909, 39.23355], [-121.3338, 39.23349]]]} | Restricted Access 2 | Sierra Foothill Research & Extension Center | 25454 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 5780.022 | Sierra Foothill Research & Extension Ctr. | ||
15599 | 15599 | 15598 | {"type": "Polygon", "coordinates": [[[-119.75792, 36.91239], [-119.75661, 36.91246], [-119.75643, 36.91024], [-119.75775, 36.91023], [-119.75792, 36.91239]]]} | Open Access 1 | River Center | 24407 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.riverparkway.org | Non Governmental Organization 10 | 7.034 | River Ctr. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);