superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
117 rows where ACCESS_TYP = 1 and MNG_AGENCY = 533 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9483 | 9483 | 9482 | {"type": "Polygon", "coordinates": [[[-121.23375, 38.76677], [-121.23373, 38.76704], [-121.2333, 38.76698], [-121.23292, 38.76735], [-121.23232, 38.76763], [-121.2317, 38.76788], [-121.23105, 38.76811], [-121.22949, 38.76852], [-121.22919, 38.76864], [-121.22843, 38.7688], [-121.22828, 38.76894], [-121.22805, 38.76933], [-121.22789, 38.7695], [-121.2274, 38.76968], [-121.22692, 38.76969], [-121.22675, 38.76998], [-121.22677, 38.77033], [-121.22568, 38.77034], [-121.22612, 38.76975], [-121.2261, 38.76952], [-121.22446, 38.76905], [-121.22456, 38.76889], [-121.2247, 38.76876], [-121.22482, 38.76862], [-121.22494, 38.76846], [-121.22497, 38.76835], [-121.22497, 38.76821], [-121.22493, 38.76808], [-121.22472, 38.76779], [-121.22505, 38.76765], [-121.22532, 38.76804], [-121.22568, 38.76821], [-121.22575, 38.76826], [-121.22585, 38.76841], [-121.22598, 38.76882], [-121.22593, 38.76887], [-121.22621, 38.76924], [-121.22715, 38.76899], [-121.2277, 38.76851], [-121.22791, 38.76837], [-121.22838, 38.76813], [-121.22865, 38.76804], [-121.22891, 38.76798], [-121.23007, 38.7678], [-121.23104, 38.76724], [-121.23083, 38.76692], [-121.23118, 38.76679], [-121.23147, 38.76718], [-121.23193, 38.76712], [-121.23215, 38.76691], [-121.23228, 38.76661], [-121.23231, 38.7665], [-121.23236, 38.76643], [-121.23263, 38.76653], [-121.23299, 38.76663], [-121.23335, 38.76671], [-121.23375, 38.76677]]]} | Open Access 1 | Secret Ravine Park | 25281 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 18.529 | Secret Ravine Park | ||
9423 | 9423 | 9422 | {"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 | Sculpture Park | 25220 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.814 | Sculpture Park | ||
9378 | 9378 | 9377 | {"type": "MultiPolygon", "coordinates": [[[[-121.28756, 38.7378], [-121.28714, 38.7382], [-121.28686, 38.73842], [-121.28655, 38.73872], [-121.28634, 38.7391], [-121.28621, 38.73939], [-121.2859, 38.73951], [-121.2857, 38.73966], [-121.28558, 38.73989], [-121.28541, 38.73989], [-121.2852, 38.74024], [-121.2851, 38.74025], [-121.2851, 38.74041], [-121.28509, 38.74042], [-121.28465, 38.74133], [-121.28396, 38.74288], [-121.28397, 38.74289], [-121.28403, 38.7429], [-121.28403, 38.74386], [-121.28266, 38.74384], [-121.2826, 38.74382], [-121.28258, 38.74378], [-121.28259, 38.74216], [-121.28252, 38.74214], [-121.28253, 38.7407], [-121.2834, 38.74073], [-121.28341, 38.74], [-121.28348, 38.7399], [-121.28406, 38.7399], [-121.28419, 38.7398], [-121.28419, 38.73974], [-121.28477, 38.7395], [-121.28494, 38.73905], [-121.28513, 38.73878], [-121.28578, 38.73851], [-121.28643, 38.73781], [-121.28756, 38.7378]]], [[[-121.28933, 38.73623], [-121.28922, 38.73665], [-121.28846, 38.73666], [-121.28846, 38.73686], [-121.28862, 38.73686], [-121.28856, 38.737], [-121.28856, 38.73713], [-121.28846, 38.73714], [-121.28829, 38.73733], [-121.28804, 38.73725], [-121.28753, 38.73769], [-121.28694, 38.7377], [-121.28738, 38.73735], [-121.28776, 38.73714], [-121.28804, 38.73687], [-121.2883, 38.73666], [-121.2884, 38.73665], [-121.28865, 38.73635], [-121.28875, 38.7362], [-121.28931, 38.73527], [-121.28927, 38.73609], [-121.28933, 38.73623]]]]} | Open Access 1 | Saugstad Park | 25169 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 25.481 | Saugstad Park | ||
9358 | 9358 | 9357 | {"type": "Polygon", "coordinates": [[[-121.28958, 38.73527], [-121.2895, 38.73568], [-121.28937, 38.73609], [-121.28927, 38.73609], [-121.28931, 38.73527], [-121.28958, 38.73527]]]} | Open Access 1 | SAUGSTAD PARK | 25170 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.396 | SAUGSTAD PARK | ||
9066 | 9066 | 9065 | {"type": "Polygon", "coordinates": [[[-121.28919, 38.77703], [-121.28863, 38.77744], [-121.28814, 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.2867, 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 | Twinwood Park | 26624 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.591 | Twinwood Park | ||
9045 | 9045 | 9044 | {"type": "MultiPolygon", "coordinates": [[[[-121.31267, 38.77031], [-121.31263, 38.77031], [-121.3125, 38.77038], [-121.31217, 38.77046], [-121.31183, 38.77081], [-121.3114, 38.77111], [-121.30965, 38.7717], [-121.30851, 38.77124], [-121.30799, 38.77124], [-121.30753, 38.77115], [-121.30707, 38.77137], [-121.30682, 38.77201], [-121.30648, 38.77217], [-121.30611, 38.77171], [-121.30565, 38.77121], [-121.30515, 38.77073], [-121.30467, 38.77032], [-121.30418, 38.76994], [-121.30367, 38.76958], [-121.30314, 38.76924], [-121.30221, 38.76872], [-121.30205, 38.76789], [-121.30196, 38.7676], [-121.30187, 38.76736], [-121.30311, 38.76736], [-121.30298, 38.7674], [-121.30284, 38.7676], [-121.303, 38.76893], [-121.3037, 38.76936], [-121.30598, 38.76938], [-121.30639, 38.76955], [-121.30657, 38.7693], [-121.30715, 38.76953], [-121.30743, 38.7696], [-121.30734, 38.76991], [-121.30771, 38.7699], [-121.30779, 38.77007], [-121.30887, 38.7708], [-121.30921, 38.77094], [-121.30975, 38.77097], [-121.31093, 38.77067], [-121.31205, 38.76981], [-121.31267, 38.76981], [-121.31267, 38.77031]]], [[[-121.30817, 38.76946], [-121.30796, 38.76949], [-121.30769, 38.76949], [-121.30747, 38.76947], [-121.3073, 38.76942], [-121.30727, 38.76937], [-121.30734, 38.76919], [-121.30734, 38.76901], [-121.3077, 38.76894], [-121.30776, 38.76907], [-121.30817, 38.76946]]]]} | Open Access 1 | Rube Nelson Park | 24719 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 27.671 | Rube Nelson Park | ||
9044 | 9044 | 9043 | {"type": "Polygon", "coordinates": [[[-121.28444, 38.7455], [-121.28428, 38.74563], [-121.28444, 38.74577], [-121.28393, 38.74617], [-121.28383, 38.74643], [-121.28377, 38.74648], [-121.28366, 38.7467], [-121.284, 38.747], [-121.28398, 38.74709], [-121.28391, 38.74718], [-121.28304, 38.74792], [-121.28206, 38.74768], [-121.28214, 38.74735], [-121.28233, 38.74448], [-121.28252, 38.74407], [-121.28257, 38.74405], [-121.28339, 38.74399], [-121.28372, 38.74399], [-121.28374, 38.7448], [-121.28366, 38.74487], [-121.28444, 38.7455]]]} | Open Access 1 | Royer Park | 24718 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 14.777 | Royer Park | ||
8997 | 8997 | 8996 | {"type": "Polygon", "coordinates": [[[-121.33947, 38.77588], [-121.33905, 38.77566], [-121.33905, 38.77566], [-121.33934, 38.77566], [-121.33947, 38.77588]]]} | Open Access 1 | Roseville holding 9 | 24669 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.076 | Roseville holding 9 | ||
8996 | 8996 | 8995 | {"type": "Polygon", "coordinates": [[[-121.31744, 38.76323], [-121.31744, 38.76338], [-121.31446, 38.76336], [-121.31446, 38.76316], [-121.31737, 38.76318], [-121.31742, 38.7632], [-121.31744, 38.76323]]]} | Open Access 1 | Roseville holding 6 | 24666 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1.416 | Roseville holding 6 | ||
8995 | 8995 | 8994 | {"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.76342], [-121.31762, 38.7638], [-121.31794, 38.76388]]]} | Open Access 1 | Roseville holding 5 | 24665 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.261 | Roseville holding 5 | ||
8994 | 8994 | 8993 | {"type": "Polygon", "coordinates": [[[-121.25991, 38.74062], [-121.2595, 38.74063], [-121.25902, 38.74044], [-121.25852, 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.25649, 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 | Roseville holding 43 | 24664 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.54 | Roseville holding 43 | ||
8993 | 8993 | 8992 | {"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.72055], [-121.21585, 38.72053], [-121.21597, 38.72036], [-121.21628, 38.72067], [-121.21632, 38.72069], [-121.21635, 38.72066], [-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 | Roseville holding 42 | 24663 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 4.5 | Roseville holding 42 | ||
8992 | 8992 | 8991 | {"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 | Roseville holding 41 | 24662 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.059 | Roseville holding 41 | ||
8991 | 8991 | 8990 | {"type": "Polygon", "coordinates": [[[-121.33095, 38.77505], [-121.3309, 38.77508], [-121.33064, 38.77475], [-121.33058, 38.77475], [-121.33055, 38.77471], [-121.33058, 38.77467], [-121.33037, 38.77434], [-121.33022, 38.77407], [-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 | Roseville holding 40 | 24661 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.732 | Roseville holding 40 | ||
8990 | 8990 | 8989 | {"type": "Polygon", "coordinates": [[[-121.29545, 38.73776], [-121.2948, 38.73776], [-121.29479, 38.73737], [-121.29512, 38.73736], [-121.29511, 38.73671], [-121.29543, 38.73671], [-121.29545, 38.73776]]]} | Open Access 1 | Roseville holding 4 | 24660 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1.117 | Roseville holding 4 | ||
8989 | 8989 | 8988 | {"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 | Roseville holding 39 | 24659 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.146 | Roseville holding 39 | ||
8988 | 8988 | 8987 | {"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 | Roseville holding 37 | 24657 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.609 | Roseville holding 37 | ||
8987 | 8987 | 8986 | {"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.73912], [-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.73971], [-121.23614, 38.74011], [-121.23586, 38.74029], [-121.2358, 38.74004], [-121.23578, 38.73942], [-121.23583, 38.7394], [-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.23968, 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.24062, 38.73914], [-121.24066, 38.73915], [-121.24122, 38.73912], [-121.24156, 38.73934]]]} | Open Access 1 | Roseville holding 36 | 24656 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 7.926 | Roseville holding 36 | ||
8986 | 8986 | 8985 | {"type": "Polygon", "coordinates": [[[-121.22836, 38.73076], [-121.22836, 38.73086], [-121.22831, 38.73091], [-121.22796, 38.73092], [-121.22796, 38.73079], [-121.22827, 38.73079], [-121.22832, 38.73076], [-121.22836, 38.73076]]]} | Open Access 1 | Roseville holding 35 | 24655 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.124 | Roseville holding 35 | ||
8985 | 8985 | 8984 | {"type": "Polygon", "coordinates": [[[-121.26563, 38.75907], [-121.26557, 38.7593], [-121.2655, 38.75934], [-121.26528, 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.26239, 38.76232], [-121.26236, 38.76614], [-121.26277, 38.76663], [-121.26082, 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.76978], [-121.25913, 38.76859], [-121.25831, 38.76753], [-121.25745, 38.76894], [-121.25746, 38.76946], [-121.25729, 38.76949], [-121.25656, 38.76968], [-121.2566, 38.76976], [-121.25746, 38.76957], [-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.25633, 38.77292], [-121.25603, 38.77257], [-121.25652, 38.77212], [-121.25656, 38.77206], [-121.2558, 38.77165], [-121.25603, 38.77139], [-121.25628, 38.77142], [-121.25663, 38.77083], [-121.2564, 38.77022], [-121.25673, 38.77014], [-121.25661, 38.7698], [-121.2571, 38.76969], [-121.25711, 38.76967], [-121.25646, 38.76981], [-121.25603, 38.76986], [-121.25586, 38.76991], [-121.25573, 38.76989], [-121.25565, 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.76057], [-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]]]} | Open Access 1 | Roseville holding 34 | 24654 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 116.431 | Roseville holding 34 |
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]);