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 LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
562 | 562 | 561 | {"type": "Polygon", "coordinates": [[[-120.12824, 38.64367], [-120.12745, 38.64502], [-120.12745, 38.64534], [-120.12754, 38.64544], [-120.12754, 38.64592], [-120.12698, 38.64679], [-120.12687, 38.64752], [-120.12602, 38.64905], [-120.12536, 38.64985], [-120.12533, 38.65022], [-120.12477, 38.65066], [-120.12428, 38.65143], [-120.12428, 38.65184], [-120.1244, 38.652], [-120.12469, 38.65274], [-120.12469, 38.65299], [-120.12431, 38.65329], [-120.12408, 38.65434], [-120.12408, 38.65528], [-120.12378, 38.65628], [-120.12355, 38.6566], [-120.12346, 38.65717], [-120.1232, 38.658], [-120.12283, 38.65868], [-120.12326, 38.65908], [-120.1232, 38.65942], [-120.12256, 38.65988], [-120.12233, 38.66033], [-120.12224, 38.66088], [-120.1223, 38.66154], [-120.12277, 38.662], [-120.12312, 38.66212], [-120.12376, 38.6622], [-120.12411, 38.66248], [-120.12513, 38.66278], [-120.12522, 38.66294], [-120.12466, 38.66328], [-120.12353, 38.66442], [-120.12347, 38.66461], [-120.12268, 38.66502], [-120.12184, 38.66626], [-120.12134, 38.66635], [-120.12123, 38.66683], [-120.12169, 38.6671], [-120.12166, 38.66751], [-120.12152, 38.66815], [-120.12073, 38.66866], [-120.11986, 38.6688], [-120.11983, 38.66866], [-120.12044, 38.66824], [-120.12046, 38.66806], [-120.12006, 38.668], [-120.11901, 38.66841], [-120.11857, 38.66877], [-120.11816, 38.66898], [-120.1179, 38.66898], [-120.11746, 38.66875], [-120.11685, 38.66854], [-120.11636, 38.66854], [-120.11617, 38.66864], [-120.11608, 38.66863], [-120.11572, 38.66887], [-120.11496, 38.66925], [-120.11473, 38.66954], [-120.11465, 38.66958], [-120.11437, 38.66997], [-120.11388, 38.67037], [-120.11329, 38.67047], [-120.11325, 38.67044], [-120.1131, 38.66996], [-120.11305, 38.66991], [-120.11335, 38.66935], [-120.11335, 38.66914], [-120.11262, 38.66884], [-120.11213, 38.66853], [-120.11183, 38.668], [-120.11168, 38.66783], [-120.11159, 38.66732], [-120.11127, 38.66715], [-120.11122, 38.66699], [-120.11045, 38.66634], [-120.11029, 38.66607], [-120.11018, 38.66606], [-120.11008, 38.6659], [-120.10967, 38.66576], [-120.10938, 38.66546], [-120.10909, 38.66489], [-120.10908, 38.66444], [-120.10921, 38.6641], [-120.11021, 38.66299], [-120.11085, 38.66284], [-120.11112, 38.66235], [-120.1115, 38.66192], [-120.11177, 38.66178], [-120.11174, 38.66147], [-120.11229, 38.66129], [-120.11209, 38.66013], [-120.11165, 38.65937], [-120.11162, 38.65915], [-120.11186, 38.65889], [-120.112, 38.65775], [-120.11226, 38.65736], [-120.11334, 38.65725], [-120.11372, 38.65745], [-120.11425, 38.65711], [-120.11471, 38.65697], [-120.11541, 38.65702], [-120.11591, 38.65674], [-120.11617, 38.6564], [-120.11635, 38.65462], [-120.11675, 38.65326], [-120.11678, 38.65221], [-120.11766, 38.65082], [-120.11824, 38.65036], [-120.11876, 38.64968], [-120.11961, 38.64919], [-120.12004, 38.64878], [-120.12034, 38.64833], [-120.12127, 38.64762], [-120.12171, 38.64679], [-120.12255, 38.64601], [-120.12319, 38.64583], [-120.1234, 38.64512], [-120.12366, 38.64473], [-120.12378, 38.64416], [-120.12372, 38.64251], [-120.12404, 38.64203], [-120.12433, 38.64205], [-120.12497, 38.64185], [-120.1257, 38.6418], [-120.12603, 38.64187], [-120.12716, 38.64223], [-120.12763, 38.64262], [-120.12809, 38.64322], [-120.12824, 38.64367]], [[-120.12168, 38.64997], [-120.12141, 38.6499], [-120.12023, 38.64997], [-120.11996, 38.6502], [-120.11958, 38.65141], [-120.11947, 38.65212], [-120.11944, 38.65342], [-120.11958, 38.65409], [-120.12005, 38.65514], [-120.12069, 38.6556], [-120.12104, 38.65569], [-120.12148, 38.65559], [-120.12189, 38.6551], [-120.12203, 38.65475], [-120.1223, 38.65436], [-120.1225, 38.65292], [-120.12291, 38.65148], [-120.1227, 38.65077], [-120.12215, 38.65023], [-120.12168, 38.64997]]]} | Open Access 1 | Silver Lake | 3403 | 2220 | El Dorado Irrigation District 965 | Special District 4 | Irrigation District 16 | http://www.eid.org/ | Special District 4 | 514.434 | Silver Lake | ||
14646 | 14646 | 14645 | {"type": "MultiPolygon", "coordinates": [[[[-115.63163, 33.19095], [-115.61441, 33.191], [-115.61443, 33.2056], [-115.59713, 33.20562], [-115.5972, 33.19108], [-115.5972, 33.18382], [-115.61446, 33.18381], [-115.61454, 33.17663], [-115.623, 33.17661], [-115.62302, 33.16938], [-115.63151, 33.16937], [-115.63147, 33.17661], [-115.63163, 33.19095]]], [[[-115.66647, 33.19104], [-115.66645, 33.2056], [-115.64891, 33.20566], [-115.6489, 33.20569], [-115.64885, 33.20571], [-115.64879, 33.22008], [-115.63179, 33.22008], [-115.63178, 33.22013], [-115.63178, 33.23461], [-115.61433, 33.23471], [-115.61437, 33.22014], [-115.62588, 33.2201], [-115.63177, 33.22012], [-115.63169, 33.20562], [-115.64885, 33.20568], [-115.64877, 33.19098], [-115.66647, 33.19104]]], [[[-115.7311, 33.08957], [-115.73106, 33.09675], [-115.73101, 33.09684], [-115.72246, 33.09684], [-115.72244, 33.10411], [-115.70084, 33.10414], [-115.70083, 33.1186], [-115.68339, 33.11865], [-115.68339, 33.13303], [-115.68349, 33.14739], [-115.69213, 33.14742], [-115.69213, 33.15473], [-115.68349, 33.15472], [-115.68347, 33.1474], [-115.66632, 33.14745], [-115.6663, 33.13299], [-115.66633, 33.12578], [-115.67059, 33.12578], [-115.67062, 33.11859], [-115.68338, 33.11863], [-115.68355, 33.10408], [-115.68354, 33.10044], [-115.68787, 33.10044], [-115.68787, 33.08953], [-115.69223, 33.08954], [-115.69224, 33.09318], [-115.70089, 33.0932], [-115.70094, 33.08956], [-115.71774, 33.08956], [-115.71816, 33.08953], [-115.7311, 33.08957]]], [[[-115.71804, 33.16202], [-115.70089, 33.16204], [-115.70087, 33.16205], [-115.70076, 33.16206], [-115.70072, 33.17656], [-115.68364, 33.17653], [-115.68363, 33.17655], [-115.68352, 33.17655], [-115.68349, 33.16204], [-115.70075, 33.16204], [-115.70077, 33.14743], [-115.71803, 33.14745], [-115.71804, 33.16202]]], [[[-115.75251, 33.23471], [-115.75249, 33.24929], [-115.75081, 33.24922], [-115.73556, 33.24917], [-115.73553, 33.23463], [-115.7355, 33.23461], [-115.71833, 33.2346], [-115.71831, 33.23462], [-115.71823, 33.23463], [-115.71817, 33.24918], [-115.70103, 33.24913], [-115.70107, 33.23468], [-115.7182, 33.23462], [-115.71822, 33.2346], [-115.71831, 33.23459], [-115.71827, 33.22006], [-115.73548, 33.22009], [-115.73543, 33.20556], [-115.75235, 33.20575], [-115.75237, 33.22024], [-115.75082, 33.22017], [-115.73548, 33.2201], [-115.73553, 33.2346], [-115.73559, 33.23462], [-115.75245, 33.23475], [-115.75247, 33.23471], [-115.75251, 33.23471]]], [[[-115.77013, 33.17658], [-115.75241, 33.17654], [-115.75235, 33.16205], [-115.75229, 33.16205], [-115.75227, 33.16202], [-115.75142, 33.16202], [-115.75082, 33.16201], [-115.73539, 33.16202], [-115.73536, 33.14747], [-115.73529, 33.14745], [-115.73529, 33.14742], [-115.73536, 33.14742], [-115.73538, 33.14745], [-115.75242, 33.14742], [-115.75237, 33.16205], [-115.7701, 33.162], [-115.77008, 33.16923], [-115.77013, 33.17658]]], [[[-115.83922, 33.2347], [-115.82193, 33.23468], [-115.82184, 33.25008], [-115.8218, 33.25074], [-115.80456, 33.25072], [-115.80458, 33.25007], [-115.80462, 33.2347], [-115.78738, 33.23468], [-115.78737, 33.22013], [-115.77008, 33.22014], [-115.77008, 33.20569], [-115.78738, 33.2057], [-115.78738, 33.22012], [-115.80463, 33.22014], [-115.80465, 33.22013], [-115.80464, 33.20572], [-115.80463, 33.20569], [-115.822, 33.20566], [-115.82195, 33.22013], [-115.83921, 33.22016], [-115.83922, 33.2347]], [[-115.82195, 33.22016], [-115.82194, 33.22015], [-115.80465, 33.22014], [-115.80463, 33.23469], [-115.82191, 33.23467], [-115.82195, 33.22016]]], [[[-115.78737, 33.23469], [-115.78727, 33.25067], [-115.77001, 33.25062], [-115.76999, 33.25005], [-115.77008, 33.23472], [-115.78737, 33.23469]]], [[[-115.82198, 33.1766], [-115.82196, 33.17662], [-115.82195, 33.19107], [-115.80467, 33.19122], [-115.80477, 33.17658], [-115.78742, 33.17653], [-115.78748, 33.16924], [-115.7875, 33.16199], [-115.80481, 33.16192], [-115.80479, 33.17657], [-115.82198, 33.1766]]]]} | Open Access 1 | Sonny Bono Salton Sea National Wildlife Refuge | http://www.fws.gov/refuge/sonny_bono_salton_sea/ | 4597 | 2048 | Imperial Irrigation District 374 | Special District 4 | Irrigation District 16 | http://www.iid.com/ | Special District 4 | 17449.358 | Sonny Bono Salton Sea NWR | 1930 |
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 |
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]);