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_NAME = "Pfeiffer Big Sur State Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
963 | 963 | 962 | {"type": "MultiPolygon", "coordinates": [[[[-121.79656, 36.26626], [-121.79216, 36.26624], [-121.79212, 36.26989], [-121.78772, 36.26982], [-121.7878, 36.2626], [-121.78776, 36.26259], [-121.78779, 36.25885], [-121.78335, 36.25879], [-121.78334, 36.25705], [-121.7833, 36.25703], [-121.78329, 36.25526], [-121.77448, 36.2551], [-121.77448, 36.24797], [-121.77009, 36.24791], [-121.77008, 36.25149], [-121.76567, 36.25144], [-121.76566, 36.24785], [-121.75684, 36.24773], [-121.75682, 36.24411], [-121.75237, 36.24415], [-121.75229, 36.237], [-121.75776, 36.23699], [-121.75776, 36.23851], [-121.76119, 36.23855], [-121.76122, 36.23347], [-121.7671, 36.23352], [-121.76723, 36.23376], [-121.76739, 36.23401], [-121.76767, 36.23458], [-121.76787, 36.23489], [-121.76838, 36.23558], [-121.76888, 36.2362], [-121.76898, 36.2363], [-121.76917, 36.23646], [-121.76939, 36.23662], [-121.77006, 36.23701], [-121.77066, 36.23741], [-121.77105, 36.23771], [-121.77156, 36.23815], [-121.77177, 36.2383], [-121.77216, 36.23851], [-121.77252, 36.23863], [-121.77136, 36.24075], [-121.77036, 36.24329], [-121.7701, 36.24434], [-121.77012, 36.24434], [-121.7704, 36.24328], [-121.7714, 36.24073], [-121.77256, 36.23862], [-121.77279, 36.23867], [-121.77331, 36.23873], [-121.7737, 36.2388], [-121.77409, 36.2389], [-121.77456, 36.23906], [-121.77457, 36.23921], [-121.77483, 36.23931], [-121.77566, 36.23967], [-121.77668, 36.24015], [-121.77709, 36.24036], [-121.77753, 36.24067], [-121.77766, 36.24085], [-121.77821, 36.24084], [-121.77803, 36.24076], [-121.77733, 36.24025], [-121.77799, 36.24029], [-121.7781, 36.24064], [-121.77851, 36.24087], [-121.78337, 36.24096], [-121.78334, 36.24473], [-121.78783, 36.24475], [-121.78783, 36.24821], [-121.78942, 36.24824], [-121.78943, 36.24911], [-121.79001, 36.24914], [-121.79002, 36.2496], [-121.7912, 36.24963], [-121.79122, 36.25005], [-121.79218, 36.25005], [-121.79223, 36.2589], [-121.79219, 36.25892], [-121.79215, 36.26259], [-121.79365, 36.26267], [-121.7941, 36.26266], [-121.79427, 36.26298], [-121.79483, 36.26389], [-121.7956, 36.26434], [-121.79643, 36.26447], [-121.79656, 36.26626]], [[-121.79313, 36.26575], [-121.79315, 36.26576], [-121.79318, 36.26548], [-121.79314, 36.26541], [-121.79313, 36.26575]]], [[[-121.77452, 36.23868], [-121.77451, 36.23896], [-121.77418, 36.23886], [-121.77418, 36.23886], [-121.77452, 36.23868]]], [[[-121.79658, 36.26261], [-121.79654, 36.26344], [-121.79657, 36.26428], [-121.79584, 36.26423], [-121.79556, 36.26367], [-121.79567, 36.26332], [-121.79552, 36.26289], [-121.79555, 36.26263], [-121.79658, 36.26261]]]]} | Open Access 1 | Pfeiffer Big Sur State Park | http://www.parks.ca.gov/default.asp?page_id=570 | 14088 | 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 | 1358.383 | Pfeiffer Big Sur SP | 1933 |
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]);