units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
87 rows where COUNTY = 4 and MNG_AG_TYP = 5 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
909 | 909 | 908 | {"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.99446, 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.99241, 32.66479], [-116.9924, 32.66481], [-116.98955, 32.66381], [-116.98915, 32.66383], [-116.98534, 32.66471], [-116.98442, 32.66526], [-116.98444, 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.66169], [-116.99324, 32.66166], [-116.99346, 32.66211], [-116.99359, 32.6624], [-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.66831], [-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.99781, 32.66579], [-116.99839, 32.6665], [-116.99859, 32.66701], [-116.99879, 32.66746], [-116.99892, 32.66874], [-117.00005, 32.6695], [-117.00038, 32.67013], [-117.00035, 32.67151], [-117.00156, 32.67463]]]]} | Open Access 1 | 5809 | Blue-Bonita Meadows | 1797 | 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 | 240.067 | Blue-Bonita Meadows | None 81 | |||
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 | |
1165 | 1165 | 1164 | {"type": "Polygon", "coordinates": [[[-116.90615, 32.72851], [-116.90484, 32.7283], [-116.90399, 32.72803], [-116.90394, 32.72518], [-116.90608, 32.72533], [-116.90615, 32.72851]]]} | Open Access 1 | 7381 | San Diego National Wildlife Refuge | 24858 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | San Diego 4 | 16.779 | San Diego NWR | 1996 | National Wildlife Refuge 105 | 2 | ||
1316 | 1316 | 1315 | {"type": "Polygon", "coordinates": [[[-116.74116, 32.57636], [-116.74114, 32.58363], [-116.73714, 32.58342], [-116.73291, 32.5834], [-116.73278, 32.58732], [-116.72047, 32.58718], [-116.72045, 32.58913], [-116.70751, 32.5894], [-116.69094, 32.5893], [-116.69082, 32.58084], [-116.69077, 32.57124], [-116.73696, 32.56738], [-116.73704, 32.56906], [-116.74116, 32.5691], [-116.74116, 32.5727], [-116.73707, 32.57263], [-116.73709, 32.57623], [-116.74116, 32.57636]]]} | No Public Access 3 | 7399 | Kuchamaa Experimental Forest | 20729 | 202 | California Department of Forestry and Fire Protection 346 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | San Diego 4 | 2363.684 | Kuchamaa Experimental Forest | 0 | None 113 | ||
1522 | 1522 | 1521 | {"type": "Polygon", "coordinates": [[[-117.23496, 33.27233], [-117.23496, 33.27267], [-117.23179, 33.27604], [-117.23077, 33.27536], [-117.2336, 33.27235], [-117.23496, 33.27233]]]} | Restricted Access 2 | 12834 | San Luis Rey River Ecological Reserve | 24942 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 14.153 | San Luis Rey River ER | 0 | State Conservation Area 8 | 2 | |
3678 | 3678 | 3677 | {"type": "Polygon", "coordinates": [[[-117.17431, 33.05469], [-117.17231, 33.05468], [-117.17229, 33.05456], [-117.17224, 33.05445], [-117.17216, 33.05434], [-117.17206, 33.05426], [-117.17194, 33.05419], [-117.17181, 33.05416], [-117.17142, 33.05413], [-117.17121, 33.05407], [-117.17104, 33.05396], [-117.17068, 33.05363], [-117.17054, 33.05374], [-117.17047, 33.05382], [-117.1704, 33.05399], [-117.17038, 33.05408], [-117.1704, 33.05417], [-117.17059, 33.05467], [-117.17004, 33.05467], [-117.16999, 33.05106], [-117.172, 33.05106], [-117.17202, 33.0523], [-117.17429, 33.0523], [-117.17431, 33.05469]]]} | No Public Access 3 | 44356 | Escondido Creek | 32162 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 29.504 | Escondido Creek | 0 | State Resource Management Area 55 | 3 | |
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 | |
5503 | 5503 | 5502 | {"type": "MultiPolygon", "coordinates": [[[[-117.24645, 33.15192], [-117.24325, 33.15203], [-117.24295, 33.1512], [-117.24431, 33.15105], [-117.24644, 33.15036], [-117.24645, 33.15192]]], [[[-117.26182, 33.14925], [-117.26138, 33.14958], [-117.25936, 33.14941], [-117.25864, 33.14971], [-117.2584, 33.14977], [-117.25816, 33.14977], [-117.25744, 33.14967], [-117.25731, 33.14967], [-117.25716, 33.14971], [-117.25701, 33.14979], [-117.25667, 33.15004], [-117.25655, 33.15019], [-117.25648, 33.15037], [-117.25635, 33.1512], [-117.25631, 33.1513], [-117.25622, 33.15142], [-117.25586, 33.15176], [-117.25562, 33.15211], [-117.25053, 33.15267], [-117.25006, 33.1537], [-117.24851, 33.15389], [-117.24842, 33.1523], [-117.24819, 33.15211], [-117.24806, 33.15211], [-117.24804, 33.15188], [-117.24906, 33.14891], [-117.24789, 33.14895], [-117.24624, 33.14851], [-117.24658, 33.14758], [-117.24459, 33.14705], [-117.24455, 33.14478], [-117.24659, 33.1439], [-117.24672, 33.1458], [-117.26179, 33.1458], [-117.26182, 33.14925]]]]} | Restricted Access 2 | 12865 | Dawson Los Monos Canyon Reserve | 17958 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | San Diego 4 | 231.903 | Dawson Los Monos Canyon Reserve | 0 | State Conservation Area 8 | 2 | |
6243 | 6243 | 6242 | {"type": "Polygon", "coordinates": [[[-116.96211, 32.96295], [-116.95351, 32.96324], [-116.95342, 32.95961], [-116.94888, 32.95974], [-116.94878, 32.95602], [-116.94045, 32.9561], [-116.94043, 32.95977], [-116.93185, 32.95964], [-116.93185, 32.95601], [-116.92761, 32.95596], [-116.92763, 32.95203], [-116.93186, 32.95198], [-116.93182, 32.94121], [-116.92765, 32.94122], [-116.92248, 32.94033], [-116.9225, 32.94032], [-116.92218, 32.93627], [-116.92764, 32.93755], [-116.92764, 32.93401], [-116.93615, 32.93378], [-116.93618, 32.93562], [-116.94046, 32.93556], [-116.94047, 32.93366], [-116.9447, 32.93354], [-116.94886, 32.93352], [-116.94892, 32.94093], [-116.95334, 32.9409], [-116.9534, 32.94251], [-116.95366, 32.94251], [-116.95404, 32.94257], [-116.95419, 32.94253], [-116.95424, 32.9425], [-116.95433, 32.94237], [-116.95436, 32.94199], [-116.95436, 32.94189], [-116.95434, 32.94179], [-116.95417, 32.94158], [-116.95413, 32.94147], [-116.95414, 32.94141], [-116.95421, 32.94125], [-116.9543, 32.94118], [-116.95462, 32.94098], [-116.95478, 32.94093], [-116.9549, 32.9409], [-116.95518, 32.94089], [-116.95541, 32.94094], [-116.95553, 32.94095], [-116.95568, 32.94125], [-116.95518, 32.94132], [-116.95504, 32.94139], [-116.95494, 32.94146], [-116.95486, 32.94158], [-116.95481, 32.94169], [-116.95481, 32.94184], [-116.95484, 32.94192], [-116.95488, 32.94211], [-116.95483, 32.94232], [-116.95478, 32.94241], [-116.9547, 32.94251], [-116.95461, 32.94259], [-116.95445, 32.94268], [-116.95429, 32.94272], [-116.95411, 32.94274], [-116.95366, 32.94268], [-116.95324, 32.94271], [-116.95308, 32.94269], [-116.95286, 32.94263], [-116.9527, 32.94263], [-116.95253, 32.94268], [-116.9524, 32.94276], [-116.9513, 32.94378], [-116.95115, 32.94389], [-116.95109, 32.94392], [-116.95165, 32.94469], [-116.94886, 32.94473], [-116.94889, 32.95222], [-116.95298, 32.9522], [-116.95323, 32.95222], [-116.95318, 32.94851], [-116.95783, 32.94845], [-116.95798, 32.95947], [-116.96207, 32.95939], [-116.96211, 32.96295]]]} | No Public Access 3 | 1316 | San Vicente Highlands | 32296 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 1545.08 | San Vicente Highlands | 0 | State Resource Management Area 55 | 3 | |
6462 | 6462 | 6461 | {"type": "Polygon", "coordinates": [[[-116.18721, 33.15378], [-116.18628, 33.1536], [-116.18497, 33.1533], [-116.18496, 33.15281], [-116.18721, 33.15378]]]} | No Public Access 3 | 2055 | Hwy 78 scenic corridor | 20163 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | San Diego 4 | 1.475 | Hwy 78 scenic corridor | None 522 | |||
7770 | 7770 | 7769 | {"type": "MultiPolygon", "coordinates": [[[[-117.23873, 32.9777], [-117.23873, 32.97825], [-117.23589, 32.97824], [-117.23589, 32.97769], [-117.23873, 32.9777]]], [[[-117.25998, 32.96757], [-117.25996, 32.96761], [-117.25982, 32.96761], [-117.25966, 32.96764], [-117.25895, 32.96787], [-117.25875, 32.96792], [-117.25836, 32.96797], [-117.25808, 32.96798], [-117.25597, 32.96796], [-117.25596, 32.96753], [-117.24944, 32.96745], [-117.24862, 32.96463], [-117.24826, 32.96383], [-117.25164, 32.96386], [-117.25164, 32.96252], [-117.25179, 32.96252], [-117.25257, 32.96267], [-117.2527, 32.96273], [-117.25298, 32.96294], [-117.25311, 32.96301], [-117.2535, 32.96312], [-117.25362, 32.96313], [-117.25382, 32.96311], [-117.25466, 32.96292], [-117.25492, 32.96291], [-117.25509, 32.96295], [-117.25578, 32.96322], [-117.25651, 32.96401], [-117.25644, 32.96406], [-117.25671, 32.96465], [-117.25696, 32.96493], [-117.2575, 32.96525], [-117.25778, 32.9656], [-117.25788, 32.9657], [-117.25801, 32.96577], [-117.25819, 32.96584], [-117.25856, 32.9661], [-117.25869, 32.96652], [-117.259, 32.96693], [-117.25942, 32.96726], [-117.25998, 32.96757]]]]} | Restricted Access 2 | 29610 | San Dieguito Lagoon Ecological Reserve | 24866 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 102.535 | San Dieguito Lagoon ER | 0 | State Conservation Area 8 | 2 | |
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 | |
7960 | 7960 | 7959 | {"type": "Polygon", "coordinates": [[[-116.77151, 33.12419], [-116.76285, 33.1242], [-116.76283, 33.12035], [-116.7715, 33.12036], [-116.77151, 33.12419]]]} | Open Access 1 | 12841 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Diego 4 | 85.079 | SLC | 0 | State Resource Management Area 55 | 3 | |
9875 | 9875 | 9874 | {"type": "Polygon", "coordinates": [[[-116.92472, 33.30781], [-116.9243, 33.30807], [-116.92002, 33.31102], [-116.91534, 33.31417], [-116.90798, 33.31919], [-116.9001, 33.31615], [-116.90138, 33.31462], [-116.90169, 33.31428], [-116.90255, 33.31327], [-116.90259, 33.31326], [-116.91226, 33.30202], [-116.91289, 33.3024], [-116.9132, 33.30251], [-116.91339, 33.30251], [-116.91357, 33.30246], [-116.9137, 33.3024], [-116.91383, 33.30228], [-116.91391, 33.30216], [-116.91394, 33.30203], [-116.91395, 33.30125], [-116.9139, 33.30096], [-116.91366, 33.30042], [-116.91412, 33.29992], [-116.91452, 33.30019], [-116.91469, 33.30037], [-116.91483, 33.30054], [-116.91525, 33.30125], [-116.91538, 33.3014], [-116.91555, 33.3015], [-116.9157, 33.30152], [-116.9158, 33.30151], [-116.91599, 33.30144], [-116.91708, 33.3031], [-116.91724, 33.30377], [-116.91759, 33.30506], [-116.91361, 33.30706], [-116.91334, 33.3069], [-116.91329, 33.30691], [-116.91257, 33.30685], [-116.91224, 33.30687], [-116.91212, 33.30722], [-116.91201, 33.30831], [-116.91242, 33.30841], [-116.91292, 33.30861], [-116.9133, 33.30875], [-116.91369, 33.30885], [-116.91378, 33.30859], [-116.91457, 33.30832], [-116.91452, 33.30776], [-116.91453, 33.30775], [-116.91491, 33.30756], [-116.91526, 33.30744], [-116.91529, 33.30745], [-116.91544, 33.30741], [-116.91603, 33.30748], [-116.9163, 33.30723], [-116.91691, 33.30711], [-116.91724, 33.30707], [-116.91734, 33.30676], [-116.91757, 33.30649], [-116.91778, 33.30638], [-116.91768, 33.30626], [-116.91788, 33.30613], [-116.91827, 33.30753], [-116.92101, 33.30709], [-116.92362, 33.30718], [-116.92413, 33.30746], [-116.92472, 33.30781]], [[-116.91622, 33.30369], [-116.91648, 33.30389], [-116.91698, 33.30386], [-116.91698, 33.30384], [-116.91676, 33.30355], [-116.91605, 33.30315], [-116.9151, 33.30326], [-116.91509, 33.30331], [-116.91454, 33.30336], [-116.91429, 33.30327], [-116.91332, 33.30301], [-116.913, 33.3028], [-116.91252, 33.30272], [-116.91272, 33.30309], [-116.91295, 33.30328], [-116.91303, 33.30345], [-116.91315, 33.304], [-116.91341, 33.30416], [-116.91438, 33.30421], [-116.91487, 33.3042], [-116.91539, 33.3041], [-116.91542, 33.3038], [-116.91602, 33.30367], [-116.91622, 33.30369]]]} | Restricted Access 2 | 5341 | Plaisted Creek Ecological Reserve | 23767 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 463.609 | Plaisted Creek ER | 0 | State Conservation Area 8 | 2 |
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]);