superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where MNG_AGENCY = 279
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
12924 | 12924 | 12923 | {"type": "Polygon", "coordinates": [[[-116.95835, 32.58995], [-116.95155, 32.59194], [-116.94918, 32.59009], [-116.947, 32.58786], [-116.94582, 32.58582], [-116.94542, 32.58527], [-116.94807, 32.58424], [-116.94748, 32.58333], [-116.94716, 32.58293], [-116.94705, 32.58296], [-116.94672, 32.58291], [-116.94635, 32.58283], [-116.94603, 32.58271], [-116.94582, 32.58248], [-116.9458, 32.58217], [-116.94581, 32.58211], [-116.94962, 32.58217], [-116.95013, 32.5831], [-116.95155, 32.5844], [-116.95157, 32.58584], [-116.9523, 32.58586], [-116.95595, 32.58857], [-116.95639, 32.58888], [-116.95835, 32.58995]]]} | No Public Access 3 | Otay Valley Regional Park | http://www.sdparks.org/content/sdparks/en/park-pages/OVRP.html | 31498 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 146.7 | Otay Valley RP | |
12925 | 12925 | 12924 | {"type": "MultiPolygon", "coordinates": [[[[-116.94813, 32.58902], [-116.9452, 32.5891], [-116.94513, 32.5821], [-116.94581, 32.58211], [-116.9458, 32.58218], [-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.94543, 32.58528], [-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.57879], [-116.96238, 32.57507], [-116.97088, 32.57514], [-116.97107, 32.58246]]]]} | No Public Access 3 | Lonestar Ridge TransNet Environmental Mitigation | 31496 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 191.665 | Lonestar Ridge TransNet Environmental Mitigation | ||
13471 | 13471 | 13470 | {"type": "Polygon", "coordinates": [[[-122.51472, 37.90786], [-122.51472, 37.90792], [-122.51462, 37.9081], [-122.5146, 37.90818], [-122.5143, 37.9088], [-122.51347, 37.91085], [-122.51289, 37.9125], [-122.51288, 37.91262], [-122.51293, 37.91302], [-122.51293, 37.91326], [-122.51289, 37.91332], [-122.51271, 37.91352], [-122.51273, 37.91343], [-122.51285, 37.9133], [-122.51288, 37.91325], [-122.51288, 37.91302], [-122.51282, 37.91261], [-122.51284, 37.91248], [-122.51341, 37.91084], [-122.51425, 37.90878], [-122.51455, 37.90817], [-122.51457, 37.90808], [-122.51467, 37.9079], [-122.51472, 37.90786]]]} | Open Access 1 | Alto Path | 30886 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.756 | Alto Path | ||
13663 | 13663 | 13662 | {"type": "Polygon", "coordinates": [[[-122.39127, 37.75408], [-122.39097, 37.75409], [-122.39088, 37.75351], [-122.39082, 37.75346], [-122.39076, 37.75345], [-122.39076, 37.7531], [-122.39079, 37.7531], [-122.39096, 37.75334], [-122.39112, 37.75365], [-122.39126, 37.75395], [-122.39127, 37.75408]]]} | Open Access 1 | Progress Park | https://www.sfparksalliance.org/our-work/park-partners/progress-park | 33456 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.522 | Progress Park | |
14091 | 14091 | 14090 | {"type": "Polygon", "coordinates": [[[-118.15638, 34.12905], [-118.1549, 34.12906], [-118.15483, 34.12838], [-118.15636, 34.12837], [-118.15633, 34.12839], [-118.15632, 34.12842], [-118.15638, 34.12905]]]} | Open Access 1 | Arlington Garden | http://www.arlingtongardenpasadena.com/ | 32632 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 2.548 | Arlington Garden | 2005 |
14340 | 14340 | 14339 | {"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.79631, 40.91983], [-123.79617, 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.80016, 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.15155, 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.15906, 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.15906, 40.55577]], [[-124.15417, 40.562], [-124.15423, 40.56176], [-124.1541, 40.56175], [-124.15409, 40.56199], [-124.15417, 40.562]]]]} | Open Access 1 | Unnamed site - California Department of Transportation | 30558 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 124.128 |
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]);