units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
47 rows where AGNCY_TYP = 3 and MNG_AGENCY = 393 sorted by GAP_STS
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11838 | 11838 | 11837 | {"type": "MultiPolygon", "coordinates": [[[[-119.50841, 35.71741], [-119.50835, 35.72211], [-119.50147, 35.72213], [-119.50148, 35.71744], [-119.50841, 35.71741]]], [[[-119.53642, 35.24923], [-119.53637, 35.25286], [-119.52764, 35.25288], [-119.52764, 35.24926], [-119.53642, 35.24923]]], [[[-119.5627, 35.26741], [-119.56269, 35.27111], [-119.55377, 35.2711], [-119.55377, 35.26739], [-119.5627, 35.26741]]], [[[-119.56271, 35.25653], [-119.56267, 35.26018], [-119.55822, 35.26019], [-119.5583, 35.25655], [-119.56271, 35.25653]]], [[[-119.56721, 35.36867], [-119.56296, 35.36869], [-119.56291, 35.36697], [-119.56275, 35.36696], [-119.56272, 35.36146], [-119.55829, 35.36147], [-119.55824, 35.35402], [-119.56269, 35.35404], [-119.56273, 35.36145], [-119.56711, 35.36145], [-119.56721, 35.36867]]], [[[-119.61863, 35.45225], [-119.61846, 35.45226], [-119.61843, 35.45575], [-119.60085, 35.45588], [-119.60076, 35.44504], [-119.60968, 35.44502], [-119.60974, 35.45224], [-119.61863, 35.45221], [-119.61863, 35.45225]]], [[[-119.62058, 35.63057], [-119.62057, 35.63396], [-119.61564, 35.63389], [-119.61562, 35.63049], [-119.62058, 35.63057]]], [[[-119.63516, 35.65584], [-119.62545, 35.65571], [-119.62534, 35.65207], [-119.63513, 35.65218], [-119.63516, 35.65584]]], [[[-119.6351, 35.63078], [-119.63514, 35.63416], [-119.63512, 35.63772], [-119.63501, 35.64495], [-119.62541, 35.64483], [-119.62537, 35.64127], [-119.62536, 35.63063], [-119.6351, 35.63078]]], [[[-119.63056, 35.6812], [-119.63053, 35.68485], [-119.62542, 35.68479], [-119.62545, 35.68117], [-119.63056, 35.6812]]], [[[-119.63796, 35.36139], [-119.63356, 35.36141], [-119.63356, 35.3578], [-119.63791, 35.35778], [-119.63796, 35.36139]]], [[[-119.64439, 35.69219], [-119.64411, 35.69937], [-119.64393, 35.70294], [-119.63934, 35.7029], [-119.63474, 35.70289], [-119.63481, 35.69214], [-119.64439, 35.69219]]], [[[-119.65439, 35.64517], [-119.65408, 35.66684], [-119.64457, 35.66678], [-119.64465, 35.65954], [-119.64471, 35.64506], [-119.65439, 35.64517]]], [[[-119.66193, 35.73204], [-119.65318, 35.73203], [-119.65309, 35.72562], [-119.65309, 35.71788], [-119.66189, 35.71792], [-119.66193, 35.73204]]], [[[-119.68501, 35.70294], [-119.6823, 35.70958], [-119.68209, 35.7102], [-119.66189, 35.7102], [-119.66189, 35.70291], [-119.68501, 35.70294]]]]} | Open Access 1 | 24167 | Kern County Valley Floor Habitat Conservation Plan | 4801 | 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 | 2784.022 | Kern County Valley Floor Habitat Conservation Plan | None 1041 | |||
14423 | 14423 | 14422 | {"type": "Polygon", "coordinates": [[[-118.89503, 35.43798], [-118.8932, 35.43744], [-118.8921, 35.43698], [-118.89108, 35.43666], [-118.88971, 35.43648], [-118.88774, 35.43601], [-118.88634, 35.43587], [-118.8853, 35.43568], [-118.88447, 35.43566], [-118.88384, 35.43552], [-118.88345, 35.43532], [-118.88285, 35.43512], [-118.8823, 35.43512], [-118.88181, 35.43521], [-118.88064, 35.43561], [-118.87884, 35.43595], [-118.87878, 35.43599], [-118.87872, 35.436], [-118.87859, 35.4361], [-118.87849, 35.43613], [-118.87832, 35.43627], [-118.87806, 35.4364], [-118.87778, 35.43659], [-118.87743, 35.43674], [-118.87721, 35.43681], [-118.87713, 35.4368], [-118.87708, 35.43682], [-118.87701, 35.43694], [-118.8769, 35.43695], [-118.87683, 35.437], [-118.8768, 35.43705], [-118.87664, 35.43711], [-118.87656, 35.43717], [-118.87648, 35.43722], [-118.87638, 35.43724], [-118.87625, 35.43734], [-118.87623, 35.43739], [-118.87605, 35.43746], [-118.87595, 35.43756], [-118.87576, 35.43766], [-118.87559, 35.43768], [-118.87553, 35.43767], [-118.87541, 35.43771], [-118.87532, 35.43785], [-118.87517, 35.43791], [-118.87508, 35.43799], [-118.87493, 35.43804], [-118.87444, 35.4383], [-118.87429, 35.43835], [-118.87399, 35.43851], [-118.87393, 35.43852], [-118.87375, 35.43861], [-118.87368, 35.43867], [-118.87354, 35.43872], [-118.87335, 35.43885], [-118.87325, 35.43889], [-118.87313, 35.439], [-118.87291, 35.43912], [-118.87277, 35.43913], [-118.87248, 35.43931], [-118.87229, 35.43937], [-118.87152, 35.43985], [-118.87145, 35.43988], [-118.87128, 35.44002], [-118.87106, 35.4401], [-118.87095, 35.44019], [-118.87085, 35.44021], [-118.87072, 35.44029], [-118.87053, 35.44045], [-118.87019, 35.44063], [-118.86968, 35.44099], [-118.86945, 35.44112], [-118.86932, 35.44123], [-118.86906, 35.44134], [-118.86895, 35.44143], [-118.86885, 35.44145], [-118.86875, 35.44151], [-118.8677, 35.44167], [-118.86747, 35.4419], [-118.86394, 35.44271], [-118.86275, 35.44311], [-118.86178, 35.44324], [-118.86038, 35.44326], [-118.8596, 35.44317], [-118.85867, 35.44332], [-118.8579, 35.44322], [-118.85729, 35.4433], [-118.8594, 35.44002], [-118.85983, 35.4394], [-118.86002, 35.43896], [-118.86016, 35.4381], [-118.86048, 35.43724], [-118.86031, 35.43629], [-118.86022, 35.43526], [-118.85964, 35.43288], [-118.86038, 35.43265], [-118.86056, 35.43256], [-118.86067, 35.43249], [-118.8608, 35.43236], [-118.86089, 35.43221], [-118.86095, 35.43204], [-118.86099, 35.43182], [-118.86108, 35.432], [-118.86119, 35.43216], [-118.86133, 35.43231], [-118.8614, 35.43232], [-118.8614, 35.43253], [-118.86408, 35.43304], [-118.86534, 35.43316], [-118.86558, 35.43321], [-118.86576, 35.43326], [-118.86597, 35.43336], [-118.86725, 35.43416], [-118.8674, 35.43424], [-118.86756, 35.43429], [-118.86785, 35.43433], [-118.86986, 35.43433], [-118.87018, 35.43437], [-118.87037, 35.43443], [-118.87054, 35.43452], [-118.87154, 35.4353], [-118.87178, 35.43542], [-118.87199, 35.43542], [-118.87434, 35.43556], [-118.87453, 35.43553], [-118.8747, 35.43547], [-118.87484, 35.43537], [-118.87493, 35.43526], [-118.87499, 35.43512], [-118.87518, 35.43422], [-118.87523, 35.43411], [-118.87532, 35.43399], [-118.87706, 35.43257], [-118.87726, 35.43245], [-118.87745, 35.43238], [-118.87884, 35.43214], [-118.88119, 35.43152], [-118.88136, 35.43149], [-118.88157, 35.43149], [-118.88183, 35.43153], [-118.88199, 35.43159], [-118.88242, 35.43183], [-118.88258, 35.4319], [-118.8828, 35.43195], [-118.88302, 35.43196], [-118.88371, 35.43187], [-118.88569, 35.43167], [-118.88774, 35.43136], [-118.88827, 35.43089], [-118.88977, 35.43097], [-118.8905, 35.43106], [-118.89101, 35.43118], [-118.8915, 35.43133], [-118.89386, 35.43222], [-118.89387, 35.43251], [-118.89375, 35.4332], [-118.89361, 35.4339], [-118.89361, 35.43438], [-118.89384, 35.43522], [-118.8939, 35.43612], [-118.89446, 35.43696], [-118.89497, 35.4379], [-118.89503, 35.43798]]]} | Open Access 1 | 44539 | Lake Ming | 20954 | 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/ming.asp | Kern 36 | 496.587 | Lake Ming | None 1227 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);