units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 569 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13882 | 13882 | 13881 | {"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 | 36472 | Rocklin holding 8 | 24531 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.03 | Rocklin holding 8 | 0 | Local Other or Unknown 14 | 4 | |
10053 | 10053 | 10052 | {"type": "Polygon", "coordinates": [[[-121.23986, 38.78689], [-121.23937, 38.78755], [-121.23887, 38.78744], [-121.23925, 38.78697], [-121.23913, 38.7869], [-121.23934, 38.78663], [-121.23986, 38.78689]]]} | Open Access 1 | 49028 | Deer Creek Park | 33729 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.051 | Deer Creek Park | 0 | Local Park 2 | 4 | |
13849 | 13849 | 13848 | {"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 | 36438 | Rocklin holding 5 | 24528 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.085 | Rocklin holding 5 | 0 | Local Other or Unknown 14 | 4 | |
3041 | 3041 | 3040 | {"type": "Polygon", "coordinates": [[[-121.23462, 38.78913], [-121.23412, 38.78977], [-121.23355, 38.78951], [-121.23407, 38.78888], [-121.23462, 38.78913]]]} | Open Access 1 | 20841 | Memorial Park | 22130 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.143 | Memorial Park | 0 | Local Park 2 | 4 | |
5476 | 5476 | 5475 | {"type": "MultiPolygon", "coordinates": [[[[-121.20025, 38.80451], [-121.20011, 38.80463], [-121.19978, 38.80457], [-121.19988, 38.80436], [-121.19994, 38.80433], [-121.19999, 38.80435], [-121.20025, 38.80451]]], [[[-121.20098, 38.80218], [-121.20095, 38.80387], [-121.20031, 38.80445], [-121.20003, 38.80428], [-121.20002, 38.80423], [-121.2001, 38.80415], [-121.20041, 38.80395], [-121.20055, 38.80383], [-121.20068, 38.80368], [-121.20079, 38.80349], [-121.20086, 38.8033], [-121.2009, 38.8031], [-121.20093, 38.80218], [-121.20098, 38.80218]]]]} | Open Access 1 | 49032 | Christine Anderson Park | 33734 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.247 | Christine Anderson Park | 2018 | Local Park 2 | 4 | |
12653 | 12653 | 12652 | {"type": "Polygon", "coordinates": [[[-121.21328, 38.78029], [-121.21327, 38.78079], [-121.21324, 38.78083], [-121.21206, 38.78087], [-121.21202, 38.78086], [-121.212, 38.78083], [-121.21198, 38.78064], [-121.212, 38.78052], [-121.21203, 38.78041], [-121.2121, 38.7803], [-121.21328, 38.78029]]]} | Open Access 1 | 29500 | Sasaki Park | 25163 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.67 | Sasaki Park | 0 | Local Park 2 | 4 | |
10048 | 10048 | 10047 | {"type": "Polygon", "coordinates": [[[-121.2703, 38.83454], [-121.26942, 38.8347], [-121.26937, 38.83469], [-121.26934, 38.83466], [-121.26929, 38.83449], [-121.26927, 38.83431], [-121.26928, 38.83413], [-121.26933, 38.83395], [-121.26946, 38.83369], [-121.26958, 38.83354], [-121.26973, 38.8334], [-121.26991, 38.83353], [-121.27003, 38.83373], [-121.26979, 38.8341], [-121.26993, 38.83424], [-121.26995, 38.83444], [-121.27029, 38.8345], [-121.2703, 38.83454]]]} | Open Access 1 | 49026 | Pernu Park | 33727 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.676 | Pernu Park | 0 | Local Park 2 | 4 | |
10073 | 10073 | 10072 | {"type": "Polygon", "coordinates": [[[-121.28222, 38.81572], [-121.28171, 38.81595], [-121.28168, 38.81588], [-121.28158, 38.8158], [-121.28132, 38.81542], [-121.28105, 38.81507], [-121.28097, 38.81499], [-121.28084, 38.81488], [-121.2808, 38.81481], [-121.28072, 38.81477], [-121.28065, 38.81477], [-121.28057, 38.81481], [-121.28053, 38.81488], [-121.28047, 38.81488], [-121.28041, 38.8148], [-121.28124, 38.81442], [-121.28222, 38.81572]]]} | Open Access 1 | 49035 | Wickman Park | 33742 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.226 | Wickman Park | 2017 | Local Park 2 | 4 | |
13850 | 13850 | 13849 | {"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 | 36439 | Rocklin holding 4 | 24527 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.26 | Rocklin holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13881 | 13881 | 13880 | {"type": "Polygon", "coordinates": [[[-121.25251, 38.82722], [-121.25091, 38.82731], [-121.25113, 38.82719], [-121.25077, 38.82655], [-121.25226, 38.82667], [-121.25237, 38.82663], [-121.25251, 38.82722]]]} | No Public Access 3 | 36471 | Rocklin holding 6 | 24529 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.285 | Rocklin holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13883 | 13883 | 13882 | {"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.82935], [-121.25594, 38.82924], [-121.25613, 38.82953]]]} | No Public Access 3 | 36473 | Rocklin holding 9 | 24532 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.565 | Rocklin holding 9 | 0 | Local Other or Unknown 14 | 4 | |
12652 | 12652 | 12651 | {"type": "Polygon", "coordinates": [[[-121.22788, 38.80669], [-121.22749, 38.80797], [-121.22717, 38.80791], [-121.22719, 38.80786], [-121.22718, 38.8078], [-121.22715, 38.80777], [-121.22709, 38.80774], [-121.22698, 38.80775], [-121.22687, 38.80783], [-121.22679, 38.80782], [-121.22678, 38.80778], [-121.22678, 38.80717], [-121.2267, 38.80681], [-121.2267, 38.80668], [-121.22788, 38.80669]]]} | Open Access 1 | 29499 | Gayaldo Park | 19244 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.626 | Gayaldo Park | 0 | Local Park 2 | 4 | |
12676 | 12676 | 12675 | {"type": "Polygon", "coordinates": [[[-121.27698, 38.82744], [-121.27696, 38.82745], [-121.27693, 38.82751], [-121.27651, 38.82772], [-121.27619, 38.82793], [-121.27561, 38.8274], [-121.27582, 38.82706], [-121.2758, 38.82685], [-121.2759, 38.82669], [-121.27619, 38.82637], [-121.27646, 38.82631], [-121.27679, 38.82713], [-121.27698, 38.82744]]]} | Open Access 1 | 29573 | Bolton Park | 16250 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.008 | Bolton Park | 0 | Local Park 2 | 4 | |
13876 | 13876 | 13875 | {"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.82189], [-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.82164], [-121.24813, 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 | 36467 | Rocklin holding 16 | 24523 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.291 | Rocklin holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13997 | 13997 | 13996 | {"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 | 36681 | Rocklin holding 2 | 24525 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.454 | Rocklin holding 2 | 0 | Local Other or Unknown 14 | 4 | |
12645 | 12645 | 12644 | {"type": "Polygon", "coordinates": [[[-121.23155, 38.77166], [-121.23143, 38.77235], [-121.23137, 38.77242], [-121.23108, 38.7723], [-121.23087, 38.77225], [-121.23066, 38.77222], [-121.23015, 38.77223], [-121.22978, 38.7723], [-121.22973, 38.77227], [-121.22965, 38.77205], [-121.22965, 38.77182], [-121.22971, 38.77162], [-121.22977, 38.7715], [-121.22999, 38.77123], [-121.23008, 38.77107], [-121.23027, 38.77115], [-121.23083, 38.77166], [-121.23155, 38.77166]]]} | Open Access 1 | 29480 | Joe Hernandez Park | 20420 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.527 | Joe Hernandez Park | 0 | Local Park 2 | 4 | |
10886 | 10886 | 10885 | {"type": "Polygon", "coordinates": [[[-121.24285, 38.7747], [-121.24256, 38.77498], [-121.24217, 38.77545], [-121.242, 38.77559], [-121.24188, 38.77564], [-121.24183, 38.77573], [-121.24146, 38.77569], [-121.24119, 38.77586], [-121.24113, 38.77582], [-121.24105, 38.77582], [-121.24102, 38.77557], [-121.24076, 38.77531], [-121.24238, 38.77431], [-121.24285, 38.7747]]]} | Open Access 1 | 20835 | Woodside Park | 33744 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.563 | Woodside Park | 0 | Local Park 2 | 4 | |
12651 | 12651 | 12650 | {"type": "Polygon", "coordinates": [[[-121.28015, 38.83781], [-121.28015, 38.83843], [-121.27996, 38.83843], [-121.27885, 38.83889], [-121.2786, 38.83882], [-121.27847, 38.83858], [-121.27813, 38.83849], [-121.27865, 38.83818], [-121.27857, 38.838], [-121.27853, 38.83798], [-121.2789, 38.83759], [-121.27921, 38.83773], [-121.27944, 38.83779], [-121.27979, 38.83783], [-121.28015, 38.83781]]]} | Open Access 1 | 29493 | Brigham & Hawes Park | 16391 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.582 | Brigham & Hawes Park | 0 | Local Park 2 | 4 | |
3042 | 3042 | 3041 | {"type": "Polygon", "coordinates": [[[-121.24331, 38.80602], [-121.2432, 38.80631], [-121.24303, 38.80634], [-121.24295, 38.80653], [-121.24276, 38.80664], [-121.24263, 38.80694], [-121.2429, 38.8072], [-121.24268, 38.80733], [-121.24243, 38.8071], [-121.24221, 38.80711], [-121.24204, 38.80721], [-121.24158, 38.80677], [-121.2422, 38.80622], [-121.24189, 38.80598], [-121.24214, 38.8058], [-121.24244, 38.80565], [-121.24265, 38.80556], [-121.24271, 38.80556], [-121.24287, 38.80573], [-121.24303, 38.80586], [-121.24331, 38.80602]]]} | Open Access 1 | 20842 | Clover Valley Park | 17439 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.722 | Clover Valley Park | 0 | Local Park 2 | 4 | |
3287 | 3287 | 3286 | {"type": "Polygon", "coordinates": [[[-121.27391, 38.79872], [-121.2739, 38.79876], [-121.27383, 38.79877], [-121.27377, 38.7988], [-121.27374, 38.79883], [-121.27373, 38.79889], [-121.27375, 38.79894], [-121.27386, 38.79901], [-121.2739, 38.79907], [-121.27399, 38.7996], [-121.27397, 38.79965], [-121.27393, 38.79966], [-121.27243, 38.79981], [-121.27216, 38.79856], [-121.27261, 38.79871], [-121.27295, 38.79868], [-121.2734, 38.79868], [-121.27381, 38.79874], [-121.27391, 38.79872]]]} | Open Access 1 | 29535 | Night Ridge Park | 22756 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 4.008 | Night Ridge Park | 0 | Local Park 2 | 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]);