units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
123 rows where ACCESS_TYP = 1 and MNG_AGENCY = 533 sorted by rowid descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
- City Agency 123
ACCESS_TYP 1
- Open Access · 123 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16204 | 16204 | 16203 | {"type": "Polygon", "coordinates": [[[-121.23553, 38.74068], [-121.23539, 38.74086], [-121.23514, 38.74106], [-121.23489, 38.74119], [-121.23435, 38.74156], [-121.23407, 38.7416], [-121.23393, 38.74169], [-121.23375, 38.74167], [-121.23358, 38.74188], [-121.23352, 38.74209], [-121.23333, 38.74225], [-121.23302, 38.74237], [-121.23287, 38.74239], [-121.23276, 38.74249], [-121.23248, 38.74254], [-121.23238, 38.74274], [-121.23176, 38.74268], [-121.23136, 38.74271], [-121.2312, 38.74277], [-121.23094, 38.74266], [-121.23083, 38.74274], [-121.23059, 38.74277], [-121.2302, 38.74297], [-121.22966, 38.74303], [-121.22909, 38.74307], [-121.22908, 38.7427], [-121.22927, 38.74277], [-121.22951, 38.74278], [-121.23, 38.74251], [-121.23004, 38.74238], [-121.23036, 38.7422], [-121.2305, 38.74232], [-121.23084, 38.74228], [-121.2314, 38.74228], [-121.23169, 38.7422], [-121.23181, 38.74208], [-121.23207, 38.74207], [-121.23242, 38.742], [-121.23269, 38.74192], [-121.23315, 38.74164], [-121.23324, 38.7414], [-121.23344, 38.74119], [-121.23374, 38.74106], [-121.2342, 38.74085], [-121.2344, 38.74083], [-121.23447, 38.74069], [-121.23465, 38.74057], [-121.23471, 38.74048], [-121.23472, 38.74022], [-121.23454, 38.74011], [-121.23439, 38.73991], [-121.23418, 38.73977], [-121.23403, 38.73974], [-121.23367, 38.73958], [-121.23347, 38.73954], [-121.23328, 38.73946], [-121.23307, 38.73953], [-121.23289, 38.73952], [-121.23197, 38.7393], [-121.23187, 38.73941], [-121.23173, 38.73944], [-121.23159, 38.73962], [-121.23135, 38.73959], [-121.2307, 38.73978], [-121.2304, 38.73988], [-121.23003, 38.73988], [-121.22985, 38.73978], [-121.22921, 38.73951], [-121.22858, 38.73909], [-121.22824, 38.73905], [-121.2281, 38.73914], [-121.22757, 38.73919], [-121.22729, 38.73924], [-121.22708, 38.73921], [-121.22685, 38.73904], [-121.22673, 38.73886], [-121.2266, 38.73885], [-121.22655, 38.73895], [-121.22645, 38.73898], [-121.22619, 38.73895], [-121.22611, 38.73895], [-121.22604, 38.73787], [-121.22607, 38.73754], [-121.22607, 38.73741], [-121.2263, 38.73732], [-121.22674, 38.73728], [-121.22707, 38.73733], [-121.22751, 38.73732], [-121.22773, 38.73735], [-121.2279, 38.73746], [-121.228, 38.73757], [-121.22818, 38.73759], [-121.22841, 38.73789], [-121.22864, 38.73809], [-121.22878, 38.73829], [-121.22911, 38.73851], [-121.22931, 38.73872], [-121.22965, 38.73897], [-121.22984, 38.73919], [-121.22965, 38.7393], [-121.22956, 38.73944], [-121.23024, 38.73974], [-121.23203, 38.73923], [-121.23264, 38.7393], [-121.23264, 38.73865], [-121.23316, 38.73897], [-121.23339, 38.73894], [-121.23351, 38.73884], [-121.23378, 38.73876], [-121.23407, 38.73883], [-121.23455, 38.73912], [-121.23461, 38.7395], [-121.23479, 38.73937], [-121.23492, 38.73933], [-121.23519, 38.7394], [-121.23543, 38.73936], [-121.23545, 38.7401], [-121.23553, 38.74068]]]} | Open Access 1 | 31300 | City Open Space | 17336 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 28.048 | City OS | 0 | Local Recreation Area 3 | 4 | |
16191 | 16191 | 16190 | {"type": "MultiPolygon", "coordinates": [[[[-121.33096, 38.78617], [-121.33052, 38.78646], [-121.33031, 38.78629], [-121.33019, 38.78624], [-121.33002, 38.78623], [-121.32975, 38.78626], [-121.32967, 38.78625], [-121.32955, 38.78626], [-121.32951, 38.78624], [-121.32941, 38.7862], [-121.32908, 38.78617], [-121.3289, 38.7861], [-121.32886, 38.78612], [-121.32881, 38.78609], [-121.32877, 38.78602], [-121.32873, 38.78601], [-121.32873, 38.78513], [-121.32903, 38.78529], [-121.32944, 38.78538], [-121.33021, 38.78538], [-121.33067, 38.7856], [-121.33088, 38.78576], [-121.33096, 38.78595], [-121.33096, 38.78617]]], [[[-121.344, 38.79455], [-121.34327, 38.79478], [-121.3428, 38.7949], [-121.34244, 38.79496], [-121.34115, 38.79514], [-121.34068, 38.79517], [-121.34013, 38.79518], [-121.34012, 38.79475], [-121.33983, 38.79472], [-121.33961, 38.79465], [-121.33921, 38.7946], [-121.33896, 38.79456], [-121.33872, 38.79445], [-121.33852, 38.79431], [-121.33819, 38.79398], [-121.33813, 38.79379], [-121.33817, 38.7937], [-121.33812, 38.79364], [-121.33812, 38.79354], [-121.33779, 38.79329], [-121.33774, 38.79317], [-121.33748, 38.79307], [-121.33718, 38.79307], [-121.3373, 38.79295], [-121.33743, 38.79294], [-121.3378, 38.793], [-121.33782, 38.79304], [-121.33792, 38.79307], [-121.33801, 38.79305], [-121.33802, 38.79298], [-121.33773, 38.79247], [-121.33769, 38.79248], [-121.33755, 38.7924], [-121.33727, 38.79201], [-121.33727, 38.79174], [-121.33719, 38.79167], [-121.33679, 38.79137], [-121.33633, 38.79124], [-121.33559, 38.79124], [-121.33517, 38.79112], [-121.33498, 38.79096], [-121.33482, 38.79084], [-121.33482, 38.79077], [-121.3344, 38.79055], [-121.3343, 38.79046], [-121.33414, 38.79038], [-121.33403, 38.7903], [-121.33384, 38.79007], [-121.33354, 38.78987], [-121.33338, 38.78983], [-121.3332, 38.78973], [-121.33299, 38.78951], [-121.33273, 38.78949], [-121.33265, 38.7895], [-121.33216, 38.78943], [-121.33206, 38.78939], [-121.33186, 38.78946], [-121.33124, 38.78922], [-121.33126, 38.78903], [-121.33132, 38.78898], [-121.33145, 38.78891], [-121.33151, 38.78877], [-121.33144, 38.78861], [-121.33138, 38.78823], [-121.33121, 38.78791], [-121.33127, 38.78787], [-121.33129, 38.78779], [-121.33105, 38.78762], [-121.33097, 38.78751], [-121.33086, 38.78743], [-121.33066, 38.78699], [-121.33065, 38.78695], [-121.33056, 38.7867], [-121.33095, 38.78645], [-121.33095, 38.78657], [-121.33106, 38.78671], [-121.33162, 38.78658], [-121.33168, 38.78652], [-121.33157, 38.78635], [-121.33163, 38.78626], [-121.33174, 38.78624], [-121.33186, 38.78618], [-121.33198, 38.78606], [-121.33205, 38.78603], [-121.33198, 38.78622], [-121.33182, 38.78645], [-121.3319, 38.7866], [-121.33193, 38.78672], [-121.33183, 38.78675], [-121.33152, 38.78676], [-121.33149, 38.78687], [-121.33132, 38.78699], [-121.33131, 38.78704], [-121.33147, 38.78716], [-121.332, 38.78745], [-121.33202, 38.78752], [-121.3321, 38.78755], [-121.33218, 38.78755], [-121.33229, 38.78749], [-121.3324, 38.78726], [-121.33254, 38.78716], [-121.33275, 38.78714], [-121.33291, 38.7872], [-121.33308, 38.78736], [-121.33313, 38.78768], [-121.33298, 38.78786], [-121.33238, 38.78827], [-121.3323, 38.78844], [-121.33232, 38.78855], [-121.33257, 38.78873], [-121.33321, 38.78898], [-121.3335, 38.78905], [-121.33367, 38.78913], [-121.33382, 38.78927], [-121.33403, 38.78925], [-121.33451, 38.78928], [-121.33462, 38.78933], [-121.33469, 38.78942], [-121.33458, 38.78978], [-121.33467, 38.79003], [-121.33492, 38.79024], [-121.33494, 38.79023], [-121.33519, 38.78892], [-121.33527, 38.78895], [-121.33537, 38.78884], [-121.33515, 38.78844], [-121.33545, 38.78814], [-121.33549, 38.78812], [-121.33555, 38.78813], [-121.33571, 38.78823], [-121.3359, 38.78831], [-121.33632, 38.78846], [-121.33662, 38.78863], [-121.3368, 38.78871], [-121.33707, 38.78879], [-121.3374, 38.78884], [-121.33743, 38.78887], [-121.33744, 38.78901], [-121.33748, 38.78913], [-121.33759, 38.78932], [-121.33778, 38.78949], [-121.3379, 38.78957], [-121.33806, 38.78965], [-121.33834, 38.78971], [-121.33859, 38.78973], [-121.33885, 38.78969], [-121.33921, 38.78959], [-121.33937, 38.78957], [-121.33946, 38.78958], [-121.33949, 38.78963], [-121.33949, 38.79017], [-121.33905, 38.79018], [-121.33906, 38.79099], [-121.33944, 38.791], [-121.3394, 38.79104], [-121.33938, 38.7911], [-121.33939, 38.79116], [-121.33943, 38.79121], [-121.33906, 38.79145], [-121.33906, 38.79173], [-121.34011, 38.79174], [-121.34012, 38.79303], [-121.34096, 38.79326], [-121.34094, 38.79355], [-121.34114, 38.79372], [-121.34133, 38.79379], [-121.34156, 38.7938], [-121.34185, 38.79366], [-121.34193, 38.79355], [-121.34321, 38.79411], [-121.3436, 38.79433], [-121.34385, 38.79429], [-121.344, 38.79455]]]]} | Open Access 1 | 29446 | Blue Oaks Open Space | 16183 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 69.837 | Blue Oaks OS | 0 | Local Recreation Area 3 | 4 | |
16167 | 16167 | 16166 | {"type": "MultiPolygon", "coordinates": [[[[-121.24491, 38.74107], [-121.24485, 38.74123], [-121.24457, 38.74138], [-121.24422, 38.74146], [-121.24418, 38.74154], [-121.24404, 38.74157], [-121.24404, 38.74167], [-121.24388, 38.74162], [-121.24361, 38.74174], [-121.24349, 38.74176], [-121.24336, 38.74188], [-121.24332, 38.74202], [-121.24326, 38.74209], [-121.24321, 38.74212], [-121.24305, 38.74211], [-121.24296, 38.74207], [-121.24284, 38.74199], [-121.24319, 38.74176], [-121.24334, 38.74147], [-121.24352, 38.74144], [-121.24416, 38.74138], [-121.24431, 38.74114], [-121.24424, 38.74094], [-121.24427, 38.74082], [-121.24421, 38.74072], [-121.24491, 38.74107]]], [[[-121.24785, 38.7396], [-121.24782, 38.73969], [-121.24773, 38.73968], [-121.24758, 38.73961], [-121.2475, 38.73967], [-121.24747, 38.73977], [-121.24742, 38.73982], [-121.24707, 38.73982], [-121.24693, 38.73977], [-121.2465, 38.73989], [-121.24636, 38.73987], [-121.24623, 38.74001], [-121.24596, 38.74004], [-121.24564, 38.74004], [-121.24543, 38.74002], [-121.2452, 38.73997], [-121.2451, 38.73998], [-121.24492, 38.74025], [-121.24486, 38.7404], [-121.2448, 38.74051], [-121.2447, 38.74063], [-121.24456, 38.74056], [-121.24477, 38.74033], [-121.24497, 38.73995], [-121.24464, 38.73963], [-121.2447, 38.7396], [-121.24482, 38.73963], [-121.24575, 38.73969], [-121.2459, 38.73964], [-121.24624, 38.73959], [-121.24647, 38.73948], [-121.24652, 38.73948], [-121.24659, 38.73955], [-121.24687, 38.73948], [-121.24703, 38.7395], [-121.24713, 38.73947], [-121.24715, 38.73941], [-121.2471, 38.73924], [-121.24711, 38.73914], [-121.24716, 38.7391], [-121.24725, 38.73908], [-121.24717, 38.73902], [-121.24718, 38.73889], [-121.24706, 38.73873], [-121.24772, 38.73942], [-121.24785, 38.7396]]], [[[-121.25347, 38.7387], [-121.25355, 38.7387], [-121.25361, 38.73874], [-121.25361, 38.73897], [-121.25358, 38.73925], [-121.25344, 38.73991], [-121.25342, 38.74016], [-121.25343, 38.74087], [-121.25342, 38.7409], [-121.25337, 38.74092], [-121.25329, 38.74093], [-121.2533, 38.74014], [-121.2531, 38.73997], [-121.25273, 38.73983], [-121.2527, 38.73961], [-121.2524, 38.73945], [-121.2523, 38.73954], [-121.25222, 38.73951], [-121.25215, 38.73951], [-121.25212, 38.73945], [-121.2502, 38.73947], [-121.24987, 38.73937], [-121.25006, 38.73908], [-121.25045, 38.73908], [-121.25053, 38.73904], [-121.25061, 38.73907], [-121.25072, 38.73906], [-121.2508, 38.73911], [-121.25117, 38.73907], [-121.25138, 38.73892], [-121.25157, 38.73883], [-121.25181, 38.73889], [-121.25204, 38.73889], [-121.25226, 38.73886], [-121.25227, 38.73884], [-121.25246, 38.73889], [-121.25272, 38.73904], [-121.25279, 38.73904], [-121.25282, 38.7391], [-121.25288, 38.73914], [-121.25299, 38.73915], [-121.25303, 38.7392], [-121.25341, 38.73932], [-121.25348, 38.73891], [-121.25347, 38.7387]]]]} | Open Access 1 | 20937 | City Open Space | 17336 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 9.82 | City OS | 0 | Local Recreation Area 3 | 4 | |
14426 | 14426 | 14425 | {"type": "Polygon", "coordinates": [[[-121.36549, 38.78949], [-121.36537, 38.78765], [-121.3654, 38.78776], [-121.36547, 38.78786], [-121.36562, 38.78798], [-121.36575, 38.78803], [-121.36596, 38.78806], [-121.36754, 38.78805], [-121.36768, 38.78807], [-121.36781, 38.7881], [-121.36793, 38.78816], [-121.36803, 38.78824], [-121.36813, 38.78839], [-121.36816, 38.78856], [-121.36812, 38.78872], [-121.368, 38.78887], [-121.36783, 38.78897], [-121.36769, 38.78901], [-121.36755, 38.78903], [-121.36607, 38.78903], [-121.36593, 38.78905], [-121.36574, 38.78911], [-121.36564, 38.78919], [-121.36553, 38.78933], [-121.36549, 38.78949]]]} | Open Access 1 | 44553 | Norm Fratis Park | 22792 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 6.308 | Norm Fratis Park | 0 | Local Park 2 | 4 | |
14425 | 14425 | 14424 | {"type": "Polygon", "coordinates": [[[-121.35177, 38.80533], [-121.35238, 38.8056], [-121.35242, 38.80565], [-121.35241, 38.80569], [-121.35202, 38.8062], [-121.35196, 38.80623], [-121.35189, 38.80623], [-121.35125, 38.80594], [-121.35112, 38.80583], [-121.35107, 38.80568], [-121.35108, 38.80556], [-121.35112, 38.80548], [-121.35118, 38.8054], [-121.35127, 38.80534], [-121.35139, 38.8053], [-121.35152, 38.80528], [-121.35165, 38.80529], [-121.35177, 38.80533]]]} | Open Access 1 | 44552 | Harrigan Greens | 19695 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 1.997 | Harrigan Greens | 0 | Local Park 2 | 4 | |
13989 | 13989 | 13988 | {"type": "Polygon", "coordinates": [[[-121.21782, 38.72076], [-121.21758, 38.7208], [-121.21734, 38.72088], [-121.21712, 38.72103], [-121.21687, 38.72108], [-121.21656, 38.72104], [-121.21655, 38.72139], [-121.21573, 38.72099], [-121.21577, 38.72075], [-121.2158, 38.72071], [-121.21586, 38.72069], [-121.21588, 38.72054], [-121.21585, 38.72053], [-121.21597, 38.72036], [-121.21628, 38.72067], [-121.21632, 38.72069], [-121.21635, 38.72067], [-121.21637, 38.71985], [-121.21634, 38.71977], [-121.21634, 38.71962], [-121.21636, 38.71954], [-121.21648, 38.71935], [-121.21642, 38.71931], [-121.21613, 38.71931], [-121.21612, 38.71922], [-121.21653, 38.71922], [-121.21654, 38.71941], [-121.21696, 38.71986], [-121.2172, 38.71964], [-121.21725, 38.71967], [-121.21702, 38.71992], [-121.21782, 38.72076]]]} | Open Access 1 | 36673 | Roseville holding 42 | 24663 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 4.488 | Roseville holding 42 | 0 | Local Other or Unknown 14 | 4 | |
13874 | 13874 | 13873 | {"type": "Polygon", "coordinates": [[[-121.26187, 38.74161], [-121.26125, 38.74206], [-121.26126, 38.74403], [-121.26106, 38.74403], [-121.26106, 38.74328], [-121.26099, 38.74322], [-121.26038, 38.74322], [-121.26038, 38.74317], [-121.26099, 38.74317], [-121.26106, 38.74311], [-121.26106, 38.74198], [-121.26165, 38.74155], [-121.26163, 38.74138], [-121.2616, 38.74118], [-121.26036, 38.74062], [-121.26014, 38.74062], [-121.2601, 38.74037], [-121.26044, 38.74031], [-121.2604, 38.74015], [-121.26031, 38.73951], [-121.26036, 38.73928], [-121.26049, 38.73903], [-121.26071, 38.7391], [-121.26059, 38.73935], [-121.26056, 38.73955], [-121.26064, 38.74012], [-121.26076, 38.74054], [-121.2609, 38.74068], [-121.26181, 38.74109], [-121.26187, 38.74161]]]} | Open Access 1 | 36465 | Roseville holding 22 | 24641 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 3.28 | Roseville holding 22 | 0 | Local Other or Unknown 14 | 4 | |
13873 | 13873 | 13872 | {"type": "Polygon", "coordinates": [[[-121.25551, 38.73951], [-121.25547, 38.73971], [-121.25543, 38.7397], [-121.25492, 38.73969], [-121.25405, 38.74009], [-121.25408, 38.74219], [-121.25395, 38.74206], [-121.25384, 38.74188], [-121.25376, 38.74169], [-121.25372, 38.74148], [-121.25371, 38.74006], [-121.25374, 38.73979], [-121.25384, 38.73938], [-121.25404, 38.73937], [-121.25406, 38.73985], [-121.25418, 38.73976], [-121.25483, 38.73952], [-121.25511, 38.73949], [-121.25551, 38.73951]]]} | Open Access 1 | 36464 | Roseville holding 21 | 24640 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 2.809 | Roseville holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13872 | 13872 | 13871 | {"type": "Polygon", "coordinates": [[[-121.26094, 38.73866], [-121.26079, 38.73896], [-121.26056, 38.73889], [-121.26071, 38.73859], [-121.26094, 38.73866]]]} | Open Access 1 | 36463 | Roseville holding 20 | 24639 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.188 | Roseville holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13871 | 13871 | 13870 | {"type": "Polygon", "coordinates": [[[-121.25991, 38.74062], [-121.2595, 38.74063], [-121.25902, 38.74044], [-121.25851, 38.74038], [-121.25832, 38.74062], [-121.25739, 38.74034], [-121.25647, 38.74023], [-121.25623, 38.74023], [-121.25597, 38.73979], [-121.25569, 38.73979], [-121.25569, 38.73955], [-121.25612, 38.73958], [-121.25648, 38.74002], [-121.25746, 38.74014], [-121.25863, 38.74022], [-121.25935, 38.74032], [-121.25958, 38.74046], [-121.25988, 38.74041], [-121.25991, 38.74062]]]} | Open Access 1 | 36462 | Roseville holding 43 | 24664 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 2.535 | Roseville holding 43 | 0 | Local Other or Unknown 14 | 4 | |
13870 | 13870 | 13869 | {"type": "Polygon", "coordinates": [[[-121.24543, 38.72224], [-121.24452, 38.72224], [-121.24452, 38.72086], [-121.2452, 38.72192], [-121.24543, 38.72224]]]} | Open Access 1 | 36461 | Roseville holding 18 | 24636 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 1.478 | Roseville holding 18 | 0 | Local Other or Unknown 14 | 4 | |
13869 | 13869 | 13868 | {"type": "MultiPolygon", "coordinates": [[[[-121.26734, 38.7323], [-121.26626, 38.7326], [-121.26625, 38.73285], [-121.26643, 38.73321], [-121.26695, 38.7334], [-121.26695, 38.73389], [-121.26687, 38.73422], [-121.26683, 38.73463], [-121.26662, 38.73479], [-121.26642, 38.73489], [-121.2661, 38.73498], [-121.26588, 38.735], [-121.2656, 38.73506], [-121.26536, 38.73519], [-121.26518, 38.73538], [-121.26504, 38.7356], [-121.26456, 38.73555], [-121.26417, 38.73571], [-121.2637, 38.73577], [-121.26275, 38.73606], [-121.26275, 38.7363], [-121.26205, 38.73631], [-121.26201, 38.73654], [-121.26195, 38.73667], [-121.26189, 38.73678], [-121.26155, 38.73663], [-121.26131, 38.73684], [-121.26071, 38.73684], [-121.26006, 38.7365], [-121.26008, 38.73647], [-121.26008, 38.73646], [-121.25969, 38.73628], [-121.25954, 38.73614], [-121.25938, 38.73601], [-121.25921, 38.73594], [-121.25879, 38.73604], [-121.2587, 38.73599], [-121.25866, 38.736], [-121.2586, 38.73321], [-121.25835, 38.73203], [-121.25829, 38.73203], [-121.25828, 38.73172], [-121.25832, 38.73171], [-121.2584, 38.73192], [-121.25855, 38.73214], [-121.25874, 38.73236], [-121.25952, 38.73293], [-121.25993, 38.73321], [-121.26032, 38.73321], [-121.26032, 38.73389], [-121.26149, 38.73473], [-121.2641, 38.73471], [-121.26476, 38.73468], [-121.26522, 38.73462], [-121.26573, 38.73442], [-121.26609, 38.73404], [-121.26621, 38.73359], [-121.26577, 38.73271], [-121.26574, 38.7325], [-121.26587, 38.73238], [-121.26653, 38.73211], [-121.26708, 38.73196], [-121.26734, 38.73194], [-121.26734, 38.7323]]], [[[-121.2719, 38.73376], [-121.2719, 38.73406], [-121.27145, 38.73404], [-121.27076, 38.73392], [-121.27048, 38.73382], [-121.27028, 38.7338], [-121.27019, 38.73376], [-121.27008, 38.73362], [-121.27001, 38.73356], [-121.26982, 38.73349], [-121.2697, 38.7334], [-121.2697, 38.73335], [-121.26936, 38.73299], [-121.2688, 38.73266], [-121.26767, 38.73227], [-121.26751, 38.73229], [-121.2675, 38.73197], [-121.26792, 38.73205], [-121.26829, 38.73216], [-121.26864, 38.73226], [-121.26942, 38.73267], [-121.26975, 38.73293], [-121.26994, 38.73315], [-121.27049, 38.73359], [-121.27092, 38.73362], [-121.27126, 38.7335], [-121.27152, 38.73374], [-121.2719, 38.73376]]]]} | Open Access 1 | 36460 | Roseville holding 19 | 24637 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 42.189 | Roseville holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13868 | 13868 | 13867 | {"type": "Polygon", "coordinates": [[[-121.25119, 38.76227], [-121.25118, 38.76283], [-121.2511, 38.76282], [-121.25103, 38.76312], [-121.25079, 38.7631], [-121.25076, 38.76321], [-121.25066, 38.76323], [-121.25051, 38.76323], [-121.25048, 38.7634], [-121.25038, 38.76345], [-121.25014, 38.76348], [-121.25016, 38.76361], [-121.25006, 38.76369], [-121.24974, 38.76379], [-121.24939, 38.76382], [-121.24918, 38.76394], [-121.24886, 38.76392], [-121.24872, 38.76407], [-121.24858, 38.76412], [-121.24851, 38.76423], [-121.24826, 38.76432], [-121.24834, 38.76444], [-121.2483, 38.76454], [-121.24817, 38.76459], [-121.2481, 38.76466], [-121.24802, 38.76467], [-121.24783, 38.76464], [-121.24778, 38.76447], [-121.2475, 38.76446], [-121.2474, 38.76452], [-121.24729, 38.76448], [-121.24719, 38.76453], [-121.24699, 38.76451], [-121.24686, 38.76442], [-121.24659, 38.76445], [-121.24649, 38.76427], [-121.24634, 38.76433], [-121.246, 38.76432], [-121.24588, 38.76427], [-121.24584, 38.76423], [-121.24585, 38.76419], [-121.24589, 38.76416], [-121.24618, 38.7642], [-121.24654, 38.76409], [-121.24674, 38.76424], [-121.24693, 38.76415], [-121.2472, 38.76415], [-121.24724, 38.76406], [-121.24738, 38.76404], [-121.24771, 38.76423], [-121.24794, 38.7639], [-121.24792, 38.76371], [-121.24802, 38.76359], [-121.24826, 38.76352], [-121.24827, 38.76329], [-121.24881, 38.76292], [-121.24897, 38.7627], [-121.24922, 38.76266], [-121.24933, 38.76223], [-121.24988, 38.76224], [-121.24989, 38.76222], [-121.25095, 38.76223], [-121.25096, 38.76227], [-121.25119, 38.76227]]]} | Open Access 1 | 36459 | Roseville holding 16 | 24634 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 10.651 | Roseville holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13867 | 13867 | 13866 | {"type": "Polygon", "coordinates": [[[-121.27246, 38.72252], [-121.27226, 38.72252], [-121.2722, 38.72249], [-121.27218, 38.72246], [-121.27217, 38.72221], [-121.27246, 38.72221], [-121.27246, 38.72252]]]} | Open Access 1 | 36458 | Roseville holding 17 | 24635 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.204 | Roseville holding 17 | 0 | Local Other or Unknown 14 | 4 | |
13866 | 13866 | 13865 | {"type": "Polygon", "coordinates": [[[-121.29545, 38.73776], [-121.2948, 38.73776], [-121.29479, 38.73737], [-121.29512, 38.73737], [-121.29511, 38.73671], [-121.29543, 38.73671], [-121.29545, 38.73776]]]} | Open Access 1 | 36457 | Roseville holding 4 | 24660 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 1.115 | Roseville holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13865 | 13865 | 13864 | {"type": "Polygon", "coordinates": [[[-121.2971, 38.73345], [-121.2966, 38.73345], [-121.29659, 38.73255], [-121.297, 38.73265], [-121.29693, 38.73288], [-121.29693, 38.73301], [-121.2969, 38.73305], [-121.29698, 38.73309], [-121.29695, 38.73311], [-121.29697, 38.73321], [-121.29706, 38.73322], [-121.29707, 38.73327], [-121.29709, 38.73331], [-121.2971, 38.73345]]]} | Open Access 1 | 36456 | Roseville holding 15 | 24633 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.801 | Roseville holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13864 | 13864 | 13863 | {"type": "Polygon", "coordinates": [[[-121.29641, 38.73769], [-121.29608, 38.7377], [-121.29606, 38.73671], [-121.29639, 38.7367], [-121.29641, 38.73769]]]} | Open Access 1 | 36455 | Roseville holding 3 | 24649 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.764 | Roseville holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13863 | 13863 | 13862 | {"type": "Polygon", "coordinates": [[[-121.30589, 38.73764], [-121.3056, 38.73748], [-121.30557, 38.73749], [-121.30532, 38.73734], [-121.3056, 38.73713], [-121.30595, 38.73672], [-121.30599, 38.7367], [-121.30605, 38.7367], [-121.30638, 38.73688], [-121.3065, 38.73698], [-121.30655, 38.73705], [-121.30659, 38.73715], [-121.3066, 38.73731], [-121.30657, 38.73739], [-121.30652, 38.73748], [-121.30642, 38.7376], [-121.30633, 38.73765], [-121.30622, 38.73769], [-121.30611, 38.7377], [-121.30599, 38.73768], [-121.30589, 38.73764]]]} | Open Access 1 | 36454 | Roseville holding 2 | 24638 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 1.865 | Roseville holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13862 | 13862 | 13861 | {"type": "Polygon", "coordinates": [[[-121.30877, 38.73764], [-121.30787, 38.73762], [-121.30771, 38.73765], [-121.30725, 38.73783], [-121.30706, 38.73799], [-121.30698, 38.73822], [-121.30677, 38.73808], [-121.30682, 38.73794], [-121.30676, 38.7379], [-121.30653, 38.738], [-121.30648, 38.73795], [-121.30646, 38.73789], [-121.30648, 38.73782], [-121.3067, 38.73757], [-121.30677, 38.73745], [-121.30717, 38.73751], [-121.30758, 38.73729], [-121.30827, 38.73728], [-121.30855, 38.73732], [-121.30877, 38.73732], [-121.30877, 38.73764]]]} | Open Access 1 | 36453 | Roseville holding 11 | 24629 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 2.129 | Roseville holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13861 | 13861 | 13860 | {"type": "Polygon", "coordinates": [[[-121.33947, 38.77588], [-121.33947, 38.77588], [-121.33905, 38.77566], [-121.33934, 38.77566], [-121.33947, 38.77588]]]} | Open Access 1 | 36452 | Roseville holding 9 | 24669 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.076 | Roseville holding 9 | 0 | Local Other or Unknown 14 | 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]);