units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where ACCESS_TYP = 4 and AGNCY_TYP = 5 sorted by MNG_AG_LEV
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, COUNTY, LABEL_NAME, YR_EST, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4482 | 4482 | 4481 | {"type": "Polygon", "coordinates": [[[-118.82809, 34.1109], [-118.82374, 34.11089], [-118.82373, 34.10731], [-118.82808, 34.10728], [-118.82809, 34.1109]]]} | Unknown Access 4 | 4333 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 39.614 | 0 | Local Other or Unknown 14 | 4 | ||
4504 | 4504 | 4503 | {"type": "MultiPolygon", "coordinates": [[[[-118.27189, 34.25899], [-118.2716, 34.25922], [-118.2716, 34.25779], [-118.27178, 34.25778], [-118.27189, 34.25756], [-118.27189, 34.25899]]], [[[-118.27237, 34.25554], [-118.27236, 34.25643], [-118.27206, 34.25642], [-118.27207, 34.25578], [-118.27217, 34.25566], [-118.27237, 34.25554]]], [[[-118.27285, 34.2587], [-118.27285, 34.25987], [-118.27263, 34.25987], [-118.27263, 34.25887], [-118.27285, 34.2587]]], [[[-118.27406, 34.25636], [-118.27354, 34.2563], [-118.27351, 34.25638], [-118.27362, 34.25645], [-118.27348, 34.25653], [-118.27348, 34.25563], [-118.27335, 34.25554], [-118.27335, 34.25468], [-118.27359, 34.25468], [-118.27359, 34.25569], [-118.27369, 34.25576], [-118.27406, 34.25565], [-118.27406, 34.25636]]]]} | Unknown Access 4 | 6855 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 3.721 | 0 | Local Other or Unknown 14 | 4 | ||
4511 | 4511 | 4510 | {"type": "Polygon", "coordinates": [[[-118.75427, 34.16206], [-118.7528, 34.16289], [-118.75305, 34.16324], [-118.75218, 34.16381], [-118.75052, 34.1638], [-118.75016, 34.1634], [-118.74922, 34.16397], [-118.74932, 34.16485], [-118.74577, 34.16484], [-118.74578, 34.15444], [-118.75019, 34.15445], [-118.75017, 34.15687], [-118.75077, 34.15683], [-118.75171, 34.15863], [-118.75245, 34.15924], [-118.75258, 34.15956], [-118.75315, 34.16008], [-118.75269, 34.16057], [-118.75282, 34.16118], [-118.75304, 34.16161], [-118.75416, 34.1616], [-118.75427, 34.16206]]]} | Unknown Access 4 | 7093 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 154.044 | 0 | Local Other or Unknown 14 | 4 | ||
4704 | 4704 | 4703 | {"type": "Polygon", "coordinates": [[[-118.40005, 34.74273], [-118.39563, 34.7428], [-118.39551, 34.74099], [-118.39993, 34.74092], [-118.40005, 34.74273]]]} | Unknown Access 4 | 46152 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 20.153 | 0 | Local Other or Unknown 14 | 4 | ||
4716 | 4716 | 4715 | {"type": "Polygon", "coordinates": [[[-118.40496, 34.77529], [-118.39615, 34.77542], [-118.39603, 34.76097], [-118.39596, 34.75394], [-118.3961, 34.75369], [-118.4048, 34.75357], [-118.40496, 34.77529]]]} | Unknown Access 4 | 46228 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 480.911 | 0 | Local Other or Unknown 14 | 4 | ||
4761 | 4761 | 4760 | {"type": "Polygon", "coordinates": [[[-118.63806, 34.24154], [-118.63783, 34.24155], [-118.63783, 34.24148], [-118.63804, 34.24148], [-118.63806, 34.24154]]]} | Unknown Access 4 | 46669 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Ventura 8 | 0.038 | 0 | Local Other or Unknown 14 | 4 | ||
15287 | 15287 | 15286 | {"type": "MultiPolygon", "coordinates": [[[[-118.6575, 34.07699], [-118.65702, 34.07699], [-118.65724, 34.07654], [-118.65708, 34.07631], [-118.6561, 34.07608], [-118.65481, 34.07794], [-118.65519, 34.07852], [-118.65684, 34.07935], [-118.65688, 34.08176], [-118.65047, 34.08185], [-118.65079, 34.08151], [-118.65087, 34.08138], [-118.65094, 34.08117], [-118.65093, 34.08095], [-118.65085, 34.08074], [-118.6507, 34.08056], [-118.6505, 34.08042], [-118.65034, 34.08035], [-118.65019, 34.08032], [-118.65043, 34.08025], [-118.65077, 34.07999], [-118.65087, 34.07997], [-118.65096, 34.07999], [-118.65094, 34.07907], [-118.65093, 34.07906], [-118.65077, 34.07912], [-118.65034, 34.07919], [-118.65001, 34.07935], [-118.64998, 34.07481], [-118.65033, 34.0748], [-118.65074, 34.07488], [-118.65099, 34.07497], [-118.65132, 34.07516], [-118.65146, 34.07521], [-118.6516, 34.07522], [-118.65182, 34.0752], [-118.65201, 34.07512], [-118.65216, 34.075], [-118.65223, 34.07491], [-118.65228, 34.0748], [-118.65743, 34.07478], [-118.6575, 34.07699]], [[-118.65202, 34.07851], [-118.65202, 34.07849], [-118.65163, 34.07837], [-118.6514, 34.07845], [-118.65122, 34.07868], [-118.65157, 34.07893], [-118.65188, 34.07884], [-118.65202, 34.07851]]], [[[-118.65002, 34.08181], [-118.65001, 34.08047], [-118.65001, 34.08047], [-118.65017, 34.08048], [-118.65031, 34.08052], [-118.65044, 34.08059], [-118.65056, 34.08067], [-118.65068, 34.08083], [-118.65073, 34.08096], [-118.65074, 34.08108], [-118.65071, 34.08127], [-118.65065, 34.08138], [-118.65057, 34.08148], [-118.65041, 34.0816], [-118.65014, 34.08173], [-118.65002, 34.08181]]], [[[-118.65207, 34.0748], [-118.65198, 34.07493], [-118.65189, 34.07499], [-118.65172, 34.07505], [-118.6516, 34.07506], [-118.65148, 34.07504], [-118.65137, 34.075], [-118.65102, 34.0748], [-118.65207, 34.0748]]]]} | Unknown Access 4 | 46406 | Saddle Peak | 29684 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 108.695 | Saddle Peak | None 1347 | |||
15491 | 15491 | 15490 | {"type": "Polygon", "coordinates": [[[-117.82325, 34.4706], [-117.82215, 34.47059], [-117.82215, 34.46969], [-117.82325, 34.4697], [-117.82325, 34.4706]]]} | Unknown Access 4 | 46159 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.509 | 0 | Local Other or Unknown 14 | 4 | ||
15492 | 15492 | 15491 | {"type": "Polygon", "coordinates": [[[-117.8138, 34.73502], [-117.81378, 34.73671], [-117.81322, 34.73671], [-117.81324, 34.73502], [-117.8138, 34.73502]]]} | Unknown Access 4 | 46161 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.366 | 0 | Local Other or Unknown 14 | 4 | ||
15493 | 15493 | 15492 | {"type": "Polygon", "coordinates": [[[-117.90663, 34.63311], [-117.90661, 34.63403], [-117.90551, 34.63401], [-117.90553, 34.63309], [-117.90663, 34.63311]]]} | Unknown Access 4 | 46162 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.558 | 0 | Local Other or Unknown 14 | 4 | ||
15516 | 15516 | 15515 | {"type": "MultiPolygon", "coordinates": [[[[-118.32788, 34.25114], [-118.32274, 34.2498], [-118.32247, 34.24892], [-118.32243, 34.24892], [-118.32214, 34.24798], [-118.32193, 34.24741], [-118.32174, 34.24699], [-118.32152, 34.24658], [-118.3211, 34.24592], [-118.32081, 34.24554], [-118.32051, 34.24517], [-118.32018, 34.24482], [-118.31982, 34.24448], [-118.31945, 34.24416], [-118.31906, 34.24385], [-118.31864, 34.24356], [-118.31808, 34.24321], [-118.31762, 34.24296], [-118.317, 34.24267], [-118.31652, 34.24247], [-118.31585, 34.24224], [-118.315, 34.24201], [-118.31212, 34.2414], [-118.31148, 34.24125], [-118.31101, 34.24111], [-118.31055, 34.24095], [-118.3101, 34.24077], [-118.30966, 34.24057], [-118.30896, 34.24019], [-118.3083, 34.23977], [-118.30374, 34.23646], [-118.30332, 34.23618], [-118.30289, 34.23591], [-118.30244, 34.23566], [-118.30198, 34.23543], [-118.30152, 34.23523], [-118.30087, 34.23499], [-118.30019, 34.23478], [-118.2996, 34.23463], [-118.2989, 34.2345], [-118.29819, 34.23441], [-118.29765, 34.23437], [-118.29693, 34.23435], [-118.29623, 34.23437], [-118.2962, 34.2339], [-118.29657, 34.23322], [-118.29648, 34.23295], [-118.29674, 34.2329], [-118.29728, 34.23289], [-118.29747, 34.23286], [-118.29763, 34.23282], [-118.29824, 34.23261], [-118.2986, 34.23263], [-118.29898, 34.23269], [-118.2993, 34.23277], [-118.2997, 34.23291], [-118.3001, 34.23309], [-118.3003, 34.23316], [-118.30163, 34.23351], [-118.30227, 34.23364], [-118.30351, 34.23379], [-118.30382, 34.23387], [-118.30402, 34.23394], [-118.30418, 34.23403], [-118.30515, 34.2347], [-118.30533, 34.2348], [-118.30569, 34.23494], [-118.30608, 34.23501], [-118.30641, 34.23501], [-118.30674, 34.23496], [-118.307, 34.23488], [-118.30749, 34.23467], [-118.30766, 34.23463], [-118.31037, 34.23445], [-118.31057, 34.23439], [-118.31098, 34.23419], [-118.31116, 34.23415], [-118.31135, 34.23416], [-118.31289, 34.23452], [-118.31307, 34.23452], [-118.31358, 34.23445], [-118.31375, 34.23446], [-118.31383, 34.23448], [-118.31383, 34.23581], [-118.31381, 34.23755], [-118.3198, 34.23758], [-118.31981, 34.23711], [-118.32024, 34.23729], [-118.32023, 34.23766], [-118.31938, 34.23839], [-118.31912, 34.23875], [-118.31955, 34.23953], [-118.32114, 34.23952], [-118.32237, 34.24026], [-118.32233, 34.24325], [-118.32411, 34.2432], [-118.32788, 34.25114]]], [[[-118.31383, 34.23431], [-118.31357, 34.23429], [-118.31305, 34.23435], [-118.3129, 34.23435], [-118.31139, 34.234], [-118.31115, 34.23399], [-118.31089, 34.23404], [-118.31048, 34.23424], [-118.31033, 34.23428], [-118.30762, 34.23446], [-118.30741, 34.23452], [-118.30691, 34.23473], [-118.30671, 34.23479], [-118.30642, 34.23484], [-118.30615, 34.23485], [-118.30578, 34.23479], [-118.30543, 34.23466], [-118.30528, 34.23457], [-118.30432, 34.23391], [-118.30407, 34.23378], [-118.3045, 34.23382], [-118.30494, 34.2338], [-118.30523, 34.23376], [-118.30632, 34.23354], [-118.30675, 34.2335], [-118.30719, 34.23352], [-118.30817, 34.23368], [-118.30847, 34.2337], [-118.30883, 34.23369], [-118.30913, 34.23366], [-118.30942, 34.2336], [-118.31019, 34.2334], [-118.31044, 34.23334], [-118.31074, 34.23331], [-118.31109, 34.23331], [-118.31157, 34.23338], [-118.31215, 34.23354], [-118.3125, 34.23362], [-118.31346, 34.23371], [-118.31383, 34.23378], [-118.31383, 34.23431]]], [[[-118.32181, 34.24954], [-118.32023, 34.24912], [-118.32023, 34.24885], [-118.31914, 34.24884], [-118.31477, 34.24768], [-118.31483, 34.24349], [-118.31371, 34.24354], [-118.31366, 34.24739], [-118.31147, 34.2468], [-118.31149, 34.24357], [-118.30931, 34.24364], [-118.3093, 34.24484], [-118.30829, 34.24484], [-118.30829, 34.24596], [-118.30491, 34.24506], [-118.30492, 34.24378], [-118.30503, 34.24377], [-118.30502, 34.24296], [-118.30556, 34.24288], [-118.30665, 34.24141], [-118.3061, 34.24015], [-118.30692, 34.2396], [-118.30796, 34.24034], [-118.30853, 34.2407], [-118.30929, 34.2411], [-118.31008, 34.24145], [-118.31091, 34.24174], [-118.3116, 34.24192], [-118.31467, 34.24257], [-118.31546, 34.24278], [-118.31608, 34.24299], [-118.31668, 34.24323], [-118.31722, 34.24349], [-118.31778, 34.2438], [-118.31818, 34.24405], [-118.31856, 34.24432], [-118.31892, 34.2446], [-118.31927, 34.2449], [-118.3196, 34.24521], [-118.3199, 34.24554], [-118.32019, 34.24588], [-118.32045, 34.24624], [-118.32069, 34.2466], [-118.32091, 34.24697], [-118.32122, 34.24762], [-118.32142, 34.24814], [-118.32171, 34.24907], [-118.32167, 34.24909], [-118.32181, 34.24954]]], [[[-118.30829, 34.24639], [-118.30829, 34.24709], [-118.30809, 34.24704], [-118.30747, 34.2467], [-118.30743, 34.24663], [-118.30739, 34.24634], [-118.30736, 34.24627], [-118.30728, 34.24618], [-118.30716, 34.24613], [-118.30707, 34.24612], [-118.30698, 34.24614], [-118.30615, 34.24647], [-118.30606, 34.24651], [-118.30591, 34.24663], [-118.30534, 34.24562], [-118.30829, 34.24639]]], [[[-118.30725, 34.24657], [-118.3072, 34.24639], [-118.3072, 34.24639], [-118.30723, 34.24639], [-118.30725, 34.24657]]], [[[-118.31366, 34.24782], [-118.31365, 34.24835], [-118.31337, 34.24831], [-118.31268, 34.24835], [-118.31256, 34.24832], [-118.31245, 34.24826], [-118.31261, 34.24754], [-118.31366, 34.24782]]], [[[-118.31743, 34.24883], [-118.31475, 34.24882], [-118.31476, 34.24811], [-118.31476, 34.24811], [-118.31743, 34.24883]]], [[[-118.32258, 34.25247], [-118.32018, 34.25246], [-118.32023, 34.24955], [-118.32195, 34.25001], [-118.32237, 34.25136], [-118.32258, 34.25192], [-118.32258, 34.25247]]], [[[-118.32851, 34.25262], [-118.32832, 34.25597], [-118.32778, 34.25641], [-118.32748, 34.25627], [-118.32733, 34.25616], [-118.32721, 34.25603], [-118.32672, 34.25592], [-118.32647, 34.25565], [-118.32649, 34.25532], [-118.32629, 34.25541], [-118.32623, 34.25541], [-118.32616, 34.25533], [-118.32665, 34.25502], [-118.3269, 34.25475], [-118.3272, 34.25454], [-118.3281, 34.254], [-118.32798, 34.2536], [-118.32812, 34.25287], [-118.32776, 34.25256], [-118.32709, 34.25239], [-118.32678, 34.25225], [-118.32659, 34.25202], [-118.32646, 34.25156], [-118.32619, 34.25128], [-118.32592, 34.25118], [-118.32529, 34.25124], [-118.32518, 34.25131], [-118.32498, 34.25174], [-118.32479, 34.25207], [-118.32461, 34.25251], [-118.32433, 34.25283], [-118.32486, 34.25394], [-118.32485, 34.25396], [-118.32449, 34.25355], [-118.32413, 34.25309], [-118.32389, 34.25272], [-118.32361, 34.25222], [-118.32342, 34.25184], [-118.32326, 34.25145], [-118.32289, 34.25027], [-118.32805, 34.25162], [-118.32851, 34.25262]]]]} | Unknown Access 4 | 46477 | Unnamed site - Desert and Mountain Conservation Authority | 29750 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 570.486 | 0 | Local Other or Unknown 14 | 4 | ||
15518 | 15518 | 15517 | {"type": "Polygon", "coordinates": [[[-118.6406, 34.26451], [-118.63942, 34.26478], [-118.63947, 34.26497], [-118.63903, 34.26505], [-118.63764, 34.26489], [-118.63789, 34.26483], [-118.63816, 34.26479], [-118.63839, 34.26478], [-118.63878, 34.2648], [-118.63911, 34.26477], [-118.63935, 34.2647], [-118.64053, 34.2643], [-118.6406, 34.26451]]]} | Unknown Access 4 | 46683 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Ventura 8 | 1.348 | 0 | Local Other or Unknown 14 | 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 | |
4153 | 4153 | 4152 | {"type": "Polygon", "coordinates": [[[-122.83779, 40.22768], [-122.83774, 40.24195], [-122.81931, 40.24226], [-122.81888, 40.22865], [-122.83779, 40.22768]]]} | Unknown Access 4 | 44717 | California State Lands Commission | 16726 | 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 | Tehama 18 | 608.074 | SLC | 0 | State Resource Management Area 55 | 3 | |
4161 | 4161 | 4160 | {"type": "Polygon", "coordinates": [[[-116.41278, 35.08058], [-116.41277, 35.09522], [-116.39514, 35.09528], [-116.39514, 35.0819], [-116.39506, 35.08051], [-116.40393, 35.08058], [-116.41278, 35.08058]]]} | Unknown Access 4 | 44748 | California State Lands Commission | 16726 | 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 Bernardino 22 | 647.887 | SLC | 0 | State Resource Management Area 55 | 3 | |
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 | |
4478 | 4478 | 4477 | {"type": "Polygon", "coordinates": [[[-116.49292, 33.88852], [-116.49291, 33.8894], [-116.48878, 33.88856], [-116.49198, 33.88852], [-116.49292, 33.88852]]]} | Unknown Access 4 | 3751 | Unnamed site - California Wildlife Conservation Board | 28678 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Riverside 10 | 4.66 | 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]);