units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
70 rows where DES_TP = 104 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY 12
- California Department of Transportation 21
- Other State 9
- California Department of Parks and Recreation 5
- California Wildlife Conservation Board 4
- California Department of Water Resources 2
- California State University 2
- California Tahoe Conservancy 2
- California Department of General Services 1
- University of California 1
- California State Lands Commission 1
- San Joaquin River Parkway and Conservation Trust 1
- Coachella Valley Mountains Conservancy 1
ACCESS_TYP 4
MNG_AG_TYP 2
DES_TP 1
- State Other or Unknown · 50 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5657 | 5657 | 5656 | {"type": "Polygon", "coordinates": [[[-122.55331, 38.60735], [-122.54863, 38.60741], [-122.54854, 38.60384], [-122.55324, 38.60379], [-122.55331, 38.60735]]]} | Open Access 1 | 43096 | Unnamed site - California Department of General Services | 28627 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 40.016 | 0 | State Other or Unknown 104 | 4 | ||
1169 | 1169 | 1168 | {"type": "MultiPolygon", "coordinates": [[[[-118.27708, 34.23336], [-118.2746, 34.23281], [-118.27449, 34.23274], [-118.27367, 34.23255], [-118.26859, 34.23141], [-118.268, 34.23107], [-118.26755, 34.23097], [-118.26718, 34.23078], [-118.26693, 34.23072], [-118.2668, 34.23061], [-118.26718, 34.23041], [-118.26682, 34.22994], [-118.26683, 34.22784], [-118.26967, 34.22964], [-118.27167, 34.23046], [-118.27708, 34.23336]]], [[[-118.27981, 34.23393], [-118.27925, 34.23386], [-118.27867, 34.23373], [-118.27191, 34.2301], [-118.26993, 34.22928], [-118.26683, 34.22733], [-118.26687, 34.22185], [-118.27531, 34.22179], [-118.27539, 34.2291], [-118.27975, 34.22907], [-118.27981, 34.23393]]]]} | Open Access 1 | 6828 | Verdugo Mountains Park Property | 1781 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=635 | Los Angeles 6 | 252.47 | Verdugo Mtns. Park Property | 1984 | State Other or Unknown 104 | 4 |
2979 | 2979 | 2978 | {"type": "Polygon", "coordinates": [[[-120.17147, 39.1305], [-120.17145, 39.13637], [-120.1712, 39.13638], [-120.17094, 39.1367], [-120.17066, 39.13676], [-120.17037, 39.13686], [-120.16983, 39.13691], [-120.16953, 39.1369], [-120.16901, 39.1366], [-120.16873, 39.13657], [-120.16812, 39.13666], [-120.16724, 39.13647], [-120.16687, 39.13649], [-120.1665, 39.13654], [-120.16616, 39.13643], [-120.16584, 39.1362], [-120.16563, 39.1361], [-120.16571, 39.13591], [-120.1652, 39.13575], [-120.16498, 39.13614], [-120.16475, 39.13622], [-120.16449, 39.13598], [-120.16342, 39.13584], [-120.16284, 39.13583], [-120.1626, 39.13559], [-120.16205, 39.13522], [-120.16162, 39.13528], [-120.16163, 39.13525], [-120.16143, 39.13496], [-120.16121, 39.13469], [-120.16081, 39.13411], [-120.16023, 39.13417], [-120.16027, 39.13409], [-120.15972, 39.13392], [-120.15967, 39.134], [-120.15941, 39.13389], [-120.15925, 39.13375], [-120.15847, 39.13314], [-120.15794, 39.13293], [-120.15793, 39.1329], [-120.15754, 39.13275], [-120.16017, 39.13035], [-120.16115, 39.12938], [-120.16136, 39.12912], [-120.16153, 39.12885], [-120.16198, 39.12785], [-120.16434, 39.1285], [-120.16376, 39.12982], [-120.16458, 39.13004], [-120.16447, 39.13029], [-120.16447, 39.13031], [-120.16653, 39.13089], [-120.16723, 39.12932], [-120.17147, 39.1305]]]} | Open Access 1 | 20528 | Ward Creek Property | 1782 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=513 | Placer 35 | 183.198 | Ward Creek Property | 1978 | State Other or Unknown 104 | 4 |
4776 | 4776 | 4775 | {"type": "MultiPolygon", "coordinates": [[[[-123.78094, 40.04105], [-123.77631, 40.04038], [-123.77621, 40.03407], [-123.77658, 40.03481], [-123.77778, 40.03667], [-123.77813, 40.03737], [-123.77819, 40.03767], [-123.7784, 40.03788], [-123.77868, 40.0386], [-123.77936, 40.03934], [-123.78039, 40.0401], [-123.78085, 40.0399], [-123.78089, 40.03991], [-123.78086, 40.03993], [-123.78094, 40.04105]]], [[[-124.15793, 40.54867], [-124.15215, 40.54859], [-124.15399, 40.54211], [-124.15466, 40.54314], [-124.15526, 40.54451], [-124.15583, 40.5456], [-124.15629, 40.54623], [-124.157, 40.54706], [-124.15756, 40.54776], [-124.15793, 40.54867]]], [[[-124.15905, 40.56405], [-124.15698, 40.56404], [-124.15638, 40.56307], [-124.15904, 40.5631], [-124.15905, 40.56405]]], [[[-124.17889, 40.59558], [-124.17889, 40.59558], [-124.17622, 40.59879], [-124.17608, 40.59791], [-124.17668, 40.59502], [-124.17645, 40.59463], [-124.17889, 40.59558]]]]} | Open Access 1 | 46941 | Unnamed site - California Department of Parks and Recreation | 30566 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Humboldt 45 | 91.244 | 0 | State Other or Unknown 104 | 4 | ||
4827 | 4827 | 4826 | {"type": "Polygon", "coordinates": [[[-118.74074, 34.07084], [-118.73649, 34.07068], [-118.73648, 34.06711], [-118.74072, 34.06713], [-118.74074, 34.07084]]]} | Open Access 1 | 48969 | Unnamed site - California Department of Parks and Recreation | 30566 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Los Angeles 6 | 39.075 | 0 | State Other or Unknown 104 | 4 | ||
10166 | 10166 | 10165 | {"type": "Polygon", "coordinates": [[[-121.50965, 38.26426], [-121.504, 38.26799], [-121.50354, 38.26776], [-121.49741, 38.2718], [-121.49714, 38.27079], [-121.49718, 38.27056], [-121.49735, 38.27044], [-121.49739, 38.27031], [-121.49769, 38.27006], [-121.49778, 38.26953], [-121.49789, 38.2695], [-121.49772, 38.26927], [-121.4976, 38.26904], [-121.49618, 38.27013], [-121.49636, 38.27139], [-121.49639, 38.27268], [-121.49826, 38.27354], [-121.49845, 38.27456], [-121.49793, 38.27673], [-121.4954, 38.27672], [-121.49517, 38.27538], [-121.4951, 38.27483], [-121.49506, 38.27443], [-121.49502, 38.27373], [-121.49502, 38.27313], [-121.49508, 38.27226], [-121.49523, 38.27126], [-121.49541, 38.27047], [-121.49531, 38.27045], [-121.49556, 38.2696], [-121.49584, 38.26887], [-121.49583, 38.26885], [-121.49576, 38.26885], [-121.49617, 38.26803], [-121.49757, 38.26552], [-121.49751, 38.26545], [-121.49743, 38.26543], [-121.49724, 38.26541], [-121.49715, 38.26534], [-121.49699, 38.26526], [-121.49701, 38.2652], [-121.4968, 38.26514], [-121.4967, 38.26509], [-121.49661, 38.26509], [-121.49571, 38.26502], [-121.49553, 38.26473], [-121.49532, 38.26455], [-121.49523, 38.26454], [-121.49511, 38.26435], [-121.49489, 38.26415], [-121.49478, 38.26414], [-121.4945, 38.2639], [-121.49426, 38.26356], [-121.49412, 38.26323], [-121.49401, 38.26242], [-121.49388, 38.26202], [-121.49327, 38.26127], [-121.49309, 38.26093], [-121.49298, 38.26063], [-121.49294, 38.25993], [-121.49297, 38.25961], [-121.49309, 38.25931], [-121.49341, 38.25904], [-121.4938, 38.25889], [-121.4939, 38.25893], [-121.49429, 38.25876], [-121.49445, 38.25876], [-121.49481, 38.25864], [-121.49524, 38.25847], [-121.49556, 38.25815], [-121.49606, 38.25758], [-121.49621, 38.25729], [-121.4963, 38.25716], [-121.49746, 38.25638], [-121.49789, 38.25614], [-121.49806, 38.25609], [-121.49821, 38.25602], [-121.49851, 38.25559], [-121.49843, 38.25518], [-121.4982, 38.25464], [-121.49814, 38.25443], [-121.49806, 38.25399], [-121.49802, 38.25353], [-121.49797, 38.25326], [-121.49795, 38.25286], [-121.4979, 38.25256], [-121.49773, 38.25179], [-121.49772, 38.25147], [-121.50104, 38.25101], [-121.50156, 38.25114], [-121.5038, 38.25083], [-121.50375, 38.25063], [-121.50339, 38.25068], [-121.5027, 38.24588], [-121.50353, 38.24609], [-121.5037, 38.24612], [-121.50384, 38.24617], [-121.50863, 38.24741], [-121.50921, 38.24635], [-121.50958, 38.24651], [-121.5081, 38.24892], [-121.50797, 38.24894], [-121.50805, 38.24901], [-121.50763, 38.24968], [-121.50783, 38.25006], [-121.50797, 38.25004], [-121.50312, 38.25795], [-121.5029, 38.25787], [-121.50269, 38.25821], [-121.50498, 38.25966], [-121.5073, 38.26083], [-121.50771, 38.26135], [-121.5083, 38.26215], [-121.50965, 38.26426]]]} | No Public Access 3 | 20470 | Delta Meadows Park Property | 18073 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Sacramento 41 | 533.415 | Delta Meadows Park Property | 1985 | State Other or Unknown 104 | 4 | |
1157 | 1157 | 1156 | {"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 | 7356 | CalTrans TransNet Environmental Mitigation | 16740 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 33.902 | CalTrans TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
3742 | 3742 | 3741 | {"type": "Polygon", "coordinates": [[[-117.25665, 33.25608], [-117.25376, 33.25609], [-117.24955, 33.25549], [-117.24981, 33.25449], [-117.25017, 33.25456], [-117.25354, 33.25499], [-117.25356, 33.25494], [-117.25383, 33.25496], [-117.25409, 33.25496], [-117.25448, 33.25494], [-117.25623, 33.25464], [-117.25665, 33.25608]]]} | Unknown Access 4 | 44862 | Zwierstra Mitigation Site | 27873 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 19.59 | Zwierstra Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
3744 | 3744 | 3743 | {"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.00401, 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 | 44877 | Anderprises TransNet Environmental Mitigation | 32283 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 42.881 | Anderprises TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
4192 | 4192 | 4191 | {"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 | 44884 | Otay Mesa North TransNet Mitigation | 23240 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 85.226 | Otay Mesa North TransNet Mitigation | 0 | State Other or Unknown 104 | 4 | |
4229 | 4229 | 4228 | {"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 | 45096 | Anderprizes Mitigation Site | 15474 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 10.024 | Anderprizes Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
4233 | 4233 | 4232 | {"type": "Polygon", "coordinates": [[[-117.22555, 33.28986], [-117.2256, 33.29089], [-117.22556, 33.29117], [-117.22548, 33.29133], [-117.22538, 33.29147], [-117.22471, 33.29228], [-117.22418, 33.2926], [-117.22348, 33.29335], [-117.2233, 33.29351], [-117.22309, 33.29367], [-117.22289, 33.29379], [-117.22184, 33.29299], [-117.22186, 33.28931], [-117.22508, 33.28931], [-117.22501, 33.28939], [-117.22555, 33.28986]]]} | Unknown Access 4 | 45102 | Tabata Mitigation Site | 26160 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 32.975 | Tabata Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
4260 | 4260 | 4259 | {"type": "Polygon", "coordinates": [[[-117.16445, 32.95224], [-117.16113, 32.95233], [-117.16099, 32.94848], [-117.16432, 32.94852], [-117.16445, 32.95224]]]} | Unknown Access 4 | 45284 | Zamudio TransNet Environmental Mitigation | 27854 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 32.329 | Zamudio TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
4283 | 4283 | 4282 | {"type": "Polygon", "coordinates": [[[-117.19602, 33.3082], [-117.19539, 33.30858], [-117.19476, 33.3096], [-117.19489, 33.31006], [-117.19121, 33.31078], [-117.17733, 33.31358], [-117.1753, 33.3124], [-117.17474, 33.31238], [-117.17432, 33.31214], [-117.17484, 33.31196], [-117.17505, 33.31183], [-117.17532, 33.31156], [-117.17668, 33.31087], [-117.17692, 33.31068], [-117.17745, 33.31006], [-117.17764, 33.30976], [-117.17793, 33.30857], [-117.17885, 33.30794], [-117.17982, 33.30805], [-117.18065, 33.30842], [-117.18136, 33.30852], [-117.18243, 33.30861], [-117.1832, 33.30892], [-117.1835, 33.30895], [-117.18388, 33.30881], [-117.18464, 33.30826], [-117.18566, 33.30798], [-117.18604, 33.30812], [-117.1866, 33.30897], [-117.18759, 33.30877], [-117.1893, 33.30835], [-117.19086, 33.30808], [-117.19144, 33.30817], [-117.19185, 33.3085], [-117.19288, 33.30906], [-117.19314, 33.30909], [-117.19384, 33.30888], [-117.19458, 33.30843], [-117.19495, 33.30838], [-117.1953, 33.3083], [-117.19548, 33.30822], [-117.19602, 33.3082]]]} | Unknown Access 4 | 45285 | Vessels Mitigation Site | 27006 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 159.815 | Vessels Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
4772 | 4772 | 4771 | {"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.7963, 40.91983], [-123.79616, 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.80017, 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.15156, 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.15907, 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.15907, 40.55577]], [[-124.15418, 40.562], [-124.15424, 40.56175], [-124.1541, 40.56175], [-124.15409, 40.56199], [-124.15418, 40.562]]]]} | Open Access 1 | 46933 | Unnamed site - California Department of Transportation | 30558 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Humboldt 45 | 124.116 | 0 | State Other or Unknown 104 | 4 | ||
7862 | 7862 | 7861 | {"type": "MultiPolygon", "coordinates": [[[[-116.94813, 32.58902], [-116.9452, 32.5891], [-116.94513, 32.5821], [-116.94581, 32.58211], [-116.9458, 32.58217], [-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.94542, 32.58527], [-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.5788], [-116.96238, 32.57507], [-116.97088, 32.57514], [-116.97107, 32.58246]]]]} | No Public Access 3 | 47715 | Lonestar Ridge TransNet Environmental Mitigation | 31496 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 191.623 | Lonestar Ridge TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
13226 | 13226 | 13225 | {"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 | 45245 | Lueng/Lowe TransNet Environmental Mitigation | 21587 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 21.401 | Lueng/Lowe TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
14573 | 14573 | 14572 | {"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 | 44878 | Dean Family Trust TransNet Environmental Mitigation | 17977 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 23.121 | Dean Family Trust TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
14621 | 14621 | 14620 | {"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 | 44854 | Ayoub Mitigation Site | 15736 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 20.055 | Ayoub Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
14627 | 14627 | 14626 | {"type": "Polygon", "coordinates": [[[-117.1923, 32.94906], [-117.191, 32.94919], [-117.19013, 32.94942], [-117.18969, 32.94958], [-117.1895, 32.94982], [-117.19051, 32.94991], [-117.19179, 32.94988], [-117.18881, 32.95146], [-117.18726, 32.95215], [-117.18661, 32.95216], [-117.18604, 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 | 44879 | Deer Canyon Environmental Mitigation | 17991 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 54.189 | Deer Canyon Environmental Mitigation | 0 | State Other or Unknown 104 | 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]);