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_LEV = 3 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
4880 | 4880 | 4879 | {"type": "Polygon", "coordinates": [[[-119.46075, 35.40515], [-119.45936, 35.40397], [-119.45838, 35.40159], [-119.45839, 35.39937], [-119.46073, 35.3997], [-119.46076, 35.40153], [-119.46074, 35.40382], [-119.46075, 35.40515]]]} | Open Access 1 | 16345 | Buttonwillow Park | 16614 | 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 | 25.28 | Buttonwillow Park | 0 | Local Park 2 | 4 | |
1638 | 1638 | 1637 | {"type": "Polygon", "coordinates": [[[-119.43775, 35.1571], [-119.43547, 35.15711], [-119.43547, 35.15585], [-119.43514, 35.15584], [-119.43497, 35.15576], [-119.43496, 35.15468], [-119.43774, 35.15467], [-119.43775, 35.1571]]]} | Open Access 1 | 14097 | Westside Cemetery | 27421 | 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 | 15.293 | Westside Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
8676 | 8676 | 8675 | {"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 | 14006 | North Kern Cemetery | 22826 | 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 | 13.858 | North Kern Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
5421 | 5421 | 5420 | {"type": "Polygon", "coordinates": [[[-119.24061, 35.76015], [-119.24029, 35.76017], [-119.23806, 35.76018], [-119.23802, 35.76133], [-119.23771, 35.76134], [-119.23771, 35.76012], [-119.23646, 35.76012], [-119.23643, 35.76003], [-119.23642, 35.75984], [-119.23641, 35.75776], [-119.24058, 35.75778], [-119.24061, 35.76015]]]} | Open Access 1 | 16370 | Delano Heritage Park | 18061 | 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 | 25.674 | Delano Heritage Park | 0 | Local Park 2 | 4 | |
16925 | 16925 | 16924 | {"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.01979, 35.39267], [-119.01979, 35.39195], [-119.02098, 35.39198], [-119.02096, 35.3976], [-119.02119, 35.39758], [-119.02118, 35.39217], [-119.02214, 35.39216], [-119.02667, 35.39563]]]} | Open Access 1 | 16493 | Metropolitan Recreation Center | 22188 | 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 | 93.734 | Metropolitan Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
2190 | 2190 | 2189 | {"type": "Polygon", "coordinates": [[[-119.02436, 35.2737], [-119.0237, 35.27402], [-119.02322, 35.27401], [-119.02321, 35.27397], [-119.0215, 35.27396], [-119.02143, 35.2739], [-119.02143, 35.27309], [-119.02204, 35.27309], [-119.02204, 35.27227], [-119.02398, 35.27227], [-119.02436, 35.2737]]]} | Open Access 1 | 16448 | Kern Delta Park | 20628 | 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 | 10.326 | Kern Delta 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 | |
2205 | 2205 | 2204 | {"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.9986, 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.99485, 35.40763], [-118.99485, 35.40765], [-118.99571, 35.40735], [-118.9961, 35.40689], [-118.99639, 35.40686], [-118.99628, 35.4071], [-118.99605, 35.40731], [-118.99612, 35.40752], [-118.99573, 35.40792], [-118.99544, 35.40799], [-118.99524, 35.40817], [-118.99522, 35.40846], [-118.99474, 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.4088], [-118.99057, 35.40903], [-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.40926], [-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.40241], [-119.00272, 35.40207], [-119.00277, 35.40197]]]} | Open Access 1 | 16517 | Panorama Park | 23390 | 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 | 30.643 | Panorama Park | 0 | Local Park 2 | 4 | |
2182 | 2182 | 2181 | {"type": "Polygon", "coordinates": [[[-118.99863, 35.33938], [-118.99644, 35.33938], [-118.99643, 35.33765], [-118.99862, 35.33765], [-118.99863, 35.33938]]]} | Open Access 1 | 16359 | Casa Loma County Park | 16930 | 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.443 | Casa Loma County 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 | |
9751 | 9751 | 9750 | {"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 | 16560 | Virginia Avenue Park | 27154 | 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.501 | Virginia Avenue Park | 0 | Local Park 2 | 4 | |
2193 | 2193 | 2192 | {"type": "Polygon", "coordinates": [[[-118.97016, 35.38673], [-118.97014, 35.38783], [-118.96981, 35.38881], [-118.96979, 35.38931], [-118.96948, 35.39011], [-118.96765, 35.39012], [-118.96763, 35.38674], [-118.97016, 35.38673]]]} | Open Access 1 | 16430 | Heritage Park | 19841 | 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 | 19.25 | Heritage Park | 0 | Local Park 2 | 4 | |
9352 | 9352 | 9351 | {"type": "Polygon", "coordinates": [[[-118.96741, 35.41248], [-118.96739, 35.41252], [-118.96733, 35.41253], [-118.96588, 35.41225], [-118.96567, 35.41223], [-118.96329, 35.41223], [-118.96325, 35.41219], [-118.96325, 35.41066], [-118.96331, 35.41062], [-118.96736, 35.41061], [-118.9674, 35.41065], [-118.96741, 35.41248]], [[-118.96437, 35.41145], [-118.96436, 35.41144], [-118.96397, 35.41144], [-118.96397, 35.4116], [-118.96437, 35.4116], [-118.96437, 35.41145]]]} | Open Access 1 | 15625 | College Park | 17505 | 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 | 17.162 | College 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 | |
8974 | 8974 | 8973 | {"type": "Polygon", "coordinates": [[[-118.95261, 34.81999], [-118.95243, 34.82027], [-118.94888, 34.82084], [-118.94844, 34.82085], [-118.94836, 34.82083], [-118.94751, 34.82076], [-118.94719, 34.82071], [-118.94573, 34.82039], [-118.94591, 34.81983], [-118.9469, 34.82005], [-118.94698, 34.82005], [-118.94705, 34.82002], [-118.94785, 34.81954], [-118.94808, 34.81946], [-118.94828, 34.81945], [-118.94989, 34.81947], [-118.94999, 34.81945], [-118.95008, 34.81939], [-118.95137, 34.81933], [-118.95231, 34.81915], [-118.9525, 34.81924], [-118.95214, 34.81975], [-118.95261, 34.81999]]]} | Open Access 1 | 16397 | Frazier Mountain Park | 19070 | 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 | 17.807 | Frazier Mtn. Park | 0 | Local Park 2 | 4 | |
2206 | 2206 | 2205 | {"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 | 16521 | Pioneer Park | 23713 | 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.264 | Pioneer Park | 0 | Local Park 2 | 4 | |
14405 | 14405 | 14404 | {"type": "Polygon", "coordinates": [[[-118.92234, 35.44163], [-118.92219, 35.44638], [-118.92126, 35.44628], [-118.92146, 35.44665], [-118.92159, 35.44693], [-118.92112, 35.44702], [-118.92068, 35.44717], [-118.9203, 35.44738], [-118.91994, 35.44765], [-118.91962, 35.44796], [-118.91919, 35.44851], [-118.91879, 35.4491], [-118.91878, 35.44916], [-118.91872, 35.44927], [-118.91845, 35.44971], [-118.91833, 35.44981], [-118.9183, 35.44982], [-118.91816, 35.44998], [-118.91798, 35.45014], [-118.9178, 35.45027], [-118.91763, 35.45037], [-118.91739, 35.45047], [-118.91723, 35.45051], [-118.917, 35.45054], [-118.9167, 35.45052], [-118.91548, 35.45084], [-118.91529, 35.45085], [-118.91424, 35.45079], [-118.91402, 35.45083], [-118.91379, 35.4509], [-118.9136, 35.45099], [-118.9134, 35.4511], [-118.91018, 35.45334], [-118.90997, 35.45345], [-118.90971, 35.45354], [-118.9095, 35.45359], [-118.90913, 35.45364], [-118.90894, 35.45362], [-118.90877, 35.45356], [-118.90823, 35.45324], [-118.9074, 35.45284], [-118.90623, 35.45205], [-118.90606, 35.45191], [-118.90591, 35.45176], [-118.90556, 35.45121], [-118.90548, 35.45113], [-118.90539, 35.45107], [-118.90524, 35.451], [-118.90508, 35.45098], [-118.90495, 35.45098], [-118.90455, 35.45105], [-118.90454, 35.44874], [-118.90448, 35.44871], [-118.90448, 35.44879], [-118.9044, 35.44866], [-118.90341, 35.44814], [-118.90267, 35.44759], [-118.90229, 35.44713], [-118.90156, 35.44537], [-118.90137, 35.44486], [-118.90137, 35.44416], [-118.90119, 35.44244], [-118.90097, 35.44183], [-118.90087, 35.44164], [-118.90313, 35.44162], [-118.90315, 35.44177], [-118.90442, 35.44176], [-118.9141, 35.44165], [-118.92115, 35.4416], [-118.92116, 35.44164], [-118.92234, 35.44163]]]} | Open Access 1 | 44511 | Hart Memorial Park | 4798 | 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 | http://www.co.kern.ca.us/parks/hart.asp | Kern 36 | 452.604 | Hart Memorial 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 |
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]);