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
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 20
- Whittier, City of 20
- San Ramon, City of 12
- San Diego, City of 9
- Long Beach, City of 8
- 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
- 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
- Glendora, City of 3
- Oceanside, City of 3
- Pomona, City of 3
- Palmdale, City of 3
- …
DES_TP 29
MNG_AG_TYP 1
- City Agency · 343 ✖
ACCESS_TYP 1
- Restricted Access · 343 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
2265 | 2265 | 2264 | {"type": "Polygon", "coordinates": [[[-121.80532, 36.92238], [-121.80509, 36.92259], [-121.80524, 36.92344], [-121.80501, 36.92403], [-121.80178, 36.92397], [-121.80168, 36.92488], [-121.80174, 36.92521], [-121.80015, 36.92537], [-121.7999, 36.92535], [-121.79967, 36.92527], [-121.79939, 36.92508], [-121.79917, 36.92485], [-121.79886, 36.92448], [-121.79865, 36.92435], [-121.79847, 36.92427], [-121.79754, 36.92367], [-121.79741, 36.92355], [-121.79735, 36.9234], [-121.79737, 36.92325], [-121.79743, 36.92324], [-121.79754, 36.92291], [-121.79743, 36.92286], [-121.79796, 36.92185], [-121.79855, 36.9219], [-121.80194, 36.92234], [-121.80196, 36.92219], [-121.80529, 36.92225], [-121.80532, 36.92238]]]} | Restricted Access 2 | 16755 | Harkins Slough | 28150 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 43.338 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
2405 | 2405 | 2404 | {"type": "Polygon", "coordinates": [[[-118.40176, 34.26476], [-118.40163, 34.26535], [-118.40154, 34.26562], [-118.40143, 34.26588], [-118.40129, 34.26614], [-118.40113, 34.26638], [-118.40076, 34.26685], [-118.39988, 34.26605], [-118.39946, 34.26558], [-118.39897, 34.26483], [-118.39843, 34.26433], [-118.39782, 34.26399], [-118.39746, 34.26329], [-118.39631, 34.26249], [-118.3954, 34.26242], [-118.39351, 34.26158], [-118.39344, 34.2618], [-118.39335, 34.2618], [-118.39148, 34.26078], [-118.39103, 34.26066], [-118.39073, 34.26044], [-118.39031, 34.26113], [-118.38941, 34.26086], [-118.38925, 34.26121], [-118.38666, 34.26042], [-118.3866, 34.26035], [-118.38665, 34.259], [-118.38713, 34.25817], [-118.3865, 34.2579], [-118.38587, 34.25895], [-118.38448, 34.25843], [-118.38394, 34.2583], [-118.38325, 34.25843], [-118.38262, 34.25846], [-118.38042, 34.25817], [-118.37936, 34.25812], [-118.37816, 34.25822], [-118.37725, 34.25823], [-118.37614, 34.2584], [-118.37506, 34.25861], [-118.37403, 34.25861], [-118.37343, 34.25859], [-118.37384, 34.2578], [-118.37427, 34.25756], [-118.37765, 34.25587], [-118.37789, 34.25571], [-118.3781, 34.25552], [-118.37827, 34.25531], [-118.3784, 34.2551], [-118.38172, 34.25574], [-118.38181, 34.25558], [-118.38262, 34.25451], [-118.38266, 34.25435], [-118.38485, 34.25642], [-118.38492, 34.25637], [-118.39338, 34.25803], [-118.39555, 34.25899], [-118.39564, 34.25907], [-118.39587, 34.25891], [-118.39595, 34.25904], [-118.3961, 34.2592], [-118.39638, 34.25958], [-118.39669, 34.25992], [-118.40172, 34.26468], [-118.40173, 34.26475], [-118.40176, 34.26476]]]} | Restricted Access 2 | 45520 | Hansen Dam Golf Course | 28354 | 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 | http://golf.lacity.org/cdp_hansen.htm | Los Angeles 6 | 201.493 | Hansen Dam GC | 0 | Local Recreation Area 3 | 4 |
2504 | 2504 | 2503 | {"type": "Polygon", "coordinates": [[[-118.4665, 34.00437], [-118.46104, 34.00726], [-118.46085, 34.00737], [-118.46087, 34.00741], [-118.45724, 34.00933], [-118.45601, 34.00775], [-118.4616, 34.00479], [-118.46148, 34.00472], [-118.46244, 34.00421], [-118.46252, 34.00428], [-118.46267, 34.00422], [-118.46531, 34.00282], [-118.4665, 34.00437]]]} | Restricted Access 2 | 6334 | Penmar Golf Course | 33009 | 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 | 52.132 | Penmar GC | 0 | Local Recreation Area 3 | 4 | |
2551 | 2551 | 2550 | {"type": "Polygon", "coordinates": [[[-122.19184, 38.13515], [-122.19158, 38.13526], [-122.19131, 38.13478], [-122.19123, 38.13468], [-122.19099, 38.1342], [-122.19079, 38.13407], [-122.19041, 38.13416], [-122.1903, 38.13436], [-122.18981, 38.13471], [-122.18936, 38.13477], [-122.18846, 38.13375], [-122.18772, 38.13324], [-122.18704, 38.13336], [-122.18679, 38.13315], [-122.18649, 38.13293], [-122.18554, 38.13206], [-122.1861, 38.13174], [-122.18524, 38.13097], [-122.18589, 38.13091], [-122.18631, 38.13097], [-122.18726, 38.13107], [-122.18796, 38.13157], [-122.18847, 38.13188], [-122.18936, 38.13246], [-122.19034, 38.13316], [-122.19067, 38.13331], [-122.1909, 38.13352], [-122.19133, 38.13422], [-122.19156, 38.13457], [-122.19184, 38.13515]]]} | Restricted Access 2 | 17806 | McIntyre Ranch | 22040 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 23.753 | McIntyre Ranch | 0 | Local Other or Unknown 14 | 4 | |
2754 | 2754 | 2753 | {"type": "Polygon", "coordinates": [[[-117.24499, 32.80093], [-117.24419, 32.8011], [-117.24283, 32.80145], [-117.24267, 32.80102], [-117.24251, 32.80051], [-117.24472, 32.80004], [-117.24499, 32.80093]]]} | Restricted Access 2 | 18441 | Pacific Beach Community Park | 33345 | 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 | 5.466 | Pacific Beach Community Park | 0 | Local Park 2 | 4 | |
2799 | 2799 | 2798 | {"type": "MultiPolygon", "coordinates": [[[[-117.05969, 32.76384], [-117.05963, 32.76392], [-117.05829, 32.76395], [-117.05834, 32.7639], [-117.05835, 32.76382], [-117.05963, 32.76378], [-117.05966, 32.76379], [-117.05969, 32.76384]]], [[[-117.06115, 32.76232], [-117.06114, 32.76248], [-117.06111, 32.76257], [-117.06106, 32.76264], [-117.06009, 32.76351], [-117.06004, 32.76235], [-117.06115, 32.76232]]]]} | Restricted Access 2 | 18582 | Clay Neighborhood Park | 31592 | 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 | 2.413 | Clay Neighborhood Park | 0 | Local Park 2 | 4 | |
2890 | 2890 | 2889 | {"type": "Polygon", "coordinates": [[[-121.39678, 36.84126], [-121.39678, 36.84159], [-121.39616, 36.84157], [-121.39614, 36.84183], [-121.39515, 36.8418], [-121.39507, 36.842], [-121.39507, 36.84215], [-121.39527, 36.84217], [-121.39527, 36.84247], [-121.39543, 36.84248], [-121.39542, 36.84336], [-121.39404, 36.84334], [-121.39252, 36.84106], [-121.39624, 36.84113], [-121.39633, 36.8412], [-121.39644, 36.84126], [-121.39678, 36.84126]]]} | Restricted Access 2 | 18924 | Rancho San Justo Sports Complex | 32730 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 13.179 | Rancho San Justo Sports Complex | 0 | Local Recreation Area 3 | 4 | |
2946 | 2946 | 2945 | {"type": "Polygon", "coordinates": [[[-118.43139, 34.07349], [-118.43133, 34.0739], [-118.43131, 34.07413], [-118.43128, 34.07416], [-118.43123, 34.07417], [-118.4312, 34.07415], [-118.43081, 34.0738], [-118.4306, 34.07366], [-118.4303, 34.07352], [-118.42983, 34.0734], [-118.42965, 34.0733], [-118.4295, 34.07319], [-118.42916, 34.07276], [-118.42892, 34.07255], [-118.42767, 34.07171], [-118.42764, 34.07166], [-118.42764, 34.0716], [-118.4278, 34.0712], [-118.42784, 34.07119], [-118.42921, 34.07171], [-118.42952, 34.07187], [-118.42979, 34.07208], [-118.43009, 34.07242], [-118.43027, 34.0726], [-118.43138, 34.07347], [-118.43139, 34.07349]]]} | Restricted Access 2 | 1906 | Holmby Park | 32999 | 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 | 8.535 | Holmby Park | 0 | Local Park 2 | 4 | |
2998 | 2998 | 2997 | {"type": "Polygon", "coordinates": [[[-117.78863, 34.0562], [-117.78469, 34.05669], [-117.78406, 34.05571], [-117.78833, 34.05518], [-117.78863, 34.0562]]]} | Restricted Access 2 | 20562 | Veterans Park Soccer Complex | 29804 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/84-veterans-park | Los Angeles 6 | 10.986 | Veterans Park Soccer Complex | 0 | Local Recreation Area 3 | 4 |
3049 | 3049 | 3048 | {"type": "Polygon", "coordinates": [[[-118.16091, 34.13982], [-118.15954, 34.13982], [-118.15942, 34.13859], [-118.16072, 34.13858], [-118.16072, 34.13907], [-118.16084, 34.13908], [-118.16091, 34.13982]]]} | Restricted Access 2 | 24522 | Wrigley Gardens | 32656 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 4.163 | Wrigley Gardens | 0 | Local Park 2 | 4 | |
3134 | 3134 | 3133 | {"type": "Polygon", "coordinates": [[[-118.29541, 33.87454], [-118.2952, 33.87454], [-118.29446, 33.87479], [-118.29448, 33.87492], [-118.29473, 33.87513], [-118.29474, 33.87518], [-118.29465, 33.87522], [-118.29361, 33.87523], [-118.29362, 33.87538], [-118.29214, 33.87542], [-118.29212, 33.87485], [-118.29185, 33.87476], [-118.29157, 33.87464], [-118.29117, 33.8744], [-118.29113, 33.87355], [-118.29311, 33.87358], [-118.29312, 33.87379], [-118.29431, 33.87391], [-118.29431, 33.87396], [-118.2945, 33.87411], [-118.29539, 33.87414], [-118.29541, 33.87454]]]} | Restricted Access 2 | 48035 | Gardena Willows Wetland Preserve | 32528 | 1117 | Gardena, City of 297 | City 2 | City Agency 2 | http://www.ci.gardena.ca.us/ | City 2 | 1117 | Gardena, City of 293 | City 2 | City Agency 2 | Los Angeles 6 | 13.513 | Gardena Willows Wetland Preserve | 0 | Local Conservation Area 4 | 2 | |
3214 | 3214 | 3213 | {"type": "Polygon", "coordinates": [[[-122.039, 37.00381], [-122.03783, 37.00449], [-122.03729, 37.00412], [-122.03759, 37.00374], [-122.03715, 37.00342], [-122.03683, 37.00294], [-122.03674, 37.00261], [-122.03807, 37.00344], [-122.039, 37.00381]]]} | Restricted Access 2 | 367 | San Lorenzo River Open Space | 28168 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 3.51 | San Lorenzo River OS | 0 | Local Recreation Area 3 | 4 | |
3237 | 3237 | 3236 | {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} | Restricted Access 2 | 48110 | Sunflower Park | 32835 | 2422 | El Centro Elementary School District 602 | Special District 4 | School District 14 | www.ecesd.org | Special District 4 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 18.451 | Sunflower Park | 2000 | Local Park 2 | 4 |
3240 | 3240 | 3239 | {"type": "MultiPolygon", "coordinates": [[[[-117.84336, 34.11907], [-117.84316, 34.11904], [-117.84312, 34.11901], [-117.84308, 34.11903], [-117.84303, 34.11903], [-117.84285, 34.11899], [-117.84275, 34.11899], [-117.84267, 34.11902], [-117.84264, 34.11899], [-117.84243, 34.11892], [-117.84247, 34.11891], [-117.84267, 34.11876], [-117.84278, 34.11871], [-117.84336, 34.11907]]], [[[-117.84124, 34.12117], [-117.84054, 34.12118], [-117.84023, 34.12153], [-117.83983, 34.12152], [-117.83911, 34.12117], [-117.83763, 34.12117], [-117.83763, 34.12145], [-117.83677, 34.12145], [-117.83667, 34.12126], [-117.83634, 34.12126], [-117.83592, 34.12145], [-117.8342, 34.12145], [-117.83431, 34.12136], [-117.83509, 34.12132], [-117.83554, 34.12118], [-117.83762, 34.12117], [-117.83763, 34.12112], [-117.8384, 34.12088], [-117.8391, 34.12113], [-117.83912, 34.12094], [-117.83982, 34.12059], [-117.8403, 34.12058], [-117.84046, 34.12015], [-117.84058, 34.11995], [-117.84123, 34.11967], [-117.84124, 34.12117]]], [[[-117.84291, 34.12337], [-117.84251, 34.12387], [-117.8422, 34.12469], [-117.84138, 34.12461], [-117.84124, 34.12468], [-117.84123, 34.12321], [-117.84124, 34.12207], [-117.84207, 34.12207], [-117.84207, 34.12238], [-117.84291, 34.12337]]]]} | Restricted Access 2 | 48130 | South Hills Wilderness Area | 32652 | 1120 | Glendora, City of 76 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 15.74 | South Hills Wilderness Area | 0 | Local Conservation Area 4 | 2 | |
3250 | 3250 | 3249 | {"type": "Polygon", "coordinates": [[[-118.04684, 34.0465], [-118.04683, 34.0474], [-118.04642, 34.04739], [-118.04643, 34.0465], [-118.04684, 34.0465]]]} | Restricted Access 2 | 48154 | South El Monte Senior Center | 32691 | 1402 | South El Monte, City of 606 | City 2 | City Agency 2 | http://www.ci.south-el-monte.ca.us/CITYDEPARTMENTSSERVICES/CommunityServices/ParksandRecreationDivision.aspx | City 2 | 1402 | South El Monte, City of 595 | City 2 | City Agency 2 | http://www.ci.south-el-monte.ca.us/CITYDEPARTMENTSSERVICES/CommunityServices/SeniorServices.aspx | Los Angeles 6 | 0.924 | South El Monte Senior Ctr. | 0 | Local Recreation Area 3 | 4 |
3290 | 3290 | 3289 | {"type": "Polygon", "coordinates": [[[-121.39236, 36.82838], [-121.39233, 36.82946], [-121.39215, 36.82958], [-121.39084, 36.82955], [-121.3909, 36.8283], [-121.39236, 36.82838]]]} | Restricted Access 2 | 48200 | Ladd Lane School Park | 32765 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 4.424 | Ladd Lane School Park | 0 | Local Park 2 | 4 | |
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 | ||
3326 | 3326 | 3325 | {"type": "Polygon", "coordinates": [[[-122.85783, 38.62011], [-122.85725, 38.62057], [-122.85665, 38.62055], [-122.85664, 38.61981], [-122.85662, 38.6198], [-122.85556, 38.6203], [-122.85404, 38.62045], [-122.85393, 38.6128], [-122.85461, 38.61267], [-122.85497, 38.61257], [-122.85528, 38.61242], [-122.85553, 38.61223], [-122.85597, 38.61183], [-122.85637, 38.61162], [-122.85646, 38.61227], [-122.85691, 38.61539], [-122.85603, 38.61518], [-122.85593, 38.61567], [-122.85597, 38.61607], [-122.85669, 38.61645], [-122.85741, 38.61634], [-122.85731, 38.6168], [-122.85769, 38.61688], [-122.85772, 38.61691], [-122.85772, 38.61697], [-122.8577, 38.61698], [-122.85783, 38.62011]]]} | Restricted Access 2 | 23633 | Tayman Park | 33078 | 1131 | Healdsburg, City of 374 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | Sonoma 16 | 59.424 | Tayman Park | 0 | Local Park 2 | 4 | |
3419 | 3419 | 3418 | {"type": "Polygon", "coordinates": [[[-117.18086, 32.69355], [-117.18013, 32.69481], [-117.17921, 32.69442], [-117.17996, 32.69317], [-117.18086, 32.69355]], [[-117.18043, 32.6934], [-117.18043, 32.69338], [-117.18037, 32.69337], [-117.17965, 32.69459], [-117.17972, 32.69461], [-117.18043, 32.6934]]]} | Restricted Access 2 | 25118 | Cutler Field | 31610 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | San Diego 4 | 3.436 | Cutler Field | 0 | Local Recreation Area 3 | 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]);