superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 2, MNG_AG_LEV = 4 and MNG_AG_TYP = 30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3728 | 3728 | 3727 | {"type": "MultiPolygon", "coordinates": [[[[-118.00813, 34.04674], [-118.00572, 34.05101], [-118.00492, 34.05209], [-118.0047, 34.05243], [-118.0044, 34.0526], [-118.00459, 34.05168], [-118.00482, 34.05171], [-118.00497, 34.05149], [-118.00512, 34.0508], [-118.00515, 34.05058], [-118.00476, 34.0505], [-118.0049, 34.04995], [-118.0053, 34.05002], [-118.00522, 34.05038], [-118.00569, 34.05046], [-118.0062, 34.04859], [-118.00572, 34.04847], [-118.00597, 34.04755], [-118.00643, 34.04763], [-118.00676, 34.04715], [-118.00675, 34.0471], [-118.00614, 34.04697], [-118.00621, 34.04672], [-118.00813, 34.04674]]], [[[-118.00544, 34.05569], [-118.00531, 34.05604], [-118.00476, 34.05566], [-118.00479, 34.05563], [-118.00491, 34.05568], [-118.00516, 34.05571], [-118.00544, 34.05569]]], [[[-118.01108, 34.04633], [-118.01063, 34.04682], [-118.01023, 34.0473], [-118.00996, 34.04766], [-118.00948, 34.04832], [-118.00896, 34.04912], [-118.00849, 34.04996], [-118.00809, 34.05077], [-118.00783, 34.05135], [-118.00756, 34.05208], [-118.00753, 34.05213], [-118.00733, 34.05273], [-118.00733, 34.05252], [-118.00732, 34.05251], [-118.00646, 34.054], [-118.0063, 34.05548], [-118.00608, 34.05535], [-118.00619, 34.05523], [-118.00629, 34.055], [-118.00632, 34.05481], [-118.0063, 34.05458], [-118.00622, 34.05439], [-118.00584, 34.0537], [-118.00577, 34.05354], [-118.00572, 34.05337], [-118.00571, 34.05316], [-118.00576, 34.05288], [-118.00613, 34.05187], [-118.00634, 34.05139], [-118.00709, 34.04998], [-118.00954, 34.04563], [-118.00963, 34.04567], [-118.00967, 34.04563], [-118.01026, 34.04597], [-118.00951, 34.04673], [-118.00951, 34.04682], [-118.01046, 34.04607], [-118.01087, 34.0463], [-118.01098, 34.04633], [-118.01108, 34.04633]]], [[[-118.01723, 34.04177], [-118.01626, 34.04227], [-118.01533, 34.04283], [-118.01464, 34.04327], [-118.0137, 34.04395], [-118.01315, 34.04438], [-118.01261, 34.04483], [-118.01196, 34.04542], [-118.01122, 34.04617], [-118.01112, 34.0462], [-118.01097, 34.0462], [-118.01088, 34.04618], [-118.01064, 34.04602], [-118.01055, 34.04599], [-118.01434, 34.04296], [-118.01443, 34.04302], [-118.01471, 34.04276], [-118.01723, 34.04177]]], [[[-118.02425, 34.03824], [-118.01421, 34.04219], [-118.01399, 34.04191], [-118.02388, 34.03802], [-118.02425, 34.03824]]], [[[-118.02362, 34.03786], [-118.02295, 34.03812], [-118.02142, 34.03872], [-118.02185, 34.03848], [-118.02227, 34.03822], [-118.02267, 34.03795], [-118.02315, 34.03758], [-118.02362, 34.03786]]]]} | Restricted Access 2 | Duck Farm Property | 18295 | 2177 | Watershed Conservation Authority 838 | Special District 4 | Conservation District 30 | https://www.wca.ca.gov/ | Special District 4 | 59.901 | Duck Farm Property | ||
7992 | 7992 | 7991 | {"type": "Polygon", "coordinates": [[[-118.17772, 33.93261], [-118.1772, 33.93362], [-118.17654, 33.93439], [-118.17624, 33.93465], [-118.17643, 33.93339], [-118.17627, 33.93335], [-118.17638, 33.93265], [-118.17663, 33.93236], [-118.17674, 33.93177], [-118.17687, 33.93092], [-118.177, 33.93101], [-118.1771, 33.93112], [-118.17768, 33.93213], [-118.17772, 33.93261]]]} | Restricted Access 2 | Parque Dos Rios | 23480 | 2177 | Watershed Conservation Authority 838 | Special District 4 | Conservation District 30 | https://www.wca.ca.gov/ | Special District 4 | 7.012 | Parque Dos Rios | ||
14959 | 14959 | 14958 | {"type": "Polygon", "coordinates": [[[-117.8387, 34.08748], [-117.83646, 34.08843], [-117.83671, 34.08887], [-117.83579, 34.08925], [-117.83468, 34.0888], [-117.83421, 34.08815], [-117.8299, 34.08931], [-117.82966, 34.08906], [-117.82897, 34.08923], [-117.82825, 34.08925], [-117.82779, 34.09009], [-117.82414, 34.09106], [-117.82236, 34.0914], [-117.82146, 34.09037], [-117.82932, 34.08826], [-117.82932, 34.08848], [-117.82926, 34.08877], [-117.82967, 34.08891], [-117.82981, 34.08892], [-117.82997, 34.08875], [-117.83024, 34.08881], [-117.83059, 34.08863], [-117.83098, 34.08845], [-117.83139, 34.08831], [-117.83181, 34.08819], [-117.83225, 34.08809], [-117.83269, 34.08803], [-117.83313, 34.08799], [-117.83349, 34.08798], [-117.83349, 34.08776], [-117.83355, 34.08758], [-117.83341, 34.08717], [-117.83793, 34.08595], [-117.8387, 34.08748]]]} | Restricted Access 2 | Walnut Creek Habitat & Open Space | 27225 | 2177 | Watershed Conservation Authority 838 | Special District 4 | Conservation District 30 | https://www.wca.ca.gov/ | Special District 4 | 53.644 | Walnut Creek Habitat & 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]);