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 = "Hungry Valley State Vehicular Recreation Area"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15312 | 15312 | 15311 | {"type": "MultiPolygon", "coordinates": [[[[-118.90833, 34.75578], [-118.9083, 34.75937], [-118.90814, 34.76695], [-118.89054, 34.76679], [-118.89034, 34.77424], [-118.89035, 34.77425], [-118.89925, 34.77435], [-118.89887, 34.78849], [-118.89887, 34.78888], [-118.90767, 34.78905], [-118.90757, 34.79947], [-118.89858, 34.79949], [-118.89846, 34.79591], [-118.89136, 34.7959], [-118.88535, 34.79582], [-118.88555, 34.79909], [-118.88536, 34.79876], [-118.88535, 34.79884], [-118.88907, 34.80651], [-118.88806, 34.80606], [-118.88781, 34.80598], [-118.88752, 34.80593], [-118.88714, 34.80592], [-118.88677, 34.80596], [-118.88644, 34.80604], [-118.88607, 34.80619], [-118.8858, 34.80636], [-118.88556, 34.80656], [-118.88536, 34.80678], [-118.88523, 34.80701], [-118.88516, 34.80715], [-118.88509, 34.80737], [-118.88481, 34.8087], [-118.88477, 34.8087], [-118.88447, 34.80799], [-118.88312, 34.80661], [-118.88249, 34.80636], [-118.88219, 34.80605], [-118.88186, 34.80577], [-118.8815, 34.80552], [-118.88116, 34.80531], [-118.87955, 34.8038], [-118.87846, 34.80199], [-118.87738, 34.80123], [-118.87604, 34.80114], [-118.87571, 34.80076], [-118.8758, 34.80033], [-118.87559, 34.80012], [-118.87541, 34.79989], [-118.87528, 34.79968], [-118.87524, 34.79808], [-118.87444, 34.79677], [-118.87419, 34.79655], [-118.87419, 34.79627], [-118.87362, 34.79611], [-118.87296, 34.79558], [-118.87222, 34.7953], [-118.87207, 34.79542], [-118.87213, 34.78866], [-118.87243, 34.78119], [-118.86356, 34.78121], [-118.86329, 34.7886], [-118.86323, 34.79271], [-118.85998, 34.79324], [-118.85989, 34.79501], [-118.85947, 34.79518], [-118.85717, 34.79492], [-118.85667, 34.79483], [-118.85623, 34.79471], [-118.85583, 34.79454], [-118.85532, 34.7943], [-118.85542, 34.79425], [-118.85516, 34.79412], [-118.85501, 34.79416], [-118.85459, 34.79396], [-118.85474, 34.79397], [-118.85475, 34.79395], [-118.85457, 34.79358], [-118.85504, 34.79356], [-118.85506, 34.79296], [-118.85586, 34.79296], [-118.8559, 34.79155], [-118.85588, 34.79153], [-118.85444, 34.79151], [-118.85442, 34.79202], [-118.85356, 34.79202], [-118.85354, 34.79293], [-118.85245, 34.79291], [-118.85236, 34.79292], [-118.85228, 34.79296], [-118.85222, 34.79301], [-118.85196, 34.79342], [-118.85094, 34.7934], [-118.84837, 34.79383], [-118.84804, 34.79386], [-118.84767, 34.79386], [-118.84763, 34.79408], [-118.84572, 34.79384], [-118.84319, 34.79342], [-118.84295, 34.79349], [-118.84019, 34.79315], [-118.83696, 34.79258], [-118.83608, 34.79225], [-118.83554, 34.79197], [-118.83551, 34.792], [-118.83503, 34.79172], [-118.83379, 34.79093], [-118.83277, 34.79007], [-118.83161, 34.78913], [-118.83015, 34.788], [-118.82933, 34.78739], [-118.82803, 34.78649], [-118.82678, 34.7857], [-118.82678, 34.78566], [-118.82565, 34.78499], [-118.82562, 34.78501], [-118.8103, 34.77584], [-118.80916, 34.77513], [-118.80775, 34.77416], [-118.80766, 34.77382], [-118.8072, 34.77335], [-118.8065, 34.77308], [-118.80575, 34.77254], [-118.8052, 34.77205], [-118.80506, 34.77178], [-118.80466, 34.77155], [-118.80412, 34.77096], [-118.80341, 34.7701], [-118.80273, 34.76912], [-118.80266, 34.76885], [-118.80238, 34.76864], [-118.80213, 34.76829], [-118.80218, 34.75975], [-118.80213, 34.75645], [-118.79681, 34.75363], [-118.79682, 34.75349], [-118.79674, 34.75331], [-118.79658, 34.75318], [-118.79656, 34.75293], [-118.79671, 34.75273], [-118.79658, 34.75251], [-118.80209, 34.75251], [-118.802, 34.74531], [-118.80253, 34.72968], [-118.80254, 34.72858], [-118.80265, 34.72857], [-118.80265, 34.72808], [-118.80275, 34.72806], [-118.80262, 34.7266], [-118.80267, 34.72657], [-118.8027, 34.72122], [-118.81143, 34.72129], [-118.81147, 34.71948], [-118.81146, 34.71946], [-118.80268, 34.71939], [-118.80264, 34.71921], [-118.80271, 34.71479], [-118.80491, 34.71481], [-118.8049, 34.71573], [-118.8071, 34.71575], [-118.80718, 34.71023], [-118.81154, 34.71022], [-118.81157, 34.71018], [-118.81157, 34.70831], [-118.81603, 34.70842], [-118.81823, 34.70845], [-118.81826, 34.70664], [-118.82107, 34.7067], [-118.82108, 34.70525], [-118.8242, 34.70448], [-118.82492, 34.70448], [-118.8249, 34.69953], [-118.82479, 34.69951], [-118.82479, 34.69946], [-118.83724, 34.69958], [-118.83819, 34.70155], [-118.83816, 34.70682], [-118.84077, 34.70687], [-118.8443, 34.71416], [-118.84811, 34.72162], [-118.84812, 34.72161], [-118.84447, 34.71406], [-118.86467, 34.7141], [-118.86466, 34.72136], [-118.87331, 34.7214], [-118.8733, 34.72327], [-118.87771, 34.72333], [-118.87772, 34.72691], [-118.88217, 34.72697], [-118.88218, 34.72876], [-118.88662, 34.72882], [-118.88664, 34.72524], [-118.89106, 34.72531], [-118.89106, 34.72709], [-118.88889, 34.72706], [-118.88887, 34.72708], [-118.88888, 34.72885], [-118.89107, 34.72888], [-118.89108, 34.73026], [-118.89094, 34.7411], [-118.89533, 34.74115], [-118.89532, 34.74296], [-118.89969, 34.743], [-118.89956, 34.7557], [-118.90833, 34.75578]]], [[[-118.92173, 34.72385], [-118.90654, 34.7237], [-118.90653, 34.72198], [-118.90425, 34.72195], [-118.90422, 34.72011], [-118.89984, 34.72009], [-118.89981, 34.71827], [-118.89105, 34.71824], [-118.89105, 34.72181], [-118.87775, 34.7215], [-118.87774, 34.71787], [-118.87331, 34.71774], [-118.87333, 34.7105], [-118.87775, 34.71062], [-118.87775, 34.71423], [-118.88217, 34.71437], [-118.88219, 34.71798], [-118.88659, 34.7181], [-118.8866, 34.71449], [-118.89103, 34.71461], [-118.8998, 34.71465], [-118.89983, 34.71646], [-118.90421, 34.71648], [-118.90422, 34.71828], [-118.90641, 34.7183], [-118.90643, 34.72011], [-118.90864, 34.72013], [-118.90868, 34.722], [-118.91079, 34.72201], [-118.91079, 34.72021], [-118.92171, 34.7202], [-118.92173, 34.72385]]]]} | Open Access 1 | Hungry Valley State Vehicular Recreation Area | http://www.parks.ca.gov/?page_id=405 | 1574 | 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 | 18818.611 | Hungry Valley SVRA | 1978 |
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]);