superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 47, MNG_AG_TYP = 5 and YR_EST = 1995
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 1 ✖
MNG_AGENCY 1
- California Department of Parks and Recreation · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15247 | 15247 | 15246 | {"type": "Polygon", "coordinates": [[[-121.24767, 37.02874], [-121.24749, 37.0291], [-121.24733, 37.02931], [-121.24721, 37.02953], [-121.24716, 37.02987], [-121.24716, 37.03018], [-121.2471, 37.03052], [-121.24709, 37.03075], [-121.24719, 37.03098], [-121.24723, 37.03124], [-121.247, 37.0312], [-121.24675, 37.03111], [-121.24648, 37.03093], [-121.24615, 37.0308], [-121.24523, 37.03065], [-121.2448, 37.03054], [-121.24436, 37.03046], [-121.2436, 37.03034], [-121.24324, 37.03041], [-121.24278, 37.03062], [-121.24245, 37.0307], [-121.2422, 37.03073], [-121.24194, 37.0307], [-121.24136, 37.03053], [-121.24101, 37.03053], [-121.24059, 37.03064], [-121.2402, 37.03077], [-121.23967, 37.03097], [-121.23937, 37.03101], [-121.23892, 37.03125], [-121.23853, 37.03152], [-121.23853, 37.03167], [-121.23869, 37.0319], [-121.23879, 37.03214], [-121.23882, 37.03234], [-121.23878, 37.0325], [-121.23865, 37.03269], [-121.23852, 37.03292], [-121.23835, 37.03313], [-121.23808, 37.03333], [-121.23785, 37.03339], [-121.23766, 37.03334], [-121.23711, 37.03401], [-121.23685, 37.03435], [-121.23658, 37.03483], [-121.23627, 37.03515], [-121.23602, 37.03569], [-121.2354, 37.03583], [-121.23522, 37.03606], [-121.23511, 37.03633], [-121.23515, 37.03661], [-121.23507, 37.03683], [-121.23492, 37.037], [-121.23475, 37.03748], [-121.23465, 37.03768], [-121.23454, 37.0378], [-121.23436, 37.03814], [-121.23415, 37.0386], [-121.23381, 37.03898], [-121.23345, 37.03952], [-121.2334, 37.04033], [-121.23349, 37.04072], [-121.23344, 37.04096], [-121.23345, 37.04126], [-121.23328, 37.04219], [-121.23345, 37.04254], [-121.23314, 37.04278], [-121.23304, 37.04302], [-121.23305, 37.04304], [-121.23321, 37.04307], [-121.23275, 37.04401], [-121.23283, 37.04419], [-121.233, 37.04436], [-121.23277, 37.04481], [-121.23276, 37.04488], [-121.23269, 37.0449], [-121.2327, 37.04513], [-121.23318, 37.04548], [-121.2329, 37.04602], [-121.23288, 37.04618], [-121.23264, 37.04645], [-121.2324, 37.04662], [-121.232, 37.047], [-121.23222, 37.04738], [-121.23243, 37.04765], [-121.23241, 37.0479], [-121.23229, 37.04798], [-121.23205, 37.04822], [-121.232, 37.04837], [-121.23203, 37.04871], [-121.23184, 37.0489], [-121.23174, 37.04904], [-121.23152, 37.04946], [-121.23146, 37.04969], [-121.23145, 37.04985], [-121.23149, 37.05025], [-121.23112, 37.05056], [-121.23066, 37.05101], [-121.23029, 37.05146], [-121.23018, 37.05165], [-121.23016, 37.0518], [-121.23005, 37.05207], [-121.22962, 37.05249], [-121.22945, 37.05296], [-121.22955, 37.05327], [-121.22959, 37.05345], [-121.22947, 37.05378], [-121.22894, 37.05423], [-121.22866, 37.0545], [-121.22835, 37.05476], [-121.2282, 37.05493], [-121.22791, 37.05517], [-121.2276, 37.05546], [-121.22752, 37.05564], [-121.22672, 37.05642], [-121.22674, 37.05655], [-121.22672, 37.05666], [-121.22659, 37.05689], [-121.22619, 37.05734], [-121.22581, 37.05765], [-121.2258, 37.058], [-121.22584, 37.05818], [-121.2258, 37.05836], [-121.22557, 37.0587], [-121.22542, 37.05942], [-121.22524, 37.05983], [-121.22507, 37.05995], [-121.22474, 37.06007], [-121.22389, 37.06067], [-121.22353, 37.06103], [-121.22346, 37.06105], [-121.22294, 37.06111], [-121.22272, 37.06107], [-121.2222, 37.06102], [-121.22192, 37.06094], [-121.22148, 37.06096], [-121.22001, 37.06204], [-121.21786, 37.06302], [-121.21504, 37.06352], [-121.21232, 37.06395], [-121.21001, 37.06398], [-121.20923, 37.06333], [-121.20857, 37.06259], [-121.20831, 37.06137], [-121.2083, 37.06136], [-121.20827, 37.06144], [-121.20823, 37.06176], [-121.20828, 37.06197], [-121.20861, 37.06281], [-121.20881, 37.06309], [-121.20916, 37.06334], [-121.20955, 37.06375], [-121.20968, 37.06396], [-121.20976, 37.06421], [-121.20979, 37.06454], [-121.20706, 37.06371], [-121.20641, 37.06313], [-121.20424, 37.06261], [-121.20272, 37.0635], [-121.20001, 37.06717], [-121.19974, 37.06745], [-121.19953, 37.06761], [-121.1993, 37.06774], [-121.19892, 37.06791], [-121.19891, 37.06794], [-121.19864, 37.06801], [-121.19835, 37.06806], [-121.19791, 37.06809], [-121.19762, 37.06807], [-121.19733, 37.06803], [-121.19691, 37.06791], [-121.19665, 37.0678], [-121.19086, 37.06509], [-121.18861, 37.06492], [-121.18034, 37.06489], [-121.18146, 37.06108], [-121.1711, 37.05619], [-121.16075, 37.06456], [-121.15771, 37.06392], [-121.15086, 37.05868], [-121.15204, 37.05086], [-121.14979, 37.04878], [-121.15146, 37.04332], [-121.15649, 37.03963], [-121.15055, 37.03862], [-121.15258, 37.03435], [-121.16257, 37.03298], [-121.16717, 37.03231], [-121.17106, 37.03178], [-121.18964, 37.02908], [-121.199, 37.02774], [-121.21722, 37.02522], [-121.23513, 37.02232], [-121.24262, 37.02113], [-121.24281, 37.02115], [-121.24315, 37.02143], [-121.24338, 37.02165], [-121.24358, 37.02193], [-121.24375, 37.02215], [-121.24397, 37.02227], [-121.24409, 37.02251], [-121.24419, 37.02276], [-121.24506, 37.02334], [-121.24539, 37.02349], [-121.24577, 37.02358], [-121.246, 37.02367], [-121.24635, 37.02413], [-121.24643, 37.0244], [-121.24644, 37.02465], [-121.24642, 37.02494], [-121.24667, 37.02512], [-121.24673, 37.02526], [-121.24715, 37.02604], [-121.24738, 37.02631], [-121.24749, 37.02652], [-121.24751, 37.02673], [-121.24744, 37.02699], [-121.24739, 37.02755], [-121.2474, 37.02785], [-121.2475, 37.02833], [-121.24764, 37.02851], [-121.24767, 37.02874]], [[-121.2005, 37.06117], [-121.20046, 37.06115], [-121.20045, 37.06118], [-121.20049, 37.06119], [-121.2005, 37.06117]], [[-121.20902, 37.05883], [-121.20901, 37.05882], [-121.20898, 37.05886], [-121.20895, 37.05904], [-121.20896, 37.05904], [-121.20902, 37.05883]], [[-121.21104, 37.05641], [-121.21103, 37.0564], [-121.21095, 37.05645], [-121.21086, 37.0566], [-121.21104, 37.05641]], [[-121.21464, 37.05599], [-121.21465, 37.05598], [-121.21443, 37.05569], [-121.21418, 37.05551], [-121.21394, 37.05546], [-121.21441, 37.05596], [-121.21464, 37.05599]], [[-121.21934, 37.0543], [-121.21935, 37.05428], [-121.21899, 37.0541], [-121.21882, 37.05415], [-121.21841, 37.05434], [-121.21786, 37.05447], [-121.21757, 37.05472], [-121.21706, 37.05522], [-121.21708, 37.05522], [-121.21762, 37.05478], [-121.2189, 37.05416], [-121.21934, 37.0543]], [[-121.2221, 37.03951], [-121.22208, 37.0395], [-121.22197, 37.03996], [-121.22205, 37.04039], [-121.22212, 37.04049], [-121.22213, 37.04048], [-121.2221, 37.03951]], [[-121.22292, 37.03722], [-121.22292, 37.0372], [-121.22279, 37.03722], [-121.22243, 37.03731], [-121.22211, 37.0375], [-121.22201, 37.03764], [-121.22292, 37.03722]], [[-121.22233, 37.04184], [-121.22231, 37.04184], [-121.22232, 37.04203], [-121.2224, 37.0421], [-121.22241, 37.04209], [-121.22233, 37.04184]], [[-121.22333, 37.04608], [-121.22322, 37.04628], [-121.22319, 37.04646], [-121.22332, 37.04669], [-121.22368, 37.047], [-121.22369, 37.04699], [-121.22342, 37.04609], [-121.2231, 37.04461], [-121.22301, 37.04504], [-121.22324, 37.04548], [-121.22333, 37.04608]], [[-121.2239, 37.0523], [-121.22389, 37.05229], [-121.22379, 37.05237], [-121.22378, 37.05245], [-121.22379, 37.05245], [-121.2239, 37.0523]], [[-121.22391, 37.04873], [-121.22389, 37.04874], [-121.22389, 37.04877], [-121.22395, 37.04903], [-121.22415, 37.04935], [-121.2244, 37.04951], [-121.22391, 37.04873]], [[-121.22419, 37.03684], [-121.22419, 37.03682], [-121.22404, 37.03685], [-121.22397, 37.03689], [-121.22419, 37.03684]], [[-121.2343, 37.03511], [-121.2343, 37.03509], [-121.23424, 37.03509], [-121.23382, 37.03509], [-121.23334, 37.03512], [-121.23298, 37.03523], [-121.23279, 37.03538], [-121.23281, 37.03538], [-121.23303, 37.03524], [-121.2343, 37.03511]], [[-121.23616, 37.03265], [-121.23614, 37.03264], [-121.236, 37.03275], [-121.23591, 37.033], [-121.23601, 37.03337], [-121.23616, 37.03265]], [[-121.23717, 37.03296], [-121.23718, 37.03294], [-121.23689, 37.03264], [-121.23665, 37.03256], [-121.23639, 37.03255], [-121.23637, 37.03256], [-121.23717, 37.03296]]]} | Open Access 1 | Pacheco State Park | http://www.parks.ca.gov/?page_id=560 | 1668 | 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 | 6940.929 | Pacheco SP | 1995 |
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]);