units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where AGNCY_WEB = "http://www.dot.ca.gov/" and GAP_STS = 4
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
4007 | 4007 | 4006 | {"type": "MultiPolygon", "coordinates": [[[[-117.14406, 32.70147], [-117.1438, 32.70178], [-117.14126, 32.70002], [-117.14133, 32.6999], [-117.14168, 32.70003], [-117.14184, 32.70014], [-117.14214, 32.70029], [-117.14239, 32.70037], [-117.14245, 32.70033], [-117.14406, 32.70147]]], [[[-117.14441, 32.70113], [-117.14421, 32.70131], [-117.14265, 32.70025], [-117.14169, 32.69956], [-117.14176, 32.69951], [-117.14179, 32.69934], [-117.14203, 32.69909], [-117.14229, 32.69886], [-117.1439, 32.7], [-117.14382, 32.70008], [-117.14379, 32.70022], [-117.14379, 32.70042], [-117.14375, 32.70045], [-117.14383, 32.70053], [-117.14392, 32.70058], [-117.14392, 32.70062], [-117.14396, 32.70074], [-117.14401, 32.70083], [-117.14441, 32.70113]]]]} | Open Access 1 | 46820 | Chicano Park | 17188 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.609 | Chicano Park | 0 | Local Park 2 | 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 | |
11165 | 11165 | 11164 | {"type": "Polygon", "coordinates": [[[-118.15596, 34.11789], [-118.15596, 34.11836], [-118.15571, 34.11836], [-118.15572, 34.11789], [-118.15596, 34.11789]]]} | Open Access 1 | 47994 | South Pasadena Community Garden and Demonstration Garden | 32415 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://www.southpasadenaca.gov/government/departments/community-services/administration/community-garden | Los Angeles 6 | 0.293 | South Pasadena Community Garden and Demonstration Garden | 2015 | Local Park 2 | 4 |
11442 | 11442 | 11441 | {"type": "Polygon", "coordinates": [[[-118.36175, 33.93255], [-118.36175, 33.93272], [-118.36145, 33.93272], [-118.36146, 33.93255], [-118.36175, 33.93255]]]} | Open Access 1 | 48138 | Lennox Community Garden | 32666 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.127 | Lennox Community Garden | 0 | Local Park 2 | 4 | |
13118 | 13118 | 13117 | {"type": "Polygon", "coordinates": [[[-118.32897, 34.10547], [-118.32877, 34.10597], [-118.32865, 34.10616], [-118.32806, 34.1056], [-118.32807, 34.10559], [-118.32819, 34.10555], [-118.32853, 34.1055], [-118.32891, 34.10541], [-118.32895, 34.10543], [-118.32897, 34.10547]]]} | Open Access 1 | 45044 | Franklin Ivar Park | 19059 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.862 | Franklin Ivar Park | 0 | Local Park 2 | 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 | |
14639 | 14639 | 14638 | {"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.14753], [-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.1483], [-117.30577, 33.14828], [-117.30574, 33.14806], [-117.30489, 33.14809], [-117.3046, 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.31831, 33.14345], [-117.3183, 33.14347], [-117.31839, 33.14363], [-117.31815, 33.14354], [-117.31788, 33.14349], [-117.31604, 33.14329], [-117.31607, 33.14321], [-117.31607, 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.14234], [-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.14303], [-117.31853, 33.14311], [-117.31855, 33.14318], [-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 | 44880 | Hallmark Transnet Environmental Mitigation | 19611 | 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.35 | Hallmark Transnet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
14640 | 14640 | 14639 | {"type": "Polygon", "coordinates": [[[-117.23926, 33.28549], [-117.23926, 33.28909], [-117.23491, 33.28917], [-117.23491, 33.28905], [-117.2349, 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.28559], [-117.22838, 33.28563], [-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.22571, 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.2829], [-117.22847, 33.28203], [-117.22846, 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.28549], [-117.23926, 33.28549]]]} | Unknown Access 4 | 44885 | Groves Property TransNet Mitigation | 19537 | 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 | 281.423 | Groves Property TransNet 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]);