superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
47 rows where MNG_AGENCY = 393 and MNG_AG_TYP = 3 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5727 | 5727 | 5726 | {"type": "Polygon", "coordinates": [[[-118.42526, 35.75506], [-118.42503, 35.75558], [-118.42496, 35.7556], [-118.42486, 35.75555], [-118.42471, 35.75542], [-118.42471, 35.75535], [-118.42484, 35.75527], [-118.42491, 35.75524], [-118.42512, 35.75508], [-118.42521, 35.75502], [-118.42526, 35.75506]]]} | Open Access 1 | Kernville Circle Park | 20633 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 0.366 | Kernville Circle Park | ||
11354 | 11354 | 11353 | {"type": "Polygon", "coordinates": [[[-118.45085, 35.70526], [-118.45085, 35.70564], [-118.44921, 35.70566], [-118.44923, 35.7053], [-118.44956, 35.70551], [-118.44985, 35.70537], [-118.45017, 35.70539], [-118.4505, 35.70526], [-118.45085, 35.70526]]]} | Open Access 1 | Wofford Heights Park | 27667 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 1.188 | Wofford Heights Park | ||
7662 | 7662 | 7661 | {"type": "Polygon", "coordinates": [[[-118.47884, 35.13979], [-118.4787, 35.14035], [-118.47877, 35.14051], [-118.47839, 35.14065], [-118.47798, 35.13995], [-118.4781, 35.13977], [-118.47884, 35.13979]]]} | Open Access 1 | Old Tehachapi Cemetery | 23105 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 1.254 | Old Tehachapi Cemetery | ||
11226 | 11226 | 11225 | {"type": "MultiPolygon", "coordinates": [[[[-118.98711, 35.39927], [-118.98684, 35.3994], [-118.98655, 35.39957], [-118.98635, 35.39972], [-118.98615, 35.39991], [-118.98585, 35.40027], [-118.98555, 35.40075], [-118.9855, 35.40088], [-118.98539, 35.40101], [-118.98536, 35.40068], [-118.98556, 35.40034], [-118.98569, 35.40016], [-118.98608, 35.39972], [-118.98632, 35.39951], [-118.98672, 35.39927], [-118.98687, 35.3992], [-118.98711, 35.39927]]], [[[-118.98751, 35.39909], [-118.98751, 35.39909], [-118.9873, 35.39905], [-118.98737, 35.39902], [-118.98751, 35.39901], [-118.98751, 35.39909]]], [[[-118.98934, 35.39916], [-118.98906, 35.39912], [-118.9887, 35.39911], [-118.98774, 35.3991], [-118.98773, 35.39899], [-118.98864, 35.39891], [-118.98896, 35.39886], [-118.98915, 35.39881], [-118.98931, 35.39906], [-118.98934, 35.39916]]]]} | Open Access 1 | Wilkins Park | 27527 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 1.874 | Wilkins Park | ||
4301 | 4301 | 4300 | {"type": "Polygon", "coordinates": [[[-117.81518, 35.64364], [-117.81517, 35.64457], [-117.814, 35.64459], [-117.81395, 35.64367], [-117.81518, 35.64364]]]} | Open Access 1 | Inyokern Park | 20225 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 2.762 | Inyokern Park | ||
9404 | 9404 | 9403 | {"type": "Polygon", "coordinates": [[[-118.22001, 35.69046], [-118.21999, 35.69219], [-118.21919, 35.69218], [-118.21924, 35.69048], [-118.22001, 35.69046]]]} | Open Access 1 | Scodie Park | 25200 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 3.31 | Scodie Park | ||
7552 | 7552 | 7551 | {"type": "Polygon", "coordinates": [[[-118.71748, 35.7406], [-118.71739, 35.74167], [-118.71616, 35.74208], [-118.71604, 35.74172], [-118.71606, 35.74166], [-118.71616, 35.74142], [-118.7163, 35.74117], [-118.71656, 35.74078], [-118.71668, 35.74063], [-118.71748, 35.7406]]]} | Open Access 1 | Oak Grove Cemetery | 22970 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 3.555 | Oak Grove Cemetery | ||
8787 | 8787 | 8786 | {"type": "Polygon", "coordinates": [[[-118.42497, 35.75299], [-118.42497, 35.75303], [-118.42462, 35.75326], [-118.42442, 35.75341], [-118.42419, 35.75362], [-118.42398, 35.75384], [-118.42373, 35.75418], [-118.42356, 35.75449], [-118.42343, 35.75481], [-118.42332, 35.7552], [-118.42327, 35.75522], [-118.42306, 35.75522], [-118.42305, 35.75504], [-118.42321, 35.75489], [-118.42336, 35.7547], [-118.42351, 35.75446], [-118.42365, 35.75417], [-118.42384, 35.75362], [-118.42392, 35.75343], [-118.424, 35.75312], [-118.42397, 35.7527], [-118.42383, 35.75239], [-118.4238, 35.7521], [-118.42369, 35.75164], [-118.42424, 35.75165], [-118.42452, 35.75211], [-118.42497, 35.75299]]]} | Open Access 1 | Riverside Park | 24454 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 4.265 | Riverside Park | ||
8317 | 8317 | 8316 | {"type": "Polygon", "coordinates": [[[-118.9552, 35.36322], [-118.95519, 35.36495], [-118.95419, 35.36495], [-118.95421, 35.36364], [-118.9542, 35.36322], [-118.9552, 35.36322]]]} | Open Access 1 | Potomac Park | 23919 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 4.279 | Potomac Park | ||
8651 | 8651 | 8650 | {"type": "Polygon", "coordinates": [[[-118.99753, 35.3014], [-118.99752, 35.30301], [-118.99641, 35.30301], [-118.99643, 35.3014], [-118.99753, 35.3014]]]} | Open Access 1 | Rexland Acres Park | 24308 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 4.446 | Rexland Acres Park | ||
11804 | 11804 | 11803 | {"type": "Polygon", "coordinates": [[[-118.40951, 35.6372], [-118.40949, 35.63724], [-118.40946, 35.63726], [-118.40939, 35.63726], [-118.40786, 35.63652], [-118.40879, 35.6353], [-118.40918, 35.6355], [-118.40922, 35.63555], [-118.40929, 35.63558], [-118.40933, 35.63565], [-118.40951, 35.6372]]]} | Open Access 1 | Mountain Mesa Park | 28441 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 4.52 | Mtn. Mesa Park | ||
4201 | 4201 | 4200 | {"type": "Polygon", "coordinates": [[[-119.54923, 35.17866], [-119.54877, 35.17941], [-119.54719, 35.17942], [-119.54835, 35.1779], [-119.54872, 35.17789], [-119.54923, 35.17866]]]} | Open Access 1 | Fellows Park | 18868 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 4.609 | Fellows Park | ||
4738 | 4738 | 4737 | {"type": "Polygon", "coordinates": [[[-119.00748, 35.27139], [-119.00748, 35.2722], [-119.00671, 35.2722], [-119.00669, 35.27228], [-119.00528, 35.27229], [-119.00528, 35.27139], [-119.00748, 35.27139]]]} | Open Access 1 | Greenfield Park | 19478 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 4.784 | Greenfield Park | ||
5979 | 5979 | 5978 | {"type": "Polygon", "coordinates": [[[-118.18957, 35.06104], [-118.18845, 35.06105], [-118.18842, 35.05918], [-118.18953, 35.05914], [-118.18957, 35.06104]]]} | Open Access 1 | Mojave West Park | 22356 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 5.254 | Mojave West Park | ||
8734 | 8734 | 8733 | {"type": "Polygon", "coordinates": [[[-118.46441, 35.13789], [-118.4644, 35.13906], [-118.46227, 35.13906], [-118.46228, 35.13789], [-118.46441, 35.13789]]]} | Open Access 1 | Tehachapi West Side Cemetery | 26219 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 6.229 | Tehachapi West Side Cemetery | ||
5387 | 5387 | 5386 | {"type": "Polygon", "coordinates": [[[-119.68943, 35.61752], [-119.68731, 35.61753], [-119.68731, 35.61624], [-119.68943, 35.61623], [-119.68943, 35.61752]]]} | Open Access 1 | Lost Hills Park | 21539 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 6.795 | Lost Hills Park | ||
7094 | 7094 | 7093 | {"type": "Polygon", "coordinates": [[[-118.16724, 35.04691], [-118.16723, 35.04813], [-118.16709, 35.04817], [-118.1671, 35.04939], [-118.16668, 35.04939], [-118.16666, 35.04886], [-118.16569, 35.04886], [-118.16566, 35.04657], [-118.16724, 35.04691]]]} | Open Access 1 | Mojave East Park | 22351 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 8.57 | Mojave East Park | ||
15495 | 15495 | 15494 | {"type": "Polygon", "coordinates": [[[-118.92094, 35.26064], [-118.92094, 35.26078], [-118.92083, 35.26117], [-118.9208, 35.26133], [-118.92079, 35.26238], [-118.92076, 35.2625], [-118.91898, 35.26249], [-118.91898, 35.26219], [-118.91879, 35.26218], [-118.91881, 35.26209], [-118.91881, 35.26185], [-118.91888, 35.26169], [-118.9189, 35.26159], [-118.91893, 35.26064], [-118.92094, 35.26064]]]} | Open Access 1 | Bear Mountain Park | 15927 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 8.929 | Bear Mtn. Park | ||
2160 | 2160 | 2159 | {"type": "Polygon", "coordinates": [[[-117.65205, 34.9951], [-117.65203, 34.99536], [-117.65203, 34.99591], [-117.65194, 34.99593], [-117.65191, 34.99682], [-117.64985, 34.99682], [-117.64992, 34.99508], [-117.65205, 34.9951]]]} | Open Access 1 | Boron Park | 16285 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 9.072 | Boron Park | ||
5959 | 5959 | 5958 | {"type": "Polygon", "coordinates": [[[-118.91208, 35.25613], [-118.91208, 35.2578], [-118.90988, 35.25781], [-118.90989, 35.25614], [-118.91208, 35.25613]]]} | Open Access 1 | Lamont Park | 20994 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 9.168 | Lamont Park |
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]);