units_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 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9718 | 9718 | 9717 | {"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 | 16458 | Kernville Circle Park | 20633 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 0.366 | Kernville Circle Park | 0 | Local Park 2 | 4 | |
2221 | 2221 | 2220 | {"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 | 16585 | Wofford Heights Park | 27667 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 1.187 | Wofford Heights Park | 0 | Local Park 2 | 4 | |
8688 | 8688 | 8687 | {"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 | 14050 | Old Tehachapi Cemetery | 23105 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 1.254 | Old Tehachapi Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2220 | 2220 | 2219 | {"type": "MultiPolygon", "coordinates": [[[[-118.98711, 35.39927], [-118.98684, 35.3994], [-118.98655, 35.39957], [-118.98635, 35.39972], [-118.98615, 35.39992], [-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 | 16571 | Wilkins Park | 27527 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 1.875 | Wilkins Park | 0 | Local Park 2 | 4 | |
9707 | 9707 | 9706 | {"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 | 16439 | Inyokern Park | 20225 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 2.762 | Inyokern Park | 0 | Local Park 2 | 4 | |
1932 | 1932 | 1931 | {"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 | 16545 | Scodie Park | 25200 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 3.31 | Scodie Park | 0 | Local Park 2 | 4 | |
3718 | 3718 | 3717 | {"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 | 14029 | Oak Grove Cemetery | 22970 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 3.555 | Oak Grove Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9740 | 9740 | 9739 | {"type": "Polygon", "coordinates": [[[-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.75447], [-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.4247, 35.75244], [-118.42497, 35.75299], [-118.42497, 35.75303]]]} | Open Access 1 | 16533 | Riverside Park | 24454 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 4.275 | Riverside Park | 0 | Local Park 2 | 4 | |
9736 | 9736 | 9735 | {"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 | 16524 | Potomac Park | 23919 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 4.28 | Potomac Park | 0 | Local Park 2 | 4 | |
9738 | 9738 | 9737 | {"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 | 16529 | Rexland Acres Park | 24308 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 4.446 | Rexland Acres Park | 0 | Local Park 2 | 4 | |
16919 | 16919 | 16918 | {"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 | 45613 | Mountain Mesa Park | 28441 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 4.52 | Mtn. Mesa Park | 0 | Local Park 2 | 4 | |
2188 | 2188 | 2187 | {"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 | 16387 | Fellows Park | 18868 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 4.609 | Fellows Park | 0 | Local Park 2 | 4 | |
9706 | 9706 | 9705 | {"type": "Polygon", "coordinates": [[[-119.00748, 35.27139], [-119.00748, 35.2722], [-119.0067, 35.2722], [-119.00669, 35.27228], [-119.00528, 35.27229], [-119.00528, 35.27139], [-119.00748, 35.27139]]]} | Open Access 1 | 16416 | Greenfield Park | 19478 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 4.784 | Greenfield Park | 0 | Local Park 2 | 4 | |
5127 | 5127 | 5126 | {"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 | 16505 | Mojave West Park | 22356 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 5.255 | Mojave West Park | 0 | Local Park 2 | 4 | |
1839 | 1839 | 1838 | {"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 | 14074 | Tehachapi West Side Cemetery | 26219 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 6.23 | Tehachapi West Side Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9730 | 9730 | 9729 | {"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 | 16479 | Lost Hills Park | 21539 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 6.797 | Lost Hills Park | 0 | Local Park 2 | 4 | |
2204 | 2204 | 2203 | {"type": "Polygon", "coordinates": [[[-118.16724, 35.04691], [-118.16723, 35.04813], [-118.16709, 35.04816], [-118.1671, 35.04939], [-118.16668, 35.04939], [-118.16667, 35.04886], [-118.16569, 35.04886], [-118.16566, 35.04657], [-118.16724, 35.04691]]]} | Open Access 1 | 16500 | Mojave East Park | 22351 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 8.564 | Mojave East Park | 0 | Local Park 2 | 4 | |
12860 | 12860 | 12859 | {"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.26218], [-118.91879, 35.26218], [-118.91881, 35.2621], [-118.91881, 35.26185], [-118.91888, 35.26169], [-118.9189, 35.26159], [-118.91893, 35.26064], [-118.92094, 35.26064]]]} | Open Access 1 | 44540 | Bear Mountain Park | 15927 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 8.928 | Bear Mtn. Park | 0 | Local Park 2 | 4 | |
9657 | 9657 | 9656 | {"type": "Polygon", "coordinates": [[[-117.65205, 34.9951], [-117.65203, 34.99536], [-117.65203, 34.99591], [-117.65194, 34.99592], [-117.65191, 34.99682], [-117.64985, 34.99682], [-117.64992, 34.99508], [-117.65205, 34.9951]]]} | Open Access 1 | 16313 | Boron Park | 16285 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 9.072 | Boron Park | 0 | Local Park 2 | 4 | |
2200 | 2200 | 2199 | {"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 | 16470 | Lamont Park | 20994 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 9.169 | Lamont Park | 0 | Local Park 2 | 4 |
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]);