superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AG_TYP = 16 sorted by MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10506 | 10506 | 10505 | {"type": "MultiPolygon", "coordinates": [[[[-120.4581, 37.66306], [-120.45808, 37.66498], [-120.45808, 37.66542], [-120.45707, 37.66528], [-120.45597, 37.66483], [-120.45469, 37.6645], [-120.45291, 37.66353], [-120.45213, 37.6633], [-120.45095, 37.66331], [-120.44582, 37.66483], [-120.44264, 37.66619], [-120.4424, 37.66704], [-120.4429, 37.66834], [-120.44449, 37.66942], [-120.44499, 37.67024], [-120.44507, 37.6707], [-120.44468, 37.67196], [-120.44451, 37.67195], [-120.44414, 37.6723], [-120.4442, 37.67238], [-120.44432, 37.67247], [-120.44448, 37.67253], [-120.4446, 37.67256], [-120.44456, 37.67299], [-120.44383, 37.67412], [-120.44205, 37.67462], [-120.44139, 37.67412], [-120.44162, 37.67396], [-120.44164, 37.67392], [-120.44164, 37.67374], [-120.44175, 37.67357], [-120.44237, 37.67322], [-120.44307, 37.67272], [-120.44313, 37.67156], [-120.44304, 37.67151], [-120.44276, 37.67145], [-120.44258, 37.67117], [-120.44266, 37.67084], [-120.44264, 37.67077], [-120.44247, 37.67048], [-120.44211, 37.6702], [-120.44208, 37.67012], [-120.44206, 37.66974], [-120.44176, 37.66924], [-120.44155, 37.66915], [-120.44135, 37.66925], [-120.44115, 37.66917], [-120.44061, 37.66888], [-120.44022, 37.66903], [-120.43995, 37.66926], [-120.43956, 37.66936], [-120.43934, 37.66911], [-120.43942, 37.6689], [-120.43942, 37.66882], [-120.43957, 37.66846], [-120.4396, 37.66791], [-120.43965, 37.66758], [-120.43945, 37.66728], [-120.4389, 37.66694], [-120.43818, 37.667], [-120.43768, 37.66672], [-120.44064, 37.66672], [-120.44097, 37.66699], [-120.44097, 37.66722], [-120.44079, 37.66791], [-120.4408, 37.66808], [-120.44211, 37.66906], [-120.44333, 37.67067], [-120.44408, 37.67218], [-120.44365, 37.67055], [-120.4424, 37.66888], [-120.44115, 37.66795], [-120.4413, 37.667], [-120.4411, 37.66672], [-120.44116, 37.6667], [-120.44105, 37.66585], [-120.44105, 37.66569], [-120.44115, 37.66504], [-120.44114, 37.66479], [-120.44096, 37.66429], [-120.44096, 37.66418], [-120.44127, 37.66392], [-120.4415, 37.66402], [-120.44191, 37.66403], [-120.44322, 37.66379], [-120.44355, 37.66352], [-120.44365, 37.6635], [-120.44613, 37.66348], [-120.44737, 37.66286], [-120.44899, 37.66304], [-120.45008, 37.66282], [-120.45062, 37.66228], [-120.45064, 37.66133], [-120.45102, 37.66105], [-120.45126, 37.66104], [-120.45125, 37.66305], [-120.4581, 37.66306]]], [[[-120.44902, 37.65939], [-120.44899, 37.66234], [-120.4484, 37.66246], [-120.44757, 37.66236], [-120.44763, 37.65939], [-120.44902, 37.65939]]], [[[-120.46249, 37.65702], [-120.46152, 37.6619], [-120.4597, 37.66152], [-120.45905, 37.66151], [-120.45764, 37.66153], [-120.45682, 37.66144], [-120.45634, 37.66131], [-120.45689, 37.66107], [-120.45787, 37.66141], [-120.4592, 37.66132], [-120.45958, 37.66118], [-120.45969, 37.66071], [-120.46021, 37.66014], [-120.46075, 37.65941], [-120.46119, 37.65891], [-120.46133, 37.65827], [-120.46114, 37.65782], [-120.46028, 37.65721], [-120.45968, 37.65721], [-120.45897, 37.65657], [-120.45841, 37.65564], [-120.45827, 37.65464], [-120.45845, 37.65412], [-120.45853, 37.65405], [-120.45959, 37.65373], [-120.45956, 37.65386], [-120.45951, 37.6545], [-120.46249, 37.65702]]]]} | Open Access 1 | Turlock Irrigation District | 26581 | 2273 | Turlock Irrigation District 978 | Special District 4 | Irrigation District 16 | http://www.tid.org/ | Special District 4 | 152.145 | Turlock Irrigation District | ||
15419 | 15419 | 15418 | {"type": "Polygon", "coordinates": [[[-120.00196, 37.03239], [-120.00171, 37.03243], [-120.00016, 37.03244], [-119.99943, 37.03242], [-119.99724, 37.03242], [-119.99579, 37.03241], [-119.99252, 37.03241], [-119.98734, 37.03239], [-119.98585, 37.0324], [-119.979, 37.03232], [-119.979, 37.03958], [-119.97675, 37.03953], [-119.97457, 37.03941], [-119.97448, 37.03591], [-119.96991, 37.03582], [-119.9699, 37.03231], [-119.97086, 37.03233], [-119.97446, 37.03226], [-119.97437, 37.02492], [-119.9744, 37.02311], [-119.97465, 37.023], [-119.97595, 37.02177], [-119.97705, 37.02028], [-119.9795, 37.01914], [-119.98213, 37.0183], [-119.98262, 37.01829], [-119.98364, 37.01781], [-119.98429, 37.01744], [-119.9852, 37.01715], [-119.98573, 37.01685], [-119.98675, 37.01624], [-119.98722, 37.01571], [-119.98802, 37.0152], [-119.98904, 37.01478], [-119.98933, 37.01476], [-119.98986, 37.01509], [-119.99053, 37.0152], [-119.99118, 37.01519], [-119.99207, 37.01523], [-119.99285, 37.01517], [-119.99361, 37.01483], [-119.99386, 37.0146], [-119.99395, 37.0136], [-119.99422, 37.01325], [-119.99436, 37.01282], [-119.99458, 37.01265], [-119.99507, 37.01245], [-119.99623, 37.0122], [-119.99704, 37.01195], [-119.99831, 37.01198], [-119.99894, 37.01182], [-119.99942, 37.01152], [-120.00002, 37.01106], [-120.00027, 37.01077], [-120.00172, 37.01077], [-120.00185, 37.02526], [-120.00196, 37.03239]]]} | No Public Access 3 | Madera Lake Park And Recreation Area | 21652 | 2275 | Madera Irrigation District 1113 | Special District 4 | Irrigation District 16 | http://www.madera-id.org/ | Special District 4 | 1216.326 | Madera Lake Park And Rec. Area | ||
7074 | 7074 | 7073 | {"type": "Polygon", "coordinates": [[[-119.00087, 36.48581], [-119.00073, 36.50019], [-118.98881, 36.50037], [-118.98849, 36.5075], [-118.98438, 36.50757], [-118.98422, 36.51497], [-118.95056, 36.51478], [-118.95017, 36.48653], [-118.95886, 36.48654], [-118.95883, 36.4839], [-118.95012, 36.48385], [-118.95008, 36.48653], [-118.94129, 36.48652], [-118.94106, 36.47196], [-118.95863, 36.47197], [-118.95841, 36.45769], [-118.96306, 36.45867], [-118.96313, 36.46251], [-118.97128, 36.46422], [-118.97135, 36.47198], [-118.9759, 36.47199], [-118.97604, 36.48655], [-118.98064, 36.48656], [-118.98063, 36.48423], [-118.98403, 36.48421], [-118.99295, 36.4837], [-118.99301, 36.48616], [-119.00087, 36.48581]]]} | No Public Access 3 | Mitigation Preserve | 22327 | 2302 | Kaweah Delta Water Conservation District 676 | Special District 4 | Irrigation District 16 | http://www.kdwcd.com/ | Special District 4 | 4600.191 | Mitigation Preserve | ||
9178 | 9178 | 9177 | {"type": "Polygon", "coordinates": [[[-117.1979, 33.04077], [-117.19691, 33.04146], [-117.19687, 33.04157], [-117.1967, 33.04154], [-117.19651, 33.04157], [-117.1957, 33.04195], [-117.19532, 33.04206], [-117.19501, 33.04209], [-117.19426, 33.04208], [-117.19394, 33.0421], [-117.19364, 33.04218], [-117.19207, 33.04311], [-117.19167, 33.0434], [-117.19148, 33.04349], [-117.19123, 33.04353], [-117.18912, 33.04351], [-117.18921, 33.04308], [-117.18939, 33.04261], [-117.18944, 33.04244], [-117.18945, 33.04225], [-117.1894, 33.0419], [-117.18942, 33.04177], [-117.18946, 33.04165], [-117.1895, 33.04157], [-117.19034, 33.04038], [-117.19045, 33.04018], [-117.19048, 33.04002], [-117.19048, 33.03979], [-117.19043, 33.03942], [-117.19038, 33.03925], [-117.19029, 33.03911], [-117.19019, 33.03901], [-117.19005, 33.03891], [-117.18986, 33.0388], [-117.18981, 33.03875], [-117.18978, 33.0387], [-117.18977, 33.03864], [-117.18979, 33.03853], [-117.18991, 33.03839], [-117.19003, 33.03828], [-117.19029, 33.0381], [-117.19187, 33.03732], [-117.1922, 33.03718], [-117.19291, 33.0369], [-117.19326, 33.0367], [-117.19356, 33.03648], [-117.19382, 33.0362], [-117.19396, 33.036], [-117.19401, 33.03591], [-117.19403, 33.03581], [-117.19403, 33.03562], [-117.19395, 33.03525], [-117.19394, 33.03517], [-117.19399, 33.03501], [-117.19404, 33.03495], [-117.1941, 33.03491], [-117.19417, 33.03491], [-117.19421, 33.03495], [-117.19432, 33.03563], [-117.19438, 33.03586], [-117.19445, 33.03604], [-117.19458, 33.0362], [-117.19475, 33.03633], [-117.19521, 33.03655], [-117.19544, 33.0367], [-117.19561, 33.03687], [-117.19579, 33.03712], [-117.19594, 33.0373], [-117.19613, 33.03745], [-117.19651, 33.03765], [-117.19669, 33.03769], [-117.19684, 33.03771], [-117.19679, 33.03841], [-117.19692, 33.03855], [-117.19732, 33.03888], [-117.19715, 33.04072], [-117.1979, 33.04077]]]} | Unknown Access 4 | San Dieguito Reservoir Watershed | 24868 | 2322 | Santa Fe Irrigation District 722 | Special District 4 | Irrigation District 16 | http://www.sfidwater.org/ | Special District 4 | 102.416 | San Dieguito Reservoir Watershed |
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]);