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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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. | ||
1932 | 1932 | 1931 | {"type": "MultiPolygon", "coordinates": [[[[-118.9888, 35.34429], [-118.98879, 35.34498], [-118.98866, 35.345], [-118.98861, 35.34651], [-118.98785, 35.34656], [-118.98693, 35.34658], [-118.98561, 35.34656], [-118.98557, 35.34652], [-118.98558, 35.34506], [-118.98694, 35.34506], [-118.98695, 35.34428], [-118.9888, 35.34429]]], [[[-118.98993, 35.34508], [-118.98991, 35.34659], [-118.98878, 35.34658], [-118.98879, 35.34507], [-118.98993, 35.34508]]]]} | Open Access 1 | Belle Terrace Park | 15984 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 19.315 | Belle Terrace 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 | ||
2440 | 2440 | 2439 | {"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 | Buttonwillow Park | 16614 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 25.278 | Buttonwillow Park | ||
2670 | 2670 | 2669 | {"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 | Casa Loma County Park | 16930 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 9.441 | Casa Loma County Park | ||
3092 | 3092 | 3091 | {"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.96398, 35.41144], [-118.96397, 35.41159], [-118.96436, 35.4116], [-118.96437, 35.41145]]]} | Open Access 1 | College Park | 17505 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 17.168 | College Park | ||
3543 | 3543 | 3542 | {"type": "Polygon", "coordinates": [[[-119.24061, 35.76015], [-119.24029, 35.76017], [-119.23807, 35.76018], [-119.23802, 35.76133], [-119.23771, 35.76134], [-119.23771, 35.76012], [-119.23646, 35.76012], [-119.23643, 35.76002], [-119.23642, 35.75984], [-119.23641, 35.75776], [-119.24058, 35.75778], [-119.24061, 35.76015]]]} | Open Access 1 | Delano Heritage Park | 18061 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 25.691 | Delano Heritage Park | ||
3597 | 3597 | 3596 | {"type": "Polygon", "coordinates": [[[-118.83305, 35.20362], [-118.83306, 35.20502], [-118.83304, 35.20534], [-118.8311, 35.20535], [-118.83104, 35.20248], [-118.83105, 35.20194], [-118.83169, 35.20192], [-118.83301, 35.20193], [-118.83305, 35.20362]]]} | Open Access 1 | Di Giorgio County Park | 18131 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 16.892 | Di Giorgio County 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 | ||
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 | ||
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 | ||
5051 | 5051 | 5050 | {"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 | Heritage Park | 19841 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 19.249 | Heritage Park | ||
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 | ||
5721 | 5721 | 5720 | {"type": "Polygon", "coordinates": [[[-119.02436, 35.2737], [-119.0237, 35.27402], [-119.02322, 35.27401], [-119.0232, 35.27397], [-119.0215, 35.27396], [-119.02143, 35.2739], [-119.02143, 35.27309], [-119.02204, 35.27308], [-119.02204, 35.27227], [-119.02398, 35.27227], [-119.02436, 35.2737]]]} | Open Access 1 | Kern Delta Park | 20628 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 10.331 | Kern Delta Park | ||
5726 | 5726 | 5725 | {"type": "MultiPolygon", "coordinates": [[[[-118.8814, 35.43149], [-118.88119, 35.43152], [-118.88038, 35.43173], [-118.88113, 35.43151], [-118.8814, 35.43149]]], [[[-118.88795, 35.43117], [-118.88774, 35.43136], [-118.88569, 35.43167], [-118.88371, 35.43187], [-118.88309, 35.43196], [-118.88292, 35.43196], [-118.8828, 35.43195], [-118.88272, 35.43194], [-118.88281, 35.43195], [-118.88292, 35.43194], [-118.88369, 35.43184], [-118.88795, 35.43117]]], [[[-118.89047, 35.43658], [-118.88522, 35.43652], [-118.8852, 35.43568], [-118.8853, 35.43568], [-118.88634, 35.43587], [-118.88774, 35.43601], [-118.88971, 35.43648], [-118.89047, 35.43658]]], [[[-118.89218, 35.43777], [-118.89198, 35.43763], [-118.8919, 35.43759], [-118.89181, 35.43755], [-118.89164, 35.43754], [-118.89144, 35.43758], [-118.89127, 35.43767], [-118.89115, 35.43782], [-118.89109, 35.438], [-118.88524, 35.43798], [-118.88521, 35.43668], [-118.89056, 35.43674], [-118.89092, 35.43677], [-118.89131, 35.4369], [-118.89148, 35.43698], [-118.89169, 35.43711], [-118.89193, 35.43734], [-118.89218, 35.43777]]], [[[-118.89217, 35.43799], [-118.8913, 35.438], [-118.8913, 35.438], [-118.89136, 35.43786], [-118.89142, 35.4378], [-118.89154, 35.43773], [-118.89163, 35.43771], [-118.89177, 35.43772], [-118.89185, 35.43775], [-118.89217, 35.43799]]], [[[-118.90448, 35.4488], [-118.90446, 35.45088], [-118.90367, 35.45094], [-118.90346, 35.4509], [-118.90298, 35.45068], [-118.90241, 35.44994], [-118.90122, 35.44881], [-118.90043, 35.44756], [-118.90031, 35.44744], [-118.90014, 35.4473], [-118.89965, 35.44703], [-118.89942, 35.44686], [-118.89937, 35.44678], [-118.89908, 35.44647], [-118.89894, 35.44636], [-118.89707, 35.44514], [-118.89609, 35.44449], [-118.89598, 35.44438], [-118.89589, 35.44426], [-118.89584, 35.44412], [-118.89583, 35.44382], [-118.89634, 35.44247], [-118.89685, 35.44139], [-118.89686, 35.44129], [-118.89685, 35.44106], [-118.8968, 35.44093], [-118.89673, 35.44081], [-118.89664, 35.4407], [-118.89642, 35.44055], [-118.89621, 35.44046], [-118.89578, 35.44022], [-118.89524, 35.43985], [-118.89422, 35.43899], [-118.89392, 35.43884], [-118.89353, 35.43874], [-118.89334, 35.43866], [-118.89322, 35.4386], [-118.89277, 35.43827], [-118.89261, 35.43813], [-118.89208, 35.43723], [-118.89179, 35.43698], [-118.89157, 35.43684], [-118.89142, 35.43676], [-118.8921, 35.43698], [-118.8932, 35.43744], [-118.89511, 35.43801], [-118.89598, 35.43832], [-118.89666, 35.43873], [-118.89746, 35.43917], [-118.89777, 35.43938], [-118.89821, 35.43977], [-118.89873, 35.44013], [-118.899, 35.44037], [-118.89925, 35.44039], [-118.89976, 35.44068], [-118.89991, 35.44083], [-118.9004, 35.44118], [-118.90067, 35.44147], [-118.9008, 35.44164], [-118.90093, 35.44176], [-118.90119, 35.44244], [-118.90137, 35.44416], [-118.90137, 35.44486], [-118.90156, 35.44537], [-118.90229, 35.44713], [-118.90267, 35.44759], [-118.90341, 35.44814], [-118.9044, 35.44867], [-118.90448, 35.4488]]], [[[-118.89665, 35.44105], [-118.89667, 35.44127], [-118.89666, 35.44135], [-118.89658, 35.44153], [-118.89659, 35.44096], [-118.89665, 35.44105]]], [[[-118.90331, 35.44033], [-118.90326, 35.44008], [-118.90379, 35.4389], [-118.90382, 35.43874], [-118.90381, 35.43859], [-118.90374, 35.43839], [-118.90287, 35.43681], [-118.90265, 35.43647], [-118.90235, 35.43617], [-118.90184, 35.4358], [-118.90158, 35.43551], [-118.90128, 35.43523], [-118.90089, 35.43491], [-118.90043, 35.43458], [-118.89967, 35.43419], [-118.89913, 35.43398], [-118.8989, 35.43385], [-118.89863, 35.43377], [-118.89752, 35.43324], [-118.89886, 35.43338], [-118.89905, 35.43342], [-118.89926, 35.43352], [-118.90246, 35.43566], [-118.90274, 35.4359], [-118.90292, 35.4361], [-118.90305, 35.43626], [-118.90402, 35.43803], [-118.90409, 35.43822], [-118.90409, 35.43834], [-118.90407, 35.43849], [-118.90341, 35.43997], [-118.90331, 35.44033]]]]} | Open Access 1 | Kern River County Park | 20631 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 150.497 | Kern River County Park | ||
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 | ||
5939 | 5939 | 5938 | {"type": "MultiPolygon", "coordinates": [[[[-118.48467, 35.6069], [-118.48278, 35.60969], [-118.48188, 35.60933], [-118.48187, 35.60581], [-118.48467, 35.6069]]], [[[-118.48583, 35.60987], [-118.48579, 35.61002], [-118.48502, 35.61027], [-118.48485, 35.61029], [-118.48426, 35.6103], [-118.48406, 35.61028], [-118.48281, 35.61028], [-118.48361, 35.60911], [-118.48425, 35.60938], [-118.48458, 35.60949], [-118.48492, 35.60963], [-118.48583, 35.60987]]], [[[-118.48681, 35.60769], [-118.48587, 35.60972], [-118.48469, 35.60937], [-118.4837, 35.60896], [-118.48502, 35.60703], [-118.48681, 35.60769]]]]} | Open Access 1 | Lake Isabella Park | 20948 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 33.192 | Lake Isabella Park | ||
5946 | 5946 | 5945 | {"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.8818, 35.43521], [-118.88064, 35.43561], [-118.87885, 35.43595], [-118.87872, 35.436], [-118.87859, 35.4361], [-118.87849, 35.43614], [-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.87637, 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.87542, 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.87312, 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.87018, 35.44063], [-118.86968, 35.44099], [-118.86945, 35.44111], [-118.86932, 35.44123], [-118.86906, 35.44134], [-118.86895, 35.44143], [-118.86885, 35.44145], [-118.86875, 35.44151], [-118.86771, 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.86107, 35.432], [-118.86119, 35.43216], [-118.86133, 35.43231], [-118.8614, 35.43232], [-118.86141, 35.43253], [-118.86408, 35.43304], [-118.86534, 35.43316], [-118.86558, 35.43321], [-118.86576, 35.43326], [-118.86597, 35.43337], [-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.43511], [-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.88303, 35.43196], [-118.88371, 35.43187], [-118.88569, 35.43167], [-118.88773, 35.43136], [-118.88827, 35.43089], [-118.88977, 35.43097], [-118.8905, 35.43107], [-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 | Lake Ming | http://www.co.kern.ca.us/parks/ming.asp | 20954 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 496.595 | Lake Ming | |
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 | ||
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 |
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]);