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 = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cache-Creek-WA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15330 | 15330 | 15329 | {"type": "MultiPolygon", "coordinates": [[[[-122.44583, 39.00798], [-122.44582, 39.00973], [-122.43674, 39.01018], [-122.43142, 39.0102], [-122.42821, 39.00889], [-122.42777, 39.00876], [-122.4276, 39.00872], [-122.42718, 39.00871], [-122.42583, 39.00871], [-122.42485, 39.00831], [-122.42455, 39.00857], [-122.42517, 39.00885], [-122.422, 39.00902], [-122.42096, 39.00905], [-122.42019, 39.0091], [-122.41908, 39.00907], [-122.41729, 39.00892], [-122.41631, 39.00887], [-122.41452, 39.00896], [-122.41405, 39.00904], [-122.41377, 39.00923], [-122.41346, 39.00951], [-122.41313, 39.00993], [-122.41294, 39.0102], [-122.41134, 39.0102], [-122.41132, 39.01022], [-122.41126, 39.01021], [-122.41135, 39.00996], [-122.41133, 39.00989], [-122.4112, 39.00979], [-122.41104, 39.00976], [-122.41051, 39.00957], [-122.41035, 39.00953], [-122.41013, 39.00941], [-122.41004, 39.00929], [-122.40987, 39.00863], [-122.40972, 39.00845], [-122.40961, 39.00838], [-122.40916, 39.00796], [-122.40883, 39.00773], [-122.40871, 39.00746], [-122.40876, 39.00701], [-122.40896, 39.00667], [-122.40909, 39.00657], [-122.4094, 39.00645], [-122.40961, 39.00623], [-122.40976, 39.00592], [-122.40991, 39.00583], [-122.41004, 39.00572], [-122.41044, 39.00548], [-122.41098, 39.00529], [-122.41163, 39.00512], [-122.41182, 39.00504], [-122.41199, 39.00501], [-122.41218, 39.00493], [-122.41248, 39.00465], [-122.4125, 39.0045], [-122.41236, 39.00436], [-122.41218, 39.00421], [-122.41184, 39.00399], [-122.4115, 39.00386], [-122.41133, 39.00374], [-122.41129, 39.00362], [-122.41124, 39.00338], [-122.41126, 39.00311], [-122.41121, 39.00293], [-122.41107, 39.00266], [-122.41107, 39.00248], [-122.4113, 39.00205], [-122.41148, 39.00186], [-122.41181, 39.00163], [-122.4121, 39.00136], [-122.41222, 39.00109], [-122.4122, 39.00079], [-122.41215, 39.00066], [-122.41207, 39.00057], [-122.41185, 39.0002], [-122.41218, 38.99961], [-122.4123, 38.99926], [-122.41235, 38.999], [-122.4123, 38.99878], [-122.41218, 38.99854], [-122.41218, 38.99836], [-122.41277, 38.99782], [-122.41322, 38.99763], [-122.41383, 38.99765], [-122.41397, 38.99763], [-122.41427, 38.99754], [-122.41486, 38.99743], [-122.41499, 38.99741], [-122.41515, 38.99742], [-122.41565, 38.99738], [-122.41572, 38.99735], [-122.41577, 38.99726], [-122.41576, 38.99698], [-122.42766, 38.99706], [-122.42763, 39.00457], [-122.43677, 39.00444], [-122.43677, 39.00826], [-122.44583, 39.00798]]], [[[-122.46419, 39.01359], [-122.46427, 39.01621], [-122.46412, 39.02103], [-122.45482, 39.02085], [-122.45487, 39.01329], [-122.46419, 39.01359]]], [[[-122.4656, 38.96147], [-122.46547, 38.96508], [-122.46539, 38.96791], [-122.46513, 38.97549], [-122.46059, 38.9754], [-122.46099, 38.96169], [-122.4656, 38.96147]]], [[[-122.49392, 38.97619], [-122.49408, 38.9797], [-122.49356, 38.98342], [-122.48827, 38.98358], [-122.48861, 38.97993], [-122.48318, 38.98013], [-122.47833, 38.98018], [-122.47837, 38.97662], [-122.48322, 38.9766], [-122.49392, 38.97619]]], [[[-122.54361, 38.9898], [-122.54238, 38.98931], [-122.54229, 38.9891], [-122.54194, 38.98897], [-122.54182, 38.98904], [-122.54026, 38.9884], [-122.54015, 38.98861], [-122.53855, 38.98865], [-122.5381, 38.98874], [-122.53689, 38.98903], [-122.5349, 38.98981], [-122.53182, 38.9912], [-122.52964, 38.99221], [-122.52748, 38.99326], [-122.52682, 38.99338], [-122.52474, 38.99365], [-122.52382, 38.9938], [-122.52351, 38.99387], [-122.52029, 38.99383], [-122.52044, 38.98659], [-122.52503, 38.98674], [-122.5251, 38.98319], [-122.52967, 38.98342], [-122.52974, 38.97996], [-122.52058, 38.97935], [-122.52049, 38.9755], [-122.52079, 38.97541], [-122.52098, 38.97526], [-122.52103, 38.97485], [-122.52096, 38.97459], [-122.52078, 38.97445], [-122.52046, 38.97434], [-122.52042, 38.97272], [-122.52095, 38.97247], [-122.52144, 38.97202], [-122.52143, 38.972], [-122.52039, 38.9719], [-122.50831, 38.97217], [-122.50775, 38.96507], [-122.5119, 38.96492], [-122.51213, 38.9685], [-122.52029, 38.96826], [-122.53456, 38.96971], [-122.53467, 38.96951], [-122.53478, 38.96942], [-122.53497, 38.96938], [-122.53542, 38.96933], [-122.53559, 38.96938], [-122.53574, 38.96946], [-122.53596, 38.96969], [-122.53626, 38.96977], [-122.53664, 38.96983], [-122.53722, 38.96997], [-122.53746, 38.97006], [-122.53768, 38.9701], [-122.53789, 38.97004], [-122.53808, 38.96995], [-122.53849, 38.96968], [-122.53878, 38.96943], [-122.53899, 38.96915], [-122.53915, 38.96875], [-122.53928, 38.96815], [-122.53953, 38.96719], [-122.53965, 38.96697], [-122.53987, 38.96677], [-122.54351, 38.96714], [-122.54349, 38.97409], [-122.53891, 38.97362], [-122.5389, 38.97706], [-122.5435, 38.97756], [-122.54347, 38.98104], [-122.54361, 38.9898]]]]} | Open Access 1 | Cache Creek Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cache-Creek-WA | 30420 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 2337.512 | Cache Creek Wildlife Area | 1988 |
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]);