superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
218 rows where MNG_AGENCY = 534
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6220 | 6220 | 6219 | {"type": "Polygon", "coordinates": [[[-121.5125, 38.64237], [-121.51095, 38.64268], [-121.51095, 38.64222], [-121.51094, 38.64193], [-121.51087, 38.64153], [-121.51079, 38.64126], [-121.5108, 38.64122], [-121.51085, 38.6412], [-121.51203, 38.64094], [-121.5125, 38.64237]]]} | Open Access 1 | Linden Park | 21293 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.919 | Linden Park | ||
6225 | 6225 | 6224 | {"type": "Polygon", "coordinates": [[[-121.4988, 38.63277], [-121.49883, 38.63292], [-121.49884, 38.63318], [-121.49883, 38.63338], [-121.49878, 38.6336], [-121.49867, 38.63386], [-121.49859, 38.63399], [-121.49844, 38.6342], [-121.49831, 38.63433], [-121.49805, 38.63455], [-121.49788, 38.63466], [-121.49544, 38.636], [-121.49481, 38.63503], [-121.49437, 38.63503], [-121.49437, 38.63481], [-121.49491, 38.6348], [-121.4949, 38.63397], [-121.49559, 38.63396], [-121.49559, 38.63277], [-121.4988, 38.63277]]]} | Open Access 1 | Natomas Baseball Complex | 22667 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 20.145 | Natomas Baseball Complex | ||
6227 | 6227 | 6226 | {"type": "Polygon", "coordinates": [[[-121.51817, 38.60479], [-121.5172, 38.60577], [-121.51702, 38.60566], [-121.51683, 38.60557], [-121.51662, 38.6055], [-121.5164, 38.60546], [-121.51634, 38.60539], [-121.51626, 38.60539], [-121.51624, 38.60546], [-121.51483, 38.60563], [-121.51464, 38.60564], [-121.51449, 38.60563], [-121.51427, 38.6056], [-121.51409, 38.60555], [-121.51365, 38.60537], [-121.51361, 38.60531], [-121.51382, 38.60492], [-121.51392, 38.60467], [-121.51404, 38.60429], [-121.5141, 38.60395], [-121.5162, 38.60423], [-121.51815, 38.60453], [-121.51817, 38.60479]]]} | Open Access 1 | Natomas Oaks Park | 22669 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 13.064 | Natomas Oaks Park | ||
6352 | 6352 | 6351 | {"type": "Polygon", "coordinates": [[[-121.50672, 38.66802], [-121.50672, 38.66802], [-121.50395, 38.66804], [-121.50412, 38.66774], [-121.50423, 38.66746], [-121.5043, 38.66714], [-121.50431, 38.66685], [-121.50529, 38.66685], [-121.50671, 38.66684], [-121.50672, 38.66802]]]} | Open Access 1 | North Natomas Park Nature Area | 22833 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 7.099 | North Natomas Park Nature Area | ||
6526 | 6526 | 6525 | {"type": "Polygon", "coordinates": [[[-121.42547, 38.54528], [-121.42544, 38.54602], [-121.42545, 38.54693], [-121.42317, 38.54694], [-121.42318, 38.54602], [-121.42372, 38.54601], [-121.42373, 38.54548], [-121.42318, 38.54545], [-121.42318, 38.54528], [-121.42547, 38.54528]]]} | Open Access 1 | Mae Fong Park | 21666 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 8.286 | Mae Fong Park | ||
6532 | 6532 | 6531 | {"type": "Polygon", "coordinates": [[[-121.53719, 38.67975], [-121.53719, 38.68044], [-121.53664, 38.68044], [-121.53429, 38.68025], [-121.53425, 38.68023], [-121.53422, 38.6802], [-121.53426, 38.67993], [-121.53434, 38.67958], [-121.53627, 38.67975], [-121.53719, 38.67975]]]} | Open Access 1 | Magnolia Park Site | 21684 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.68 | Magnolia Park Site | ||
6533 | 6533 | 6532 | {"type": "MultiPolygon", "coordinates": [[[[-121.39146, 38.55714], [-121.39076, 38.55721], [-121.39064, 38.55522], [-121.39032, 38.55522], [-121.38874, 38.55538], [-121.38866, 38.55491], [-121.38868, 38.55472], [-121.38862, 38.55445], [-121.38924, 38.55438], [-121.38979, 38.55436], [-121.38998, 38.55437], [-121.39001, 38.5544], [-121.39002, 38.55448], [-121.39019, 38.55448], [-121.39021, 38.55439], [-121.39026, 38.55436], [-121.39103, 38.55434], [-121.39128, 38.55431], [-121.39146, 38.55714]]], [[[-121.39125, 38.55376], [-121.39098, 38.55378], [-121.391, 38.55418], [-121.39057, 38.55419], [-121.39041, 38.55143], [-121.38987, 38.55054], [-121.39086, 38.55056], [-121.39086, 38.55089], [-121.39111, 38.55127], [-121.39125, 38.55376]]]]} | Open Access 1 | Magoichi Oki Park | 21685 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 15.078 | Magoichi Oki Park | ||
6551 | 6551 | 6550 | {"type": "MultiPolygon", "coordinates": [[[[-121.44157, 38.63372], [-121.44112, 38.63373], [-121.44112, 38.63475], [-121.44009, 38.63474], [-121.4401, 38.63351], [-121.44111, 38.63351], [-121.44113, 38.6331], [-121.44157, 38.6331], [-121.44157, 38.63372]]], [[[-121.44223, 38.6338], [-121.44223, 38.63476], [-121.44176, 38.63476], [-121.44175, 38.63375], [-121.44179, 38.6338], [-121.44223, 38.6338]]]]} | Open Access 1 | Mama Marks Park | 21715 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.794 | Mama Marks Park | ||
6587 | 6587 | 6586 | {"type": "Polygon", "coordinates": [[[-121.46357, 38.62459], [-121.46333, 38.62489], [-121.46332, 38.62522], [-121.46284, 38.62521], [-121.46269, 38.62519], [-121.4625, 38.6251], [-121.46242, 38.62504], [-121.46236, 38.62496], [-121.46236, 38.62493], [-121.46239, 38.6249], [-121.4633, 38.62445], [-121.46337, 38.62446], [-121.46357, 38.62459]]]} | Open Access 1 | Manor Park | 21757 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.286 | Manor Park | ||
6595 | 6595 | 6594 | {"type": "Polygon", "coordinates": [[[-121.52299, 38.61658], [-121.52049, 38.61766], [-121.5203, 38.61747], [-121.52004, 38.61731], [-121.52002, 38.61728], [-121.52021, 38.61693], [-121.52025, 38.61679], [-121.52027, 38.61664], [-121.52026, 38.61645], [-121.5201, 38.61544], [-121.5201, 38.61527], [-121.52012, 38.61498], [-121.52106, 38.61501], [-121.52257, 38.61588], [-121.52273, 38.61603], [-121.52285, 38.61621], [-121.52294, 38.61638], [-121.52299, 38.61658]]]} | Open Access 1 | Manuel Barandas Park | 21764 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.87 | Manuel Barandas Park | ||
6596 | 6596 | 6595 | {"type": "Polygon", "coordinates": [[[-121.4802, 38.48651], [-121.47926, 38.4865], [-121.47864, 38.48614], [-121.47863, 38.48558], [-121.4802, 38.4856], [-121.4802, 38.48651]]]} | Open Access 1 | Manuel E. Silva Park | 21765 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.151 | Manuel E. Silva Park | ||
6610 | 6610 | 6609 | {"type": "Polygon", "coordinates": [[[-121.47237, 38.51927], [-121.47146, 38.51927], [-121.47145, 38.51878], [-121.47237, 38.51878], [-121.47237, 38.51927]]]} | Open Access 1 | Maple Park | 21779 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.068 | Maple Park | ||
6733 | 6733 | 6732 | {"type": "Polygon", "coordinates": [[[-121.47668, 38.49061], [-121.47667, 38.49111], [-121.47664, 38.49114], [-121.4766, 38.49115], [-121.47565, 38.49115], [-121.47565, 38.49055], [-121.47659, 38.49055], [-121.47664, 38.49056], [-121.47668, 38.49061]]]} | Open Access 1 | Martin Luther King, Jr. Park | 21921 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.485 | Martin Luther King, Jr. Park | ||
6743 | 6743 | 6742 | {"type": "Polygon", "coordinates": [[[-121.49491, 38.63481], [-121.49437, 38.63481], [-121.49437, 38.63509], [-121.49423, 38.63516], [-121.49415, 38.63523], [-121.49412, 38.63537], [-121.49415, 38.63543], [-121.49412, 38.63551], [-121.49399, 38.63561], [-121.49396, 38.63568], [-121.49397, 38.63576], [-121.49393, 38.63578], [-121.49363, 38.63532], [-121.49367, 38.63523], [-121.49365, 38.63515], [-121.49359, 38.63508], [-121.4935, 38.63503], [-121.49349, 38.63455], [-121.49356, 38.6342], [-121.49356, 38.63397], [-121.4949, 38.63397], [-121.49491, 38.63481]]]} | Open Access 1 | Parkebridge Park | 23442 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.972 | Parkebridge Park | ||
6764 | 6764 | 6763 | {"type": "Polygon", "coordinates": [[[-121.41435, 38.52142], [-121.41435, 38.52203], [-121.41431, 38.52207], [-121.4119, 38.52207], [-121.41187, 38.52203], [-121.41187, 38.52141], [-121.41191, 38.52138], [-121.41431, 38.52138], [-121.41435, 38.52142]]]} | Open Access 1 | Max Baer Park | 21964 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.086 | Max Baer Park | ||
6798 | 6798 | 6797 | {"type": "Polygon", "coordinates": [[[-121.49653, 38.54876], [-121.49596, 38.55049], [-121.49243, 38.54982], [-121.49273, 38.54884], [-121.49299, 38.54889], [-121.4931, 38.54873], [-121.49326, 38.54876], [-121.49334, 38.54854], [-121.49353, 38.54857], [-121.49363, 38.54821], [-121.49653, 38.54876]]]} | Restricted Access 2 | McClatchy School Park | 21999 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 14.626 | McClatchy School Park | ||
6885 | 6885 | 6884 | {"type": "Polygon", "coordinates": [[[-121.49954, 38.65316], [-121.49936, 38.65321], [-121.49909, 38.65324], [-121.4973, 38.65325], [-121.49735, 38.65296], [-121.49747, 38.65264], [-121.4975, 38.65243], [-121.49749, 38.65172], [-121.49735, 38.65104], [-121.49903, 38.65103], [-121.49925, 38.65104], [-121.49943, 38.65108], [-121.49959, 38.65114], [-121.49974, 38.65122], [-121.49987, 38.65132], [-121.50002, 38.6515], [-121.50011, 38.6517], [-121.50013, 38.65186], [-121.50013, 38.65238], [-121.50012, 38.65255], [-121.50004, 38.65276], [-121.49989, 38.65294], [-121.49976, 38.65304], [-121.49954, 38.65316]]]} | Open Access 1 | Meadows Community Park Site | 22095 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 13.294 | Meadows Community Park Site | ||
6890 | 6890 | 6889 | {"type": "Polygon", "coordinates": [[[-121.48276, 38.47441], [-121.48275, 38.47578], [-121.4823, 38.47578], [-121.48211, 38.47579], [-121.48198, 38.47577], [-121.48051, 38.47575], [-121.48047, 38.47563], [-121.48042, 38.47559], [-121.48031, 38.47518], [-121.48002, 38.47449], [-121.48003, 38.47445], [-121.48009, 38.47443], [-121.48276, 38.47441]]]} | Open Access 1 | Meadowview Park | 22100 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 8.039 | Meadowview Park | ||
6894 | 6894 | 6893 | {"type": "Polygon", "coordinates": [[[-121.45446, 38.46679], [-121.45412, 38.46688], [-121.45281, 38.46727], [-121.45257, 38.46736], [-121.45202, 38.46639], [-121.45205, 38.46634], [-121.45383, 38.4655], [-121.45404, 38.46575], [-121.45425, 38.46607], [-121.45446, 38.46679]]]} | Open Access 1 | Mesa Grande Park | 22173 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.29 | Mesa Grande Park | ||
7186 | 7186 | 7185 | {"type": "Polygon", "coordinates": [[[-121.53713, 38.65115], [-121.53714, 38.65221], [-121.53713, 38.65224], [-121.53708, 38.65226], [-121.53664, 38.65228], [-121.53536, 38.65229], [-121.53531, 38.65226], [-121.53527, 38.65204], [-121.53507, 38.65134], [-121.53509, 38.65128], [-121.53513, 38.65127], [-121.53597, 38.65116], [-121.5365, 38.65112], [-121.53707, 38.65112], [-121.53713, 38.65115]]]} | Open Access 1 | Quail Park | 24046 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.192 | Quail Park |
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]);