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 SUID_NMA descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14610 | 14610 | 14609 | {"type": "Polygon", "coordinates": [[[-118.86048, 35.43724], [-118.86016, 35.4381], [-118.86002, 35.43895], [-118.85983, 35.4394], [-118.8594, 35.44002], [-118.85729, 35.4433], [-118.85404, 35.44375], [-118.85191, 35.44323], [-118.85136, 35.44191], [-118.85208, 35.44189], [-118.85209, 35.44188], [-118.85187, 35.44165], [-118.85179, 35.44152], [-118.8517, 35.44143], [-118.85151, 35.44114], [-118.85136, 35.4408], [-118.85127, 35.44037], [-118.85124, 35.4397], [-118.85125, 35.43952], [-118.85142, 35.43847], [-118.85168, 35.4376], [-118.85179, 35.43699], [-118.85188, 35.43672], [-118.85194, 35.43629], [-118.85201, 35.43606], [-118.85205, 35.43586], [-118.85218, 35.43553], [-118.85249, 35.43501], [-118.85257, 35.43462], [-118.85274, 35.43427], [-118.85284, 35.43411], [-118.85288, 35.4338], [-118.85293, 35.43364], [-118.85293, 35.4334], [-118.853, 35.43324], [-118.85845, 35.4332], [-118.85874, 35.43316], [-118.85964, 35.43288], [-118.86022, 35.43526], [-118.86031, 35.43629], [-118.86048, 35.43724]]]} | Restricted Access 2 | Kern River Golf Course | 33105 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 196.032 | Kern River GC | ||
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 | ||
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 | ||
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 | ||
11150 | 11150 | 11149 | {"type": "Polygon", "coordinates": [[[-119.43775, 35.1571], [-119.43547, 35.15711], [-119.43547, 35.15586], [-119.43514, 35.15584], [-119.43497, 35.15576], [-119.43496, 35.15468], [-119.43774, 35.15467], [-119.43775, 35.1571]]]} | Open Access 1 | Westside Cemetery | 27421 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 15.295 | Westside Cemetery | ||
10933 | 10933 | 10932 | {"type": "Polygon", "coordinates": [[[-118.97194, 35.3614], [-118.97196, 35.36207], [-118.97194, 35.3622], [-118.97194, 35.36313], [-118.96973, 35.36314], [-118.96972, 35.36265], [-118.96973, 35.36144], [-118.97194, 35.3614]]]} | Open Access 1 | Virginia Avenue Park | 27154 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 9.501 | Virginia Avenue 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 | ||
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 | ||
8934 | 8934 | 8933 | {"type": "Polygon", "coordinates": [[[-118.1691, 34.86788], [-118.16698, 34.86792], [-118.16697, 34.86609], [-118.16909, 34.86606], [-118.1691, 34.86788]]]} | Open Access 1 | Rosamond Park | 24602 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 9.71 | Rosamond Park | ||
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 | ||
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 | ||
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 | ||
8174 | 8174 | 8173 | {"type": "Polygon", "coordinates": [[[-118.92977, 35.36702], [-118.92976, 35.3687], [-118.92755, 35.36872], [-118.92755, 35.36704], [-118.92977, 35.36702]]]} | Open Access 1 | Pioneer Park | 23713 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 9.263 | Pioneer Park | ||
7908 | 7908 | 7907 | {"type": "Polygon", "coordinates": [[[-119.00277, 35.40197], [-119.00276, 35.40298], [-119.00203, 35.40325], [-119.00138, 35.40357], [-119.0005, 35.40394], [-119.00016, 35.40412], [-118.99991, 35.40409], [-118.99977, 35.40441], [-118.999, 35.40483], [-118.99861, 35.40483], [-118.9986, 35.40507], [-118.99724, 35.40578], [-118.99686, 35.40581], [-118.99665, 35.40603], [-118.99636, 35.40609], [-118.99562, 35.40651], [-118.99558, 35.40669], [-118.99545, 35.40663], [-118.99528, 35.40671], [-118.99528, 35.40673], [-118.99552, 35.40695], [-118.99546, 35.4072], [-118.99501, 35.40745], [-118.99486, 35.40763], [-118.99486, 35.40764], [-118.99571, 35.40735], [-118.9961, 35.40689], [-118.99639, 35.40686], [-118.99628, 35.4071], [-118.99606, 35.4073], [-118.99612, 35.40752], [-118.99573, 35.40792], [-118.99544, 35.40799], [-118.99524, 35.40817], [-118.99522, 35.40846], [-118.99475, 35.40865], [-118.99475, 35.40889], [-118.99432, 35.40934], [-118.99402, 35.40968], [-118.99274, 35.40959], [-118.99233, 35.40968], [-118.99188, 35.4095], [-118.99158, 35.40909], [-118.99113, 35.40881], [-118.99059, 35.40902], [-118.99096, 35.40919], [-118.99097, 35.40959], [-118.99076, 35.40981], [-118.99079, 35.41005], [-118.99066, 35.41014], [-118.99016, 35.40945], [-118.98971, 35.40926], [-118.98942, 35.40927], [-118.98921, 35.40947], [-118.98837, 35.40934], [-118.9878, 35.40931], [-118.98706, 35.40935], [-118.98639, 35.40945], [-118.98596, 35.40962], [-118.98536, 35.40921], [-118.98804, 35.40916], [-118.98887, 35.40908], [-118.98934, 35.409], [-118.99003, 35.40883], [-118.99203, 35.40819], [-118.99235, 35.40806], [-118.99298, 35.40777], [-119.00172, 35.40303], [-119.00191, 35.4029], [-119.00214, 35.40272], [-119.00246, 35.40242], [-119.00272, 35.40207], [-119.00277, 35.40197]]]} | Open Access 1 | Panorama Park | 23390 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 30.666 | Panorama 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 | ||
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 | ||
7443 | 7443 | 7442 | {"type": "Polygon", "coordinates": [[[-119.25839, 35.76429], [-119.25672, 35.76457], [-119.25645, 35.76341], [-119.25645, 35.76146], [-119.25834, 35.76146], [-119.25837, 35.7623], [-119.25839, 35.76429]]]} | Open Access 1 | North Kern Cemetery | 22826 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 13.856 | North Kern Cemetery | ||
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 | ||
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 | ||
709 | 709 | 708 | {"type": "Polygon", "coordinates": [[[-119.02667, 35.39563], [-119.02663, 35.3959], [-119.02664, 35.39629], [-119.02662, 35.39646], [-119.02651, 35.39681], [-119.02638, 35.39701], [-119.02618, 35.39724], [-119.02598, 35.3974], [-119.02582, 35.39749], [-119.02557, 35.39761], [-119.02484, 35.39761], [-119.02316, 35.39817], [-119.02118, 35.39851], [-119.02117, 35.39894], [-119.01888, 35.39893], [-119.01891, 35.39267], [-119.01978, 35.39266], [-119.01979, 35.39195], [-119.02098, 35.39198], [-119.02097, 35.39759], [-119.02119, 35.39757], [-119.02118, 35.39217], [-119.02214, 35.39216], [-119.02667, 35.39563]]]} | Open Access 1 | Metropolitan Recreation Center | 22188 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 93.777 | Metropolitan Rec. Ctr. |
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]);