superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 465
- San Diego, City of 433
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 218
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 124
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 94
- Modesto, City of 84
- 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
- Poway, City of 67
- Newport Beach, City of 65
- Santa Barbara, City of 64
- Davis, City of 64
- San Luis Obispo, City of 63
- Napa, City of 62
- Clovis, City of 62
- Bakersfield, City of 61
- Manteca, City of 60
- Anaheim, City of 59
- …
ACCESS_TYP 4
- Open Access 9,652
- Restricted Access 354
- No Public Access 155
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,190 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10974 | 10974 | 10973 | {"type": "Polygon", "coordinates": [[[-120.82355, 37.78764], [-120.82233, 37.78798], [-120.8217, 37.78871], [-120.82072, 37.78937], [-120.82016, 37.78948], [-120.81983, 37.78951], [-120.81884, 37.79034], [-120.8183, 37.79059], [-120.81778, 37.7866], [-120.81797, 37.78648], [-120.81786, 37.7856], [-120.81856, 37.7856], [-120.81916, 37.78542], [-120.81965, 37.78535], [-120.82005, 37.78539], [-120.82031, 37.78558], [-120.82222, 37.78558], [-120.82354, 37.78555], [-120.82355, 37.78764]]]} | Open Access 1 | W T Kerr Community Park | 27201 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 48.181 | W T Kerr Community Park | ||
11238 | 11238 | 11237 | {"type": "Polygon", "coordinates": [[[-120.87737, 37.76176], [-120.87616, 37.76176], [-120.87611, 37.76172], [-120.8761, 37.76055], [-120.87615, 37.76051], [-120.87682, 37.76051], [-120.87688, 37.76054], [-120.87736, 37.76051], [-120.87737, 37.76176]]]} | Open Access 1 | William A. Fish Veterans Memorial Park | 27537 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 3.801 | William A. Fish Veterans Memorial Park | ||
11260 | 11260 | 11259 | {"type": "Polygon", "coordinates": [[[-120.84861, 37.76492], [-120.8483, 37.76505], [-120.84814, 37.76482], [-120.84845, 37.76468], [-120.84861, 37.76492]]]} | Open Access 1 | William Meyer Park | 27553 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 0.233 | William Meyer Park | ||
662 | 662 | 661 | {"type": "Polygon", "coordinates": [[[-118.0508, 33.77469], [-118.05071, 33.77474], [-118.05066, 33.77481], [-118.05066, 33.77506], [-118.05064, 33.77513], [-118.05061, 33.77515], [-118.05051, 33.77515], [-118.04961, 33.77506], [-118.04924, 33.77506], [-118.04919, 33.77501], [-118.04919, 33.77486], [-118.04917, 33.77481], [-118.04913, 33.77476], [-118.04903, 33.77471], [-118.0508, 33.77469]]]} | Open Access 1 | Almond Park | 15398 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1.507 | Almond Park | ||
818 | 818 | 817 | {"type": "Polygon", "coordinates": [[[-118.05123, 33.78279], [-118.05121, 33.78401], [-118.04864, 33.78403], [-118.04753, 33.78326], [-118.0475, 33.78274], [-118.05123, 33.78279]]]} | Open Access 1 | Arbor Park | 15559 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 10.75 | Arbor Park | ||
2088 | 2088 | 2087 | {"type": "Polygon", "coordinates": [[[-118.06195, 33.77555], [-118.0613, 33.77555], [-118.06131, 33.77488], [-118.06133, 33.77485], [-118.06137, 33.77484], [-118.06186, 33.77484], [-118.06194, 33.77488], [-118.06196, 33.77493], [-118.06195, 33.77555]]]} | Open Access 1 | Bluebell Park | 16192 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1.171 | Bluebell Park | ||
3860 | 3860 | 3859 | {"type": "Polygon", "coordinates": [[[-118.09665, 33.77734], [-118.09664, 33.77835], [-118.09659, 33.77908], [-118.09606, 33.779], [-118.09566, 33.77902], [-118.09569, 33.77668], [-118.09574, 33.77489], [-118.09606, 33.77483], [-118.09664, 33.77485], [-118.09662, 33.77729], [-118.09665, 33.77734]]]} | Open Access 1 | Edison Park | 18446 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 9.949 | Edison Park | ||
3878 | 3878 | 3877 | {"type": "MultiPolygon", "coordinates": [[[[-118.10598, 33.73945], [-118.10581, 33.73968], [-118.1051, 33.73933], [-118.10527, 33.73909], [-118.10598, 33.73945]]], [[[-118.10701, 33.73996], [-118.10683, 33.7402], [-118.10615, 33.73985], [-118.10632, 33.73962], [-118.10701, 33.73996]]], [[[-118.10746, 33.7402], [-118.10729, 33.74044], [-118.10691, 33.74024], [-118.10708, 33.74], [-118.10746, 33.7402]]]]} | Open Access 1 | Eisenhower Park | 18475 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1.459 | Eisenhower Park | ||
3934 | 3934 | 3933 | {"type": "MultiPolygon", "coordinates": [[[[-118.09836, 33.73752], [-118.09788, 33.7375], [-118.09784, 33.73745], [-118.09801, 33.7372], [-118.09836, 33.73752]]], [[[-118.10024, 33.73925], [-118.10001, 33.73945], [-118.09809, 33.73769], [-118.09857, 33.73772], [-118.10024, 33.73925]]], [[[-118.10169, 33.74058], [-118.10152, 33.74083], [-118.10011, 33.73954], [-118.10034, 33.73934], [-118.10169, 33.74058]]], [[[-118.10382, 33.74254], [-118.10364, 33.74278], [-118.1024, 33.74164], [-118.10162, 33.74093], [-118.1018, 33.74068], [-118.10382, 33.74254]]], [[[-118.10525, 33.74384], [-118.10503, 33.74405], [-118.10381, 33.74293], [-118.10401, 33.74271], [-118.10525, 33.74384]]], [[[-118.10603, 33.74458], [-118.10599, 33.74466], [-118.10595, 33.7449], [-118.10517, 33.74419], [-118.1054, 33.74399], [-118.10603, 33.74458]]], [[[-118.10648, 33.74497], [-118.10612, 33.74497], [-118.1061, 33.74486], [-118.10613, 33.74465], [-118.10648, 33.74497]]]]} | Open Access 1 | Electric Ave Greenbelt | 18557 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 7.721 | Electric Ave Greenbelt | ||
4800 | 4800 | 4799 | {"type": "Polygon", "coordinates": [[[-118.10036, 33.74943], [-118.10034, 33.74971], [-118.10013, 33.74989], [-118.09978, 33.74999], [-118.09918, 33.74999], [-118.09748, 33.74977], [-118.09567, 33.74976], [-118.09489, 33.75005], [-118.0943, 33.75006], [-118.09404, 33.75022], [-118.09393, 33.7505], [-118.09274, 33.75002], [-118.09208, 33.7498], [-118.09206, 33.74981], [-118.09182, 33.74974], [-118.09161, 33.74966], [-118.09078, 33.74928], [-118.0906, 33.74923], [-118.0904, 33.74923], [-118.09024, 33.74927], [-118.09011, 33.74934], [-118.08996, 33.74946], [-118.08988, 33.74959], [-118.0898, 33.74978], [-118.09, 33.74998], [-118.09008, 33.75003], [-118.08995, 33.75016], [-118.08991, 33.75016], [-118.08987, 33.75014], [-118.0898, 33.75007], [-118.08968, 33.75005], [-118.08939, 33.74991], [-118.08937, 33.74987], [-118.08938, 33.74984], [-118.0904, 33.74833], [-118.09168, 33.7494], [-118.10036, 33.74943]]]} | Open Access 1 | Gum Grove Park | 19568 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 14.959 | Gum Grove Park | ||
5003 | 5003 | 5002 | {"type": "Polygon", "coordinates": [[[-118.0526, 33.78098], [-118.05249, 33.78107], [-118.05209, 33.78107], [-118.05186, 33.78077], [-118.05193, 33.78071], [-118.05195, 33.78065], [-118.05193, 33.78054], [-118.05193, 33.78014], [-118.05195, 33.78009], [-118.05199, 33.78008], [-118.05252, 33.78009], [-118.05256, 33.78009], [-118.05259, 33.78012], [-118.0526, 33.78098]]]} | Open Access 1 | Heather Park | 19785 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1.615 | Heather Park | ||
5628 | 5628 | 5627 | {"type": "Polygon", "coordinates": [[[-118.111, 33.74554], [-118.11097, 33.74555], [-118.10971, 33.74629], [-118.10972, 33.74521], [-118.11008, 33.74524], [-118.11037, 33.7453], [-118.11059, 33.74537], [-118.111, 33.74554]]]} | Open Access 1 | Marina Park | 21837 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1.915 | Marina Park | ||
6833 | 6833 | 6832 | {"type": "Polygon", "coordinates": [[[-118.0966, 33.74354], [-118.0966, 33.74357], [-118.09593, 33.74451], [-118.09565, 33.74437], [-118.09566, 33.74429], [-118.09478, 33.74377], [-118.09476, 33.74327], [-118.09514, 33.74279], [-118.0966, 33.74354]]]} | Open Access 1 | McGaugh Gymnasium, Pool, Tennis Courts & Fields | 22033 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 4.456 | McGaugh Gymnasium, Pool, Tennis Courts & Fields | ||
8044 | 8044 | 8043 | {"type": "Polygon", "coordinates": [[[-118.10808, 33.74807], [-118.10744, 33.74844], [-118.1074, 33.74793], [-118.10733, 33.74749], [-118.10727, 33.74736], [-118.1072, 33.74729], [-118.10708, 33.74722], [-118.10708, 33.74717], [-118.10709, 33.74716], [-118.10808, 33.74807]]]} | Open Access 1 | Seal Beach holding 1 | 25240 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 0.923 | Seal Beach holding 1 | ||
9446 | 9446 | 9445 | {"type": "Polygon", "coordinates": [[[-118.06595, 33.77472], [-118.06558, 33.7748], [-118.06521, 33.7749], [-118.06481, 33.77506], [-118.06449, 33.77523], [-118.06408, 33.77551], [-118.06382, 33.77574], [-118.06343, 33.77613], [-118.06332, 33.77613], [-118.06287, 33.77585], [-118.0627, 33.77578], [-118.06252, 33.77572], [-118.06235, 33.77569], [-118.06217, 33.77568], [-118.06212, 33.77564], [-118.06212, 33.77508], [-118.06218, 33.77491], [-118.06217, 33.77476], [-118.06595, 33.77472]]]} | Open Access 1 | Seal Beach Tennis Center | 25242 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 6.797 | Seal Beach Tennis Ctr. | ||
11512 | 11512 | 11511 | {"type": "Polygon", "coordinates": [[[-118.10221, 33.74239], [-118.10162, 33.7432], [-118.10041, 33.74259], [-118.10094, 33.74187], [-118.1018, 33.7423], [-118.10187, 33.74222], [-118.10221, 33.74239]]]} | Open Access 1 | Zoeter Field | 27867 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 3.138 | Zoeter Field | ||
16 | 16 | 15 | {"type": "Polygon", "coordinates": [[[-117.1296, 32.71069], [-117.1296, 32.71124], [-117.12944, 32.71124], [-117.12944, 32.71069], [-117.1296, 32.71069]]]} | Open Access 1 | 30th Street Mini Park | 15192 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.23 | 30th Street MP | ||
31 | 31 | 30 | {"type": "MultiPolygon", "coordinates": [[[[-117.03192, 32.71435], [-117.03192, 32.71458], [-117.02892, 32.7154], [-117.02858, 32.71552], [-117.02823, 32.71566], [-117.02786, 32.71584], [-117.02757, 32.71601], [-117.02701, 32.71574], [-117.02692, 32.71561], [-117.02817, 32.71536], [-117.02875, 32.71491], [-117.02926, 32.71481], [-117.03019, 32.71466], [-117.03192, 32.71435]]], [[[-117.03286, 32.71467], [-117.03255, 32.71474], [-117.03254, 32.71477], [-117.03239, 32.7148], [-117.03224, 32.71491], [-117.0321, 32.71434], [-117.03243, 32.71411], [-117.03254, 32.71383], [-117.03262, 32.71402], [-117.03272, 32.71416], [-117.03286, 32.71467]]], [[[-117.03416, 32.71343], [-117.03405, 32.71351], [-117.03386, 32.71331], [-117.03402, 32.71328], [-117.03416, 32.71343]]], [[[-117.03542, 32.71289], [-117.0353, 32.71299], [-117.03508, 32.71277], [-117.03473, 32.71302], [-117.03502, 32.71334], [-117.03493, 32.71345], [-117.03468, 32.71321], [-117.03456, 32.71329], [-117.03416, 32.71289], [-117.03419, 32.71288], [-117.03436, 32.71291], [-117.03453, 32.71287], [-117.03461, 32.71283], [-117.03502, 32.71249], [-117.03542, 32.71289]]], [[[-117.03463, 32.71357], [-117.03444, 32.71372], [-117.03423, 32.7135], [-117.03434, 32.71342], [-117.03442, 32.7135], [-117.03451, 32.71346], [-117.03463, 32.71357]]], [[[-117.03603, 32.71207], [-117.03547, 32.71248], [-117.03575, 32.71277], [-117.03561, 32.71286], [-117.03513, 32.71239], [-117.03524, 32.71228], [-117.03533, 32.71214], [-117.03537, 32.71202], [-117.03539, 32.71184], [-117.03603, 32.71207]]], [[[-117.03787, 32.71075], [-117.03723, 32.71121], [-117.03724, 32.71202], [-117.03697, 32.71164], [-117.03695, 32.71077], [-117.03787, 32.71075]]], [[[-117.03705, 32.7123], [-117.03703, 32.71236], [-117.03698, 32.71239], [-117.03697, 32.71218], [-117.03705, 32.7123]]], [[[-117.04564, 32.70908], [-117.04562, 32.70918], [-117.04555, 32.70927], [-117.04513, 32.70952], [-117.04496, 32.70958], [-117.04459, 32.70965], [-117.04441, 32.7097], [-117.0444, 32.70968], [-117.04564, 32.70908]]], [[[-117.0479, 32.70912], [-117.04758, 32.70951], [-117.0474, 32.70956], [-117.04722, 32.70953], [-117.04686, 32.70934], [-117.04672, 32.70943], [-117.04668, 32.70957], [-117.04644, 32.70957], [-117.04643, 32.70939], [-117.04624, 32.70932], [-117.04611, 32.70922], [-117.04603, 32.70907], [-117.04601, 32.70889], [-117.04591, 32.70885], [-117.04579, 32.70887], [-117.0457, 32.70892], [-117.04564, 32.70901], [-117.04564, 32.70868], [-117.04716, 32.70856], [-117.04765, 32.70903], [-117.04772, 32.70903], [-117.0479, 32.70912]]], [[[-117.04869, 32.70945], [-117.04868, 32.71023], [-117.04828, 32.71023], [-117.04827, 32.70945], [-117.04869, 32.70945]]]]} | Open Access 1 | Encanto Expressway Open Space | 18635 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 14.138 | Encanto Expressway OS | ||
42 | 42 | 41 | {"type": "MultiPolygon", "coordinates": [[[[-117.08618, 32.78287], [-117.08622, 32.78293], [-117.08624, 32.78303], [-117.08622, 32.78311], [-117.08617, 32.7832], [-117.08531, 32.78378], [-117.08524, 32.78389], [-117.0852, 32.78402], [-117.08519, 32.78416], [-117.08523, 32.78429], [-117.08533, 32.78443], [-117.08553, 32.78456], [-117.0856, 32.78469], [-117.08463, 32.78553], [-117.08436, 32.78592], [-117.0838, 32.78593], [-117.08272, 32.78658], [-117.08188, 32.7879], [-117.08286, 32.78773], [-117.08044, 32.79012], [-117.08043, 32.79016], [-117.08034, 32.79009], [-117.08057, 32.78985], [-117.0793, 32.78893], [-117.07776, 32.79006], [-117.07763, 32.79017], [-117.07667, 32.79085], [-117.07584, 32.79148], [-117.07542, 32.79293], [-117.07593, 32.79393], [-117.07626, 32.79416], [-117.07659, 32.79381], [-117.0766, 32.79377], [-117.07671, 32.79385], [-117.07667, 32.79385], [-117.07664, 32.79387], [-117.07561, 32.79498], [-117.07591, 32.79563], [-117.07546, 32.79607], [-117.07495, 32.79571], [-117.0747, 32.79596], [-117.07404, 32.79548], [-117.07362, 32.79414], [-117.07449, 32.79342], [-117.07448, 32.79296], [-117.07389, 32.79245], [-117.07286, 32.79331], [-117.06841, 32.79401], [-117.06839, 32.79409], [-117.06843, 32.79426], [-117.06836, 32.7943], [-117.06808, 32.79402], [-117.06769, 32.79358], [-117.0676, 32.79345], [-117.0676, 32.79336], [-117.06773, 32.79353], [-117.06781, 32.79355], [-117.06852, 32.79334], [-117.06922, 32.79322], [-117.07092, 32.79298], [-117.07154, 32.79284], [-117.07175, 32.79276], [-117.07203, 32.79268], [-117.07252, 32.79249], [-117.07267, 32.79241], [-117.07272, 32.79241], [-117.07334, 32.79207], [-117.07408, 32.79157], [-117.0754, 32.79057], [-117.07323, 32.78843], [-117.07149, 32.78856], [-117.07143, 32.7885], [-117.07022, 32.78771], [-117.06892, 32.78716], [-117.0687, 32.78701], [-117.06765, 32.78579], [-117.06757, 32.78526], [-117.06807, 32.78473], [-117.06822, 32.78539], [-117.06985, 32.78614], [-117.07023, 32.7864], [-117.07028, 32.78636], [-117.07052, 32.78646], [-117.07051, 32.78654], [-117.07139, 32.78694], [-117.07187, 32.78714], [-117.07191, 32.78709], [-117.07267, 32.78742], [-117.07402, 32.78704], [-117.07404, 32.78702], [-117.07405, 32.78729], [-117.07496, 32.78863], [-117.07732, 32.78821], [-117.07817, 32.78757], [-117.07746, 32.78677], [-117.07421, 32.78551], [-117.07432, 32.78501], [-117.07451, 32.78473], [-117.07458, 32.78465], [-117.07655, 32.78524], [-117.07826, 32.78523], [-117.07841, 32.78539], [-117.07853, 32.78555], [-117.07906, 32.78608], [-117.07925, 32.78623], [-117.07969, 32.78654], [-117.08013, 32.78577], [-117.08138, 32.78469], [-117.08369, 32.78401], [-117.08345, 32.78298], [-117.08294, 32.78299], [-117.08288, 32.78279], [-117.08293, 32.78263], [-117.08618, 32.78287]]], [[[-117.08637, 32.78311], [-117.08635, 32.78329], [-117.08602, 32.78376], [-117.08606, 32.7838], [-117.08569, 32.78433], [-117.08555, 32.78436], [-117.0855, 32.78433], [-117.08544, 32.78428], [-117.08538, 32.78415], [-117.08537, 32.78403], [-117.08542, 32.7839], [-117.08551, 32.78382], [-117.0856, 32.78377], [-117.08621, 32.78334], [-117.08632, 32.78321], [-117.08637, 32.78311]]]]} | Open Access 1 | Navajo Canyon Open Space Park | 22675 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 155.928 | Navajo Canyon OS Park | ||
44 | 44 | 43 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73848], [-117.09279, 32.73755], [-117.09338, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.09361, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09322, 32.73912], [-117.09324, 32.74036], [-117.09385, 32.74037], [-117.09387, 32.74117], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | Open Access 1 | 47th Street Canyon | 15202 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 10.029 | 47th Street Canyon |
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]);