superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AGENCY = 646 and MNG_AG_LEV = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6285 | 6285 | 6284 | {"type": "MultiPolygon", "coordinates": [[[[-117.97762, 34.55779], [-117.9766, 34.55961], [-117.97615, 34.55961], [-117.97612, 34.55779], [-117.97762, 34.55779]]], [[[-117.97703, 34.55398], [-117.97702, 34.55468], [-117.97674, 34.55468], [-117.97674, 34.55398], [-117.97703, 34.55398]]], [[[-117.97925, 34.55142], [-117.97924, 34.55397], [-117.9775, 34.55397], [-117.97784, 34.55335], [-117.97825, 34.55333], [-117.97826, 34.55196], [-117.97891, 34.55196], [-117.97893, 34.55142], [-117.97925, 34.55142]]], [[[-117.98274, 34.56873], [-117.98274, 34.57055], [-117.98057, 34.57055], [-117.98056, 34.56872], [-117.98274, 34.56873]]], [[[-117.98816, 34.54299], [-117.98815, 34.54466], [-117.98593, 34.54468], [-117.98697, 34.54299], [-117.98816, 34.54299]]], [[[-117.9937, 34.58516], [-117.99369, 34.58699], [-117.99143, 34.58701], [-117.99144, 34.58518], [-117.9937, 34.58516]]], [[[-117.9969, 34.52998], [-117.9969, 34.52998], [-117.9963, 34.531], [-117.9963, 34.5301], [-117.99657, 34.53008], [-117.99657, 34.52938], [-117.9969, 34.52938], [-117.9969, 34.52998]]], [[[-118.02654, 34.50915], [-118.02654, 34.50999], [-118.02544, 34.51001], [-118.02544, 34.51093], [-118.02324, 34.51097], [-118.02324, 34.51373], [-118.00515, 34.51378], [-118.00508, 34.51374], [-118.00416, 34.51343], [-118.00236, 34.51343], [-118.00235, 34.51063], [-118.00105, 34.51062], [-118.00105, 34.51057], [-118.00563, 34.51018], [-118.00565, 34.51015], [-118.01886, 34.51011], [-118.02323, 34.51004], [-118.02325, 34.50919], [-118.02654, 34.50915]], [[-118.00564, 34.51222], [-118.00566, 34.51221], [-118.00565, 34.51197], [-118.00484, 34.51198], [-118.00564, 34.51222]]], [[[-118.00572, 34.52102], [-118.0025, 34.52103], [-118.0025, 34.51923], [-118.00233, 34.51921], [-118.00232, 34.51436], [-118.00261, 34.51433], [-118.00446, 34.51493], [-118.00467, 34.51559], [-118.00568, 34.516], [-118.00572, 34.52102]]], [[[-118.02763, 34.50795], [-118.02763, 34.50822], [-118.02325, 34.50828], [-118.02326, 34.508], [-118.02763, 34.50795]]]]} | No Public Access 3 | Little Rock Wash | 21356 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | http://www.lrcid.com/ | Special District 4 | 293.718 | Little Rock Wash | ||
6288 | 6288 | 6287 | {"type": "MultiPolygon", "coordinates": [[[[-117.90871, 34.53918], [-117.90871, 34.54011], [-117.9086, 34.54081], [-117.90748, 34.54082], [-117.90748, 34.53918], [-117.90871, 34.53918]]], [[[-117.94266, 34.53928], [-117.94156, 34.53928], [-117.94155, 34.53746], [-117.94265, 34.53746], [-117.94266, 34.53928]]], [[[-117.96331, 34.54305], [-117.96331, 34.54385], [-117.96252, 34.54385], [-117.96253, 34.54305], [-117.96331, 34.54305]]], [[[-117.976, 34.50296], [-117.97599, 34.50478], [-117.9749, 34.50478], [-117.97491, 34.50296], [-117.976, 34.50296]]], [[[-117.97928, 34.51891], [-117.97908, 34.51905], [-117.97879, 34.51923], [-117.97861, 34.51929], [-117.97826, 34.51953], [-117.97804, 34.51962], [-117.97781, 34.51968], [-117.97733, 34.51992], [-117.97708, 34.51998], [-117.97706, 34.51981], [-117.97663, 34.5198], [-117.97662, 34.52021], [-117.97538, 34.5207], [-117.97538, 34.52106], [-117.97504, 34.52106], [-117.97505, 34.52051], [-117.97508, 34.52049], [-117.97507, 34.52017], [-117.97516, 34.51847], [-117.97592, 34.5181], [-117.97708, 34.51764], [-117.97709, 34.51974], [-117.97726, 34.51971], [-117.97739, 34.51962], [-117.9777, 34.51949], [-117.97794, 34.51942], [-117.9781, 34.51934], [-117.97834, 34.51917], [-117.97866, 34.51903], [-117.97891, 34.51888], [-117.97927, 34.5186], [-117.97928, 34.51891]]], [[[-117.98817, 34.54292], [-117.98816, 34.54299], [-117.98697, 34.54299], [-117.98701, 34.54293], [-117.98817, 34.54292]]], [[[-117.98819, 34.51876], [-117.98807, 34.51874], [-117.98806, 34.51756], [-117.98818, 34.51757], [-117.98819, 34.51876]]], [[[-117.98918, 34.51959], [-117.98917, 34.52033], [-117.98818, 34.52034], [-117.98817, 34.51959], [-117.98918, 34.51959]]], [[[-117.99345, 34.51866], [-117.9926, 34.51867], [-117.9926, 34.51859], [-117.99345, 34.51858], [-117.99345, 34.51866]]], [[[-118.00126, 34.51466], [-118.00113, 34.51482], [-117.99999, 34.51573], [-117.99964, 34.51601], [-117.99931, 34.51622], [-117.999, 34.51647], [-117.99793, 34.51699], [-117.99728, 34.51737], [-117.99687, 34.51738], [-117.99687, 34.51762], [-117.99619, 34.51802], [-117.99619, 34.51812], [-117.99539, 34.51812], [-117.99567, 34.51801], [-117.9959, 34.51784], [-117.99623, 34.51736], [-117.99694, 34.51726], [-117.99844, 34.5166], [-118.00119, 34.51443], [-118.00126, 34.51442], [-118.00126, 34.51466]]], [[[-117.99539, 34.51812], [-117.99538, 34.51838], [-117.99482, 34.51855], [-117.99467, 34.51856], [-117.99466, 34.51864], [-117.99422, 34.51864], [-117.9942, 34.51856], [-117.99351, 34.51857], [-117.99421, 34.51848], [-117.99422, 34.51836], [-117.99455, 34.51835], [-117.99471, 34.51832], [-117.99539, 34.51812]]], [[[-118.01442, 34.52901], [-118.01285, 34.529], [-118.0123, 34.52821], [-118.01441, 34.52821], [-118.01442, 34.52901]]], [[[-118.01951, 34.5391], [-118.01951, 34.54001], [-118.01887, 34.54001], [-118.01886, 34.5391], [-118.01951, 34.5391]]]]} | No Public Access 3 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | http://www.lrcid.com/ | Special District 4 | 42.722 | Littlerock Creek Irrigation District OS |
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]);