superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
218 rows where MNG_AGENCY = 534 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
4347 | 4347 | 4346 | {"type": "Polygon", "coordinates": [[[-121.46014, 38.54819], [-121.4595, 38.54819], [-121.45946, 38.54749], [-121.4601, 38.54751], [-121.46014, 38.54819]]]} | Open Access 1 | Fourth Avenue Park | 19027 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.075 | Fourth Avenue Park | ||
3156 | 3156 | 3155 | {"type": "Polygon", "coordinates": [[[-121.54229, 38.48581], [-121.54226, 38.48585], [-121.54184, 38.48591], [-121.5417, 38.48591], [-121.54162, 38.48595], [-121.54159, 38.486], [-121.54102, 38.48588], [-121.54172, 38.48551], [-121.54172, 38.48543], [-121.54229, 38.48517], [-121.54225, 38.48521], [-121.54223, 38.48526], [-121.54226, 38.48535], [-121.54225, 38.48555], [-121.54229, 38.48581]]]} | Open Access 1 | Cool Wind Way Park | 17618 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.159 | Cool Wind Way Park | ||
8969 | 8969 | 8968 | {"type": "Polygon", "coordinates": [[[-121.45225, 38.61393], [-121.45152, 38.61433], [-121.45093, 38.61471], [-121.45092, 38.61393], [-121.45225, 38.61393]]]} | Open Access 1 | Triangle Park | 26532 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.211 | Triangle 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 | ||
5578 | 5578 | 5577 | {"type": "Polygon", "coordinates": [[[-121.43833, 38.45244], [-121.43643, 38.45242], [-121.43642, 38.45213], [-121.43738, 38.45213], [-121.43772, 38.45216], [-121.43826, 38.45217], [-121.4383, 38.45218], [-121.43832, 38.45221], [-121.43833, 38.45244]]]} | Open Access 1 | John Reith Park | 20465 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.297 | John Reith Park | ||
9660 | 9660 | 9659 | {"type": "MultiPolygon", "coordinates": [[[[-121.44531, 38.55478], [-121.44524, 38.55494], [-121.44395, 38.55458], [-121.44361, 38.55445], [-121.44357, 38.55443], [-121.44355, 38.55439], [-121.44357, 38.55436], [-121.44361, 38.55436], [-121.44391, 38.5544], [-121.44531, 38.55478]]], [[[-121.44712, 38.55534], [-121.44711, 38.55537], [-121.44708, 38.55539], [-121.44675, 38.55535], [-121.4454, 38.55498], [-121.44547, 38.55483], [-121.44679, 38.55519], [-121.44703, 38.55528], [-121.4471, 38.55531], [-121.44712, 38.55534]]]]} | Open Access 1 | Sierra Vista Park | 25469 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.304 | Sierra Vista Park | ||
8586 | 8586 | 8585 | {"type": "Polygon", "coordinates": [[[-121.5243, 38.66653], [-121.52401, 38.66704], [-121.52394, 38.66723], [-121.52389, 38.66739], [-121.52387, 38.66762], [-121.52387, 38.66868], [-121.52378, 38.66864], [-121.52361, 38.66866], [-121.52351, 38.66861], [-121.5234, 38.66853], [-121.5231, 38.66825], [-121.52309, 38.6682], [-121.52346, 38.66791], [-121.52371, 38.66763], [-121.52385, 38.66741], [-121.52394, 38.6672], [-121.52407, 38.66657], [-121.52413, 38.66653], [-121.5243, 38.66653]]]} | Open Access 1 | Redbud Park | 24230 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.442 | Redbud 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 | ||
7461 | 7461 | 7460 | {"type": "Polygon", "coordinates": [[[-121.54627, 38.51423], [-121.54497, 38.5146], [-121.54474, 38.51413], [-121.54556, 38.51393], [-121.54592, 38.51391], [-121.54607, 38.51387], [-121.54627, 38.51423]]]} | Open Access 1 | North Point Way River Access | 22847 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.531 | North Point Way River Access | ||
8761 | 8761 | 8760 | {"type": "Polygon", "coordinates": [[[-121.44917, 38.58392], [-121.44878, 38.58454], [-121.448, 38.58423], [-121.44844, 38.58351], [-121.44894, 38.58377], [-121.44917, 38.58392]]]} | Open Access 1 | River Park | 24418 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.582 | River Park | ||
11039 | 11039 | 11038 | {"type": "Polygon", "coordinates": [[[-121.48248, 38.58238], [-121.4821, 38.58326], [-121.48143, 38.58308], [-121.48181, 38.5822], [-121.48248, 38.58238]]]} | Open Access 1 | Washington Park | 27279 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.582 | Washington Park | ||
7890 | 7890 | 7889 | {"type": "Polygon", "coordinates": [[[-121.50062, 38.61252], [-121.49992, 38.61253], [-121.49991, 38.61187], [-121.49961, 38.61162], [-121.5006, 38.6116], [-121.50062, 38.61252]]]} | Open Access 1 | Park Plaza | 23435 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.62 | Park Plaza | ||
7462 | 7462 | 7461 | {"type": "Polygon", "coordinates": [[[-121.45979, 38.65635], [-121.45981, 38.65646], [-121.45983, 38.65691], [-121.4598, 38.65703], [-121.45975, 38.65714], [-121.45968, 38.65724], [-121.45959, 38.65733], [-121.45949, 38.65741], [-121.45936, 38.65748], [-121.4591, 38.65757], [-121.45889, 38.65759], [-121.45847, 38.65759], [-121.45842, 38.65756], [-121.4584, 38.65753], [-121.4584, 38.65736], [-121.45844, 38.65721], [-121.4585, 38.65709], [-121.45866, 38.65689], [-121.45871, 38.65689], [-121.45907, 38.65697], [-121.45946, 38.65698], [-121.4596, 38.65704], [-121.45966, 38.65703], [-121.45972, 38.657], [-121.45974, 38.65697], [-121.45975, 38.65692], [-121.45979, 38.65692], [-121.4598, 38.65685], [-121.45978, 38.6565], [-121.45975, 38.65632], [-121.45979, 38.65635]]]} | Open Access 1 | North Pointe Park | 22848 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.723 | North Pointe Park | ||
3868 | 3868 | 3867 | {"type": "Polygon", "coordinates": [[[-121.47357, 38.4861], [-121.47167, 38.48617], [-121.47167, 38.48616], [-121.47171, 38.48611], [-121.47223, 38.48592], [-121.47289, 38.48556], [-121.47313, 38.48548], [-121.47341, 38.48542], [-121.47357, 38.4861]]]} | Open Access 1 | Edward Kemble Park | 18457 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.745 | Edward Kemble Park | ||
8124 | 8124 | 8123 | {"type": "Polygon", "coordinates": [[[-121.45478, 38.48328], [-121.45473, 38.48347], [-121.45471, 38.48361], [-121.45472, 38.48378], [-121.45477, 38.48399], [-121.45476, 38.48403], [-121.45472, 38.48406], [-121.45401, 38.48423], [-121.45393, 38.48421], [-121.45366, 38.4835], [-121.45478, 38.48328]]]} | Open Access 1 | Phoenix Green | 23645 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.764 | Phoenix Green | ||
9850 | 9850 | 9849 | {"type": "Polygon", "coordinates": [[[-121.54197, 38.66281], [-121.54193, 38.66283], [-121.54147, 38.66283], [-121.54133, 38.6628], [-121.5412, 38.66285], [-121.54111, 38.66281], [-121.54111, 38.66195], [-121.54118, 38.66195], [-121.54127, 38.66193], [-121.54168, 38.66193], [-121.54181, 38.66197], [-121.54191, 38.66197], [-121.54197, 38.662], [-121.54197, 38.66281]]]} | Open Access 1 | Sparrow Park | 25717 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.809 | Sparrow Park | ||
11338 | 11338 | 11337 | {"type": "Polygon", "coordinates": [[[-121.44494, 38.6102], [-121.44398, 38.6102], [-121.44398, 38.60939], [-121.44494, 38.60938], [-121.44494, 38.6102]]]} | Open Access 1 | Winner's Circle Park | 27648 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.889 | Winner's Circle Park | ||
7596 | 7596 | 7595 | {"type": "Polygon", "coordinates": [[[-121.50317, 38.6276], [-121.50316, 38.62873], [-121.50246, 38.62873], [-121.50246, 38.6276], [-121.50317, 38.6276]]]} | Open Access 1 | Oakbrook Park Site | 23019 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.904 | Oakbrook Park Site | ||
7587 | 7587 | 7586 | {"type": "Polygon", "coordinates": [[[-121.46189, 38.5431], [-121.46127, 38.5431], [-121.46126, 38.54227], [-121.46073, 38.54226], [-121.46073, 38.54214], [-121.46126, 38.54214], [-121.46127, 38.5419], [-121.46189, 38.54189], [-121.46189, 38.5431]]]} | Open Access 1 | Oak Park Open Space | 23005 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.966 | Oak Park OS |
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]);