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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2913 | 2913 | 2912 | {"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 | Dixieanne Tot Lot | 18171 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.152 | Dixieanne Tot Lot | ||
3313 | 3313 | 3312 | {"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 | Crescent Park | 17796 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.208 | Crescent Park | ||
3797 | 3797 | 3796 | {"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 | East Lawn Childrens Park | 18376 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.33 | East Lawn Childrens Park | ||
5442 | 5442 | 5441 | {"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 | Jack Rea Park | 20307 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.344 | Jack Rea Park | ||
10779 | 10779 | 10778 | {"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 | Verano Creek Park | 26984 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.355 | Verano Creek Park | ||
4099 | 4099 | 4098 | {"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 | Evelyn Dutra Park | 18759 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.413 | Evelyn Dutra Park | ||
4407 | 4407 | 4406 | {"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 | Fremont Community Garden | 19097 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.452 | Fremont Community Garden | ||
7688 | 7688 | 7687 | {"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 | Saint Rose Of Lima Park | 24792 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.455 | Saint Rose Of Lima Park | ||
3782 | 3782 | 3781 | {"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 | Greenfair Park | 19476 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.599 | Greenfair Park | ||
8230 | 8230 | 8229 | {"type": "Polygon", "coordinates": [[[-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], [-121.4908, 38.54367], [-121.49083, 38.54372]]]} | Open Access 1 | Plaza Cervantes | 23777 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.627 | Plaza Cervantes | ||
10132 | 10132 | 10131 | {"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 | Sunset Park | 26059 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.632 | Sunset Park | ||
4917 | 4917 | 4916 | {"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 | Harrier Park | 19692 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.744 | Harrier Park | ||
674 | 674 | 673 | {"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 | Brooks Truitt Park | https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/Central-City/Brooks-Truitt-Park | 33540 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.896 | Brooks Truitt Park | |
2271 | 2271 | 2270 | {"type": "MultiPolygon", "coordinates": [[[[-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.49145, 38.54403], [-121.49149, 38.54405], [-121.4915, 38.54409]]], [[[-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], [-121.49151, 38.54319], [-121.49154, 38.54322], [-121.49158, 38.54335], [-121.49154, 38.54364], [-121.49155, 38.54385]]]]} | Open Access 1 | Brockway Park | 16413 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.923 | Brockway Park | ||
3992 | 3992 | 3991 | {"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 | Emiliano Zapata Park | 18629 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.955 | Emiliano Zapata Park | ||
10387 | 10387 | 10386 | {"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 | Tony Court Park | 26399 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.961 | Tony Court Park | ||
5386 | 5386 | 5385 | {"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.49004, 38.58488], [-121.48986, 38.58482], [-121.49005, 38.58439], [-121.49051, 38.58452]]]} | Open Access 1 | J. Neely Johnson Park | 20292 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.969 | J. Neely Johnson Park | ||
2077 | 2077 | 2076 | {"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 | Blue Oak Park | 16180 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.981 | Blue Oak Park | ||
7996 | 7996 | 7995 | {"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 | Partnere Off Leash Dog Park | 23486 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.001 | Partnere Off Leash Dog Park | ||
8746 | 8746 | 8745 | {"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 | Temple Avenue Park | 26234 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.026 | Temple Avenue 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]);