units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where DES_TP = 2 and MNG_AGENCY = 533 sorted by ACRES
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 67
MNG_AGENCY 1
- Roseville, City of · 67 ✖
DES_TP 1
- Local Park · 67 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10912 | 10912 | 10911 | {"type": "Polygon", "coordinates": [[[-121.29644, 38.75001], [-121.29609, 38.75022], [-121.29585, 38.74981], [-121.29616, 38.74994], [-121.29644, 38.75001]]]} | Open Access 1 | 20913 | Shirley Ferretti Park | 25415 | 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.216 | Shirley Ferretti Park | 0 | Local Park 2 | 4 | |
12626 | 12626 | 12625 | {"type": "Polygon", "coordinates": [[[-121.26237, 38.75515], [-121.26208, 38.75534], [-121.26154, 38.75545], [-121.26146, 38.75549], [-121.26132, 38.75524], [-121.26189, 38.75488], [-121.26206, 38.75493], [-121.26237, 38.75515]]]} | Open Access 1 | 29477 | Sculpture Park | 25220 | 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.815 | Sculpture Park | 0 | Local Park 2 | 4 | |
10919 | 10919 | 10918 | {"type": "Polygon", "coordinates": [[[-121.27803, 38.72429], [-121.27768, 38.72463], [-121.27752, 38.7245], [-121.27731, 38.72422], [-121.27719, 38.72411], [-121.27719, 38.72409], [-121.27725, 38.72397], [-121.27728, 38.72386], [-121.2778, 38.72386], [-121.27781, 38.72414], [-121.27803, 38.72429]]]} | Open Access 1 | 20925 | Kenwood Oaks Park | 20623 | 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.887 | Kenwood Oaks Park | 0 | Local Park 2 | 4 | |
3598 | 3598 | 3597 | {"type": "Polygon", "coordinates": [[[-121.29155, 38.75104], [-121.29139, 38.75143], [-121.29139, 38.75183], [-121.29041, 38.75183], [-121.29043, 38.75127], [-121.29053, 38.75131], [-121.29097, 38.75085], [-121.29122, 38.75095], [-121.29155, 38.75104]]]} | Open Access 1 | 29457 | Weber Park | 27325 | 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.903 | Weber Park | 0 | Local Park 2 | 4 | |
12625 | 12625 | 12624 | {"type": "Polygon", "coordinates": [[[-121.2488, 38.75554], [-121.24795, 38.75599], [-121.24775, 38.75603], [-121.24729, 38.75548], [-121.24815, 38.75497], [-121.24838, 38.7552], [-121.2488, 38.75554]]]} | Open Access 1 | 29475 | John Piches Park | 20462 | 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.981 | John Piches 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 | |
4094 | 4094 | 4093 | {"type": "Polygon", "coordinates": [[[-121.36163, 38.78195], [-121.36202, 38.78195], [-121.36207, 38.78197], [-121.3621, 38.78202], [-121.3621, 38.78293], [-121.36208, 38.78302], [-121.36204, 38.78311], [-121.36196, 38.78318], [-121.36186, 38.78322], [-121.36173, 38.78325], [-121.36153, 38.78324], [-121.36138, 38.78317], [-121.36128, 38.78306], [-121.36125, 38.78293], [-121.36125, 38.782], [-121.36127, 38.78196], [-121.36133, 38.78195], [-121.36163, 38.78195]]]} | Open Access 1 | 44548 | C. Doulton Burner Park | 16626 | 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.505 | C. Doulton Burner Park | 0 | Local Park 2 | 4 | |
3044 | 3044 | 3043 | {"type": "Polygon", "coordinates": [[[-121.28919, 38.77703], [-121.28863, 38.77744], [-121.28813, 38.77795], [-121.28803, 38.778], [-121.28791, 38.778], [-121.28718, 38.77778], [-121.28651, 38.77763], [-121.28655, 38.77743], [-121.28663, 38.7774], [-121.28669, 38.77746], [-121.28679, 38.77747], [-121.28692, 38.77744], [-121.28769, 38.7774], [-121.2879, 38.77737], [-121.28811, 38.77731], [-121.28847, 38.77715], [-121.28875, 38.77697], [-121.28886, 38.77692], [-121.28892, 38.77686], [-121.289, 38.77688], [-121.28919, 38.77703]]]} | Open Access 1 | 20876 | Twinwood Park | 26624 | 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.59 | Twinwood Park | 0 | Local Park 2 | 4 | |
3633 | 3633 | 3632 | {"type": "Polygon", "coordinates": [[[-121.33483, 38.79171], [-121.33446, 38.79171], [-121.3334, 38.79087], [-121.3337, 38.79064], [-121.33377, 38.79063], [-121.33391, 38.79064], [-121.33401, 38.7906], [-121.33406, 38.79053], [-121.33406, 38.79047], [-121.33402, 38.79041], [-121.33395, 38.79036], [-121.33403, 38.7903], [-121.33414, 38.79038], [-121.3343, 38.79046], [-121.3344, 38.79055], [-121.33482, 38.79077], [-121.33483, 38.79171]]]} | Open Access 1 | 29447 | Adam V. Baquera Park | 15257 | 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.668 | Adam V. Baquera Park | 0 | Local Park 2 | 4 | |
4276 | 4276 | 4275 | {"type": "Polygon", "coordinates": [[[-121.36832, 38.78194], [-121.36963, 38.78194], [-121.36975, 38.78195], [-121.36987, 38.78199], [-121.37, 38.78209], [-121.37005, 38.78218], [-121.37006, 38.78232], [-121.37003, 38.78241], [-121.36996, 38.7825], [-121.36982, 38.78258], [-121.3697, 38.78261], [-121.3683, 38.78261], [-121.36826, 38.78259], [-121.36824, 38.78254], [-121.36824, 38.78201], [-121.36826, 38.78197], [-121.36832, 38.78194]]]} | Open Access 1 | 45270 | Alberto and Carmen Heredia Park | 15340 | 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.744 | Alberto and Carmen Heredia Park | 0 | Local Park 2 | 4 | |
3637 | 3637 | 3636 | {"type": "Polygon", "coordinates": [[[-121.29798, 38.79045], [-121.29787, 38.79056], [-121.29647, 38.78955], [-121.29697, 38.78912], [-121.2972, 38.78923], [-121.29802, 38.78946], [-121.29805, 38.78949], [-121.29803, 38.78966], [-121.29802, 38.79021], [-121.298, 38.79026], [-121.29795, 38.79031], [-121.29793, 38.79036], [-121.29795, 38.79041], [-121.29798, 38.79045]]]} | Open Access 1 | 29462 | Summerhill Park | 25959 | 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.889 | Summerhill Park | 0 | Local Park 2 | 4 | |
10910 | 10910 | 10909 | {"type": "Polygon", "coordinates": [[[-121.28143, 38.75753], [-121.28031, 38.7582], [-121.27963, 38.7575], [-121.28075, 38.75684], [-121.28143, 38.75753]]]} | Open Access 1 | 20899 | Woodbridge Park | 27687 | 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.938 | Woodbridge Park | 0 | Local Park 2 | 4 | |
5034 | 5034 | 5033 | {"type": "Polygon", "coordinates": [[[-121.2388, 38.76523], [-121.23847, 38.76535], [-121.23837, 38.76531], [-121.23826, 38.76531], [-121.23819, 38.76535], [-121.23815, 38.76541], [-121.23814, 38.76548], [-121.23818, 38.76554], [-121.23789, 38.7657], [-121.2375, 38.76574], [-121.23744, 38.76562], [-121.23735, 38.76551], [-121.23723, 38.76541], [-121.23707, 38.76532], [-121.23704, 38.76527], [-121.23718, 38.76505], [-121.23735, 38.76483], [-121.23754, 38.76463], [-121.23784, 38.76438], [-121.23858, 38.76499], [-121.23871, 38.76512], [-121.2388, 38.76523]]]} | Open Access 1 | 20837 | Cambria Park | 16749 | 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.001 | Cambria Park | 0 | Local Park 2 | 4 | |
12462 | 12462 | 12461 | {"type": "Polygon", "coordinates": [[[-121.32842, 38.79859], [-121.32841, 38.7991], [-121.32835, 38.79916], [-121.32623, 38.79916], [-121.32624, 38.79857], [-121.32842, 38.79859]]]} | Open Access 1 | 48761 | Walter and Doris Rickey Park | 33488 | 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.029 | Walter and Doris Rickey Park | 0 | Local Park 2 | 4 | |
10915 | 10915 | 10914 | {"type": "Polygon", "coordinates": [[[-121.27631, 38.74104], [-121.27637, 38.74105], [-121.27689, 38.74135], [-121.27712, 38.74146], [-121.27775, 38.74169], [-121.27777, 38.74174], [-121.27776, 38.7422], [-121.27774, 38.74223], [-121.27767, 38.74226], [-121.27718, 38.74225], [-121.27631, 38.74215], [-121.27626, 38.74213], [-121.27624, 38.74208], [-121.27624, 38.7411], [-121.27626, 38.74106], [-121.27631, 38.74104]]]} | Open Access 1 | 20919 | Garbolino Park | 19190 | 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.058 | Garbolino Park | 0 | Local Park 2 | 4 | |
3636 | 3636 | 3635 | {"type": "Polygon", "coordinates": [[[-121.2735, 38.793], [-121.2735, 38.793], [-121.27194, 38.79238], [-121.27218, 38.79202], [-121.2723, 38.79191], [-121.27246, 38.79182], [-121.27265, 38.79175], [-121.27284, 38.79173], [-121.27305, 38.79174], [-121.27326, 38.79179], [-121.27343, 38.79187], [-121.27359, 38.792], [-121.2737, 38.79214], [-121.27376, 38.79231], [-121.27377, 38.79243], [-121.27374, 38.7926], [-121.27369, 38.7927], [-121.2735, 38.793]]]} | Open Access 1 | 29460 | Del Stephenson Park | 18056 | 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.526 | Del Stephenson Park | 0 | Local Park 2 | 4 | |
12647 | 12647 | 12646 | {"type": "Polygon", "coordinates": [[[-121.2594, 38.74656], [-121.2593, 38.74661], [-121.25925, 38.7467], [-121.25919, 38.74691], [-121.2591, 38.747], [-121.25877, 38.747], [-121.25821, 38.74694], [-121.258, 38.74697], [-121.258, 38.74604], [-121.2582, 38.74599], [-121.25828, 38.74594], [-121.25832, 38.74583], [-121.25832, 38.74568], [-121.25867, 38.74549], [-121.25883, 38.74544], [-121.25893, 38.74525], [-121.25912, 38.74525], [-121.25913, 38.7458], [-121.25914, 38.74601], [-121.25924, 38.7463], [-121.2594, 38.74656]]]} | Open Access 1 | 29482 | Marco Dog Park | 21796 | 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.975 | Marco Dog Park | 0 | Local Park 2 | 4 | |
10889 | 10889 | 10888 | {"type": "Polygon", "coordinates": [[[-121.22636, 38.76641], [-121.22597, 38.76681], [-121.22581, 38.76691], [-121.22564, 38.76699], [-121.22522, 38.76711], [-121.22482, 38.76726], [-121.22478, 38.76716], [-121.22476, 38.76704], [-121.22476, 38.7666], [-121.22479, 38.76644], [-121.22488, 38.76626], [-121.22507, 38.76605], [-121.22515, 38.76594], [-121.22521, 38.76584], [-121.22525, 38.76571], [-121.22601, 38.76549], [-121.22606, 38.76579], [-121.22614, 38.76606], [-121.22613, 38.76612], [-121.22604, 38.76622], [-121.22603, 38.76627], [-121.22604, 38.76632], [-121.2261, 38.76638], [-121.22617, 38.76641], [-121.22626, 38.76641], [-121.22634, 38.76638], [-121.22636, 38.76641]]]} | Open Access 1 | 20836 | David Uribe Park | 17945 | 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.999 | David Uribe Park | 0 | Local Park 2 | 4 | |
10913 | 10913 | 10912 | {"type": "Polygon", "coordinates": [[[-121.29803, 38.7269], [-121.29665, 38.7269], [-121.29661, 38.72687], [-121.29659, 38.72684], [-121.29664, 38.72603], [-121.29671, 38.72579], [-121.29673, 38.72567], [-121.29803, 38.72567], [-121.29803, 38.7269]]]} | Open Access 1 | 20916 | Cresthaven Park | 17806 | 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.084 | Cresthaven Park | 0 | Local Park 2 | 4 | |
10897 | 10897 | 10896 | {"type": "Polygon", "coordinates": [[[-121.33607, 38.80579], [-121.33607, 38.80666], [-121.33435, 38.80665], [-121.33415, 38.80581], [-121.33417, 38.80577], [-121.33422, 38.80574], [-121.33466, 38.80568], [-121.33501, 38.80567], [-121.33549, 38.80569], [-121.33607, 38.80579]]]} | Open Access 1 | 20851 | Leonard Davis Park | 21173 | 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.123 | Leonard Davis 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]);