superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
124 rows where MNG_AGENCY = 533 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7575 | 7575 | 7574 | {"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.73097], [-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.2539, 38.73008], [-121.25343, 38.73003], [-121.25286, 38.73006], [-121.25286, 38.72987], [-121.2539, 38.72987], [-121.25391, 38.72967], [-121.25567, 38.72967], [-121.25572, 38.72971]]]} | Open Access 1 | Roseville holding 38 | 24658 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 5.222 | Roseville holding 38 | ||
8955 | 8955 | 8954 | {"type": "Polygon", "coordinates": [[[-121.25834, 38.73133], [-121.25794, 38.73149], [-121.25793, 38.73087], [-121.25833, 38.73087], [-121.25834, 38.73133]]]} | Open Access 1 | Roseville holding 10 | 24628 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.513 | Roseville holding 10 | ||
6605 | 6605 | 6604 | {"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 | Marco Dog Park | 21796 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 3.975 | Marco Dog Park | ||
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 | ||
8972 | 8972 | 8971 | {"type": "Polygon", "coordinates": [[[-121.26094, 38.73866], [-121.26079, 38.73896], [-121.26056, 38.73889], [-121.26071, 38.73859], [-121.26094, 38.73866]]]} | Open Access 1 | Roseville holding 20 | 24639 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.187 | Roseville holding 20 | ||
8974 | 8974 | 8973 | {"type": "Polygon", "coordinates": [[[-121.26187, 38.74161], [-121.26125, 38.74206], [-121.26126, 38.74403], [-121.26106, 38.74403], [-121.26106, 38.74327], [-121.26098, 38.74322], [-121.26038, 38.74322], [-121.26038, 38.74317], [-121.26099, 38.74317], [-121.26106, 38.74311], [-121.26106, 38.74198], [-121.26164, 38.74155], [-121.26163, 38.74138], [-121.2616, 38.74118], [-121.26037, 38.74062], [-121.26014, 38.74062], [-121.2601, 38.74037], [-121.26044, 38.7403], [-121.2604, 38.74015], [-121.26031, 38.73951], [-121.26036, 38.73928], [-121.26049, 38.73903], [-121.26071, 38.7391], [-121.26059, 38.73935], [-121.26056, 38.73955], [-121.26064, 38.74012], [-121.26076, 38.74054], [-121.2609, 38.74068], [-121.26181, 38.74109], [-121.26187, 38.74161]]]} | Open Access 1 | Roseville holding 22 | 24641 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 3.293 | Roseville holding 22 | ||
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 | ||
7013 | 7013 | 7012 | {"type": "Polygon", "coordinates": [[[-121.26288, 38.75472], [-121.26165, 38.75576], [-121.26024, 38.75636], [-121.2599, 38.75658], [-121.25957, 38.75693], [-121.25942, 38.7572], [-121.25928, 38.75719], [-121.25913, 38.75715], [-121.25811, 38.75675], [-121.2583, 38.75636], [-121.25846, 38.75613], [-121.25865, 38.75607], [-121.25897, 38.75611], [-121.25925, 38.75602], [-121.25879, 38.75582], [-121.25853, 38.75577], [-121.25864, 38.75568], [-121.25905, 38.75576], [-121.2594, 38.75588], [-121.25963, 38.7556], [-121.25971, 38.75563], [-121.25996, 38.75532], [-121.26005, 38.75535], [-121.26039, 38.75492], [-121.26036, 38.75477], [-121.26023, 38.7547], [-121.26041, 38.75449], [-121.26063, 38.75445], [-121.26067, 38.75462], [-121.26083, 38.75481], [-121.26119, 38.75475], [-121.26116, 38.75459], [-121.26112, 38.75458], [-121.26108, 38.75438], [-121.26112, 38.75435], [-121.26136, 38.75427], [-121.26157, 38.75423], [-121.26148, 38.75381], [-121.26193, 38.75408], [-121.2621, 38.75415], [-121.26238, 38.75435], [-121.2627, 38.75464], [-121.26288, 38.75472]], [[-121.26235, 38.75516], [-121.26235, 38.75514], [-121.26206, 38.75493], [-121.26189, 38.75488], [-121.26133, 38.75525], [-121.26147, 38.75548], [-121.26154, 38.75545], [-121.26208, 38.75534], [-121.26235, 38.75516]]]} | Open Access 1 | Miner's Ravine Trail | 22260 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 12.465 | Miner's Ravine Trail | ||
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 | ||
8984 | 8984 | 8983 | {"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 | Roseville holding 33 | 24653 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 10.415 | Roseville holding 33 | ||
8976 | 8976 | 8975 | {"type": "Polygon", "coordinates": [[[-121.2719, 38.72246], [-121.27189, 38.72249], [-121.27183, 38.72252], [-121.27163, 38.72252], [-121.27162, 38.72235], [-121.27153, 38.72222], [-121.27189, 38.72221], [-121.2719, 38.72246]]]} | Open Access 1 | Roseville holding 24 | 24643 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.216 | Roseville holding 24 | ||
8975 | 8975 | 8974 | {"type": "Polygon", "coordinates": [[[-121.27192, 38.72489], [-121.27154, 38.72489], [-121.27165, 38.72472], [-121.27164, 38.72427], [-121.27117, 38.72371], [-121.27131, 38.72364], [-121.27155, 38.72304], [-121.2716, 38.72267], [-121.27184, 38.72267], [-121.27188, 38.72269], [-121.27191, 38.72273], [-121.27192, 38.72489]]]} | Open Access 1 | Roseville holding 23 | 24642 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.208 | Roseville holding 23 | ||
10069 | 10069 | 10068 | {"type": "Polygon", "coordinates": [[[-121.27193, 38.72703], [-121.2719, 38.72707], [-121.27185, 38.72708], [-121.27094, 38.72708], [-121.2707, 38.72705], [-121.27051, 38.72697], [-121.27035, 38.72685], [-121.27024, 38.72671], [-121.27019, 38.72654], [-121.27018, 38.72645], [-121.27021, 38.72612], [-121.27069, 38.72614], [-121.27071, 38.72557], [-121.27122, 38.72527], [-121.27144, 38.72505], [-121.27154, 38.72489], [-121.27192, 38.72489], [-121.27193, 38.72703]]]} | Open Access 1 | Sun Tree Park | 25979 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 6.476 | Sun Tree Park | ||
8962 | 8962 | 8961 | {"type": "Polygon", "coordinates": [[[-121.27246, 38.72252], [-121.27227, 38.72252], [-121.2722, 38.72249], [-121.27218, 38.72246], [-121.27217, 38.72221], [-121.27246, 38.72221], [-121.27246, 38.72252]]]} | Open Access 1 | Roseville holding 17 | 24635 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.204 | Roseville holding 17 | ||
8980 | 8980 | 8979 | {"type": "Polygon", "coordinates": [[[-121.27303, 38.72705], [-121.27266, 38.72708], [-121.27227, 38.72708], [-121.27222, 38.72706], [-121.27221, 38.72704], [-121.27219, 38.72273], [-121.27221, 38.72269], [-121.27227, 38.72267], [-121.27246, 38.72266], [-121.27249, 38.72298], [-121.27246, 38.72335], [-121.27246, 38.72361], [-121.27252, 38.72382], [-121.27248, 38.72408], [-121.27248, 38.72432], [-121.27248, 38.72481], [-121.27251, 38.72514], [-121.27251, 38.72643], [-121.27263, 38.72662], [-121.2728, 38.72666], [-121.27303, 38.72705]]]} | Open Access 1 | Roseville holding 28 | 24647 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 3.55 | Roseville holding 28 | ||
5132 | 5132 | 5131 | {"type": "Polygon", "coordinates": [[[-121.27306, 38.75203], [-121.27181, 38.75204], [-121.27181, 38.75184], [-121.27082, 38.75101], [-121.27076, 38.75092], [-121.27152, 38.75045], [-121.27159, 38.75056], [-121.27169, 38.75052], [-121.27177, 38.75059], [-121.27186, 38.75064], [-121.27206, 38.75069], [-121.27228, 38.75067], [-121.27264, 38.75054], [-121.27306, 38.75203]]]} | Open Access 1 | Lincoln Estates Park | 21248 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 5.413 | Lincoln Estates Park | ||
3542 | 3542 | 3541 | {"type": "Polygon", "coordinates": [[[-121.27351, 38.793], [-121.2735, 38.793], [-121.27194, 38.79238], [-121.27218, 38.79201], [-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.27351, 38.793]]]} | Open Access 1 | Del Stephenson Park | 18056 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 3.525 | Del Stephenson Park | ||
11251 | 11251 | 11250 | {"type": "Polygon", "coordinates": [[[-121.27515, 38.75394], [-121.27379, 38.75397], [-121.27323, 38.75423], [-121.27256, 38.75336], [-121.27242, 38.75326], [-121.27147, 38.75324], [-121.27081, 38.75361], [-121.27047, 38.75404], [-121.27048, 38.75274], [-121.27131, 38.7524], [-121.27181, 38.75204], [-121.27232, 38.75203], [-121.27234, 38.75259], [-121.27515, 38.75257], [-121.27515, 38.75394]]]} | Open Access 1 | William L. Taylor Park | 27548 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 13.616 | William L. Taylor Park | ||
6896 | 6896 | 6895 | {"type": "Polygon", "coordinates": [[[-121.27603, 38.78552], [-121.27597, 38.7856], [-121.2759, 38.78566], [-121.27561, 38.78584], [-121.27527, 38.78597], [-121.2749, 38.78607], [-121.27452, 38.78613], [-121.27404, 38.78616], [-121.27345, 38.78617], [-121.27316, 38.78614], [-121.27271, 38.78661], [-121.27261, 38.7867], [-121.27241, 38.78681], [-121.27226, 38.78686], [-121.27211, 38.78688], [-121.27194, 38.78688], [-121.27177, 38.78686], [-121.27162, 38.78681], [-121.27149, 38.78675], [-121.27134, 38.78664], [-121.27106, 38.78634], [-121.27106, 38.78628], [-121.27098, 38.78629], [-121.27091, 38.78632], [-121.27019, 38.78602], [-121.26991, 38.78607], [-121.26991, 38.786], [-121.26995, 38.78591], [-121.26994, 38.78586], [-121.26988, 38.78579], [-121.26979, 38.78576], [-121.26963, 38.78578], [-121.26905, 38.78577], [-121.26881, 38.78579], [-121.26857, 38.78582], [-121.26805, 38.78593], [-121.26783, 38.78593], [-121.26776, 38.78596], [-121.26729, 38.78599], [-121.26721, 38.78607], [-121.26697, 38.78664], [-121.26684, 38.78648], [-121.26707, 38.78593], [-121.26736, 38.78575], [-121.26862, 38.78553], [-121.26945, 38.78548], [-121.26981, 38.78552], [-121.2708, 38.78601], [-121.27134, 38.78606], [-121.27207, 38.78582], [-121.27242, 38.78581], [-121.27348, 38.78594], [-121.274, 38.78597], [-121.27441, 38.78594], [-121.2749, 38.78586], [-121.27564, 38.78562], [-121.27583, 38.78542], [-121.27603, 38.78552]]]} | Open Access 1 | Melba And William Erven Park | 22107 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 8.154 | Melba And William Erven Park | ||
8983 | 8983 | 8982 | {"type": "Polygon", "coordinates": [[[-121.2774, 38.75226], [-121.27672, 38.7523], [-121.276, 38.7525], [-121.27516, 38.75246], [-121.27515, 38.75257], [-121.27232, 38.75259], [-121.27232, 38.75203], [-121.27305, 38.75202], [-121.27274, 38.7509], [-121.27349, 38.75084], [-121.2741, 38.75115], [-121.27423, 38.75136], [-121.27424, 38.75152], [-121.2746, 38.75152], [-121.27459, 38.75166], [-121.27461, 38.75202], [-121.27739, 38.75201], [-121.2774, 38.75226]]]} | Open Access 1 | Roseville holding 32 | 24652 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 9.599 | Roseville holding 32 |
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]);