superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 569
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7878 | 7878 | 7877 | {"type": "Polygon", "coordinates": [[[-121.25393, 38.78071], [-121.25378, 38.78075], [-121.25354, 38.7812], [-121.25332, 38.78152], [-121.25253, 38.78125], [-121.25248, 38.78099], [-121.2523, 38.78062], [-121.25194, 38.78034], [-121.25182, 38.77988], [-121.25143, 38.77943], [-121.25156, 38.77935], [-121.25167, 38.77925], [-121.2519, 38.77938], [-121.2524, 38.77939], [-121.25269, 38.77906], [-121.25253, 38.77872], [-121.25246, 38.77866], [-121.25303, 38.77856], [-121.25315, 38.77891], [-121.25285, 38.77968], [-121.25335, 38.78053], [-121.25363, 38.78053], [-121.25393, 38.78071]]]} | Open Access 1 | Sunset East Park | 33740 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 6.953 | Sunset East Park | ||
8320 | 8320 | 8319 | {"type": "Polygon", "coordinates": [[[-121.2825, 38.79914], [-121.2825, 38.80031], [-121.28248, 38.80043], [-121.28249, 38.80049], [-121.28043, 38.80049], [-121.28023, 38.80035], [-121.27984, 38.80004], [-121.28143, 38.79878], [-121.28166, 38.7989], [-121.28191, 38.79899], [-121.28217, 38.79906], [-121.28245, 38.79911], [-121.2825, 38.79914]]]} | Open Access 1 | Sonora Park | 25620 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 7.604 | Sonora Park | ||
8849 | 8849 | 8848 | {"type": "Polygon", "coordinates": [[[-121.24832, 38.81574], [-121.24816, 38.81736], [-121.24554, 38.81955], [-121.24531, 38.82059], [-121.24477, 38.8206], [-121.24473, 38.81975], [-121.24493, 38.81919], [-121.24645, 38.81846], [-121.247, 38.81793], [-121.24738, 38.81759], [-121.24767, 38.81717], [-121.24777, 38.81673], [-121.24776, 38.81645], [-121.24751, 38.81583], [-121.24708, 38.81533], [-121.24719, 38.81519], [-121.24832, 38.81574]]]} | Open Access 1 | Rocklin holding 1 | 24516 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 7.876 | Rocklin holding 1 | ||
8850 | 8850 | 8849 | {"type": "Polygon", "coordinates": [[[-121.24719, 38.81519], [-121.24708, 38.81533], [-121.24646, 38.8156], [-121.24592, 38.81606], [-121.24517, 38.81673], [-121.245, 38.81686], [-121.24396, 38.81756], [-121.2436, 38.81739], [-121.24366, 38.81718], [-121.24319, 38.81681], [-121.24303, 38.81679], [-121.24263, 38.81688], [-121.24243, 38.81721], [-121.24148, 38.81704], [-121.24115, 38.81686], [-121.24339, 38.81598], [-121.24411, 38.81634], [-121.24679, 38.81499], [-121.24719, 38.81519]]]} | Open Access 1 | Rocklin holding 10 | 24517 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 10.409 | Rocklin holding 10 | ||
8851 | 8851 | 8850 | {"type": "Polygon", "coordinates": [[[-121.23974, 38.82421], [-121.23937, 38.82442], [-121.23779, 38.82586], [-121.2375, 38.82602], [-121.2368, 38.82659], [-121.23489, 38.82856], [-121.23477, 38.82889], [-121.23305, 38.83123], [-121.23265, 38.83258], [-121.23247, 38.83254], [-121.23254, 38.83145], [-121.23391, 38.82914], [-121.23607, 38.82689], [-121.23606, 38.82687], [-121.23568, 38.82667], [-121.23601, 38.82647], [-121.23626, 38.82593], [-121.2368, 38.82579], [-121.23684, 38.82608], [-121.23686, 38.82609], [-121.23924, 38.82425], [-121.23974, 38.82421]]]} | Open Access 1 | Rocklin holding 11 | 24518 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 10.487 | Rocklin holding 11 | ||
8852 | 8852 | 8851 | {"type": "Polygon", "coordinates": [[[-121.24491, 38.81284], [-121.24339, 38.81598], [-121.24115, 38.81686], [-121.24144, 38.81658], [-121.24264, 38.81567], [-121.2435, 38.81429], [-121.24363, 38.81433], [-121.24393, 38.81353], [-121.24396, 38.81278], [-121.24348, 38.81269], [-121.24337, 38.81273], [-121.24361, 38.81234], [-121.24491, 38.81284]]]} | Open Access 1 | Rocklin holding 12 | 24519 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 7.89 | Rocklin holding 12 | ||
8853 | 8853 | 8852 | {"type": "Polygon", "coordinates": [[[-121.24892, 38.8153], [-121.24897, 38.8155], [-121.24892, 38.81582], [-121.24833, 38.81574], [-121.24679, 38.81499], [-121.2441, 38.81634], [-121.24339, 38.81598], [-121.24492, 38.81284], [-121.2456, 38.81269], [-121.24565, 38.81283], [-121.24574, 38.81296], [-121.24586, 38.81308], [-121.24603, 38.81319], [-121.24624, 38.81327], [-121.24735, 38.81352], [-121.24739, 38.81355], [-121.24739, 38.81359], [-121.24733, 38.81369], [-121.24724, 38.81379], [-121.24696, 38.81361], [-121.24617, 38.8139], [-121.24582, 38.8135], [-121.2454, 38.81359], [-121.24521, 38.81368], [-121.24499, 38.81384], [-121.24486, 38.81433], [-121.24475, 38.81453], [-121.24446, 38.81475], [-121.24438, 38.8149], [-121.24467, 38.8153], [-121.24495, 38.81532], [-121.24537, 38.81525], [-121.24564, 38.81501], [-121.24615, 38.81471], [-121.24668, 38.81448], [-121.24698, 38.81468], [-121.24811, 38.81527], [-121.24841, 38.8153], [-121.24892, 38.8153]]]} | Open Access 1 | Rocklin holding 13 | 24520 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 13.458 | Rocklin holding 13 | ||
8854 | 8854 | 8853 | {"type": "Polygon", "coordinates": [[[-121.24919, 38.81208], [-121.2487, 38.81358], [-121.24805, 38.81312], [-121.24792, 38.81356], [-121.24762, 38.81346], [-121.24623, 38.81314], [-121.24608, 38.81307], [-121.24592, 38.81295], [-121.24581, 38.81281], [-121.24574, 38.81265], [-121.24628, 38.8128], [-121.2474, 38.81263], [-121.24827, 38.81222], [-121.24889, 38.81175], [-121.24919, 38.81208]]]} | Open Access 1 | Rocklin holding 14 | 24521 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 6.349 | Rocklin holding 14 | ||
8855 | 8855 | 8854 | {"type": "Polygon", "coordinates": [[[-121.28098, 38.81077], [-121.28052, 38.81145], [-121.28007, 38.81206], [-121.28027, 38.81237], [-121.27713, 38.81374], [-121.27617, 38.81277], [-121.2766, 38.8125], [-121.27652, 38.81214], [-121.27694, 38.81167], [-121.27795, 38.81167], [-121.28073, 38.81046], [-121.28098, 38.81077]]]} | Open Access 1 | Rocklin holding 15 | 24522 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 16.757 | Rocklin holding 15 | ||
8856 | 8856 | 8855 | {"type": "Polygon", "coordinates": [[[-121.24992, 38.82075], [-121.24983, 38.82082], [-121.24969, 38.82069], [-121.24963, 38.82066], [-121.2494, 38.82074], [-121.24841, 38.82147], [-121.24809, 38.8218], [-121.24791, 38.82193], [-121.24786, 38.8219], [-121.24771, 38.82201], [-121.24661, 38.82235], [-121.24613, 38.82242], [-121.24608, 38.8224], [-121.24598, 38.82222], [-121.24676, 38.82199], [-121.24716, 38.82183], [-121.24748, 38.82163], [-121.24812, 38.82119], [-121.24848, 38.82097], [-121.24885, 38.82078], [-121.24924, 38.82062], [-121.24958, 38.8205], [-121.24963, 38.82049], [-121.24967, 38.82051], [-121.24979, 38.82064], [-121.24992, 38.82075]]]} | Open Access 1 | Rocklin holding 16 | 24523 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 3.292 | Rocklin holding 16 | ||
8857 | 8857 | 8856 | {"type": "Polygon", "coordinates": [[[-121.26559, 38.82111], [-121.26234, 38.82106], [-121.26396, 38.81851], [-121.26338, 38.81563], [-121.26341, 38.81439], [-121.26407, 38.81448], [-121.26519, 38.8147], [-121.26558, 38.81763], [-121.26582, 38.81916], [-121.26559, 38.82111]]]} | No Public Access 3 | Rocklin holding 17 | 24524 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 33.244 | Rocklin holding 17 | ||
8858 | 8858 | 8857 | {"type": "Polygon", "coordinates": [[[-121.2456, 38.81268], [-121.24492, 38.81284], [-121.24361, 38.81234], [-121.24371, 38.81213], [-121.24377, 38.81207], [-121.24383, 38.81206], [-121.24392, 38.81207], [-121.24399, 38.81206], [-121.24405, 38.81202], [-121.24407, 38.81195], [-121.24422, 38.81192], [-121.24438, 38.81185], [-121.24476, 38.81174], [-121.24491, 38.81171], [-121.24504, 38.81172], [-121.24516, 38.81175], [-121.24527, 38.81181], [-121.24533, 38.81185], [-121.2454, 38.81193], [-121.24543, 38.81202], [-121.2456, 38.81268]]]} | Open Access 1 | Rocklin holding 2 | 24525 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 3.454 | Rocklin holding 2 | ||
8859 | 8859 | 8858 | {"type": "Polygon", "coordinates": [[[-121.26424, 38.82108], [-121.26403, 38.82133], [-121.26303, 38.82156], [-121.26234, 38.82151], [-121.26169, 38.82177], [-121.26083, 38.82268], [-121.26025, 38.82268], [-121.25959, 38.82319], [-121.25959, 38.82321], [-121.26023, 38.82329], [-121.26016, 38.8237], [-121.25865, 38.82437], [-121.25774, 38.82444], [-121.25753, 38.82471], [-121.25701, 38.82425], [-121.25747, 38.82401], [-121.25869, 38.82323], [-121.26023, 38.82202], [-121.26138, 38.82135], [-121.26194, 38.82112], [-121.26234, 38.82107], [-121.26424, 38.82108]]]} | No Public Access 3 | Rocklin holding 3 | 24526 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 12.658 | Rocklin holding 3 | ||
8860 | 8860 | 8859 | {"type": "Polygon", "coordinates": [[[-121.24892, 38.81582], [-121.24882, 38.81637], [-121.24871, 38.81741], [-121.2486, 38.81755], [-121.24816, 38.81736], [-121.24832, 38.81574], [-121.24892, 38.81582]]]} | Open Access 1 | Rocklin holding 4 | 24527 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 2.26 | Rocklin holding 4 | ||
8861 | 8861 | 8860 | {"type": "Polygon", "coordinates": [[[-121.23015, 38.83665], [-121.22932, 38.83664], [-121.2292, 38.8355], [-121.22932, 38.8355], [-121.22944, 38.83578], [-121.22963, 38.8361], [-121.22986, 38.83639], [-121.23015, 38.83665]]]} | Open Access 1 | Rocklin holding 5 | 24528 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1.085 | Rocklin holding 5 | ||
8868 | 8868 | 8867 | {"type": "Polygon", "coordinates": [[[-121.25251, 38.82722], [-121.25091, 38.82731], [-121.25112, 38.82719], [-121.25077, 38.82655], [-121.25226, 38.82667], [-121.25237, 38.82663], [-121.25251, 38.82722]]]} | No Public Access 3 | Rocklin holding 6 | 24529 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 2.287 | Rocklin holding 6 | ||
8869 | 8869 | 8868 | {"type": "Polygon", "coordinates": [[[-121.25747, 38.82554], [-121.25724, 38.82581], [-121.25685, 38.82593], [-121.25694, 38.82622], [-121.25666, 38.82626], [-121.25656, 38.82592], [-121.25644, 38.82581], [-121.25608, 38.82602], [-121.25539, 38.82611], [-121.25449, 38.82674], [-121.25371, 38.82681], [-121.25267, 38.82716], [-121.25254, 38.82656], [-121.25284, 38.82644], [-121.25367, 38.82638], [-121.25449, 38.82624], [-121.25513, 38.82583], [-121.25571, 38.82557], [-121.25628, 38.82504], [-121.25671, 38.82444], [-121.25736, 38.82486], [-121.25717, 38.82502], [-121.25743, 38.82524], [-121.25747, 38.82554]]]} | No Public Access 3 | Rocklin holding 7 | 24530 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 7.971 | Rocklin holding 7 | ||
8870 | 8870 | 8869 | {"type": "Polygon", "coordinates": [[[-121.25806, 38.82755], [-121.25787, 38.82775], [-121.25752, 38.82708], [-121.25728, 38.82686], [-121.25697, 38.82662], [-121.25692, 38.82637], [-121.25716, 38.82632], [-121.25735, 38.82645], [-121.25806, 38.82755]]]} | No Public Access 3 | Rocklin holding 8 | 24531 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1.03 | Rocklin holding 8 | ||
8871 | 8871 | 8870 | {"type": "Polygon", "coordinates": [[[-121.25613, 38.82953], [-121.25455, 38.83106], [-121.25434, 38.83148], [-121.25459, 38.83065], [-121.25495, 38.83003], [-121.25525, 38.82964], [-121.25526, 38.82948], [-121.25506, 38.82931], [-121.25526, 38.82919], [-121.25549, 38.82909], [-121.25567, 38.82934], [-121.25594, 38.82924], [-121.25613, 38.82953]]]} | No Public Access 3 | Rocklin holding 9 | 24532 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 2.567 | Rocklin holding 9 | ||
9051 | 9051 | 9050 | {"type": "Polygon", "coordinates": [[[-121.28229, 38.80549], [-121.27957, 38.80433], [-121.27949, 38.80428], [-121.27949, 38.80423], [-121.2796, 38.80409], [-121.27968, 38.80394], [-121.28009, 38.80255], [-121.28007, 38.80266], [-121.2801, 38.80277], [-121.28019, 38.80292], [-121.2803, 38.803], [-121.28042, 38.80305], [-121.28063, 38.80308], [-121.28033, 38.80369], [-121.28037, 38.80393], [-121.2815, 38.8045], [-121.28229, 38.80549]]]} | Open Access 1 | Ruhkala Park | 24728 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 5.043 | Ruhkala 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]);