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 UNIT_NAME 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4814 | 4814 | 4813 | {"type": "Polygon", "coordinates": [[[-121.22585, 38.76387], [-121.22532, 38.76402], [-121.22495, 38.76411], [-121.22456, 38.76418], [-121.22408, 38.76423], [-121.22418, 38.76363], [-121.22563, 38.76349], [-121.22577, 38.76368], [-121.22585, 38.76387]]]} | Open Access 1 | 48764 | Unknown Park - Roseville, City of | 33491 | 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.092 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
13841 | 13841 | 13840 | {"type": "Polygon", "coordinates": [[[-121.25572, 38.72971], [-121.25572, 38.73032], [-121.2557, 38.73046], [-121.25562, 38.73062], [-121.25555, 38.73072], [-121.25548, 38.7307], [-121.25502, 38.73118], [-121.25487, 38.73128], [-121.25469, 38.73134], [-121.25452, 38.73102], [-121.25441, 38.73102], [-121.25442, 38.731], [-121.25449, 38.73098], [-121.25448, 38.7306], [-121.25445, 38.73046], [-121.25435, 38.73028], [-121.25413, 38.73021], [-121.25399, 38.73019], [-121.25392, 38.73021], [-121.25391, 38.73008], [-121.25343, 38.73003], [-121.25286, 38.73006], [-121.25286, 38.72987], [-121.25391, 38.72987], [-121.25391, 38.72967], [-121.25567, 38.72967], [-121.25572, 38.72971]]]} | Open Access 1 | 36432 | Roseville holding 38 | 24658 | 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 | 5.217 | Roseville holding 38 | 0 | Local Other or Unknown 14 | 4 | |
13846 | 13846 | 13845 | {"type": "Polygon", "coordinates": [[[-121.24296, 38.71911], [-121.24239, 38.71886], [-121.2423, 38.71857], [-121.2423, 38.71852], [-121.24233, 38.71848], [-121.24273, 38.71815], [-121.24269, 38.71824], [-121.24268, 38.71838], [-121.24271, 38.71863], [-121.24281, 38.71889], [-121.24296, 38.71911]]]} | Open Access 1 | 36435 | Roseville holding 37 | 24657 | 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.609 | Roseville holding 37 | 0 | Local Other or Unknown 14 | 4 | |
13839 | 13839 | 13838 | {"type": "Polygon", "coordinates": [[[-121.24156, 38.73934], [-121.24125, 38.73946], [-121.24051, 38.73948], [-121.23986, 38.73945], [-121.2389, 38.7392], [-121.23841, 38.73917], [-121.23818, 38.73912], [-121.23784, 38.73924], [-121.23757, 38.73919], [-121.23748, 38.73911], [-121.23722, 38.73929], [-121.23715, 38.73925], [-121.23711, 38.73918], [-121.23683, 38.73919], [-121.23671, 38.73931], [-121.2367, 38.73946], [-121.23634, 38.7397], [-121.23614, 38.74011], [-121.23586, 38.74029], [-121.2358, 38.74004], [-121.23578, 38.73942], [-121.23583, 38.73941], [-121.23581, 38.73859], [-121.23594, 38.73848], [-121.23736, 38.73854], [-121.23819, 38.73859], [-121.23827, 38.73864], [-121.23838, 38.73864], [-121.23862, 38.73869], [-121.2387, 38.73882], [-121.23882, 38.73891], [-121.23891, 38.73892], [-121.23896, 38.73896], [-121.23928, 38.73901], [-121.23969, 38.73912], [-121.23979, 38.73911], [-121.2399, 38.73916], [-121.24007, 38.73913], [-121.24012, 38.7391], [-121.24017, 38.73912], [-121.24022, 38.73912], [-121.24029, 38.73908], [-121.24043, 38.73913], [-121.24063, 38.73914], [-121.24065, 38.73915], [-121.24122, 38.73912], [-121.24156, 38.73934]]]} | Open Access 1 | 36430 | Roseville holding 36 | 24656 | 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 | 7.922 | Roseville holding 36 | 0 | Local Other or Unknown 14 | 4 | |
13836 | 13836 | 13835 | {"type": "Polygon", "coordinates": [[[-121.22836, 38.73076], [-121.22836, 38.73086], [-121.22831, 38.73091], [-121.22796, 38.73092], [-121.22796, 38.73079], [-121.22828, 38.73079], [-121.22832, 38.73076], [-121.22836, 38.73076]]]} | Open Access 1 | 36427 | Roseville holding 35 | 24655 | 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.124 | Roseville holding 35 | 0 | Local Other or Unknown 14 | 4 | |
13833 | 13833 | 13832 | {"type": "MultiPolygon", "coordinates": [[[[-121.26563, 38.75907], [-121.26557, 38.7593], [-121.2655, 38.75933], [-121.26527, 38.75949], [-121.26532, 38.75954], [-121.26548, 38.75949], [-121.26554, 38.75951], [-121.2656, 38.75956], [-121.2656, 38.76219], [-121.26264, 38.76212], [-121.26238, 38.76232], [-121.26236, 38.76614], [-121.26277, 38.76663], [-121.26083, 38.76664], [-121.2601, 38.76776], [-121.26007, 38.76784], [-121.26007, 38.76802], [-121.26014, 38.76828], [-121.26048, 38.76883], [-121.26044, 38.76961], [-121.26028, 38.77043], [-121.25966, 38.77028], [-121.25947, 38.77022], [-121.25929, 38.77014], [-121.25866, 38.76979], [-121.25872, 38.76979], [-121.25913, 38.76859], [-121.25831, 38.76752], [-121.25745, 38.76894], [-121.25746, 38.76946], [-121.25729, 38.76949], [-121.25656, 38.76967], [-121.2566, 38.76976], [-121.25733, 38.76959], [-121.25746, 38.76957], [-121.25746, 38.76959], [-121.25646, 38.76981], [-121.25603, 38.76986], [-121.25586, 38.76991], [-121.25581, 38.76991], [-121.25573, 38.76989], [-121.25566, 38.76979], [-121.25497, 38.76977], [-121.25568, 38.76893], [-121.25606, 38.76844], [-121.2565, 38.76781], [-121.25726, 38.76665], [-121.2574, 38.76664], [-121.25789, 38.76595], [-121.25836, 38.76526], [-121.25906, 38.76417], [-121.26115, 38.76082], [-121.26133, 38.76058], [-121.26153, 38.76035], [-121.26192, 38.76001], [-121.2623, 38.75976], [-121.26277, 38.75952], [-121.26323, 38.75935], [-121.2637, 38.75922], [-121.26419, 38.75914], [-121.26563, 38.75907]]], [[[-121.25747, 38.7696], [-121.25759, 38.76957], [-121.25774, 38.76958], [-121.2579, 38.7696], [-121.25807, 38.76965], [-121.25822, 38.76972], [-121.25931, 38.77031], [-121.25957, 38.77041], [-121.26025, 38.77057], [-121.26018, 38.77076], [-121.2601, 38.77085], [-121.26003, 38.77089], [-121.25963, 38.77103], [-121.25942, 38.77113], [-121.25923, 38.77128], [-121.25908, 38.77147], [-121.25878, 38.77197], [-121.25851, 38.77251], [-121.25829, 38.77354], [-121.25636, 38.7731], [-121.25634, 38.77292], [-121.25603, 38.77257], [-121.25652, 38.77212], [-121.25656, 38.77206], [-121.2558, 38.77165], [-121.25603, 38.77139], [-121.25627, 38.77142], [-121.25663, 38.77083], [-121.2564, 38.77022], [-121.25673, 38.77014], [-121.25661, 38.7698], [-121.25747, 38.7696]]]]} | Open Access 1 | 36423 | Roseville holding 34 | 24654 | 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 | 116.361 | Roseville holding 34 | 0 | Local Other or Unknown 14 | 4 | |
13834 | 13834 | 13833 | {"type": "Polygon", "coordinates": [[[-121.27048, 38.75274], [-121.27047, 38.7546], [-121.27033, 38.75483], [-121.27031, 38.75482], [-121.26791, 38.75602], [-121.26765, 38.75586], [-121.2677, 38.75551], [-121.26776, 38.75465], [-121.26924, 38.754], [-121.26978, 38.75317], [-121.27029, 38.75281], [-121.27048, 38.75274]]]} | Open Access 1 | 36424 | Roseville holding 33 | 24653 | 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.414 | Roseville holding 33 | 0 | Local Other or Unknown 14 | 4 | |
13830 | 13830 | 13829 | {"type": "Polygon", "coordinates": [[[-121.2774, 38.75226], [-121.27672, 38.7523], [-121.276, 38.7525], [-121.27515, 38.75246], [-121.27515, 38.75257], [-121.27232, 38.75259], [-121.27232, 38.75203], [-121.27306, 38.75202], [-121.27274, 38.7509], [-121.27349, 38.75084], [-121.2741, 38.75115], [-121.27423, 38.75136], [-121.27424, 38.75153], [-121.2746, 38.75152], [-121.27459, 38.75166], [-121.27461, 38.75202], [-121.27739, 38.75201], [-121.2774, 38.75226]]]} | Open Access 1 | 36417 | Roseville holding 32 | 24652 | 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.585 | Roseville holding 32 | 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]);