superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "121.745" and MNG_AGENCY = 533
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9074 | 9074 | 9073 | {"type": "Polygon", "coordinates": [[[-121.2973, 38.77105], [-121.29627, 38.77371], [-121.29594, 38.77403], [-121.29577, 38.77402], [-121.29575, 38.77359], [-121.29542, 38.77352], [-121.29546, 38.77342], [-121.29591, 38.7732], [-121.29601, 38.77269], [-121.2955, 38.77257], [-121.29562, 38.77115], [-121.29349, 38.77107], [-121.29138, 38.77075], [-121.29084, 38.77092], [-121.29032, 38.77139], [-121.28966, 38.77214], [-121.28931, 38.77274], [-121.28892, 38.77308], [-121.28835, 38.77325], [-121.28818, 38.77293], [-121.28885, 38.77244], [-121.28935, 38.77178], [-121.28958, 38.77131], [-121.28809, 38.7716], [-121.2865, 38.77128], [-121.28652, 38.77291], [-121.28546, 38.77328], [-121.28462, 38.77144], [-121.28459, 38.76955], [-121.28436, 38.7693], [-121.28281, 38.77027], [-121.28139, 38.7708], [-121.28093, 38.77081], [-121.28071, 38.77166], [-121.28002, 38.77322], [-121.27909, 38.77296], [-121.27906, 38.77121], [-121.27965, 38.77107], [-121.27963, 38.76942], [-121.27856, 38.76711], [-121.27973, 38.76678], [-121.28008, 38.76721], [-121.28113, 38.76857], [-121.28131, 38.76955], [-121.28279, 38.76867], [-121.28443, 38.76812], [-121.28496, 38.76747], [-121.28522, 38.76753], [-121.28546, 38.76755], [-121.28633, 38.76749], [-121.28662, 38.7675], [-121.28693, 38.76756], [-121.28685, 38.76785], [-121.28844, 38.76817], [-121.29064, 38.76944], [-121.2926, 38.76935], [-121.29565, 38.76983], [-121.29572, 38.76949], [-121.29698, 38.76923], [-121.2973, 38.77105]]]} | Restricted Access 2 | Diamond Oaks Golf Course | 33092 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 121.745 | Diamond Oaks GC |
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]);