superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where MNG_AGENCY = 483 and MNG_AG_TYP = 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11463 | 11463 | 11462 | {"type": "Polygon", "coordinates": [[[-121.19451, 39.33672], [-121.19414, 39.33949], [-121.18597, 39.3391], [-121.18689, 39.33154], [-121.18707, 39.33029], [-121.18742, 39.3303], [-121.18842, 39.3304], [-121.18881, 39.3304], [-121.18925, 39.33042], [-121.18963, 39.33042], [-121.19002, 39.33044], [-121.19016, 39.33043], [-121.18978, 39.33209], [-121.19067, 39.33218], [-121.19105, 39.33663], [-121.1914, 39.33671], [-121.19169, 39.33661], [-121.19204, 39.33663], [-121.19255, 39.33679], [-121.19303, 39.33701], [-121.19349, 39.33708], [-121.19376, 39.33714], [-121.19405, 39.33696], [-121.19418, 39.33677], [-121.19451, 39.33672]]]} | Unknown Access 4 | Yuba County Water Agency 25 | 27814 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 108.827 | Yuba County Water Agency 25 | ||
11464 | 11464 | 11463 | {"type": "Polygon", "coordinates": [[[-121.19416, 39.34305], [-121.18906, 39.34311], [-121.18673, 39.34309], [-121.18576, 39.34311], [-121.18597, 39.33911], [-121.19414, 39.3395], [-121.19416, 39.34305]]]} | Unknown Access 4 | Yuba County Water Agency 26 | 27815 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 74.259 | Yuba County Water Agency 26 | ||
11465 | 11465 | 11464 | {"type": "Polygon", "coordinates": [[[-121.27825, 39.4961], [-121.27797, 39.49638], [-121.27702, 39.49592], [-121.27717, 39.49573], [-121.27743, 39.49552], [-121.27825, 39.4961]]]} | Unknown Access 4 | Yuba County Water Agency 29 | 27817 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.15 | Yuba County Water Agency 29 | ||
11466 | 11466 | 11465 | {"type": "Polygon", "coordinates": [[[-121.27738, 39.49699], [-121.277, 39.49737], [-121.27617, 39.49697], [-121.2765, 39.49657], [-121.27738, 39.49699]]]} | Unknown Access 4 | Yuba County Water Agency 3 | 27818 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.143 | Yuba County Water Agency 3 | ||
11467 | 11467 | 11466 | {"type": "Polygon", "coordinates": [[[-121.27854, 39.4958], [-121.27825, 39.4961], [-121.27743, 39.49552], [-121.2781, 39.49497], [-121.27831, 39.49492], [-121.27841, 39.49547], [-121.27854, 39.4958]]]} | Unknown Access 4 | Yuba County Water Agency 30 | 27819 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.61 | Yuba County Water Agency 30 | ||
11468 | 11468 | 11467 | {"type": "Polygon", "coordinates": [[[-121.27829, 39.49721], [-121.27799, 39.49761], [-121.27712, 39.49725], [-121.2775, 39.49687], [-121.27829, 39.49721]]]} | Unknown Access 4 | Yuba County Water Agency 31 | 27820 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.044 | Yuba County Water Agency 31 | ||
11469 | 11469 | 11468 | {"type": "Polygon", "coordinates": [[[-121.277, 39.49738], [-121.27682, 39.49756], [-121.27671, 39.49771], [-121.27587, 39.49733], [-121.27617, 39.49697], [-121.277, 39.49738]]]} | Unknown Access 4 | Yuba County Water Agency 32 | 27821 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.95 | Yuba County Water Agency 32 | ||
11470 | 11470 | 11469 | {"type": "Polygon", "coordinates": [[[-121.27799, 39.49761], [-121.27768, 39.49802], [-121.27678, 39.49762], [-121.27712, 39.49725], [-121.27799, 39.49761]]]} | Unknown Access 4 | Yuba County Water Agency 33 | 27822 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.114 | Yuba County Water Agency 33 | ||
11471 | 11471 | 11470 | {"type": "Polygon", "coordinates": [[[-121.27655, 39.4991], [-121.2759, 39.49956], [-121.27563, 39.49942], [-121.27589, 39.49889], [-121.27615, 39.49905], [-121.27655, 39.4991]]]} | Unknown Access 4 | Yuba County Water Agency 34 | 27823 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.673 | Yuba County Water Agency 34 | ||
11472 | 11472 | 11471 | {"type": "Polygon", "coordinates": [[[-121.27589, 39.49889], [-121.27563, 39.49942], [-121.27481, 39.49898], [-121.27531, 39.49782], [-121.27554, 39.49761], [-121.27564, 39.49806], [-121.27575, 39.49869], [-121.27589, 39.49889]]]} | Unknown Access 4 | Yuba County Water Agency 35 | 27824 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2.388 | Yuba County Water Agency 35 | ||
11473 | 11473 | 11472 | {"type": "Polygon", "coordinates": [[[-121.2765, 39.49801], [-121.27626, 39.49834], [-121.27594, 39.49879], [-121.27582, 39.49848], [-121.27576, 39.49805], [-121.27567, 39.49769], [-121.2765, 39.49801]]]} | Unknown Access 4 | Yuba County Water Agency 36 | 27825 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.008 | Yuba County Water Agency 36 | ||
11474 | 11474 | 11473 | {"type": "Polygon", "coordinates": [[[-121.27768, 39.49802], [-121.27748, 39.49831], [-121.27659, 39.49789], [-121.27678, 39.49762], [-121.27768, 39.49802]]]} | Unknown Access 4 | Yuba County Water Agency 37 | 27826 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.771 | Yuba County Water Agency 37 | ||
11475 | 11475 | 11474 | {"type": "Polygon", "coordinates": [[[-121.2878, 39.49075], [-121.28749, 39.49816], [-121.28627, 39.49819], [-121.27875, 39.49803], [-121.27866, 39.49811], [-121.2808, 39.49561], [-121.28207, 39.49531], [-121.28582, 39.49306], [-121.27774, 39.4835], [-121.28324, 39.48881], [-121.28684, 39.4861], [-121.28687, 39.49073], [-121.2878, 39.49075]]]} | Unknown Access 4 | Yuba County Water Agency 38 | 27827 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 121.494 | Yuba County Water Agency 38 | ||
11476 | 11476 | 11475 | {"type": "Polygon", "coordinates": [[[-121.28103, 39.50008], [-121.27996, 39.49892], [-121.27995, 39.49806], [-121.28102, 39.49808], [-121.28103, 39.50008]]]} | Unknown Access 4 | Yuba County Water Agency 39 | 27828 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 3.617 | Yuba County Water Agency 39 | ||
11477 | 11477 | 11476 | {"type": "Polygon", "coordinates": [[[-121.28536, 39.46045], [-121.28531, 39.46143], [-121.28411, 39.46143], [-121.28411, 39.46113], [-121.28423, 39.46099], [-121.28459, 39.46073], [-121.28498, 39.46026], [-121.28536, 39.46045]]]} | Unknown Access 4 | Yuba County Water Agency 4 | 27829 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2.361 | Yuba County Water Agency 4 | ||
11478 | 11478 | 11477 | {"type": "Polygon", "coordinates": [[[-121.28986, 39.50148], [-121.28872, 39.50152], [-121.28863, 39.49951], [-121.28976, 39.49949], [-121.28986, 39.50148]]]} | Unknown Access 4 | Yuba County Water Agency 40 | 27830 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 5.363 | Yuba County Water Agency 40 | ||
11479 | 11479 | 11478 | {"type": "Polygon", "coordinates": [[[-121.28866, 39.50015], [-121.28525, 39.50023], [-121.28524, 39.49961], [-121.28629, 39.49959], [-121.28863, 39.49951], [-121.28866, 39.50015]]]} | Unknown Access 4 | Yuba County Water Agency 41 | 27831 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 5.004 | Yuba County Water Agency 41 | ||
11480 | 11480 | 11479 | {"type": "Polygon", "coordinates": [[[-121.27563, 39.49942], [-121.27246, 39.50161], [-121.27156, 39.50224], [-121.27495, 39.498], [-121.27524, 39.498], [-121.27482, 39.49898], [-121.27563, 39.49942]]]} | Unknown Access 4 | Yuba County Water Agency 42 | 27832 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 8.405 | Yuba County Water Agency 42 | ||
11481 | 11481 | 11480 | {"type": "Polygon", "coordinates": [[[-121.28906, 39.50662], [-121.28848, 39.50646], [-121.28784, 39.50624], [-121.28721, 39.50636], [-121.28646, 39.50697], [-121.28622, 39.50753], [-121.28542, 39.50752], [-121.28578, 39.50712], [-121.28621, 39.50655], [-121.28666, 39.50578], [-121.28667, 39.50497], [-121.28663, 39.5039], [-121.28656, 39.50322], [-121.28624, 39.50282], [-121.28582, 39.50266], [-121.28531, 39.50266], [-121.28525, 39.50023], [-121.28866, 39.50015], [-121.2887, 39.50107], [-121.28777, 39.50109], [-121.28785, 39.50189], [-121.28782, 39.50258], [-121.28772, 39.5031], [-121.28775, 39.50358], [-121.28759, 39.50433], [-121.28746, 39.50478], [-121.28755, 39.50521], [-121.28791, 39.50559], [-121.28843, 39.50576], [-121.28904, 39.50584], [-121.28906, 39.50662]]]} | Unknown Access 4 | Yuba County Water Agency 43 | 27833 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 30.316 | Yuba County Water Agency 43 | ||
11482 | 11482 | 11481 | {"type": "Polygon", "coordinates": [[[-121.19544, 39.32953], [-121.19529, 39.3307], [-121.19482, 39.33058], [-121.19431, 39.33048], [-121.1939, 39.33048], [-121.19341, 39.3305], [-121.19293, 39.33057], [-121.19258, 39.33071], [-121.19237, 39.33083], [-121.19196, 39.33088], [-121.19188, 39.33092], [-121.19197, 39.3303], [-121.19287, 39.3302], [-121.19319, 39.33019], [-121.19385, 39.33006], [-121.19449, 39.32991], [-121.19501, 39.32976], [-121.19525, 39.32965], [-121.19544, 39.32953]]]} | Unknown Access 4 | Yuba County Water Agency 44 | 27834 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 4.516 | Yuba County Water Agency 44 |
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]);