units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "840.334", DES_TP = 8 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15552 | 15552 | 15551 | {"type": "MultiPolygon", "coordinates": [[[[-122.72009, 38.37147], [-122.71926, 38.37177], [-122.71925, 38.37265], [-122.71699, 38.37267], [-122.71616, 38.37133], [-122.71645, 38.37127], [-122.7167, 38.37125], [-122.71693, 38.37125], [-122.72009, 38.37147]]], [[[-122.75284, 38.37969], [-122.75203, 38.38046], [-122.75178, 38.38073], [-122.75159, 38.38099], [-122.7507, 38.3824], [-122.75046, 38.38273], [-122.75017, 38.38308], [-122.74986, 38.3834], [-122.74958, 38.38365], [-122.74834, 38.38466], [-122.74804, 38.38488], [-122.74745, 38.38523], [-122.74682, 38.38552], [-122.74639, 38.38569], [-122.74587, 38.38585], [-122.74528, 38.38599], [-122.74416, 38.38618], [-122.74415, 38.38213], [-122.74624, 38.38209], [-122.74624, 38.37983], [-122.75284, 38.37969]]], [[[-122.75511, 38.38384], [-122.75511, 38.38384], [-122.74981, 38.38391], [-122.75018, 38.3836], [-122.7507, 38.38303], [-122.75099, 38.38264], [-122.75195, 38.38112], [-122.75212, 38.38088], [-122.75228, 38.38071], [-122.75262, 38.38041], [-122.75281, 38.38028], [-122.75306, 38.38016], [-122.75344, 38.38003], [-122.75368, 38.37999], [-122.75398, 38.37997], [-122.75502, 38.37994], [-122.75513, 38.38238], [-122.75511, 38.38384]]], [[[-122.75687, 38.40921], [-122.75684, 38.40955], [-122.75674, 38.41136], [-122.75668, 38.41162], [-122.75661, 38.41296], [-122.75641, 38.41295], [-122.75621, 38.41311], [-122.75615, 38.41401], [-122.75083, 38.41441], [-122.75048, 38.41153], [-122.75072, 38.4115], [-122.75071, 38.40963], [-122.75661, 38.40922], [-122.75664, 38.40878], [-122.75645, 38.40709], [-122.75657, 38.40708], [-122.75674, 38.40877], [-122.75675, 38.40921], [-122.75687, 38.40921]]], [[[-122.76305, 38.39085], [-122.75418, 38.39206], [-122.75418, 38.39561], [-122.75155, 38.39562], [-122.75155, 38.38709], [-122.75184, 38.38711], [-122.75394, 38.387], [-122.75341, 38.38771], [-122.75296, 38.38778], [-122.75275, 38.38798], [-122.75276, 38.38945], [-122.75329, 38.38955], [-122.75343, 38.38954], [-122.75517, 38.38984], [-122.75546, 38.38969], [-122.75586, 38.38943], [-122.75586, 38.3869], [-122.76093, 38.38661], [-122.76096, 38.38738], [-122.76115, 38.38738], [-122.76117, 38.38795], [-122.76199, 38.38795], [-122.762, 38.38784], [-122.76299, 38.38783], [-122.76305, 38.39085]]], [[[-122.7564, 38.40664], [-122.75588, 38.40668], [-122.75572, 38.40677], [-122.75516, 38.40681], [-122.75515, 38.40671], [-122.75479, 38.40667], [-122.75438, 38.40669], [-122.75437, 38.4067], [-122.75179, 38.40668], [-122.75179, 38.4065], [-122.75183, 38.40579], [-122.75607, 38.40552], [-122.75611, 38.40579], [-122.75629, 38.40579], [-122.7564, 38.40664]]], [[[-122.76189, 38.37549], [-122.76121, 38.37551], [-122.76121, 38.37608], [-122.76089, 38.37611], [-122.76074, 38.37614], [-122.76046, 38.37625], [-122.75908, 38.3772], [-122.75876, 38.37721], [-122.75873, 38.376], [-122.75635, 38.37603], [-122.75627, 38.37236], [-122.7542, 38.37239], [-122.75418, 38.37147], [-122.75623, 38.37144], [-122.75619, 38.36922], [-122.75637, 38.36921], [-122.75633, 38.36746], [-122.75408, 38.36747], [-122.75403, 38.36441], [-122.75402, 38.3644], [-122.75391, 38.36448], [-122.7539, 38.36312], [-122.75589, 38.36308], [-122.7561, 38.36294], [-122.75619, 38.36291], [-122.75621, 38.36301], [-122.75804, 38.36296], [-122.75843, 38.36376], [-122.75846, 38.36377], [-122.75853, 38.36632], [-122.75858, 38.36919], [-122.7586, 38.36954], [-122.75864, 38.37126], [-122.75872, 38.37501], [-122.76187, 38.37498], [-122.76189, 38.37549]]], [[[-122.75751, 38.40108], [-122.75671, 38.40118], [-122.75674, 38.4015], [-122.75637, 38.40154], [-122.75508, 38.40156], [-122.75506, 38.39923], [-122.75749, 38.3992], [-122.75751, 38.40108]]], [[[-122.76129, 38.37803], [-122.75889, 38.37806], [-122.75889, 38.37806], [-122.7589, 38.37792], [-122.75894, 38.37781], [-122.75901, 38.37768], [-122.75915, 38.37753], [-122.76066, 38.37647], [-122.76082, 38.37638], [-122.76096, 38.37633], [-122.76122, 38.37629], [-122.76129, 38.37803]]], [[[-122.76589, 38.47792], [-122.76578, 38.47792], [-122.76577, 38.47796], [-122.76491, 38.47796], [-122.7649, 38.47803], [-122.76287, 38.47803], [-122.76286, 38.47715], [-122.76287, 38.47624], [-122.76579, 38.47623], [-122.76579, 38.4778], [-122.76589, 38.47781], [-122.76589, 38.47792]]], [[[-122.76909, 38.39921], [-122.76909, 38.4004], [-122.76849, 38.40049], [-122.76789, 38.40183], [-122.76789, 38.40205], [-122.76738, 38.40205], [-122.76738, 38.4015], [-122.76694, 38.4015], [-122.76693, 38.40178], [-122.76735, 38.40179], [-122.76734, 38.40206], [-122.76672, 38.40206], [-122.76673, 38.39975], [-122.76909, 38.39921]]], [[[-122.77985, 38.38778], [-122.77867, 38.38851], [-122.77242, 38.38856], [-122.76953, 38.38618], [-122.7781, 38.38605], [-122.77985, 38.38778]]], [[[-122.77366, 38.39817], [-122.77366, 38.40077], [-122.77229, 38.40077], [-122.77228, 38.40227], [-122.77143, 38.40228], [-122.77143, 38.40341], [-122.77135, 38.40341], [-122.77135, 38.40123], [-122.77049, 38.40124], [-122.77049, 38.39889], [-122.77366, 38.39817]]], [[[-122.78171, 38.43789], [-122.78119, 38.43789], [-122.78118, 38.43515], [-122.78117, 38.43514], [-122.7811, 38.43515], [-122.78111, 38.43789], [-122.77983, 38.4379], [-122.77982, 38.43755], [-122.77906, 38.43754], [-122.77906, 38.43738], [-122.77884, 38.43738], [-122.77882, 38.4379], [-122.7744, 38.43793], [-122.7744, 38.4362], [-122.77447, 38.43619], [-122.77451, 38.43057], [-122.77141, 38.43056], [-122.77137, 38.42731], [-122.77252, 38.42587], [-122.77359, 38.42481], [-122.77382, 38.42464], [-122.77411, 38.42451], [-122.77447, 38.42443], [-122.77732, 38.42421], [-122.77734, 38.42578], [-122.77679, 38.42579], [-122.7768, 38.42637], [-122.77754, 38.42637], [-122.77754, 38.42599], [-122.77887, 38.42598], [-122.77886, 38.42798], [-122.77888, 38.43065], [-122.78168, 38.43066], [-122.78171, 38.43789]]], [[[-122.77884, 38.51847], [-122.77564, 38.51847], [-122.77563, 38.51795], [-122.77484, 38.51795], [-122.77483, 38.51746], [-122.77563, 38.51745], [-122.77563, 38.51709], [-122.77884, 38.51708], [-122.77884, 38.51847]]], [[[-122.77907, 38.47094], [-122.77901, 38.47094], [-122.77901, 38.47105], [-122.77722, 38.47106], [-122.77723, 38.47045], [-122.77906, 38.47047], [-122.77907, 38.47094]]], [[[-122.78767, 38.38685], [-122.78114, 38.38699], [-122.77999, 38.3877], [-122.77835, 38.38605], [-122.77932, 38.38603], [-122.7796, 38.386], [-122.77973, 38.38595], [-122.78764, 38.38579], [-122.78767, 38.38685]]], [[[-122.78111, 38.44116], [-122.77888, 38.44115], [-122.77886, 38.44013], [-122.77962, 38.44012], [-122.77965, 38.43807], [-122.78103, 38.43806], [-122.7811, 38.4381], [-122.78111, 38.44116]]], [[[-122.78177, 38.47439], [-122.77907, 38.47438], [-122.77903, 38.47268], [-122.77902, 38.47118], [-122.77959, 38.4717], [-122.77955, 38.47175], [-122.77964, 38.47213], [-122.77992, 38.47214], [-122.77991, 38.47219], [-122.77998, 38.47239], [-122.78013, 38.47239], [-122.78013, 38.47243], [-122.78028, 38.47247], [-122.78035, 38.47246], [-122.7806, 38.47221], [-122.78058, 38.47203], [-122.78066, 38.47202], [-122.78071, 38.47198], [-122.7807, 38.47154], [-122.78018, 38.47154], [-122.78018, 38.47162], [-122.77971, 38.47162], [-122.77958, 38.47159], [-122.77916, 38.47119], [-122.77916, 38.47096], [-122.78173, 38.47097], [-122.78177, 38.47439]]]]} | No Public Access 3 | 1044 | Santa Rosa Plain Vernal Pool Ecological Reserve | 32301 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sonoma 16 | 840.334 | Santa Rosa Plain Vernal Pool ER | 0 | State Conservation Area 8 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps(
id INT,
map,
ACCESS_TYP INT,
UNIT_ID INT,
UNIT_NAME TEXT,
SUID_NMA INT,
AGNCY_ID INT,
AGNCY_NAME INT,
AGNCY_LEV INT,
AGNCY_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
PARK_URL TEXT,
COUNTY INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
DES_TP INT,
GAP_STS TEXT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
ON [units_with_maps] ([ACCESS_TYP]);