superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where AGNCY_WEB = "https://www.mariposacounty.org/index.aspx?NID=207" and MNG_AG_LEV = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2551 | 2551 | 2550 | {"type": "Polygon", "coordinates": [[[-120.19792, 37.71182], [-120.19757, 37.71212], [-120.19695, 37.7116], [-120.19711, 37.71145], [-120.19728, 37.71108], [-120.19792, 37.71182]]]} | Open Access 1 | Coulterville Park | 17693 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 1.108 | Coulterville Park | ||
2710 | 2710 | 2709 | {"type": "Polygon", "coordinates": [[[-120.08731, 37.43762], [-120.08619, 37.43839], [-120.08546, 37.43775], [-120.08551, 37.43708], [-120.0873, 37.43716], [-120.08731, 37.43762]]]} | Open Access 1 | Catheys Valley Park | 16977 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 4.04 | Catheys Valley Park | ||
5255 | 5255 | 5254 | {"type": "Polygon", "coordinates": [[[-120.23813, 37.50154], [-120.23784, 37.50158], [-120.23765, 37.50073], [-120.23789, 37.5007], [-120.23794, 37.50094], [-120.23797, 37.50095], [-120.23809, 37.50144], [-120.2381, 37.50145], [-120.23813, 37.50154]]]} | Open Access 1 | Hornitos Park | 20094 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 0.55 | Hornitos Park | ||
6685 | 6685 | 6684 | {"type": "Polygon", "coordinates": [[[-119.9714, 37.48113], [-119.97153, 37.48192], [-119.97136, 37.48254], [-119.97118, 37.48288], [-119.9704, 37.48403], [-119.96782, 37.48146], [-119.96715, 37.48176], [-119.96667, 37.48206], [-119.96618, 37.48252], [-119.96609, 37.48262], [-119.96527, 37.48336], [-119.96479, 37.48305], [-119.96404, 37.48223], [-119.9637, 37.48241], [-119.96364, 37.48222], [-119.96397, 37.48205], [-119.96427, 37.4817], [-119.96411, 37.48152], [-119.96543, 37.48071], [-119.96544, 37.48069], [-119.96395, 37.47936], [-119.96285, 37.47879], [-119.96107, 37.47861], [-119.96034, 37.47643], [-119.9654, 37.47635], [-119.96717, 37.47867], [-119.96701, 37.47956], [-119.96881, 37.48108], [-119.971, 37.48013], [-119.971, 37.4802], [-119.97087, 37.48104], [-119.9714, 37.48113]]]} | Open Access 1 | Mariposa Park | 21865 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 80.611 | Mariposa Park | ||
11390 | 11390 | 11389 | {"type": "Polygon", "coordinates": [[[-119.85082, 37.44887], [-119.85015, 37.4499], [-119.84984, 37.44973], [-119.84923, 37.44961], [-119.84861, 37.44946], [-119.84756, 37.44967], [-119.84741, 37.44969], [-119.84747, 37.44898], [-119.84763, 37.44739], [-119.84952, 37.44862], [-119.85082, 37.44887]]]} | Open Access 1 | Woodland Park | 27721 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 10.399 | Woodland Park | ||
13590 | 13590 | 13589 | {"type": "Polygon", "coordinates": [[[-120.10404, 37.44406], [-120.10403, 37.44496], [-120.10267, 37.44507], [-120.10278, 37.44409], [-120.10404, 37.44406]]]} | Open Access 1 | Catheys Valley Cemetery | 31064 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 2.969 | Catheys Valley Cemetery |
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]);