superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where MNG_AGENCY = 279 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- State Agency 29
MNG_AGENCY 1
- California Department of Transportation · 29 ✖
LAYER 1 ✖
- Other State 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14340 | 14340 | 14339 | {"type": "MultiPolygon", "coordinates": [[[[-123.78953, 40.0753], [-123.7895, 40.07556], [-123.78937, 40.07563], [-123.78923, 40.07562], [-123.78895, 40.07539], [-123.78896, 40.07522], [-123.78889, 40.07509], [-123.78898, 40.0749], [-123.78947, 40.07503], [-123.78953, 40.0753]]], [[[-123.80311, 40.92168], [-123.80295, 40.92183], [-123.80259, 40.92175], [-123.80217, 40.92158], [-123.80189, 40.92163], [-123.80154, 40.92173], [-123.80135, 40.92181], [-123.80095, 40.92202], [-123.80048, 40.92219], [-123.79993, 40.92252], [-123.79977, 40.92257], [-123.79706, 40.92221], [-123.79506, 40.92144], [-123.79484, 40.91961], [-123.79532, 40.91907], [-123.79581, 40.91872], [-123.7969, 40.9187], [-123.7967, 40.91955], [-123.79647, 40.91965], [-123.79631, 40.91983], [-123.79617, 40.92023], [-123.79619, 40.92066], [-123.79623, 40.92097], [-123.79652, 40.92115], [-123.79731, 40.92106], [-123.79784, 40.92114], [-123.79858, 40.92122], [-123.80016, 40.92128], [-123.80216, 40.92123], [-123.80242, 40.92129], [-123.80298, 40.92146], [-123.80311, 40.92168]]], [[[-124.15195, 40.80245], [-124.15185, 40.80277], [-124.15155, 40.80277], [-124.15145, 40.80283], [-124.15145, 40.80296], [-124.15115, 40.80296], [-124.15115, 40.80236], [-124.15119, 40.80236], [-124.15157, 40.80212], [-124.15195, 40.80245]]], [[[-124.15906, 40.55577], [-124.15904, 40.5631], [-124.15159, 40.56302], [-124.15233, 40.56174], [-124.15358, 40.55931], [-124.15391, 40.55636], [-124.15462, 40.55636], [-124.15467, 40.55574], [-124.15906, 40.55577]], [[-124.15417, 40.562], [-124.15423, 40.56176], [-124.1541, 40.56175], [-124.15409, 40.56199], [-124.15417, 40.562]]]]} | Open Access 1 | Unnamed site - California Department of Transportation | 30558 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 124.128 | |||
13471 | 13471 | 13470 | {"type": "Polygon", "coordinates": [[[-122.51472, 37.90786], [-122.51472, 37.90792], [-122.51462, 37.9081], [-122.5146, 37.90818], [-122.5143, 37.9088], [-122.51347, 37.91085], [-122.51289, 37.9125], [-122.51288, 37.91262], [-122.51293, 37.91302], [-122.51293, 37.91326], [-122.51289, 37.91332], [-122.51271, 37.91352], [-122.51273, 37.91343], [-122.51285, 37.9133], [-122.51288, 37.91325], [-122.51288, 37.91302], [-122.51282, 37.91261], [-122.51284, 37.91248], [-122.51341, 37.91084], [-122.51425, 37.90878], [-122.51455, 37.90817], [-122.51457, 37.90808], [-122.51467, 37.9079], [-122.51472, 37.90786]]]} | Open Access 1 | Alto Path | 30886 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.756 | Alto Path | ||
4333 | 4333 | 4332 | {"type": "Polygon", "coordinates": [[[-117.00555, 32.56116], [-117.00554, 32.56472], [-117.00446, 32.56471], [-117.00445, 32.56601], [-117.00443, 32.56603], [-117.00418, 32.566], [-117.004, 32.56588], [-117.00338, 32.56582], [-117.00337, 32.56469], [-117.00123, 32.56466], [-117.00126, 32.56109], [-117.00555, 32.56116]]]} | No Public Access 3 | Anderprises TransNet Environmental Mitigation | 32283 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 42.9 | Anderprises TransNet Environmental Mitigation | ||
1175 | 1175 | 1174 | {"type": "Polygon", "coordinates": [[[-117.00555, 32.56025], [-117.00555, 32.56116], [-117.00126, 32.56109], [-117.00126, 32.56018], [-117.00555, 32.56025]]]} | Unknown Access 4 | Anderprizes Mitigation Site | 15474 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 10.022 | Anderprizes Mitigation Site | ||
14091 | 14091 | 14090 | {"type": "Polygon", "coordinates": [[[-118.15638, 34.12905], [-118.1549, 34.12906], [-118.15483, 34.12838], [-118.15636, 34.12837], [-118.15633, 34.12839], [-118.15632, 34.12842], [-118.15638, 34.12905]]]} | Open Access 1 | Arlington Garden | http://www.arlingtongardenpasadena.com/ | 32632 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 2.548 | Arlington Garden | 2005 |
1271 | 1271 | 1270 | {"type": "Polygon", "coordinates": [[[-117.2959, 33.08404], [-117.29591, 33.08449], [-117.29589, 33.08457], [-117.29581, 33.08472], [-117.29571, 33.08486], [-117.29559, 33.08498], [-117.29544, 33.08509], [-117.29545, 33.08513], [-117.29301, 33.08641], [-117.29248, 33.08662], [-117.29177, 33.08681], [-117.2917, 33.08409], [-117.2959, 33.08404]]]} | Unknown Access 4 | Ayoub Mitigation Site | 15736 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 20.055 | Ayoub Mitigation Site | ||
383 | 383 | 382 | {"type": "MultiPolygon", "coordinates": [[[[-116.98194, 32.66387], [-116.98012, 32.66389], [-116.98006, 32.66252], [-116.98113, 32.66321], [-116.98194, 32.66387]]], [[[-116.99533, 32.66736], [-116.9952, 32.6671], [-116.99494, 32.66669], [-116.9947, 32.66636], [-116.99447, 32.6661], [-116.99404, 32.6657], [-116.99371, 32.66545], [-116.99336, 32.66523], [-116.99305, 32.66506], [-116.99253, 32.66482], [-116.99242, 32.66479], [-116.9924, 32.66481], [-116.98955, 32.66381], [-116.98915, 32.66383], [-116.98534, 32.66471], [-116.98442, 32.66526], [-116.98443, 32.66385], [-116.98299, 32.66386], [-116.98277, 32.66357], [-116.98191, 32.66274], [-116.98083, 32.66182], [-116.98012, 32.66126], [-116.98162, 32.66028], [-116.99252, 32.66025], [-116.99312, 32.66168], [-116.99324, 32.66166], [-116.99346, 32.66211], [-116.99359, 32.66239], [-116.99369, 32.66237], [-116.99393, 32.6629], [-116.99407, 32.66325], [-116.9942, 32.66361], [-116.9944, 32.66434], [-116.99449, 32.66471], [-116.99456, 32.66515], [-116.99455, 32.66531], [-116.99458, 32.66546], [-116.99462, 32.66554], [-116.9947, 32.66567], [-116.99489, 32.66587], [-116.99513, 32.66618], [-116.99523, 32.66641], [-116.99531, 32.66663], [-116.99536, 32.66698], [-116.99535, 32.66725], [-116.99533, 32.66736]]], [[[-117.00156, 32.67463], [-116.99849, 32.67546], [-116.99657, 32.67064], [-116.99567, 32.66833], [-116.9957, 32.6683], [-116.99555, 32.66794], [-116.99562, 32.6678], [-116.99568, 32.66754], [-116.99571, 32.66723], [-116.99569, 32.66683], [-116.99561, 32.66648], [-116.99551, 32.66623], [-116.99533, 32.66591], [-116.99522, 32.66576], [-116.99497, 32.66549], [-116.99488, 32.66534], [-116.99485, 32.66493], [-116.99477, 32.66442], [-116.99459, 32.66368], [-116.9944, 32.66315], [-116.99369, 32.66154], [-116.99617, 32.66084], [-116.99614, 32.66208], [-116.99667, 32.66343], [-116.99675, 32.66451], [-116.99839, 32.6665], [-116.99859, 32.66701], [-116.99879, 32.66746], [-116.99892, 32.66873], [-117.00005, 32.6695], [-117.00038, 32.67013], [-117.00035, 32.67151], [-117.00156, 32.67463]]]]} | Open Access 1 | Blue-Bonita Meadows | 1797 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 240.053 | Blue-Bonita Meadows | ||
2527 | 2527 | 2526 | {"type": "Polygon", "coordinates": [[[-116.91384, 32.82128], [-116.9136, 32.82217], [-116.91351, 32.82247], [-116.91325, 32.82312], [-116.91306, 32.82352], [-116.91285, 32.82388], [-116.91253, 32.82436], [-116.91234, 32.8246], [-116.91137, 32.82546], [-116.91041, 32.8248], [-116.9096, 32.82296], [-116.90946, 32.82252], [-116.90948, 32.82219], [-116.91047, 32.82103], [-116.91059, 32.82076], [-116.91384, 32.82128]]]} | Open Access 1 | CalTrans TransNet Environmental Mitigation | 16740 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 33.901 | CalTrans TransNet Environmental Mitigation | ||
1097 | 1097 | 1096 | {"type": "Polygon", "coordinates": [[[-117.97916, 33.9094], [-117.97859, 33.91001], [-117.97804, 33.91048], [-117.9775, 33.91087], [-117.97591, 33.91182], [-117.97546, 33.91214], [-117.96943, 33.91722], [-117.96887, 33.91721], [-117.97303, 33.91372], [-117.97303, 33.9137], [-117.97384, 33.91309], [-117.9751, 33.91199], [-117.97561, 33.91162], [-117.97741, 33.91054], [-117.97802, 33.91008], [-117.97805, 33.91001], [-117.97841, 33.90968], [-117.9788, 33.90926], [-117.97904, 33.90937], [-117.97916, 33.9094]]]} | Open Access 1 | Coyote Creek Bikeway | http://www.lhcm.org/386/Bikeways | 32861 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 11.01 | Coyote Creek Bikeway | 2011 |
3486 | 3486 | 3485 | {"type": "Polygon", "coordinates": [[[-117.24569, 32.9638], [-117.24306, 32.96378], [-117.24305, 32.96017], [-117.24531, 32.9602], [-117.24558, 32.96169], [-117.24569, 32.9638]]]} | Unknown Access 4 | Dean Family Trust TransNet Environmental Mitigation | 17977 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 23.119 | Dean Family Trust TransNet Environmental Mitigation | ||
3503 | 3503 | 3502 | {"type": "Polygon", "coordinates": [[[-117.1923, 32.94906], [-117.19099, 32.94919], [-117.19013, 32.94942], [-117.18969, 32.94958], [-117.18951, 32.94982], [-117.19051, 32.94991], [-117.19179, 32.94988], [-117.18881, 32.95146], [-117.18726, 32.95215], [-117.18661, 32.95216], [-117.18603, 32.95168], [-117.1852, 32.95166], [-117.18365, 32.9519], [-117.18288, 32.95212], [-117.18285, 32.94953], [-117.18356, 32.94954], [-117.18489, 32.94924], [-117.18599, 32.94907], [-117.18671, 32.94907], [-117.1883, 32.94888], [-117.18953, 32.94857], [-117.18983, 32.94848], [-117.19089, 32.94847], [-117.1916, 32.9486], [-117.1923, 32.94906]]]} | Open Access 1 | Deer Canyon Environmental Mitigation | 17991 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 54.196 | Deer Canyon Environmental Mitigation | ||
3570 | 3570 | 3569 | {"type": "MultiPolygon", "coordinates": [[[[-122.29969, 38.27466], [-122.29947, 38.27466], [-122.29946, 38.27356], [-122.29948, 38.27356], [-122.29969, 38.27466]]], [[[-122.46397, 38.50119], [-122.46394, 38.50121], [-122.46301, 38.50039], [-122.46304, 38.50037], [-122.46397, 38.50119]]]]} | No Public Access 3 | Department of Transportation | 18097 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.423 | Department of Transportation | ||
3576 | 3576 | 3575 | {"type": "Polygon", "coordinates": [[[-122.25654, 38.2078], [-122.25633, 38.20788], [-122.2563, 38.20749], [-122.2564, 38.20753], [-122.25652, 38.20754], [-122.25654, 38.2078]]]} | No Public Access 3 | Dept Of Transportation/Paul Kenny | 18103 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.163 | Dept Of Transportation/Paul Kenny | ||
4781 | 4781 | 4780 | {"type": "Polygon", "coordinates": [[[-117.23926, 33.28549], [-117.23926, 33.28909], [-117.23491, 33.28917], [-117.23491, 33.28906], [-117.23489, 33.28905], [-117.23474, 33.28918], [-117.23415, 33.29054], [-117.23405, 33.29043], [-117.23392, 33.29033], [-117.23377, 33.29024], [-117.23361, 33.29018], [-117.23148, 33.28969], [-117.23111, 33.28962], [-117.23055, 33.28956], [-117.23055, 33.2856], [-117.22838, 33.28564], [-117.22837, 33.28929], [-117.22772, 33.2893], [-117.22737, 33.28923], [-117.2265, 33.28895], [-117.22601, 33.28878], [-117.22595, 33.28872], [-117.22575, 33.28868], [-117.2257, 33.28792], [-117.22516, 33.28706], [-117.22519, 33.28669], [-117.22535, 33.28629], [-117.22535, 33.28602], [-117.22514, 33.28568], [-117.22551, 33.28334], [-117.22564, 33.28297], [-117.22601, 33.28228], [-117.22622, 33.28194], [-117.22668, 33.2815], [-117.22671, 33.28162], [-117.22676, 33.28169], [-117.22686, 33.28177], [-117.2269, 33.28184], [-117.22711, 33.28231], [-117.22773, 33.28289], [-117.22846, 33.28204], [-117.22845, 33.28202], [-117.22816, 33.28203], [-117.22708, 33.28113], [-117.22784, 33.28019], [-117.22798, 33.28008], [-117.22965, 33.279], [-117.22998, 33.27881], [-117.2345, 33.27683], [-117.23471, 33.27672], [-117.23494, 33.27658], [-117.23493, 33.28186], [-117.23731, 33.28182], [-117.23731, 33.2832], [-117.23567, 33.28324], [-117.23567, 33.2855], [-117.23923, 33.28544], [-117.23923, 33.28548], [-117.23926, 33.28549]]]} | Unknown Access 4 | Groves Property TransNet Mitigation | 19537 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 281.555 | Groves Property TransNet Mitigation | ||
4849 | 4849 | 4848 | {"type": "MultiPolygon", "coordinates": [[[[-117.30789, 33.14718], [-117.30772, 33.14736], [-117.30771, 33.14776], [-117.30743, 33.14776], [-117.30737, 33.14766], [-117.30705, 33.14754], [-117.30696, 33.14783], [-117.30706, 33.148], [-117.30683, 33.14848], [-117.30683, 33.14853], [-117.30595, 33.14884], [-117.30597, 33.14857], [-117.30597, 33.14831], [-117.30577, 33.14828], [-117.30574, 33.14807], [-117.30489, 33.14809], [-117.30459, 33.14818], [-117.30433, 33.14833], [-117.30412, 33.14849], [-117.30391, 33.14872], [-117.30376, 33.14923], [-117.30349, 33.14922], [-117.3037, 33.14814], [-117.30373, 33.14817], [-117.3073, 33.14696], [-117.30741, 33.14684], [-117.30789, 33.14718]]], [[[-117.3193, 33.14321], [-117.31899, 33.14379], [-117.31832, 33.14346], [-117.31831, 33.14347], [-117.31839, 33.14363], [-117.31815, 33.14354], [-117.31788, 33.14349], [-117.31604, 33.14329], [-117.31607, 33.14321], [-117.31606, 33.1432], [-117.31432, 33.143], [-117.31446, 33.14269], [-117.31497, 33.14275], [-117.31528, 33.14261], [-117.31575, 33.14215], [-117.31581, 33.14205], [-117.31585, 33.14202], [-117.31617, 33.14201], [-117.31631, 33.14205], [-117.31636, 33.14211], [-117.31637, 33.14233], [-117.3164, 33.14236], [-117.3166, 33.14232], [-117.31679, 33.1423], [-117.31684, 33.14228], [-117.31686, 33.14225], [-117.31696, 33.14196], [-117.317, 33.14192], [-117.31707, 33.1419], [-117.31748, 33.14197], [-117.31758, 33.14202], [-117.31763, 33.14209], [-117.31765, 33.14216], [-117.31757, 33.14238], [-117.31757, 33.14241], [-117.31791, 33.14259], [-117.31795, 33.1426], [-117.31799, 33.14258], [-117.31807, 33.14237], [-117.31814, 33.14231], [-117.31823, 33.14231], [-117.31849, 33.14237], [-117.31855, 33.1424], [-117.31858, 33.14246], [-117.31862, 33.14272], [-117.31852, 33.14304], [-117.31855, 33.14322], [-117.31857, 33.14324], [-117.31866, 33.14328], [-117.3188, 33.14331], [-117.319, 33.14317], [-117.31919, 33.14308], [-117.31925, 33.14311], [-117.31927, 33.14319], [-117.3193, 33.14321]]]]} | Unknown Access 4 | Hallmark Transnet Environmental Mitigation | 19611 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 19.364 | Hallmark Transnet Environmental Mitigation | ||
5511 | 5511 | 5510 | {"type": "MultiPolygon", "coordinates": [[[[-117.24846, 33.24868], [-117.24839, 33.24871], [-117.2469, 33.24873], [-117.24645, 33.24865], [-117.24604, 33.24863], [-117.24565, 33.24867], [-117.24515, 33.24879], [-117.24508, 33.24877], [-117.24498, 33.24859], [-117.24493, 33.2451], [-117.2483, 33.24507], [-117.24833, 33.24558], [-117.24831, 33.24561], [-117.24827, 33.24565], [-117.24828, 33.24578], [-117.24833, 33.24583], [-117.24834, 33.24606], [-117.2485, 33.24653], [-117.24854, 33.24677], [-117.24852, 33.24699], [-117.24841, 33.24737], [-117.24838, 33.2476], [-117.24839, 33.24781], [-117.24846, 33.24825], [-117.24847, 33.24864], [-117.24846, 33.24868]]], [[[-117.24931, 33.25309], [-117.24829, 33.25358], [-117.24817, 33.25368], [-117.24651, 33.25308], [-117.24637, 33.25305], [-117.246, 33.25299], [-117.24564, 33.25296], [-117.24533, 33.25296], [-117.24499, 33.25298], [-117.24498, 33.24895], [-117.24509, 33.24899], [-117.24517, 33.24898], [-117.2454, 33.2489], [-117.24562, 33.24884], [-117.24606, 33.24879], [-117.24647, 33.24882], [-117.2469, 33.2489], [-117.24928, 33.24886], [-117.24931, 33.25309]]]]} | Unknown Access 4 | Jeffries Ranch Mitigation Site | 20385 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 79.978 | Jeffries Ranch Mitigation Site | ||
12925 | 12925 | 12924 | {"type": "MultiPolygon", "coordinates": [[[[-116.94813, 32.58902], [-116.9452, 32.5891], [-116.94513, 32.5821], [-116.94581, 32.58211], [-116.9458, 32.58218], [-116.94582, 32.58248], [-116.94603, 32.58271], [-116.94635, 32.58283], [-116.94672, 32.58291], [-116.94705, 32.58296], [-116.94715, 32.58293], [-116.94748, 32.58333], [-116.94808, 32.58424], [-116.94543, 32.58528], [-116.94582, 32.58582], [-116.947, 32.58786], [-116.94813, 32.58902]]], [[[-116.96324, 32.58239], [-116.96221, 32.58238], [-116.96223, 32.58109], [-116.96255, 32.58146], [-116.96287, 32.58187], [-116.96324, 32.58239]]], [[[-116.97107, 32.58246], [-116.96665, 32.58242], [-116.96664, 32.58433], [-116.9656, 32.58432], [-116.96528, 32.5838], [-116.96527, 32.58366], [-116.96504, 32.58323], [-116.96479, 32.58282], [-116.96439, 32.58227], [-116.96379, 32.5813], [-116.96318, 32.58026], [-116.96293, 32.57991], [-116.96267, 32.57957], [-116.96225, 32.57912], [-116.96225, 32.57881], [-116.96235, 32.57879], [-116.96238, 32.57507], [-116.97088, 32.57514], [-116.97107, 32.58246]]]]} | No Public Access 3 | Lonestar Ridge TransNet Environmental Mitigation | 31496 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 191.665 | Lonestar Ridge TransNet Environmental Mitigation | ||
6460 | 6460 | 6459 | {"type": "Polygon", "coordinates": [[[-117.23056, 33.28559], [-117.23055, 33.28926], [-117.23037, 33.28927], [-117.23036, 33.28955], [-117.22971, 33.28951], [-117.22837, 33.28938], [-117.22838, 33.28563], [-117.23056, 33.28559]]]} | Unknown Access 4 | Lueng/Lowe TransNet Environmental Mitigation | 21587 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 21.401 | Lueng/Lowe TransNet Environmental Mitigation | ||
7219 | 7219 | 7218 | {"type": "Polygon", "coordinates": [[[-117.1954, 33.31432], [-117.19505, 33.31429], [-117.19404, 33.31474], [-117.19356, 33.31463], [-117.1905, 33.31328], [-117.18794, 33.31349], [-117.18526, 33.31418], [-117.1771, 33.31479], [-117.17421, 33.31628], [-117.17383, 33.31428], [-117.19121, 33.31078], [-117.19489, 33.31006], [-117.19536, 33.30995], [-117.1954, 33.31432]]]} | Unknown Access 4 | Morrison Mitigation Site | 22497 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 123.586 | Morrison Mitigation Site | ||
7789 | 7789 | 7788 | {"type": "Polygon", "coordinates": [[[-117.0144, 32.5799], [-117.00992, 32.57971], [-117.00998, 32.57781], [-117.0099, 32.57209], [-117.01425, 32.57223], [-117.01413, 32.57247], [-117.01413, 32.57266], [-117.01421, 32.57544], [-117.01423, 32.5755], [-117.01432, 32.57559], [-117.0144, 32.5799]]]} | Open Access 1 | Otay Mesa North TransNet Mitigation | 23240 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 85.222 | Otay Mesa North TransNet Mitigation |
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]);