units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
363 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 2 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, YR_EST
MNG_AGENCY >30
- Los Angeles, City of 20
- Whittier, City of 20
- San Ramon, City of 15
- San Diego, City of 10
- Long Beach, City of 9
- Arcadia, City of 8
- Manhattan Beach, City of 8
- Santa Cruz, City of 7
- Modesto, City of 7
- San Jose, City of 6
- Carlsbad, City of 6
- Hollister, City of 6
- Pasadena, City of 6
- Santa Ana, City of 5
- Fullerton, City of 5
- Vacaville, City of 5
- San Bernardino, City of 5
- Beverly Hills, City of 5
- Lawndale, City of 5
- San Gabriel, City of 5
- Glendora, City of 4
- El Segundo, City of 4
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- South El Monte, City of 4
- Watsonville, City of 3
- San Luis Obispo, City of 3
- Oceanside, City of 3
- Pomona, City of 3
- …
DES_TP >30
- Local Recreation Area 168
- Local Park 151
- Local Conservation Area 10
- Local Other or Unknown 6
- Local Historic or Cultural Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 1
- City Agency · 363 ✖
ACCESS_TYP 1
- Restricted Access · 363 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
280 | 280 | 279 | {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} | Restricted Access 2 | 956 | South Monterey Dunes | 25664 | 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.07 | South Monterey Dunes | None 30 | |||
2159 | 2159 | 2158 | {"type": "Polygon", "coordinates": [[[-122.5122, 37.93636], [-122.50745, 37.93685], [-122.50733, 37.93585], [-122.50733, 37.93514], [-122.50753, 37.93394], [-122.50773, 37.93298], [-122.50798, 37.93199], [-122.50819, 37.9308], [-122.50832, 37.93034], [-122.50839, 37.92998], [-122.50843, 37.92956], [-122.50862, 37.92877], [-122.50865, 37.92853], [-122.50876, 37.92835], [-122.50901, 37.92814], [-122.50954, 37.92788], [-122.50987, 37.92778], [-122.5106, 37.92744], [-122.51067, 37.9274], [-122.51066, 37.9273], [-122.51068, 37.92728], [-122.51062, 37.9269], [-122.51051, 37.92633], [-122.51056, 37.9263], [-122.51068, 37.92631], [-122.51084, 37.92759], [-122.51106, 37.9289], [-122.5122, 37.93636]]]} | Restricted Access 2 | 16168 | Muzzi Marsh | 22617 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 77.169 | Muzzi Marsh | None 177 | |||
2219 | 2219 | 2218 | {"type": "MultiPolygon", "coordinates": [[[[-122.53623, 38.01398], [-122.53597, 38.01397], [-122.53407, 38.01539], [-122.53406, 38.01497], [-122.53397, 38.01496], [-122.53397, 38.01473], [-122.5334, 38.01505], [-122.53336, 38.0164], [-122.5328, 38.0164], [-122.53257, 38.01637], [-122.53171, 38.0164], [-122.53089, 38.01638], [-122.53055, 38.01646], [-122.53322, 38.01055], [-122.53338, 38.01089], [-122.53304, 38.01129], [-122.53413, 38.01286], [-122.53623, 38.01398]]], [[[-122.53425, 38.01729], [-122.53416, 38.01705], [-122.53412, 38.01637], [-122.53424, 38.01636], [-122.53425, 38.01729]]]]} | Restricted Access 2 | 16569 | Gallinas Creek Marsh Restoration | 19179 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 31.196 | Gallinas Creek Marsh Restoration | None 182 | |||
3324 | 3324 | 3323 | {"type": "Polygon", "coordinates": [[[-122.27889, 38.17188], [-122.27858, 38.17195], [-122.27857, 38.17572], [-122.27872, 38.17877], [-122.27823, 38.18104], [-122.27177, 38.1811], [-122.27109, 38.17691], [-122.27079, 38.17569], [-122.27055, 38.1742], [-122.27069, 38.17415], [-122.27064, 38.17387], [-122.27063, 38.17387], [-122.27051, 38.17391], [-122.27043, 38.17342], [-122.26936, 38.17213], [-122.26887, 38.17121], [-122.26869, 38.17053], [-122.26892, 38.16862], [-122.26885, 38.16712], [-122.26865, 38.16622], [-122.2668, 38.16148], [-122.27865, 38.16144], [-122.27884, 38.17091], [-122.27889, 38.17188]], [[-122.27213, 38.16617], [-122.27245, 38.16694], [-122.27835, 38.16698], [-122.27832, 38.16431], [-122.27137, 38.16431], [-122.26809, 38.16423], [-122.26881, 38.16606], [-122.27213, 38.16617]]]} | Restricted Access 2 | 23605 | American Canyon/Fish and Game | 15450 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 375.475 | American Canyon/Fish and Game | 0 | None 271 | ||
3448 | 3448 | 3447 | {"type": "Polygon", "coordinates": [[[-122.37728, 37.8995], [-122.37687, 37.90346], [-122.35981, 37.90125], [-122.3598, 37.90126], [-122.35981, 37.9018], [-122.35775, 37.90181], [-122.35773, 37.90092], [-122.35788, 37.90109], [-122.35803, 37.90098], [-122.35781, 37.9007], [-122.3576, 37.90062], [-122.3574, 37.8997], [-122.3572, 37.89911], [-122.35737, 37.89887], [-122.35772, 37.89812], [-122.35749, 37.89767], [-122.35716, 37.89727], [-122.35737, 37.89693], [-122.35721, 37.89654], [-122.3575, 37.89591], [-122.35742, 37.89558], [-122.35717, 37.89509], [-122.35687, 37.8949], [-122.3566, 37.89494], [-122.3563, 37.89461], [-122.35471, 37.89435], [-122.35458, 37.89471], [-122.35306, 37.89475], [-122.35246, 37.8945], [-122.35191, 37.89435], [-122.3514, 37.89407], [-122.35136, 37.8937], [-122.35107, 37.89356], [-122.35082, 37.89383], [-122.35146, 37.89463], [-122.35148, 37.89464], [-122.35174, 37.89554], [-122.352, 37.89603], [-122.35227, 37.89631], [-122.35261, 37.89649], [-122.35277, 37.8969], [-122.35282, 37.89693], [-122.35286, 37.89882], [-122.34909, 37.89467], [-122.34902, 37.8918], [-122.35677, 37.89326], [-122.35962, 37.89378], [-122.35969, 37.89617], [-122.37728, 37.8995]]]} | Restricted Access 2 | 25298 | Brooks Island | 16426 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 289.362 | Brooks Island | None 282 | |||
3449 | 3449 | 3448 | {"type": "Polygon", "coordinates": [[[-122.10288, 37.98676], [-122.10284, 37.98741], [-122.0973, 37.9875], [-122.09724, 37.98631], [-122.09749, 37.98606], [-122.09779, 37.98587], [-122.0981, 37.98575], [-122.09846, 37.98558], [-122.09872, 37.98543], [-122.09892, 37.98521], [-122.09945, 37.98532], [-122.10123, 37.98528], [-122.10169, 37.98536], [-122.10203, 37.98589], [-122.10241, 37.98638], [-122.1027, 37.98663], [-122.10288, 37.98676]]]} | Restricted Access 2 | 25304 | Martinez | 21925 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 24.888 | Martinez | None 283 | |||
4165 | 4165 | 4164 | {"type": "Polygon", "coordinates": [[[-121.94848, 37.74904], [-121.94621, 37.74996], [-121.94536, 37.74865], [-121.94551, 37.7483], [-121.94569, 37.74815], [-121.94589, 37.7481], [-121.94621, 37.74811], [-121.94644, 37.7482], [-121.9468, 37.74876], [-121.94796, 37.74823], [-121.94848, 37.74904]]]} | Restricted Access 2 | 47573 | California High School Tennis Courts and Track | 31298 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 7.772 | California High School Tennis Courts and Track | None 360 | |||
4166 | 4166 | 4165 | {"type": "Polygon", "coordinates": [[[-121.07771, 39.22081], [-121.07676, 39.22153], [-121.07673, 39.22149], [-121.07655, 39.22152], [-121.07648, 39.22148], [-121.07549, 39.22233], [-121.07527, 39.22221], [-121.07499, 39.22212], [-121.07443, 39.22199], [-121.07444, 39.22102], [-121.07552, 39.22103], [-121.07557, 39.22092], [-121.07556, 39.22075], [-121.07569, 39.22072], [-121.07668, 39.22003], [-121.07771, 39.22081]]]} | Restricted Access 2 | 48291 | Margaret G Scotten School Ballfields | 32866 | 2429 | Grass Valley School District 728 | Special District 4 | School District 14 | www.gvsd.us | Special District 4 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 8.566 | Margaret G Scotten School Ballfields | 2018 | None 361 | ||
7105 | 7105 | 7104 | {"type": "Polygon", "coordinates": [[[-118.40261, 33.92509], [-118.40215, 33.92509], [-118.40215, 33.92477], [-118.40261, 33.92477], [-118.40261, 33.92509]]]} | Restricted Access 2 | 6158 | Camp Eucalyptus | 29706 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 0.378 | Camp Eucalyptus | None 581 | |||
7202 | 7202 | 7201 | {"type": "MultiPolygon", "coordinates": [[[[-122.08675, 37.42707], [-122.08665, 37.42777], [-122.0866, 37.42777], [-122.08652, 37.42829], [-122.08642, 37.42853], [-122.08634, 37.42879], [-122.08634, 37.4303], [-122.08631, 37.4319], [-122.08627, 37.43212], [-122.08618, 37.43232], [-122.07998, 37.43227], [-122.07998, 37.43132], [-122.07863, 37.43129], [-122.07818, 37.43017], [-122.07811, 37.42836], [-122.0782, 37.42835], [-122.07825, 37.42808], [-122.07871, 37.42822], [-122.07869, 37.42827], [-122.0787, 37.42828], [-122.07905, 37.42837], [-122.07918, 37.42839], [-122.07931, 37.42835], [-122.07941, 37.42831], [-122.07951, 37.42824], [-122.0796, 37.42813], [-122.0797, 37.42809], [-122.08017, 37.42808], [-122.08018, 37.42802], [-122.08101, 37.42802], [-122.08132, 37.42798], [-122.08163, 37.4279], [-122.08192, 37.42776], [-122.08196, 37.4278], [-122.08199, 37.42778], [-122.08212, 37.42768], [-122.08222, 37.42756], [-122.0823, 37.42743], [-122.08236, 37.42729], [-122.08235, 37.42727], [-122.0823, 37.42726], [-122.08232, 37.42705], [-122.08231, 37.42687], [-122.08227, 37.42669], [-122.08222, 37.42655], [-122.08214, 37.42641], [-122.08206, 37.4263], [-122.08198, 37.42634], [-122.0819, 37.4262], [-122.08171, 37.42594], [-122.0814, 37.42575], [-122.08137, 37.42576], [-122.08116, 37.42567], [-122.08118, 37.42556], [-122.08056, 37.42392], [-122.08052, 37.42331], [-122.08252, 37.42314], [-122.08323, 37.42312], [-122.08368, 37.42312], [-122.08438, 37.42316], [-122.08484, 37.42321], [-122.08644, 37.42349], [-122.08643, 37.4251], [-122.08648, 37.42532], [-122.08658, 37.42552], [-122.08658, 37.42554], [-122.08664, 37.42566], [-122.08667, 37.42578], [-122.08672, 37.42643], [-122.08671, 37.42644], [-122.08675, 37.42707]], [[-122.08565, 37.42951], [-122.08582, 37.42933], [-122.08576, 37.42914], [-122.0844, 37.4291], [-122.08442, 37.4296], [-122.08422, 37.42967], [-122.08298, 37.42981], [-122.08175, 37.43038], [-122.08106, 37.43059], [-122.08118, 37.43081], [-122.08189, 37.43067], [-122.08301, 37.43019], [-122.08385, 37.43006], [-122.08567, 37.42997], [-122.08565, 37.42951]]], [[[-122.09679, 37.43194], [-122.09677, 37.43202], [-122.09523, 37.43188], [-122.09523, 37.4321], [-122.09529, 37.43234], [-122.09543, 37.43261], [-122.0956, 37.43281], [-122.09581, 37.43298], [-122.09607, 37.43312], [-122.09633, 37.4332], [-122.09662, 37.43324], [-122.09647, 37.43436], [-122.09557, 37.43461], [-122.09481, 37.43405], [-122.09451, 37.43353], [-122.09493, 37.43321], [-122.09492, 37.43296], [-122.09465, 37.43263], [-122.09358, 37.43242], [-122.09288, 37.43266], [-122.09258, 37.43252], [-122.08673, 37.43233], [-122.08677, 37.43221], [-122.0868, 37.43188], [-122.08683, 37.42881], [-122.08695, 37.42803], [-122.08691, 37.428], [-122.087, 37.42744], [-122.08702, 37.42715], [-122.08701, 37.42662], [-122.08698, 37.42661], [-122.08698, 37.42595], [-122.08709, 37.42469], [-122.09056, 37.42473], [-122.09126, 37.42477], [-122.09197, 37.42493], [-122.09235, 37.42504], [-122.09272, 37.42518], [-122.09314, 37.42536], [-122.09353, 37.42559], [-122.09379, 37.42577], [-122.09422, 37.42612], [-122.09449, 37.4264], [-122.0947, 37.42666], [-122.09497, 37.42707], [-122.09512, 37.42725], [-122.09526, 37.42758], [-122.09537, 37.42794], [-122.09543, 37.4283], [-122.09545, 37.42873], [-122.09524, 37.43178], [-122.09679, 37.43194]], [[-122.09321, 37.42862], [-122.09353, 37.4287], [-122.09364, 37.42845], [-122.09299, 37.42828], [-122.09295, 37.4287], [-122.09319, 37.42876], [-122.09324, 37.42867], [-122.09321, 37.42862]], [[-122.09427, 37.42776], [-122.09428, 37.42775], [-122.09427, 37.42758], [-122.09406, 37.42767], [-122.09427, 37.42776]]]]} | Restricted Access 2 | 48420 | Shoreline Golf Links | 33080 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | https://www.shorelinelinks.com/ | Santa Clara 19 | 289.243 | Shoreline Golf Links | 1986 | None 590 | |
7285 | 7285 | 7284 | {"type": "MultiPolygon", "coordinates": [[[[-117.95983, 35.12231], [-117.95872, 35.12232], [-117.95655, 35.12177], [-117.95527, 35.12204], [-117.95512, 35.12207], [-117.95498, 35.12215], [-117.95463, 35.12234], [-117.95354, 35.12419], [-117.95339, 35.12518], [-117.95338, 35.1258], [-117.95164, 35.1258], [-117.95164, 35.12565], [-117.95169, 35.12544], [-117.95179, 35.12528], [-117.9519, 35.12516], [-117.95197, 35.12482], [-117.95181, 35.12444], [-117.95159, 35.12419], [-117.95055, 35.12353], [-117.94994, 35.12329], [-117.94971, 35.12316], [-117.94946, 35.12327], [-117.9491, 35.12355], [-117.94868, 35.12484], [-117.94847, 35.12535], [-117.94855, 35.12537], [-117.9485, 35.12583], [-117.94503, 35.12583], [-117.94502, 35.12557], [-117.94396, 35.12425], [-117.94403, 35.1234], [-117.94411, 35.123], [-117.94433, 35.12284], [-117.94497, 35.12324], [-117.94504, 35.12411], [-117.94539, 35.12444], [-117.94632, 35.12517], [-117.94734, 35.12559], [-117.94786, 35.12477], [-117.9487, 35.12354], [-117.9479, 35.12314], [-117.94735, 35.12303], [-117.94684, 35.12276], [-117.94475, 35.12249], [-117.94453, 35.12244], [-117.94455, 35.12223], [-117.94535, 35.12216], [-117.94711, 35.12197], [-117.94786, 35.12211], [-117.94949, 35.12295], [-117.94995, 35.12287], [-117.95071, 35.12241], [-117.95112, 35.12266], [-117.95203, 35.12267], [-117.95237, 35.12257], [-117.95337, 35.12203], [-117.95359, 35.12186], [-117.95369, 35.12163], [-117.95483, 35.12057], [-117.95504, 35.12008], [-117.95513, 35.11981], [-117.95503, 35.1193], [-117.95497, 35.11906], [-117.9549, 35.11863], [-117.95736, 35.11868], [-117.9566, 35.11915], [-117.9566, 35.11917], [-117.95706, 35.11977], [-117.95796, 35.12056], [-117.95832, 35.12077], [-117.95915, 35.12101], [-117.95961, 35.12121], [-117.95983, 35.12121], [-117.95983, 35.12231]]], [[[-117.96166, 35.13066], [-117.96126, 35.13091], [-117.96113, 35.13092], [-117.96104, 35.1309], [-117.96099, 35.13085], [-117.96056, 35.1304], [-117.95966, 35.13056], [-117.95925, 35.13016], [-117.95911, 35.12989], [-117.95782, 35.13009], [-117.9568, 35.13035], [-117.95606, 35.13048], [-117.95568, 35.13035], [-117.95516, 35.13034], [-117.95499, 35.13029], [-117.95449, 35.12986], [-117.95416, 35.12994], [-117.95384, 35.13031], [-117.95311, 35.1307], [-117.95258, 35.13121], [-117.95206, 35.13153], [-117.95173, 35.1316], [-117.95015, 35.13225], [-117.95013, 35.13111], [-117.95031, 35.13108], [-117.95081, 35.13083], [-117.95114, 35.13003], [-117.95113, 35.13003], [-117.95094, 35.13012], [-117.95063, 35.13023], [-117.95045, 35.13028], [-117.95022, 35.13031], [-117.95015, 35.13031], [-117.95013, 35.13014], [-117.95051, 35.13009], [-117.95062, 35.13004], [-117.9507, 35.13003], [-117.95097, 35.12992], [-117.95126, 35.12971], [-117.95141, 35.12956], [-117.95159, 35.12926], [-117.95161, 35.12918], [-117.95165, 35.12888], [-117.95164, 35.12853], [-117.95162, 35.12612], [-117.95344, 35.12612], [-117.95338, 35.12702], [-117.95347, 35.12749], [-117.95333, 35.12797], [-117.95298, 35.12825], [-117.95271, 35.1286], [-117.95263, 35.12887], [-117.95264, 35.1292], [-117.95373, 35.12922], [-117.95375, 35.12895], [-117.95428, 35.12885], [-117.95586, 35.12844], [-117.95667, 35.12839], [-117.95727, 35.12848], [-117.95813, 35.12838], [-117.95863, 35.12857], [-117.95895, 35.12859], [-117.96003, 35.12813], [-117.96003, 35.12819], [-117.96011, 35.12839], [-117.9602, 35.12869], [-117.96041, 35.12912], [-117.96055, 35.12933], [-117.96083, 35.12974], [-117.96166, 35.13066]]], [[[-117.94984, 35.13219], [-117.94919, 35.13247], [-117.9489, 35.13268], [-117.94835, 35.13286], [-117.9477, 35.13328], [-117.94715, 35.13328], [-117.94714, 35.13315], [-117.94567, 35.13316], [-117.94564, 35.13299], [-117.94471, 35.1329], [-117.94471, 35.13281], [-117.94476, 35.1327], [-117.94508, 35.1326], [-117.94504, 35.13243], [-117.94452, 35.1326], [-117.94441, 35.1326], [-117.94434, 35.13254], [-117.94422, 35.13229], [-117.94412, 35.13222], [-117.94339, 35.13198], [-117.94354, 35.13187], [-117.94361, 35.13168], [-117.94357, 35.13137], [-117.9434, 35.13101], [-117.94349, 35.13096], [-117.94351, 35.13092], [-117.94313, 35.13091], [-117.94315, 35.13046], [-117.9433, 35.13045], [-117.94332, 35.12993], [-117.94288, 35.12992], [-117.94286, 35.13016], [-117.94264, 35.13015], [-117.94268, 35.12929], [-117.94233, 35.12925], [-117.9423, 35.12918], [-117.94098, 35.12914], [-117.94092, 35.12908], [-117.94111, 35.12885], [-117.94107, 35.12882], [-117.94141, 35.12892], [-117.94214, 35.12881], [-117.94255, 35.12865], [-117.94255, 35.1284], [-117.94247, 35.12833], [-117.94236, 35.12785], [-117.94267, 35.1275], [-117.94311, 35.12732], [-117.94325, 35.12741], [-117.94311, 35.12771], [-117.94311, 35.12798], [-117.94339, 35.12807], [-117.94384, 35.12803], [-117.94422, 35.12792], [-117.94423, 35.12764], [-117.94412, 35.12743], [-117.94501, 35.12737], [-117.94523, 35.12746], [-117.94523, 35.12762], [-117.94495, 35.12785], [-117.9449, 35.1283], [-117.94442, 35.12849], [-117.94344, 35.12858], [-117.94331, 35.12869], [-117.94334, 35.12915], [-117.94311, 35.12929], [-117.94311, 35.12953], [-117.94375, 35.12968], [-117.94381, 35.12986], [-117.9437, 35.13002], [-117.9437, 35.1302], [-117.94384, 35.13032], [-117.94437, 35.13043], [-117.9447, 35.13062], [-117.94537, 35.13076], [-117.94551, 35.13094], [-117.94554, 35.13227], [-117.94545, 35.1323], [-117.94545, 35.13232], [-117.94558, 35.13232], [-117.94562, 35.13073], [-117.94666, 35.13073], [-117.94667, 35.13027], [-117.9477, 35.13027], [-117.94772, 35.13113], [-117.9478, 35.13123], [-117.9479, 35.13128], [-117.94815, 35.1313], [-117.94902, 35.13129], [-117.94923, 35.13128], [-117.94932, 35.13125], [-117.9494, 35.13119], [-117.94944, 35.13111], [-117.94945, 35.13026], [-117.94981, 35.13026], [-117.94971, 35.13033], [-117.94965, 35.13041], [-117.94966, 35.13116], [-117.94981, 35.13116], [-117.94984, 35.13219]]]]} | Restricted Access 2 | 48425 | Tierra Del Sol Golf | 33049 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 178.11 | Tierra Del Sol Golf | 0 | None 602 | ||
9458 | 9458 | 9457 | {"type": "Polygon", "coordinates": [[[-121.91787, 37.70301], [-121.91749, 37.7032], [-121.91745, 37.7035], [-121.91675, 37.70379], [-121.91628, 37.70412], [-121.91617, 37.70434], [-121.9134, 37.70372], [-121.91278, 37.70359], [-121.91207, 37.70363], [-121.91182, 37.70216], [-121.91671, 37.7022], [-121.91696, 37.70262], [-121.91755, 37.70242], [-121.91787, 37.70301]]]} | Restricted Access 2 | 15814 | Dublin Sports Grounds | 18293 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 22.454 | Dublin Sports Grounds | 1989 | None 781 | ||
9493 | 9493 | 9492 | {"type": "MultiPolygon", "coordinates": [[[[-117.94979, 35.1278], [-117.94897, 35.12779], [-117.9487, 35.12788], [-117.94845, 35.1281], [-117.94846, 35.13001], [-117.94782, 35.13002], [-117.94782, 35.12984], [-117.94781, 35.12855], [-117.94753, 35.12829], [-117.94728, 35.12823], [-117.94692, 35.12838], [-117.94679, 35.12855], [-117.94677, 35.12887], [-117.94677, 35.13003], [-117.94655, 35.13003], [-117.94636, 35.12998], [-117.94627, 35.12999], [-117.9462, 35.13003], [-117.94617, 35.13008], [-117.94615, 35.13018], [-117.94619, 35.13027], [-117.94625, 35.13031], [-117.94634, 35.13033], [-117.94653, 35.13028], [-117.94667, 35.13027], [-117.94667, 35.13073], [-117.94562, 35.13074], [-117.94558, 35.13233], [-117.94541, 35.13232], [-117.94554, 35.13226], [-117.94551, 35.13094], [-117.94537, 35.13076], [-117.9447, 35.13062], [-117.94437, 35.13043], [-117.94384, 35.13032], [-117.9437, 35.1302], [-117.9437, 35.13002], [-117.94381, 35.12986], [-117.94375, 35.12968], [-117.94311, 35.12954], [-117.94311, 35.12929], [-117.94334, 35.12915], [-117.94331, 35.12869], [-117.94345, 35.12858], [-117.94442, 35.12849], [-117.94489, 35.12831], [-117.94495, 35.12785], [-117.94523, 35.12762], [-117.94523, 35.12745], [-117.94501, 35.12737], [-117.94413, 35.12743], [-117.94412, 35.12745], [-117.94423, 35.12764], [-117.94423, 35.12791], [-117.94384, 35.12803], [-117.94339, 35.12807], [-117.94311, 35.12798], [-117.94311, 35.12771], [-117.94325, 35.12741], [-117.94311, 35.12732], [-117.94267, 35.1275], [-117.94236, 35.12785], [-117.94247, 35.12833], [-117.94255, 35.1284], [-117.94255, 35.12865], [-117.94214, 35.12881], [-117.94141, 35.12892], [-117.94102, 35.12879], [-117.94103, 35.12755], [-117.94109, 35.12739], [-117.9412, 35.12699], [-117.94123, 35.12672], [-117.94124, 35.12613], [-117.94977, 35.12613], [-117.94979, 35.1278]]], [[[-117.94286, 35.13016], [-117.94286, 35.13018], [-117.94264, 35.13018], [-117.94264, 35.13015], [-117.94286, 35.13016]]], [[[-117.94567, 35.13316], [-117.94481, 35.1331], [-117.94404, 35.133], [-117.94334, 35.13283], [-117.94307, 35.13275], [-117.94334, 35.13215], [-117.94332, 35.13203], [-117.94339, 35.13198], [-117.94412, 35.13222], [-117.94422, 35.13229], [-117.94434, 35.13254], [-117.94441, 35.1326], [-117.94452, 35.1326], [-117.94504, 35.13242], [-117.94508, 35.1326], [-117.94476, 35.1327], [-117.94471, 35.13281], [-117.94471, 35.1329], [-117.94564, 35.13299], [-117.94567, 35.13316]]], [[[-117.94352, 35.13092], [-117.94349, 35.13096], [-117.9434, 35.13101], [-117.94331, 35.13102], [-117.9432, 35.13099], [-117.94313, 35.13092], [-117.94352, 35.13092]]]]} | Restricted Access 2 | 15889 | California City Central Park/Tierra Del Sol Golf | 33388 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 67.723 | California City Central Park/Tierra Del Sol Golf | None 786 | |||
9610 | 9610 | 9609 | {"type": "Polygon", "coordinates": [[[-122.51578, 37.93447], [-122.51567, 37.93481], [-122.51546, 37.93574], [-122.51546, 37.9358], [-122.51567, 37.93605], [-122.51514, 37.93636], [-122.51465, 37.9367], [-122.5141, 37.93719], [-122.51372, 37.93759], [-122.51345, 37.93792], [-122.51322, 37.9383], [-122.5131, 37.93865], [-122.51297, 37.93799], [-122.51263, 37.93588], [-122.51159, 37.92886], [-122.51137, 37.92754], [-122.51163, 37.92751], [-122.51171, 37.92758], [-122.51164, 37.92782], [-122.51162, 37.92803], [-122.51163, 37.92814], [-122.51181, 37.9292], [-122.51206, 37.93053], [-122.51209, 37.93066], [-122.51219, 37.9309], [-122.51226, 37.93101], [-122.5124, 37.93117], [-122.51252, 37.93127], [-122.51279, 37.93144], [-122.51308, 37.93157], [-122.51341, 37.93165], [-122.51357, 37.93168], [-122.5139, 37.9317], [-122.51498, 37.93163], [-122.51524, 37.93167], [-122.51541, 37.93172], [-122.5155, 37.93177], [-122.51556, 37.93183], [-122.51559, 37.93191], [-122.51588, 37.93331], [-122.51589, 37.93378], [-122.51585, 37.93413], [-122.51578, 37.93447]]]} | Restricted Access 2 | 16166 | Shorebird Marsh | 25419 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 46.096 | Shorebird Marsh | None 816 | |||
10378 | 10378 | 10377 | {"type": "MultiPolygon", "coordinates": [[[[-121.92445, 36.62692], [-121.92367, 36.62794], [-121.92237, 36.62731], [-121.92247, 36.62704], [-121.91997, 36.62581], [-121.92003, 36.62571], [-121.91989, 36.62563], [-121.91971, 36.62549], [-121.91887, 36.62507], [-121.91881, 36.62498], [-121.91882, 36.62488], [-121.91886, 36.62482], [-121.91893, 36.62478], [-121.91901, 36.62475], [-121.9191, 36.62476], [-121.92302, 36.62586], [-121.92292, 36.62621], [-121.92316, 36.62628], [-121.9236, 36.62644], [-121.92382, 36.62655], [-121.9242, 36.62678], [-121.92445, 36.62692]]], [[[-121.92659, 36.62954], [-121.9265, 36.62993], [-121.92645, 36.62997], [-121.92639, 36.62997], [-121.92345, 36.62854], [-121.92375, 36.62815], [-121.92659, 36.62954]]], [[[-121.92669, 36.62885], [-121.92661, 36.62939], [-121.92384, 36.62803], [-121.92418, 36.6276], [-121.92669, 36.62885]]], [[[-121.93197, 36.6333], [-121.93172, 36.634], [-121.93169, 36.63404], [-121.93163, 36.63405], [-121.92913, 36.63361], [-121.92879, 36.6335], [-121.92834, 36.63329], [-121.92832, 36.63325], [-121.92832, 36.63321], [-121.92865, 36.63278], [-121.9287, 36.63263], [-121.92867, 36.63201], [-121.92861, 36.63176], [-121.92855, 36.63158], [-121.92845, 36.63137], [-121.92829, 36.63114], [-121.92812, 36.63094], [-121.9279, 36.63074], [-121.92752, 36.63049], [-121.92732, 36.63039], [-121.927, 36.63027], [-121.92672, 36.63013], [-121.92671, 36.63008], [-121.92678, 36.62964], [-121.92943, 36.63095], [-121.92971, 36.63106], [-121.92997, 36.63113], [-121.9294, 36.63268], [-121.93197, 36.6333]]], [[[-121.92934, 36.63016], [-121.92922, 36.63068], [-121.9268, 36.62949], [-121.92689, 36.62894], [-121.92934, 36.63016]]], [[[-121.9352, 36.63631], [-121.93508, 36.63686], [-121.93454, 36.63701], [-121.93434, 36.63703], [-121.93421, 36.63702], [-121.9341, 36.63698], [-121.93401, 36.63693], [-121.93388, 36.63682], [-121.93402, 36.63596], [-121.93434, 36.63622], [-121.9352, 36.63631]]]]} | Restricted Access 2 | 18334 | Pacific Grove Golf Links | 33064 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 42.199 | Pacific Grove Golf Links | None 907 | |||
10933 | 10933 | 10932 | {"type": "Polygon", "coordinates": [[[-121.64543, 38.58948], [-121.63841, 38.58953], [-121.63129, 38.58946], [-121.63131, 38.58253], [-121.63156, 38.58084], [-121.63183, 38.58003], [-121.63258, 38.57849], [-121.63329, 38.57731], [-121.63423, 38.5762], [-121.6349, 38.57544], [-121.63534, 38.57532], [-121.63556, 38.57529], [-121.63601, 38.57532], [-121.63644, 38.57548], [-121.63674, 38.57566], [-121.63742, 38.57615], [-121.63776, 38.57626], [-121.63805, 38.5764], [-121.63835, 38.57647], [-121.63858, 38.57649], [-121.63928, 38.57661], [-121.64007, 38.57663], [-121.64366, 38.57663], [-121.64405, 38.57668], [-121.64434, 38.57677], [-121.64464, 38.57694], [-121.64491, 38.57715], [-121.64512, 38.57745], [-121.64521, 38.57777], [-121.64497, 38.58825], [-121.64504, 38.5886], [-121.64513, 38.58894], [-121.64543, 38.58948]]]} | Restricted Access 2 | 20958 | Davis Wetland Demonstration | 17955 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 419.626 | Davis Wetland Demonstration | None 954 | |||
11086 | 11086 | 11085 | {"type": "MultiPolygon", "coordinates": [[[[-121.44086, 38.39459], [-121.43552, 38.39463], [-121.42709, 38.39468], [-121.422, 38.39493], [-121.41795, 38.39493], [-121.41795, 38.39458], [-121.42201, 38.39457], [-121.42708, 38.39433], [-121.43606, 38.39427], [-121.43607, 38.39461], [-121.43609, 38.39462], [-121.4361, 38.39461], [-121.43609, 38.39427], [-121.44035, 38.39424], [-121.44036, 38.39395], [-121.44032, 38.39394], [-121.44085, 38.39394], [-121.44086, 38.39459]]], [[[-121.43609, 38.40531], [-121.43598, 38.4086], [-121.43569, 38.4086], [-121.43577, 38.4059], [-121.43587, 38.40526], [-121.43609, 38.40531]]], [[[-121.44071, 38.4054], [-121.44048, 38.40543], [-121.43989, 38.4056], [-121.43949, 38.40567], [-121.43917, 38.40568], [-121.43887, 38.40567], [-121.43641, 38.40584], [-121.4362, 38.40594], [-121.43621, 38.40553], [-121.43635, 38.40551], [-121.43878, 38.40534], [-121.43941, 38.40533], [-121.43974, 38.40528], [-121.44034, 38.40511], [-121.44071, 38.40506], [-121.44071, 38.4054]]], [[[-121.44105, 38.38668], [-121.44097, 38.38669], [-121.44089, 38.38673], [-121.44083, 38.38679], [-121.44081, 38.38686], [-121.44084, 38.39374], [-121.44019, 38.39375], [-121.44016, 38.38659], [-121.44105, 38.38659], [-121.44105, 38.38668]]]]} | Restricted Access 2 | 21328 | CITY OF ELK GROVE | 17310 | 1097 | Elk Grove, City of 963 | City 2 | City Agency 2 | http://www.elkgrovecity.org/ | City 2 | 1097 | Elk Grove, City of 931 | City 2 | City Agency 2 | Sacramento 41 | 37.05 | CITY OF ELK GROVE | None 963 | |||
12582 | 12582 | 12581 | {"type": "Polygon", "coordinates": [[[-122.39817, 38.49063], [-122.39349, 38.49061], [-122.39329, 38.49416], [-122.38896, 38.49414], [-122.38885, 38.49057], [-122.38485, 38.49054], [-122.38486, 38.49056], [-122.385, 38.4906], [-122.38593, 38.49097], [-122.38622, 38.49115], [-122.38645, 38.49145], [-122.38643, 38.49174], [-122.38642, 38.49229], [-122.38561, 38.4925], [-122.38526, 38.49284], [-122.38477, 38.49305], [-122.38447, 38.49332], [-122.38392, 38.49411], [-122.38452, 38.49412], [-122.38418, 38.49454], [-122.38387, 38.49499], [-122.38382, 38.49523], [-122.3839, 38.49534], [-122.38423, 38.49601], [-122.38426, 38.49614], [-122.38446, 38.49674], [-122.38475, 38.49729], [-122.38508, 38.49782], [-122.38587, 38.49991], [-122.38609, 38.50018], [-122.38658, 38.50049], [-122.38738, 38.50054], [-122.38769, 38.50078], [-122.38783, 38.50099], [-122.3878, 38.50113], [-122.38782, 38.50119], [-122.38788, 38.50123], [-122.38865, 38.50227], [-122.38927, 38.50242], [-122.38984, 38.50245], [-122.39022, 38.50267], [-122.39069, 38.50347], [-122.39134, 38.50398], [-122.39197, 38.50411], [-122.39222, 38.50425], [-122.3933, 38.50458], [-122.39365, 38.50473], [-122.3943, 38.5053], [-122.39402, 38.50548], [-122.39373, 38.50545], [-122.39252, 38.50515], [-122.39219, 38.50588], [-122.39001, 38.50494], [-122.38879, 38.50423], [-122.38809, 38.50398], [-122.3877, 38.50405], [-122.38735, 38.50435], [-122.38707, 38.50457], [-122.3869, 38.50496], [-122.38659, 38.50479], [-122.38605, 38.50445], [-122.38604, 38.50426], [-122.38661, 38.50404], [-122.38686, 38.50381], [-122.38668, 38.50345], [-122.38637, 38.50304], [-122.38621, 38.50292], [-122.38514, 38.50246], [-122.38439, 38.50254], [-122.38404, 38.50252], [-122.3838, 38.50246], [-122.38367, 38.50194], [-122.38341, 38.50158], [-122.38275, 38.50137], [-122.38227, 38.50144], [-122.382, 38.50165], [-122.38133, 38.50228], [-122.38108, 38.50261], [-122.38068, 38.50275], [-122.38055, 38.50273], [-122.3804, 38.50261], [-122.38058, 38.50218], [-122.38123, 38.50133], [-122.38123, 38.50131], [-122.38063, 38.50133], [-122.37517, 38.50132], [-122.36512, 38.5081], [-122.3562, 38.50837], [-122.35386, 38.50839], [-122.35386, 38.50734], [-122.35357, 38.50656], [-122.35341, 38.50604], [-122.3535, 38.50475], [-122.35355, 38.50357], [-122.3537, 38.50281], [-122.35356, 38.50215], [-122.35268, 38.50113], [-122.34707, 38.50106], [-122.34706, 38.5009], [-122.34235, 38.50107], [-122.34246, 38.49735], [-122.34705, 38.49741], [-122.34713, 38.49374], [-122.34255, 38.49362], [-122.34252, 38.49261], [-122.34281, 38.49253], [-122.34319, 38.49226], [-122.34341, 38.49206], [-122.34359, 38.49192], [-122.34374, 38.49187], [-122.34404, 38.4918], [-122.34487, 38.49169], [-122.34541, 38.49165], [-122.34587, 38.49159], [-122.34614, 38.49154], [-122.34641, 38.49142], [-122.34664, 38.49126], [-122.34688, 38.49107], [-122.34709, 38.49082], [-122.34725, 38.49067], [-122.34739, 38.49063], [-122.34778, 38.49056], [-122.34849, 38.49048], [-122.34866, 38.49052], [-122.34905, 38.49075], [-122.34943, 38.49109], [-122.34953, 38.4912], [-122.34965, 38.49138], [-122.34984, 38.49177], [-122.34985, 38.49199], [-122.34972, 38.49268], [-122.3497, 38.4929], [-122.34967, 38.49309], [-122.34971, 38.49323], [-122.34991, 38.49354], [-122.35017, 38.49369], [-122.35018, 38.49368], [-122.34987, 38.49319], [-122.34986, 38.49301], [-122.34993, 38.49271], [-122.35003, 38.49211], [-122.35003, 38.49188], [-122.34999, 38.49168], [-122.34972, 38.49111], [-122.34955, 38.4909], [-122.34889, 38.49042], [-122.34888, 38.49025], [-122.34853, 38.49016], [-122.34775, 38.49014], [-122.34737, 38.4902], [-122.34693, 38.49041], [-122.34568, 38.49121], [-122.34513, 38.49128], [-122.34478, 38.491], [-122.34571, 38.49062], [-122.34603, 38.49032], [-122.34615, 38.49002], [-122.3465, 38.48959], [-122.34722, 38.48934], [-122.34899, 38.48903], [-122.34902, 38.48883], [-122.34915, 38.48868], [-122.34926, 38.4886], [-122.34989, 38.48841], [-122.35022, 38.48828], [-122.3506, 38.48819], [-122.35122, 38.48796], [-122.3516, 38.48785], [-122.35205, 38.48774], [-122.3529, 38.48759], [-122.35312, 38.48753], [-122.35329, 38.4874], [-122.35342, 38.48726], [-122.35351, 38.48703], [-122.35356, 38.48679], [-122.35364, 38.48656], [-122.35374, 38.48634], [-122.3538, 38.4861], [-122.3538, 38.48594], [-122.3539, 38.4858], [-122.35407, 38.48568], [-122.35435, 38.48552], [-122.35452, 38.48547], [-122.35517, 38.4852], [-122.35525, 38.48512], [-122.3553, 38.48459], [-122.35539, 38.48441], [-122.35546, 38.48421], [-122.35551, 38.48396], [-122.35555, 38.48346], [-122.35559, 38.4832], [-122.35571, 38.48301], [-122.35589, 38.48293], [-122.35648, 38.48288], [-122.35656, 38.48292], [-122.35686, 38.48317], [-122.35703, 38.48328], [-122.3573, 38.48333], [-122.35754, 38.48332], [-122.35782, 38.48323], [-122.35813, 38.48302], [-122.3587, 38.48252], [-122.35906, 38.48208], [-122.35947, 38.48167], [-122.36052, 38.4817], [-122.36082, 38.48183], [-122.36101, 38.48179], [-122.36116, 38.48178], [-122.36151, 38.4819], [-122.36166, 38.4819], [-122.36294, 38.48154], [-122.36335, 38.48162], [-122.36372, 38.48186], [-122.36444, 38.48175], [-122.36465, 38.48168], [-122.36499, 38.48146], [-122.3653, 38.48122], [-122.36562, 38.48106], [-122.36563, 38.48152], [-122.3663, 38.48119], [-122.36668, 38.48119], [-122.36817, 38.4816], [-122.36936, 38.48169], [-122.37008, 38.4816], [-122.37064, 38.48124], [-122.3709, 38.48068], [-122.37093, 38.47998], [-122.37108, 38.47975], [-122.3716, 38.47922], [-122.37163, 38.48028], [-122.37201, 38.48069], [-122.37306, 38.48094], [-122.37317, 38.4819], [-122.37282, 38.48225], [-122.37286, 38.4827], [-122.37323, 38.483], [-122.37943, 38.48583], [-122.38069, 38.48618], [-122.38092, 38.48655], [-122.38174, 38.48748], [-122.3818, 38.48776], [-122.38226, 38.48817], [-122.38299, 38.48859], [-122.38302, 38.48884], [-122.38255, 38.4892], [-122.38261, 38.48945], [-122.38351, 38.49016], [-122.38423, 38.49036], [-122.38414, 38.48696], [-122.38994, 38.48702], [-122.39667, 38.48705], [-122.39811, 38.48703], [-122.39817, 38.49063]], [[-122.36784, 38.49357], [-122.36758, 38.49291], [-122.36744, 38.49263], [-122.36752, 38.49165], [-122.36744, 38.49138], [-122.36709, 38.49094], [-122.36676, 38.49036], [-122.35629, 38.49029], [-122.35637, 38.49396], [-122.37223, 38.49404], [-122.37207, 38.49394], [-122.3714, 38.49371], [-122.36997, 38.49348], [-122.36784, 38.49357]]]} | Restricted Access 2 | 29127 | Lake Hennessey | 28933 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1973.435 | Lake Hennessey | 0 | None 1090 | ||
12760 | 12760 | 12759 | {"type": "Polygon", "coordinates": [[[-121.5371, 38.58568], [-121.53598, 38.58568], [-121.53599, 38.58453], [-121.53471, 38.58454], [-121.53471, 38.58397], [-121.5371, 38.58383], [-121.5371, 38.58568]]]} | Restricted Access 2 | 29861 | Westifield School Playsite | 31656 | 1376 | West Sacramento, City of 548 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 1376 | West Sacramento, City of 541 | City 2 | City Agency 2 | Yolo 33 | 6.689 | Westifield School Playsite | None 1117 | |||
14195 | 14195 | 14194 | {"type": "Polygon", "coordinates": [[[-118.54281, 34.25984], [-118.54023, 34.25984], [-118.5403, 34.2596], [-118.5404, 34.25932], [-118.54124, 34.2574], [-118.54174, 34.25744], [-118.54281, 34.25743], [-118.54281, 34.25984]]]} | Restricted Access 2 | 46859 | Northridge City Little League | 30336 | 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 | 12.794 | Northridge City Little League | None 1208 |
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]);