superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where LAYER = 2 and MNG_AGENCY = 643
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
411 | 411 | 410 | {"type": "Polygon", "coordinates": [[[-120.60826, 35.11002], [-120.60826, 35.1106], [-120.60753, 35.1106], [-120.60746, 35.11057], [-120.60745, 35.11003], [-120.60826, 35.11002]]]} | Open Access 1 | Costa Bella Park | 33486 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 1.155 | Costa Bella Park | ||
1074 | 1074 | 1073 | {"type": "Polygon", "coordinates": [[[-120.61198, 35.11407], [-120.61192, 35.1148], [-120.60972, 35.11469], [-120.60972, 35.11439], [-120.60966, 35.11409], [-120.61027, 35.11394], [-120.61038, 35.11396], [-120.6107, 35.11398], [-120.6107, 35.11401], [-120.61198, 35.11407]]]} | Open Access 1 | 16th Street Park | 15175 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 4.081 | 16th Street Park | ||
4643 | 4643 | 4642 | {"type": "Polygon", "coordinates": [[[-120.61047, 35.10757], [-120.61022, 35.10769], [-120.61023, 35.10811], [-120.61013, 35.10811], [-120.61013, 35.10769], [-120.60987, 35.10757], [-120.60988, 35.10752], [-120.60987, 35.10747], [-120.61013, 35.10735], [-120.61012, 35.10693], [-120.6102, 35.10693], [-120.61021, 35.10734], [-120.61047, 35.10746], [-120.61045, 35.10751], [-120.61047, 35.10757]]]} | Open Access 1 | Golden West Park | 19376 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 0.539 | Golden West Park | ||
4780 | 4780 | 4779 | {"type": "Polygon", "coordinates": [[[-120.62064, 35.12747], [-120.62062, 35.12788], [-120.62023, 35.12788], [-120.62022, 35.12806], [-120.61963, 35.12805], [-120.6196, 35.12831], [-120.61945, 35.12842], [-120.61927, 35.12849], [-120.61901, 35.12917], [-120.61815, 35.12891], [-120.61839, 35.12836], [-120.61837, 35.12795], [-120.61842, 35.12735], [-120.62064, 35.12747]]]} | Open Access 1 | Grover Heights Park | 19536 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 6.017 | Grover Heights Park | ||
5079 | 5079 | 5078 | {"type": "Polygon", "coordinates": [[[-120.61241, 35.11026], [-120.61236, 35.11057], [-120.61232, 35.11061], [-120.61228, 35.11061], [-120.61184, 35.11056], [-120.61162, 35.11056], [-120.61162, 35.11015], [-120.61204, 35.11017], [-120.61239, 35.11023], [-120.61241, 35.11026]]]} | Open Access 1 | Hero Community Park | 19875 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 0.77 | Hero Community Park | ||
5857 | 5857 | 5856 | {"type": "Polygon", "coordinates": [[[-120.61439, 35.11511], [-120.61433, 35.11594], [-120.61209, 35.11583], [-120.61214, 35.115], [-120.61439, 35.11511]]]} | Open Access 1 | Mentone Basin Park | 22157 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 4.654 | Mentone Basin Park | ||
8495 | 8495 | 8494 | {"type": "Polygon", "coordinates": [[[-120.62008, 35.12262], [-120.62005, 35.12313], [-120.61953, 35.12312], [-120.61949, 35.12374], [-120.619, 35.12372], [-120.61908, 35.12257], [-120.62008, 35.12262]]]} | Open Access 1 | Ramona Garden Park | 24113 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 2.058 | Ramona Garden Park | ||
9795 | 9795 | 9794 | {"type": "Polygon", "coordinates": [[[-120.61031, 35.12154], [-120.61029, 35.12194], [-120.60969, 35.12191], [-120.60971, 35.12151], [-120.61031, 35.12154]]]} | Open Access 1 | South County Skate Park | 25645 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 0.608 | South County Skate Park |
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]);