units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 9
- Local Park 174
- Local Recreation Area 17
- Local Conservation Area 3
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 200 ✖
MNG_AGENCY 1
- Sacramento, City of · 200 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11032 | 11032 | 11031 | {"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 | 21205 | Maple Park | 21779 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.069 | Maple Park | 0 | Local Park 2 | 4 | |
5672 | 5672 | 5671 | {"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 | 21158 | Fourth Avenue Park | 19027 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.076 | Fourth Avenue Park | 0 | Local Park 2 | 4 | |
11052 | 11052 | 11051 | {"type": "Polygon", "coordinates": [[[-121.54229, 38.48517], [-121.54225, 38.48521], [-121.54223, 38.48526], [-121.54226, 38.48535], [-121.54225, 38.48555], [-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]]]} | Open Access 1 | 21235 | Cool Wind Way Park | 17618 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.159 | Cool Wind Way Park | 0 | Local Park 2 | 4 | |
5133 | 5133 | 5132 | {"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 | 21098 | Triangle Park | 26532 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.212 | Triangle Park | 0 | Local Park 2 | 4 | |
11005 | 11005 | 11004 | {"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 | 21086 | Manor Park | 21757 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.285 | Manor Park | 0 | Local Park 2 | 4 | |
5662 | 5662 | 5661 | {"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 | 21253 | John Reith Park | 20465 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.298 | John Reith Park | 0 | Local Park 2 | 4 | |
11708 | 11708 | 11707 | {"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 | 24005 | Sierra Vista Park | 25469 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.305 | Sierra Vista Park | 0 | Local Park 2 | 4 | |
10981 | 10981 | 10980 | {"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 | 21048 | Redbud Park | 24230 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.442 | Redbud Park | 0 | Local Park 2 | 4 | |
11035 | 11035 | 11034 | {"type": "Polygon", "coordinates": [[[-121.47565, 38.49055], [-121.47659, 38.49055], [-121.47664, 38.49056], [-121.47668, 38.49061], [-121.47667, 38.49111], [-121.47664, 38.49114], [-121.4766, 38.49115], [-121.47565, 38.49115], [-121.47565, 38.49055]]]} | Open Access 1 | 21227 | Martin Luther King, Jr. Park | 21921 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.485 | Martin Luther King, Jr. Park | 0 | Local Park 2 | 4 | |
5673 | 5673 | 5672 | {"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 | 21209 | North Point Way River Access | 22847 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.532 | North Point Way River Access | 0 | Local Recreation Area 3 | 4 | |
4453 | 4453 | 4452 | {"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 | 21126 | River Park | 24418 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.582 | River Park | 0 | Local Park 2 | 4 | |
3064 | 3064 | 3063 | {"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 | 21127 | Washington Park | 27279 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.583 | Washington Park | 0 | Local Park 2 | 4 | |
11015 | 11015 | 11014 | {"type": "Polygon", "coordinates": [[[-121.50062, 38.61252], [-121.49992, 38.61253], [-121.49991, 38.61186], [-121.49961, 38.61162], [-121.5006, 38.6116], [-121.50062, 38.61252]]]} | Open Access 1 | 21100 | Park Plaza | 23435 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.62 | Park Plaza | 0 | Local Park 2 | 4 | |
10988 | 10988 | 10987 | {"type": "Polygon", "coordinates": [[[-121.45975, 38.65632], [-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.4596, 38.65733], [-121.45949, 38.65741], [-121.45936, 38.65748], [-121.4591, 38.65756], [-121.4589, 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.45906, 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]]]} | Open Access 1 | 21053 | North Pointe Park | 22848 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.723 | North Pointe Park | 0 | Local Park 2 | 4 | |
11051 | 11051 | 11050 | {"type": "Polygon", "coordinates": [[[-121.47357, 38.4861], [-121.47167, 38.48617], [-121.47167, 38.48616], [-121.4717, 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 | 21234 | Edward Kemble Park | 18457 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.745 | Edward Kemble Park | 0 | Local Park 2 | 4 | |
11054 | 11054 | 11053 | {"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 | 21237 | Phoenix Green | 23645 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.764 | Phoenix Green | 0 | Local Park 2 | 4 | |
11066 | 11066 | 11065 | {"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 | 21260 | Sparrow Park | 25717 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.809 | Sparrow Park | 0 | Local Park 2 | 4 | |
11020 | 11020 | 11019 | {"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 | 21105 | Winner's Circle Park | 27648 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.89 | Winner's Circle Park | 0 | Local Park 2 | 4 | |
11004 | 11004 | 11003 | {"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 | 21073 | Oakbrook Park Site | 23019 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.905 | Oakbrook Park Site | 0 | Local Park 2 | 4 | |
16170 | 16170 | 16169 | {"type": "Polygon", "coordinates": [[[-121.46189, 38.5431], [-121.46127, 38.5431], [-121.46127, 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 | 21178 | Oak Park Open Space | 23005 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.96 | Oak Park OS | 0 | Local Recreation Area 3 | 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]);