superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=527"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15133 | 15133 | 15132 | {"type": "Polygon", "coordinates": [[[-122.41813, 37.23992], [-122.41776, 37.24008], [-122.41606, 37.23789], [-122.41585, 37.23754], [-122.41567, 37.23712], [-122.41557, 37.23674], [-122.41535, 37.23501], [-122.41527, 37.23464], [-122.41517, 37.23428], [-122.41504, 37.23392], [-122.41484, 37.23345], [-122.4146, 37.233], [-122.41432, 37.23256], [-122.41393, 37.23205], [-122.4075, 37.22442], [-122.40639, 37.22258], [-122.40636, 37.22193], [-122.40652, 37.22192], [-122.40646, 37.22137], [-122.40868, 37.22129], [-122.40872, 37.22138], [-122.40884, 37.22148], [-122.40885, 37.22162], [-122.40894, 37.22173], [-122.40896, 37.22187], [-122.40884, 37.22197], [-122.40875, 37.22208], [-122.4089, 37.22233], [-122.40902, 37.22244], [-122.40895, 37.22256], [-122.40885, 37.22267], [-122.40895, 37.22279], [-122.40905, 37.22306], [-122.40918, 37.22315], [-122.40922, 37.22328], [-122.40932, 37.2234], [-122.40947, 37.22347], [-122.40999, 37.22349], [-122.41014, 37.22355], [-122.41027, 37.22365], [-122.41032, 37.22378], [-122.41026, 37.22405], [-122.4104, 37.22412], [-122.41048, 37.22425], [-122.41062, 37.22433], [-122.4106, 37.22447], [-122.41049, 37.22458], [-122.41015, 37.22463], [-122.41005, 37.22474], [-122.40988, 37.22472], [-122.40959, 37.22457], [-122.40942, 37.2246], [-122.40937, 37.22473], [-122.40933, 37.22486], [-122.40924, 37.22499], [-122.40919, 37.22512], [-122.40925, 37.2254], [-122.40932, 37.22552], [-122.40942, 37.22579], [-122.40952, 37.2259], [-122.40957, 37.22604], [-122.40981, 37.22624], [-122.40995, 37.22632], [-122.41012, 37.22636], [-122.41027, 37.22642], [-122.41044, 37.22645], [-122.41078, 37.22641], [-122.41081, 37.22642], [-122.41092, 37.22641], [-122.41105, 37.22633], [-122.41112, 37.22634], [-122.41123, 37.22631], [-122.41135, 37.22631], [-122.41135, 37.22633], [-122.4114, 37.22633], [-122.41152, 37.22643], [-122.41155, 37.22655], [-122.4115, 37.22669], [-122.41138, 37.22677], [-122.41137, 37.22687], [-122.41145, 37.22695], [-122.41128, 37.227], [-122.41116, 37.22697], [-122.41102, 37.22697], [-122.41089, 37.22699], [-122.41077, 37.22704], [-122.41067, 37.22711], [-122.41063, 37.22722], [-122.41079, 37.2273], [-122.41075, 37.2274], [-122.41085, 37.22748], [-122.41096, 37.2275], [-122.41106, 37.22746], [-122.41117, 37.22736], [-122.41138, 37.22738], [-122.41145, 37.22745], [-122.41157, 37.22754], [-122.41171, 37.22772], [-122.41169, 37.22784], [-122.41156, 37.22786], [-122.41147, 37.22779], [-122.41125, 37.2277], [-122.41113, 37.22764], [-122.411, 37.22767], [-122.41094, 37.22782], [-122.41102, 37.22793], [-122.41115, 37.228], [-122.41128, 37.22809], [-122.41131, 37.22823], [-122.41163, 37.22839], [-122.41188, 37.22859], [-122.41203, 37.22865], [-122.41215, 37.22875], [-122.41243, 37.22891], [-122.41252, 37.22904], [-122.41273, 37.22926], [-122.4128, 37.22938], [-122.41292, 37.22948], [-122.41321, 37.22982], [-122.41327, 37.22995], [-122.4133, 37.23009], [-122.41353, 37.23029], [-122.41369, 37.23035], [-122.41377, 37.23047], [-122.41395, 37.2307], [-122.41396, 37.23084], [-122.41398, 37.23097], [-122.41393, 37.23125], [-122.41397, 37.23139], [-122.41396, 37.23144], [-122.41398, 37.23158], [-122.4141, 37.23167], [-122.41438, 37.23184], [-122.41449, 37.23195], [-122.41462, 37.23204], [-122.41477, 37.23212], [-122.41482, 37.23226], [-122.41513, 37.23258], [-122.41522, 37.2327], [-122.41539, 37.23273], [-122.41554, 37.23266], [-122.41572, 37.23265], [-122.41589, 37.23267], [-122.41603, 37.23278], [-122.4161, 37.23288], [-122.416, 37.23295], [-122.41591, 37.23307], [-122.41574, 37.23311], [-122.4156, 37.23319], [-122.41556, 37.23332], [-122.41556, 37.23345], [-122.41566, 37.23372], [-122.41583, 37.23396], [-122.41594, 37.23408], [-122.41593, 37.23422], [-122.4159, 37.23435], [-122.41595, 37.23449], [-122.4161, 37.23473], [-122.41615, 37.23487], [-122.41616, 37.23501], [-122.41622, 37.23529], [-122.41628, 37.23541], [-122.41647, 37.23565], [-122.41659, 37.23576], [-122.41657, 37.23589], [-122.41651, 37.23602], [-122.41653, 37.23615], [-122.41641, 37.23626], [-122.41626, 37.2362], [-122.41612, 37.23629], [-122.41608, 37.23642], [-122.41603, 37.23669], [-122.41606, 37.23683], [-122.41611, 37.23696], [-122.41621, 37.23708], [-122.41628, 37.23721], [-122.41648, 37.23743], [-122.41662, 37.23768], [-122.4167, 37.23796], [-122.41676, 37.23808], [-122.41688, 37.23819], [-122.41701, 37.23829], [-122.41711, 37.23841], [-122.41713, 37.23855], [-122.41734, 37.23877], [-122.41738, 37.2389], [-122.41747, 37.23902], [-122.41769, 37.2394], [-122.41793, 37.2396], [-122.4181, 37.23985], [-122.41813, 37.23992]]]} | Open Access 1 | Bean Hollow State Beach | http://www.parks.ca.gov/?page_id=527 | 1429 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 54.585 | Bean Hollow SB | 1969 |
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]);