units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 1015, DES_TP = 2 and MNG_AGENCY = 977
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16373 | 16373 | 16372 | {"type": "MultiPolygon", "coordinates": [[[[-120.61168, 37.65074], [-120.61119, 37.6508], [-120.6107, 37.65012], [-120.6096, 37.64943], [-120.60929, 37.64908], [-120.60895, 37.64912], [-120.60862, 37.64956], [-120.6086, 37.64996], [-120.60801, 37.65017], [-120.6077, 37.65055], [-120.60704, 37.65153], [-120.60665, 37.65203], [-120.60629, 37.65264], [-120.60628, 37.65275], [-120.6059, 37.65326], [-120.60575, 37.65389], [-120.60622, 37.65453], [-120.60604, 37.65484], [-120.60602, 37.65518], [-120.60606, 37.65547], [-120.60575, 37.6558], [-120.60564, 37.65648], [-120.60569, 37.65688], [-120.60474, 37.65732], [-120.60465, 37.65722], [-120.6046, 37.6563], [-120.60477, 37.65586], [-120.60476, 37.65579], [-120.60408, 37.65493], [-120.6042, 37.65423], [-120.60368, 37.65372], [-120.60324, 37.6539], [-120.60294, 37.65362], [-120.60343, 37.65322], [-120.60334, 37.65282], [-120.60269, 37.65267], [-120.60234, 37.65284], [-120.60251, 37.65359], [-120.6023, 37.65387], [-120.60181, 37.65423], [-120.60154, 37.65397], [-120.60188, 37.65338], [-120.60183, 37.65277], [-120.6018, 37.65266], [-120.60148, 37.65218], [-120.60099, 37.65184], [-120.60043, 37.65164], [-120.59976, 37.65155], [-120.59972, 37.65124], [-120.60279, 37.6524], [-120.60404, 37.65252], [-120.60566, 37.6518], [-120.6087, 37.64915], [-120.61047, 37.64804], [-120.61067, 37.64782], [-120.61066, 37.64824], [-120.61134, 37.64884], [-120.61129, 37.64988], [-120.61168, 37.65074]]], [[[-120.60572, 37.657], [-120.60529, 37.65791], [-120.60529, 37.65791], [-120.60482, 37.65741], [-120.60572, 37.657]]], [[[-120.61382, 37.64373], [-120.61373, 37.644], [-120.61306, 37.64444], [-120.61109, 37.64514], [-120.61086, 37.64519], [-120.60991, 37.64551], [-120.60933, 37.64563], [-120.60838, 37.64566], [-120.60744, 37.6455], [-120.60696, 37.64524], [-120.60617, 37.64478], [-120.60696, 37.6447], [-120.60916, 37.64471], [-120.61382, 37.64373]]], [[[-120.61428, 37.64851], [-120.61318, 37.64784], [-120.61261, 37.64739], [-120.61218, 37.64685], [-120.61329, 37.64634], [-120.61332, 37.64684], [-120.61382, 37.64735], [-120.61428, 37.64851]]], [[[-120.61487, 37.64591], [-120.61471, 37.64614], [-120.61426, 37.64599], [-120.61487, 37.64591], [-120.61487, 37.64591]]], [[[-120.62931, 37.64723], [-120.62794, 37.64723], [-120.62789, 37.64698], [-120.6276, 37.64638], [-120.62746, 37.64621], [-120.62725, 37.64602], [-120.62694, 37.64584], [-120.62674, 37.64577], [-120.62644, 37.64578], [-120.62565, 37.64609], [-120.62521, 37.64616], [-120.62477, 37.6463], [-120.62443, 37.64636], [-120.62399, 37.64631], [-120.62373, 37.64621], [-120.62354, 37.64617], [-120.62287, 37.64624], [-120.62256, 37.64624], [-120.62074, 37.64615], [-120.62046, 37.64607], [-120.61959, 37.64563], [-120.61933, 37.64553], [-120.62927, 37.64553], [-120.62931, 37.64723]]], [[[-120.62536, 37.65895], [-120.6252, 37.65899], [-120.62484, 37.65895], [-120.62484, 37.65817], [-120.62533, 37.65817], [-120.62536, 37.65895]]], [[[-120.6272, 37.66097], [-120.62719, 37.66184], [-120.62489, 37.66183], [-120.62487, 37.66056], [-120.62557, 37.66062], [-120.62579, 37.66066], [-120.62611, 37.66077], [-120.6266, 37.6609], [-120.62695, 37.6609], [-120.6272, 37.66097]]], [[[-120.63625, 37.64972], [-120.63585, 37.6494], [-120.63538, 37.64896], [-120.63529, 37.64885], [-120.63524, 37.64872], [-120.63507, 37.64851], [-120.63503, 37.64726], [-120.63621, 37.64725], [-120.63625, 37.64972]]], [[[-120.64994, 37.65494], [-120.64928, 37.65562], [-120.64766, 37.65477], [-120.64765, 37.65468], [-120.64803, 37.65443], [-120.64809, 37.65432], [-120.64804, 37.65425], [-120.64793, 37.65421], [-120.64784, 37.65421], [-120.64722, 37.65436], [-120.64708, 37.65437], [-120.64689, 37.65429], [-120.64677, 37.65414], [-120.64679, 37.65381], [-120.64691, 37.65341], [-120.64689, 37.65321], [-120.64691, 37.65304], [-120.64688, 37.6529], [-120.64673, 37.65269], [-120.64624, 37.65235], [-120.64611, 37.65228], [-120.64603, 37.65207], [-120.64585, 37.65201], [-120.64542, 37.65213], [-120.64478, 37.65219], [-120.64457, 37.65219], [-120.6444, 37.65212], [-120.64422, 37.65199], [-120.64394, 37.65172], [-120.64329, 37.65082], [-120.64288, 37.65047], [-120.6427, 37.65034], [-120.64244, 37.65021], [-120.64176, 37.64992], [-120.64068, 37.64968], [-120.64045, 37.64965], [-120.63993, 37.64965], [-120.63992, 37.64885], [-120.64094, 37.64922], [-120.64569, 37.65068], [-120.64825, 37.65269], [-120.64875, 37.6532], [-120.6499, 37.65413], [-120.64994, 37.65494]]], [[[-120.64986, 37.66297], [-120.64988, 37.66305], [-120.64977, 37.66334], [-120.64965, 37.66348], [-120.6493, 37.6637], [-120.64926, 37.66292], [-120.64943, 37.6629], [-120.64967, 37.66284], [-120.64986, 37.66297]]], [[[-120.65144, 37.66129], [-120.65136, 37.66139], [-120.65126, 37.66142], [-120.65059, 37.66148], [-120.65045, 37.66152], [-120.65037, 37.66163], [-120.65036, 37.66177], [-120.65032, 37.66185], [-120.65023, 37.66193], [-120.6501, 37.66198], [-120.64994, 37.66202], [-120.64992, 37.65997], [-120.65088, 37.65998], [-120.65105, 37.66018], [-120.65109, 37.66028], [-120.6511, 37.66069], [-120.65105, 37.66091], [-120.65134, 37.66099], [-120.65141, 37.66104], [-120.65145, 37.66116], [-120.65144, 37.66129]]], [[[-120.67478, 37.65643], [-120.67379, 37.65631], [-120.67277, 37.65654], [-120.67247, 37.65658], [-120.67118, 37.65636], [-120.67052, 37.65609], [-120.67039, 37.65607], [-120.6701, 37.65607], [-120.67009, 37.65624], [-120.67013, 37.65631], [-120.67046, 37.65661], [-120.67045, 37.6567], [-120.67033, 37.65681], [-120.67009, 37.65692], [-120.66998, 37.65695], [-120.66989, 37.65694], [-120.66959, 37.65662], [-120.66944, 37.65654], [-120.66925, 37.65657], [-120.66787, 37.65747], [-120.6678, 37.65755], [-120.66782, 37.65767], [-120.6679, 37.6578], [-120.66817, 37.65804], [-120.66827, 37.65824], [-120.66819, 37.65837], [-120.66792, 37.65837], [-120.66719, 37.65807], [-120.66683, 37.65802], [-120.66668, 37.65806], [-120.66613, 37.65827], [-120.66574, 37.6585], [-120.66564, 37.65865], [-120.66564, 37.65883], [-120.66551, 37.659], [-120.66533, 37.65903], [-120.66525, 37.6589], [-120.6652, 37.65876], [-120.66503, 37.65867], [-120.66477, 37.65878], [-120.66457, 37.65893], [-120.66416, 37.65913], [-120.66388, 37.6592], [-120.6634, 37.65926], [-120.66318, 37.65927], [-120.663, 37.65925], [-120.6628, 37.65921], [-120.66244, 37.65908], [-120.662, 37.65903], [-120.66183, 37.65903], [-120.66123, 37.65908], [-120.66107, 37.65904], [-120.66094, 37.65891], [-120.66091, 37.65883], [-120.66096, 37.65868], [-120.66103, 37.65862], [-120.6611, 37.65845], [-120.66107, 37.65836], [-120.66099, 37.65832], [-120.66044, 37.65834], [-120.66026, 37.65821], [-120.66025, 37.65792], [-120.66021, 37.65787], [-120.66009, 37.65784], [-120.66, 37.65789], [-120.65981, 37.65808], [-120.65967, 37.65815], [-120.65943, 37.65818], [-120.65934, 37.65814], [-120.65918, 37.65796], [-120.65901, 37.65789], [-120.65903, 37.6576], [-120.6672, 37.65759], [-120.66986, 37.65551], [-120.67132, 37.65502], [-120.67223, 37.65479], [-120.67301, 37.6547], [-120.67366, 37.65465], [-120.67408, 37.65481], [-120.67455, 37.65547], [-120.67475, 37.65549], [-120.67478, 37.65643]]], [[[-120.67644, 37.68455], [-120.67416, 37.68453], [-120.67415, 37.68549], [-120.67304, 37.6855], [-120.67315, 37.69279], [-120.66739, 37.69278], [-120.66739, 37.69174], [-120.66808, 37.69174], [-120.66927, 37.69167], [-120.67001, 37.69099], [-120.67008, 37.69083], [-120.67004, 37.69055], [-120.66994, 37.6903], [-120.66956, 37.6897], [-120.66958, 37.68918], [-120.66972, 37.6889], [-120.67004, 37.68846], [-120.67035, 37.68814], [-120.67084, 37.68774], [-120.67099, 37.68754], [-120.67114, 37.6872], [-120.6712, 37.68672], [-120.67116, 37.68596], [-120.67122, 37.68569], [-120.67146, 37.68535], [-120.6718, 37.6847], [-120.67203, 37.68433], [-120.67298, 37.68325], [-120.67323, 37.68311], [-120.67352, 37.68299], [-120.6739, 37.68288], [-120.6744, 37.68258], [-120.67451, 37.68242], [-120.6745, 37.68229], [-120.67442, 37.68218], [-120.67395, 37.68188], [-120.67641, 37.68188], [-120.67644, 37.68455]]], [[[-120.67471, 37.65419], [-120.67294, 37.65434], [-120.67193, 37.65445], [-120.67136, 37.65413], [-120.67065, 37.65403], [-120.66966, 37.6532], [-120.66833, 37.65251], [-120.66757, 37.65182], [-120.67469, 37.65197], [-120.67469, 37.65355], [-120.67471, 37.65419]]], [[[-120.67472, 37.65441], [-120.67472, 37.65453], [-120.67369, 37.65449], [-120.67472, 37.65441], [-120.67472, 37.65441]]], [[[-120.67475, 37.65533], [-120.67467, 37.65534], [-120.67421, 37.6547], [-120.6741, 37.65466], [-120.67473, 37.65468], [-120.67475, 37.65533]]], [[[-120.67769, 37.65477], [-120.67742, 37.65478], [-120.67637, 37.65487], [-120.67533, 37.65536], [-120.67527, 37.65519], [-120.67527, 37.65495], [-120.67561, 37.65503], [-120.6762, 37.65474], [-120.67741, 37.65478], [-120.67744, 37.65469], [-120.67769, 37.65477]]], [[[-120.68197, 37.66549], [-120.67692, 37.66551], [-120.67681, 37.66535], [-120.67669, 37.66513], [-120.67668, 37.66487], [-120.67675, 37.66467], [-120.6769, 37.66448], [-120.677, 37.66443], [-120.67731, 37.6644], [-120.67771, 37.66439], [-120.67796, 37.66432], [-120.67857, 37.66408], [-120.67944, 37.66389], [-120.67954, 37.66369], [-120.67944, 37.66361], [-120.67913, 37.66357], [-120.67887, 37.66357], [-120.67763, 37.66393], [-120.67683, 37.66394], [-120.67663, 37.66386], [-120.67649, 37.66369], [-120.67646, 37.6636], [-120.67646, 37.66325], [-120.67641, 37.66314], [-120.67642, 37.66303], [-120.67656, 37.66268], [-120.67667, 37.66256], [-120.67684, 37.66247], [-120.67693, 37.66245], [-120.67742, 37.66246], [-120.67759, 37.66252], [-120.67783, 37.66251], [-120.67798, 37.66244], [-120.67842, 37.66218], [-120.67871, 37.66209], [-120.67901, 37.6621], [-120.67939, 37.66228], [-120.67972, 37.66251], [-120.67999, 37.66251], [-120.68023, 37.66232], [-120.68032, 37.66215], [-120.68023, 37.66164], [-120.68022, 37.66103], [-120.68028, 37.66064], [-120.68008, 37.65991], [-120.68006, 37.65964], [-120.6799, 37.6591], [-120.67962, 37.65854], [-120.67899, 37.65777], [-120.67855, 37.65737], [-120.67817, 37.6569], [-120.67778, 37.65662], [-120.67766, 37.65656], [-120.67746, 37.65655], [-120.67736, 37.65659], [-120.67709, 37.65685], [-120.6769, 37.65696], [-120.67669, 37.65696], [-120.67585, 37.65658], [-120.67543, 37.6565], [-120.6753, 37.6565], [-120.67529, 37.65551], [-120.67539, 37.65551], [-120.67642, 37.65501], [-120.67768, 37.65493], [-120.67853, 37.655], [-120.68007, 37.65537], [-120.68013, 37.65525], [-120.68029, 37.65534], [-120.68068, 37.65577], [-120.68106, 37.65605], [-120.68161, 37.65612], [-120.68187, 37.65611], [-120.68197, 37.66549]]], [[[-120.68005, 37.65485], [-120.68003, 37.65492], [-120.67861, 37.65458], [-120.67785, 37.65453], [-120.67977, 37.65419], [-120.68005, 37.65485]]], [[[-120.68187, 37.65585], [-120.68171, 37.65586], [-120.68123, 37.6558], [-120.68095, 37.6556], [-120.68053, 37.65514], [-120.68025, 37.65498], [-120.6803, 37.65486], [-120.68008, 37.65431], [-120.68042, 37.6546], [-120.68186, 37.6551], [-120.68187, 37.65585]]]]} | Open Access 1 | 18251 | Modesto Reservoir Regional Park | 29283 | 2081 | Modesto Irrigation District 1015 | Special District 4 | Irrigation District 17 | http://www.mid.org/ | Special District 4 | 2081 | Modesto Irrigation District 977 | Special District 4 | Irrigation District 16 | http://www.stancounty.com/ER/PARKS/reservoir.shtm | Stanislaus 2 | 380.478 | Modesto Reservoir RP | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);