units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where DES_TP = 14 and MNG_AGENCY = 533 sorted by map descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 46
MNG_AGENCY 1
- Roseville, City of · 46 ✖
DES_TP 1
- Local Other or Unknown · 46 ✖
ACCESS_TYP 1
- Open Access 46
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3539 | 3539 | 3538 | {"type": "Polygon", "coordinates": [[[-121.3399, 38.77607], [-121.33948, 38.77588], [-121.33948, 38.77588], [-121.33969, 38.77582], [-121.3399, 38.77607]]]} | Open Access 1 | 36403 | Roseville holding 13 | 24631 | 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.081 | Roseville holding 13 | 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 | |
13853 | 13853 | 13852 | {"type": "Polygon", "coordinates": [[[-121.33095, 38.77505], [-121.3309, 38.77508], [-121.33064, 38.77475], [-121.33058, 38.77475], [-121.33055, 38.77471], [-121.33059, 38.77467], [-121.33037, 38.77434], [-121.33022, 38.77406], [-121.33005, 38.77369], [-121.32995, 38.77341], [-121.32979, 38.77341], [-121.32965, 38.77334], [-121.32966, 38.77266], [-121.32976, 38.77265], [-121.32982, 38.77269], [-121.32991, 38.77309], [-121.32999, 38.77336], [-121.3301, 38.77364], [-121.33022, 38.77392], [-121.33036, 38.7742], [-121.33057, 38.77455], [-121.33095, 38.77505]]]} | Open Access 1 | 36442 | Roseville holding 40 | 24661 | 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.731 | Roseville holding 40 | 0 | Local Other or Unknown 14 | 4 | |
13852 | 13852 | 13851 | {"type": "Polygon", "coordinates": [[[-121.33024, 38.76448], [-121.33023, 38.7647], [-121.32995, 38.7647], [-121.32996, 38.76448], [-121.33024, 38.76448]]]} | Open Access 1 | 36441 | Roseville holding 39 | 24659 | 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.146 | Roseville holding 39 | 0 | Local Other or Unknown 14 | 4 | |
3547 | 3547 | 3546 | {"type": "Polygon", "coordinates": [[[-121.32679, 38.76689], [-121.3266, 38.76689], [-121.3266, 38.76659], [-121.32679, 38.76659], [-121.32679, 38.76689]]]} | Open Access 1 | 36445 | Roseville holding 1 | 24627 | 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.139 | Roseville holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13856 | 13856 | 13855 | {"type": "Polygon", "coordinates": [[[-121.32457, 38.76049], [-121.32457, 38.76049], [-121.32436, 38.76079], [-121.32439, 38.7605], [-121.32457, 38.76049]]]} | Open Access 1 | 36447 | Roseville holding 7 | 24667 | 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.06 | Roseville holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13851 | 13851 | 13850 | {"type": "Polygon", "coordinates": [[[-121.32215, 38.76468], [-121.32215, 38.76468], [-121.32201, 38.76495], [-121.32198, 38.76464], [-121.32215, 38.76468]]]} | Open Access 1 | 36440 | Roseville holding 41 | 24662 | 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.06 | Roseville holding 41 | 0 | Local Other or Unknown 14 | 4 | |
13820 | 13820 | 13819 | {"type": "Polygon", "coordinates": [[[-121.31816, 38.77053], [-121.31806, 38.77076], [-121.31784, 38.77063], [-121.31776, 38.77046], [-121.31816, 38.77053]]]} | Open Access 1 | 36404 | Roseville holding 14 | 24632 | 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.147 | Roseville holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13859 | 13859 | 13858 | {"type": "Polygon", "coordinates": [[[-121.31794, 38.76388], [-121.31789, 38.76403], [-121.31784, 38.76406], [-121.31764, 38.76402], [-121.31755, 38.76399], [-121.31753, 38.76397], [-121.31752, 38.76394], [-121.3176, 38.7635], [-121.31761, 38.76338], [-121.31777, 38.76339], [-121.31791, 38.76343], [-121.31778, 38.76341], [-121.31767, 38.76341], [-121.31767, 38.76352], [-121.31762, 38.7638], [-121.31794, 38.76388]]]} | Open Access 1 | 36450 | Roseville holding 5 | 24665 | 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.263 | Roseville holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13824 | 13824 | 13823 | {"type": "Polygon", "coordinates": [[[-121.31748, 38.76975], [-121.31732, 38.76971], [-121.31722, 38.76963], [-121.31737, 38.76942], [-121.31747, 38.76953], [-121.31748, 38.76975]]]} | Open Access 1 | 36410 | Roseville holding 12 | 24630 | 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.121 | Roseville holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13858 | 13858 | 13857 | {"type": "Polygon", "coordinates": [[[-121.31745, 38.76323], [-121.31744, 38.76338], [-121.31446, 38.76336], [-121.31446, 38.76316], [-121.31737, 38.76318], [-121.31742, 38.7632], [-121.31745, 38.76323]]]} | Open Access 1 | 36449 | Roseville holding 6 | 24666 | 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.418 | Roseville holding 6 | 0 | Local Other or Unknown 14 | 4 | |
5386 | 5386 | 5385 | {"type": "Polygon", "coordinates": [[[-121.31243, 38.80095], [-121.3121, 38.80123], [-121.31177, 38.801], [-121.31176, 38.80095], [-121.31148, 38.80074], [-121.31191, 38.80058], [-121.31243, 38.80095]]]} | Open Access 1 | 36419 | Roseville holding 30 | 24650 | 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.7 | Roseville holding 30 | 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 | |
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 | |
13857 | 13857 | 13856 | {"type": "Polygon", "coordinates": [[[-121.29997, 38.7584], [-121.29997, 38.7584], [-121.29997, 38.75871], [-121.29978, 38.75851], [-121.29978, 38.75839], [-121.29997, 38.7584]]]} | Open Access 1 | 36448 | Roseville holding 8 | 24668 | 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.096 | Roseville holding 8 | 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 | |
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 | |
10918 | 10918 | 10917 | {"type": "Polygon", "coordinates": [[[-121.28931, 38.73527], [-121.28926, 38.73535], [-121.28919, 38.73532], [-121.28927, 38.73501], [-121.28923, 38.73477], [-121.28889, 38.73486], [-121.28886, 38.73484], [-121.2892, 38.73473], [-121.28893, 38.73434], [-121.28848, 38.73416], [-121.28827, 38.73404], [-121.28811, 38.73391], [-121.28768, 38.73376], [-121.28769, 38.73373], [-121.28697, 38.73301], [-121.28696, 38.73287], [-121.28596, 38.73286], [-121.28595, 38.73305], [-121.28563, 38.73306], [-121.28482, 38.73357], [-121.2845, 38.73363], [-121.28378, 38.73346], [-121.28357, 38.73328], [-121.28339, 38.73323], [-121.28305, 38.73259], [-121.2832, 38.73219], [-121.2832, 38.73179], [-121.28349, 38.73159], [-121.28366, 38.73137], [-121.28382, 38.73123], [-121.28412, 38.73154], [-121.28378, 38.73159], [-121.28366, 38.73184], [-121.28366, 38.73285], [-121.28421, 38.7332], [-121.28441, 38.73322], [-121.28474, 38.73313], [-121.28474, 38.73306], [-121.28486, 38.73306], [-121.28508, 38.73292], [-121.28537, 38.73268], [-121.28574, 38.73246], [-121.28582, 38.73234], [-121.28596, 38.73234], [-121.28597, 38.73238], [-121.2864, 38.73239], [-121.28691, 38.73245], [-121.28733, 38.73266], [-121.28753, 38.73284], [-121.2878, 38.73301], [-121.28786, 38.73307], [-121.28825, 38.7333], [-121.28826, 38.73334], [-121.28844, 38.73337], [-121.28862, 38.73345], [-121.28884, 38.73347], [-121.28928, 38.73373], [-121.28931, 38.73527]]]} | Open Access 1 | 20924 | Flood Control | 18952 | 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.315 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
5385 | 5385 | 5384 | {"type": "Polygon", "coordinates": [[[-121.28307, 38.78], [-121.28264, 38.78022], [-121.28219, 38.78039], [-121.28199, 38.78005], [-121.28182, 38.77989], [-121.28146, 38.77964], [-121.28221, 38.77939], [-121.28307, 38.78]]]} | Open Access 1 | 36418 | Roseville holding 31 | 24651 | 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.841 | Roseville holding 31 | 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]);