superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where MNG_AGENCY = 279 and MNG_AG_TYP = 5 sorted by ACCESS_TYP
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 9 ✖
MNG_AGENCY 1
- California Department of Transportation · 9 ✖
ACCESS_TYP 1
Link | rowid | id | map | ACCESS_TYP ▼ | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6460 | 6460 | 6459 | {"type": "Polygon", "coordinates": [[[-117.23056, 33.28559], [-117.23055, 33.28926], [-117.23037, 33.28927], [-117.23036, 33.28955], [-117.22971, 33.28951], [-117.22837, 33.28938], [-117.22838, 33.28563], [-117.23056, 33.28559]]]} | Unknown Access 4 | Lueng/Lowe TransNet Environmental Mitigation | 21587 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 21.401 | Lueng/Lowe TransNet Environmental Mitigation | ||
7219 | 7219 | 7218 | {"type": "Polygon", "coordinates": [[[-117.1954, 33.31432], [-117.19505, 33.31429], [-117.19404, 33.31474], [-117.19356, 33.31463], [-117.1905, 33.31328], [-117.18794, 33.31349], [-117.18526, 33.31418], [-117.1771, 33.31479], [-117.17421, 33.31628], [-117.17383, 33.31428], [-117.19121, 33.31078], [-117.19489, 33.31006], [-117.19536, 33.30995], [-117.1954, 33.31432]]]} | Unknown Access 4 | Morrison Mitigation Site | 22497 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 123.586 | Morrison Mitigation Site | ||
8524 | 8524 | 8523 | {"type": "MultiPolygon", "coordinates": [[[[-117.11049, 33.29365], [-117.1103, 33.29404], [-117.11018, 33.29456], [-117.10973, 33.29442], [-117.10966, 33.29574], [-117.10934, 33.29638], [-117.10919, 33.29704], [-117.10856, 33.29701], [-117.1084, 33.29701], [-117.108, 33.29706], [-117.10539, 33.297], [-117.10342, 33.29701], [-117.10348, 33.29514], [-117.09362, 33.29524], [-117.09359, 33.29573], [-117.0939, 33.29709], [-117.09238, 33.29711], [-117.09236, 33.29895], [-117.08718, 33.29898], [-117.08717, 33.299], [-117.08758, 33.2997], [-117.08627, 33.2997], [-117.08578, 33.29899], [-117.08578, 33.29765], [-117.08601, 33.29714], [-117.08607, 33.29696], [-117.08675, 33.29551], [-117.08682, 33.29539], [-117.08689, 33.29514], [-117.08695, 33.29469], [-117.08703, 33.29393], [-117.08691, 33.29353], [-117.08651, 33.29263], [-117.08649, 33.29248], [-117.08633, 33.29237], [-117.08624, 33.29225], [-117.08614, 33.29205], [-117.08592, 33.29176], [-117.08553, 33.29148], [-117.08417, 33.29035], [-117.08402, 33.29019], [-117.08374, 33.2898], [-117.08357, 33.2894], [-117.08345, 33.2891], [-117.08344, 33.28894], [-117.08347, 33.2886], [-117.08347, 33.28849], [-117.08343, 33.2884], [-117.08337, 33.2883], [-117.08378, 33.28608], [-117.08366, 33.28609], [-117.08323, 33.2884], [-117.08322, 33.28867], [-117.08326, 33.28898], [-117.08322, 33.289], [-117.08323, 33.28913], [-117.08341, 33.28973], [-117.08125, 33.28975], [-117.08127, 33.29053], [-117.08133, 33.29159], [-117.08062, 33.29177], [-117.08021, 33.29189], [-117.07879, 33.29235], [-117.07696, 33.2916], [-117.07695, 33.28976], [-117.07557, 33.28977], [-117.07543, 33.2898], [-117.07501, 33.28999], [-117.07487, 33.29008], [-117.07468, 33.29015], [-117.07438, 33.29036], [-117.07403, 33.29055], [-117.07393, 33.29064], [-117.07384, 33.29074], [-117.07377, 33.2908], [-117.07299, 33.29116], [-117.07275, 33.29112], [-117.07266, 33.29109], [-117.07259, 33.29103], [-117.07252, 33.29085], [-117.0721, 33.29006], [-117.07207, 33.29002], [-117.07148, 33.28984], [-117.07179, 33.28884], [-117.07215, 33.28903], [-117.07231, 33.2893], [-117.07268, 33.2904], [-117.07295, 33.29079], [-117.07345, 33.29061], [-117.0736, 33.29021], [-117.07393, 33.28991], [-117.07375, 33.28943], [-117.07386, 33.28913], [-117.07385, 33.28881], [-117.07414, 33.28832], [-117.07424, 33.28805], [-117.0745, 33.28774], [-117.07523, 33.28763], [-117.07564, 33.28742], [-117.07575, 33.2871], [-117.0762, 33.28686], [-117.07698, 33.28671], [-117.07699, 33.28419], [-117.08377, 33.28415], [-117.08378, 33.28411], [-117.08375, 33.28402], [-117.08356, 33.28372], [-117.0835, 33.28358], [-117.08347, 33.2834], [-117.08349, 33.28312], [-117.08577, 33.28314], [-117.0858, 33.28237], [-117.09026, 33.28235], [-117.09032, 33.28597], [-117.09412, 33.28591], [-117.09361, 33.28821], [-117.09497, 33.28826], [-117.09604, 33.28865], [-117.09643, 33.28899], [-117.09718, 33.28857], [-117.09768, 33.28865], [-117.09805, 33.28835], [-117.09809, 33.28783], [-117.0986, 33.28763], [-117.09951, 33.28799], [-117.10078, 33.2877], [-117.10134, 33.28734], [-117.102, 33.2874], [-117.10224, 33.28696], [-117.10221, 33.2864], [-117.10192, 33.28561], [-117.10078, 33.2841], [-117.10097, 33.28334], [-117.09984, 33.28219], [-117.09941, 33.28162], [-117.09963, 33.28147], [-117.10078, 33.281], [-117.10118, 33.27924], [-117.10211, 33.27739], [-117.10345, 33.27742], [-117.1035, 33.27853], [-117.10541, 33.27853], [-117.10554, 33.28213], [-117.10477, 33.28216], [-117.1049, 33.28577], [-117.10488, 33.28619], [-117.10378, 33.28686], [-117.10371, 33.28889], [-117.10394, 33.28921], [-117.10401, 33.28977], [-117.10464, 33.28998], [-117.10631, 33.29012], [-117.10702, 33.29041], [-117.10735, 33.29025], [-117.10764, 33.29071], [-117.10777, 33.29107], [-117.10791, 33.29246], [-117.10809, 33.29246], [-117.10885, 33.29254], [-117.10944, 33.29314], [-117.11008, 33.29351], [-117.11049, 33.29365]], [[-117.09382, 33.28839], [-117.09381, 33.28837], [-117.09373, 33.28837], [-117.09372, 33.28846], [-117.0938, 33.28847], [-117.09382, 33.28839]]], [[[-117.08213, 33.28987], [-117.08177, 33.29005], [-117.08144, 33.29027], [-117.08143, 33.28986], [-117.08213, 33.28987]]], [[[-117.0864, 33.29585], [-117.08631, 33.29592], [-117.0863, 33.29598], [-117.08622, 33.29609], [-117.08608, 33.29602], [-117.08597, 33.29601], [-117.08367, 33.29624], [-117.08343, 33.29622], [-117.08309, 33.29612], [-117.08292, 33.29603], [-117.08276, 33.2959], [-117.08264, 33.29571], [-117.08236, 33.29487], [-117.08152, 33.29279], [-117.08151, 33.29269], [-117.0815, 33.29164], [-117.08145, 33.2905], [-117.08153, 33.29038], [-117.08175, 33.29023], [-117.08203, 33.29007], [-117.08237, 33.28992], [-117.08251, 33.28987], [-117.08347, 33.28987], [-117.08418, 33.29062], [-117.08474, 33.29111], [-117.08495, 33.29134], [-117.08526, 33.29154], [-117.08547, 33.29175], [-117.08559, 33.2919], [-117.08595, 33.29219], [-117.08614, 33.29242], [-117.08617, 33.29249], [-117.08624, 33.29258], [-117.08644, 33.29306], [-117.08658, 33.29329], [-117.08674, 33.29397], [-117.08671, 33.29421], [-117.0866, 33.29439], [-117.08661, 33.29466], [-117.08658, 33.29495], [-117.08649, 33.2953], [-117.08648, 33.2956], [-117.08642, 33.29575], [-117.0864, 33.29585]]]]} | Unknown Access 4 | Rancho Lilac Mitigation Site | 24150 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 910.217 | Rancho Lilac Mitigation Site | ||
9892 | 9892 | 9891 | {"type": "Polygon", "coordinates": [[[-117.24347, 33.25349], [-117.23987, 33.25567], [-117.23957, 33.25589], [-117.23933, 33.25604], [-117.23932, 33.25241], [-117.23924, 33.25052], [-117.23923, 33.24955], [-117.23925, 33.24879], [-117.24069, 33.2488], [-117.2407, 33.24978], [-117.24229, 33.25127], [-117.2434, 33.25222], [-117.24343, 33.25276], [-117.24338, 33.25304], [-117.24347, 33.25349]]]} | Unknown Access 4 | Stacco Mitigation Site | 25771 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 47.447 | Stacco Mitigation Site | ||
10208 | 10208 | 10207 | {"type": "Polygon", "coordinates": [[[-117.22555, 33.28986], [-117.2256, 33.29088], [-117.22556, 33.29117], [-117.22548, 33.29133], [-117.22538, 33.29148], [-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.22502, 33.2894], [-117.22555, 33.28986]]]} | Unknown Access 4 | Tabata Mitigation Site | 26160 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 32.976 | Tabata Mitigation Site | ||
10369 | 10369 | 10368 | {"type": "Polygon", "coordinates": [[[-117.24499, 33.25283], [-117.24415, 33.25259], [-117.24354, 33.25307], [-117.24362, 33.2534], [-117.24347, 33.25349], [-117.24338, 33.25304], [-117.24343, 33.25276], [-117.2434, 33.25222], [-117.24229, 33.25127], [-117.2407, 33.24977], [-117.24069, 33.2488], [-117.24299, 33.24882], [-117.24498, 33.2488], [-117.24499, 33.25283]]]} | Unknown Access 4 | Timeout Holdings Mitigation Site | 26371 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 31.489 | Timeout Holdings Mitigation Site | ||
10794 | 10794 | 10793 | {"type": "Polygon", "coordinates": [[[-117.19602, 33.3082], [-117.19539, 33.30858], [-117.19477, 33.30959], [-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.18066, 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.19287, 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 | Vessels Mitigation Site | 27006 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 159.825 | Vessels Mitigation Site | ||
11502 | 11502 | 11501 | {"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 | Zamudio TransNet Environmental Mitigation | 27854 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 32.326 | Zamudio TransNet Environmental Mitigation | ||
11518 | 11518 | 11517 | {"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.25449, 33.25493], [-117.25623, 33.25464], [-117.25665, 33.25608]]]} | Unknown Access 4 | Zwierstra Mitigation Site | 27873 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 19.59 | Zwierstra Mitigation Site |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);