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)
Suggested facets: PARK_URL, YR_EST, GAP_STS
DES_TP 10
- Local Park 192
- Local Recreation Area 18
- Local Conservation Area 3
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 220 ✖
MNG_AGENCY 1
- Sacramento, City of · 220 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3063 | 3063 | 3062 | {"type": "Polygon", "coordinates": [[[-121.44839, 38.60939], [-121.44839, 38.60953], [-121.44794, 38.60953], [-121.44795, 38.60939], [-121.44839, 38.60939]]]} | Open Access 1 | 21124 | Dixieanne Tot Lot | 18171 | 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 | 0.152 | Dixieanne Tot Lot | 0 | Local Recreation Area 3 | 4 | |
5661 | 5661 | 5660 | {"type": "Polygon", "coordinates": [[[-121.46115, 38.56625], [-121.46113, 38.56629], [-121.46094, 38.5663], [-121.46078, 38.56628], [-121.46062, 38.56624], [-121.46046, 38.56617], [-121.46033, 38.56608], [-121.46035, 38.56603], [-121.46115, 38.56625]]]} | Open Access 1 | 21145 | Crescent Park | 17796 | 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 | 0.208 | Crescent Park | 0 | Local Park 2 | 4 | |
5665 | 5665 | 5664 | {"type": "Polygon", "coordinates": [[[-121.45286, 38.56331], [-121.45268, 38.56368], [-121.45263, 38.56369], [-121.45236, 38.56362], [-121.45254, 38.56322], [-121.45286, 38.56331]]]} | Open Access 1 | 21149 | East Lawn Childrens Park | 18376 | 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 | 0.331 | East Lawn Childrens Park | 0 | Local Park 2 | 4 | |
11018 | 11018 | 11017 | {"type": "Polygon", "coordinates": [[[-121.45893, 38.6102], [-121.45821, 38.61059], [-121.45821, 38.61059], [-121.45818, 38.6102], [-121.45893, 38.6102]]]} | Open Access 1 | 21103 | Jack Rea Park | 20307 | 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 | 0.344 | Jack Rea Park | 0 | Local Park 2 | 4 | |
10993 | 10993 | 10992 | {"type": "Polygon", "coordinates": [[[-121.42536, 38.6435], [-121.42493, 38.64382], [-121.42471, 38.64363], [-121.42514, 38.64332], [-121.42536, 38.6435]]]} | Open Access 1 | 21059 | Verano Creek Park | 26984 | 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 | 0.355 | Verano Creek Park | 0 | Local Park 2 | 4 | |
11042 | 11042 | 11041 | {"type": "Polygon", "coordinates": [[[-121.54328, 38.50023], [-121.54324, 38.50055], [-121.54269, 38.50051], [-121.54277, 38.50022], [-121.54289, 38.50019], [-121.54328, 38.50023]]]} | Open Access 1 | 21220 | Evelyn Dutra Park | 18759 | 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 | 0.414 | Evelyn Dutra Park | 0 | Local Park 2 | 4 | |
2708 | 2708 | 2707 | {"type": "Polygon", "coordinates": [[[-121.49106, 38.57115], [-121.49087, 38.57158], [-121.49048, 38.57147], [-121.49066, 38.57105], [-121.49106, 38.57115]]]} | Open Access 1 | 21287 | Fremont Community Garden | 19097 | 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 | 0.453 | Fremont Community Garden | 0 | Local Park 2 | 4 | |
5647 | 5647 | 5646 | {"type": "Polygon", "coordinates": [[[-121.49775, 38.58034], [-121.4976, 38.5807], [-121.49713, 38.58058], [-121.49729, 38.58021], [-121.49775, 38.58034]]]} | Open Access 1 | 21131 | Saint Rose Of Lima Park | 24792 | 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 | 0.455 | Saint Rose Of Lima Park | 0 | Local Park 2 | 4 | |
3065 | 3065 | 3064 | {"type": "Polygon", "coordinates": [[[-121.43954, 38.54796], [-121.43925, 38.54796], [-121.43924, 38.54707], [-121.43947, 38.54706], [-121.43948, 38.5472], [-121.43953, 38.54721], [-121.43954, 38.54796]]]} | Open Access 1 | 21159 | Greenfair Park | 19476 | 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 | 0.599 | Greenfair Park | 0 | Local Park 2 | 4 | |
5676 | 5676 | 5675 | {"type": "Polygon", "coordinates": [[[-121.49013, 38.54356], [-121.4908, 38.54367], [-121.49083, 38.54372], [-121.49075, 38.54397], [-121.49072, 38.54399], [-121.49068, 38.544], [-121.49002, 38.54389], [-121.48999, 38.54384], [-121.49006, 38.5436], [-121.49009, 38.54358], [-121.49013, 38.54356]]]} | Open Access 1 | 21175 | Plaza Cervantes | 23777 | 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 | 0.628 | Plaza Cervantes | None 459 | |||
11707 | 11707 | 11706 | {"type": "Polygon", "coordinates": [[[-121.45555, 38.55759], [-121.45548, 38.55775], [-121.45419, 38.55739], [-121.45387, 38.55726], [-121.45385, 38.55722], [-121.45386, 38.55719], [-121.4539, 38.55718], [-121.4543, 38.55725], [-121.45555, 38.55759]]]} | Open Access 1 | 24004 | Sunset Park | 26059 | 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 | 0.633 | Sunset Park | 0 | Local Park 2 | 4 | |
11069 | 11069 | 11068 | {"type": "Polygon", "coordinates": [[[-121.53347, 38.65284], [-121.53295, 38.65303], [-121.533, 38.65368], [-121.53229, 38.65259], [-121.53287, 38.6529], [-121.5334, 38.65271], [-121.53347, 38.65284]]]} | Open Access 1 | 21269 | Harrier Park | 19692 | 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 | 0.74 | Harrier Park | 0 | Local Park 2 | 4 | |
13121 | 13121 | 13120 | {"type": "Polygon", "coordinates": [[[-121.48561, 38.56902], [-121.48543, 38.56942], [-121.48476, 38.56924], [-121.48504, 38.56859], [-121.48522, 38.56878], [-121.48533, 38.56887], [-121.48561, 38.56902]]]} | Open Access 1 | 48821 | Brooks Truitt Park | 33540 | 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 | https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/Central-City/Brooks-Truitt-Park | Sacramento 41 | 0.896 | Brooks Truitt Park | 0 | Local Park 2 | 4 |
11075 | 11075 | 11074 | {"type": "MultiPolygon", "coordinates": [[[[-121.4912, 38.54398], [-121.49146, 38.54403], [-121.49149, 38.54405], [-121.4915, 38.54409], [-121.49131, 38.54436], [-121.49116, 38.54469], [-121.49106, 38.54476], [-121.49097, 38.54478], [-121.49093, 38.54475], [-121.49092, 38.54471], [-121.49115, 38.54402], [-121.4912, 38.54398]]], [[[-121.49146, 38.54318], [-121.49151, 38.54319], [-121.49154, 38.54322], [-121.49159, 38.54335], [-121.49154, 38.54364], [-121.49155, 38.54385], [-121.49153, 38.54389], [-121.49148, 38.5439], [-121.49126, 38.54386], [-121.49122, 38.54381], [-121.49141, 38.54321], [-121.49146, 38.54318]]]]} | Open Access 1 | 21278 | Brockway Park | 16413 | 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 | 0.923 | Brockway Park | 0 | Local Park 2 | 4 | |
10983 | 10983 | 10982 | {"type": "Polygon", "coordinates": [[[-121.49238, 38.58624], [-121.492, 38.58712], [-121.4916, 38.58701], [-121.49198, 38.58613], [-121.49238, 38.58624]]]} | Open Access 1 | 21118 | Emiliano Zapata Park | 18629 | 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 | 0.955 | Emiliano Zapata Park | 0 | Local Park 2 | 4 | |
11046 | 11046 | 11045 | {"type": "Polygon", "coordinates": [[[-121.53648, 38.49043], [-121.53648, 38.49047], [-121.53642, 38.49052], [-121.53616, 38.49063], [-121.53595, 38.49067], [-121.53544, 38.49069], [-121.53535, 38.49071], [-121.53529, 38.49075], [-121.53583, 38.49001], [-121.53582, 38.49007], [-121.53587, 38.49013], [-121.53592, 38.49015], [-121.53603, 38.49016], [-121.53648, 38.49043]]]} | Open Access 1 | 21228 | Tony Court Park | 26399 | 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 | 0.961 | Tony Court Park | 0 | Local Park 2 | 4 | |
4450 | 4450 | 4449 | {"type": "Polygon", "coordinates": [[[-121.49051, 38.58452], [-121.49031, 38.58498], [-121.49032, 38.58499], [-121.49039, 38.58502], [-121.49021, 38.58543], [-121.48985, 38.58533], [-121.49005, 38.58487], [-121.48986, 38.58482], [-121.49005, 38.58439], [-121.49051, 38.58452]]]} | Open Access 1 | 21120 | J. Neely Johnson Park | 20292 | 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 | 0.967 | J. Neely Johnson Park | 0 | Local Park 2 | 4 | |
10976 | 10976 | 10975 | {"type": "Polygon", "coordinates": [[[-121.5211, 38.67146], [-121.52034, 38.6716], [-121.52019, 38.6711], [-121.52096, 38.67095], [-121.5211, 38.67146]]]} | Open Access 1 | 21043 | Blue Oak Park | 16180 | 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 | 0.981 | Blue Oak Park | 0 | Local Park 2 | 4 | |
11716 | 11716 | 11715 | {"type": "Polygon", "coordinates": [[[-121.51473, 38.52293], [-121.51454, 38.52353], [-121.51389, 38.5234], [-121.51408, 38.5228], [-121.51473, 38.52293]]]} | Open Access 1 | 24012 | Partnere Off Leash Dog Park | 23486 | 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.002 | Partnere Off Leash Dog Park | 0 | Local Park 2 | 4 | |
5678 | 5678 | 5677 | {"type": "Polygon", "coordinates": [[[-121.47047, 38.53964], [-121.46938, 38.53962], [-121.46938, 38.53924], [-121.47044, 38.53924], [-121.47047, 38.53929], [-121.47047, 38.53964]]]} | Open Access 1 | 21180 | Temple Avenue Park | 26234 | 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.027 | Temple Avenue Park | 0 | Local Park 2 | 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]);