superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

47 rows where MNG_AGENCY = 393

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Kern, County of · 47 ✖
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
275 275 274 {"type": "MultiPolygon", "coordinates": [[[[-119.3271, 35.23519], [-119.32338, 35.23601], [-119.32338, 35.23601], [-119.32338, 35.23584], [-119.32375, 35.23573], [-119.32462, 35.23517], [-119.3271, 35.23519]]], [[[-119.33225, 35.24252], [-119.32342, 35.24243], [-119.32339, 35.23627], [-119.32797, 35.23524], [-119.32799, 35.2355], [-119.32807, 35.23593], [-119.32811, 35.23606], [-119.32814, 35.23626], [-119.32815, 35.23644], [-119.32805, 35.23711], [-119.32806, 35.23749], [-119.32808, 35.23762], [-119.32819, 35.23794], [-119.32822, 35.2381], [-119.32822, 35.23837], [-119.32819, 35.23859], [-119.32813, 35.23876], [-119.32832, 35.23876], [-119.32838, 35.23862], [-119.32841, 35.23846], [-119.32841, 35.23804], [-119.32836, 35.2378], [-119.32825, 35.2375], [-119.32824, 35.23712], [-119.32827, 35.237], [-119.32834, 35.23645], [-119.32834, 35.23621], [-119.3282, 35.23556], [-119.32817, 35.23519], [-119.33068, 35.23462], [-119.33068, 35.2352], [-119.33113, 35.23521], [-119.33114, 35.23607], [-119.33218, 35.23608], [-119.33225, 35.24252]]]]} Open Access 1 A. W. Noon Park   15225 303 Kern, County of 393 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 154.128 A. W. Noon Park  
495 495 494 {"type": "Polygon", "coordinates": [[[-118.49074, 35.06302], [-118.48621, 35.06305], [-118.48633, 35.06672], [-118.48631, 35.07216], [-118.4797, 35.07209], [-118.47973, 35.0667], [-118.47748, 35.06669], [-118.47723, 35.05221], [-118.4858, 35.05203], [-118.48597, 35.05571], [-118.49048, 35.0557], [-118.49063, 35.05937], [-118.49064, 35.06027], [-118.49074, 35.06302]]]} Open Access 1 Tehachapi Mountain Park http://www.co.kern.ca.us/parks/tehachapi.asp 4823 303 Kern, County of 393 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 490.931 Tehachapi Mtn. Park  
496 496 495 {"type": "Polygon", "coordinates": [[[-118.92234, 35.44163], [-118.92219, 35.44638], [-118.92127, 35.44628], [-118.92159, 35.44693], [-118.92113, 35.44702], [-118.92068, 35.44717], [-118.92029, 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.91425, 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.9054, 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.44872], [-118.90448, 35.44879], [-118.90439, 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.90316, 35.44177], [-118.90442, 35.44176], [-118.9141, 35.44165], [-118.92115, 35.4416], [-118.92117, 35.44164], [-118.92234, 35.44163]]]} Open Access 1 Hart Memorial Park http://www.co.kern.ca.us/parks/hart.asp 4798 303 Kern, County of 393 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 452.61 Hart Memorial Park  
497 497 496 {"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.36698], [-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.45227], [-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 Kern County Valley Floor Habitat Conservation Plan   4801 303 Kern, County of 393 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 2784.101 Kern County Valley Floor Habitat Conservation Plan  
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  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);