superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where MNG_AGENCY = 390 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5284 | 5284 | 5283 | {"type": "Polygon", "coordinates": [[[-121.41891, 37.73385], [-121.41881, 37.73389], [-121.41869, 37.73384], [-121.41869, 37.7338], [-121.41866, 37.73375], [-121.41862, 37.73372], [-121.41855, 37.7337], [-121.41831, 37.7333], [-121.41862, 37.73318], [-121.41887, 37.73359], [-121.41886, 37.73365], [-121.41887, 37.73369], [-121.41891, 37.73374], [-121.41891, 37.73385]]]} | Open Access 1 | Huck Park | 20131 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.517 | Huck Park | ||
10436 | 10436 | 10435 | {"type": "Polygon", "coordinates": [[[-121.43885, 37.72484], [-121.43881, 37.72486], [-121.43877, 37.72509], [-121.43829, 37.72499], [-121.43822, 37.72492], [-121.43821, 37.72477], [-121.43877, 37.72458], [-121.43884, 37.72471], [-121.43883, 37.72477], [-121.43885, 37.72484]]]} | Open Access 1 | Tracy Press Park | 26505 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.518 | Tracy Press Park | ||
8536 | 8536 | 8535 | {"type": "Polygon", "coordinates": [[[-121.42879, 37.72261], [-121.42879, 37.72289], [-121.42848, 37.72289], [-121.42846, 37.72316], [-121.42824, 37.72315], [-121.42824, 37.72261], [-121.42879, 37.72261]]]} | Open Access 1 | Sullivan Park | 25950 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.519 | Sullivan Park | ||
3764 | 3764 | 3763 | {"type": "Polygon", "coordinates": [[[-121.46771, 37.7481], [-121.46753, 37.74837], [-121.46693, 37.74811], [-121.46713, 37.74782], [-121.46771, 37.7481]]]} | Open Access 1 | Eagan Family Park | 18335 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.526 | Eagan Family Park | ||
4098 | 4098 | 4097 | {"type": "Polygon", "coordinates": [[[-121.44278, 37.71963], [-121.44271, 37.7197], [-121.4427, 37.71975], [-121.44272, 37.7198], [-121.44263, 37.71983], [-121.44257, 37.71994], [-121.44224, 37.71989], [-121.4423, 37.71951], [-121.44235, 37.7194], [-121.4424, 37.71932], [-121.44264, 37.71944], [-121.44278, 37.71963]]]} | Open Access 1 | Evelyn Costa Park | 18758 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.529 | Evelyn Costa Park | ||
3050 | 3050 | 3049 | {"type": "Polygon", "coordinates": [[[-121.42023, 37.71427], [-121.42012, 37.71451], [-121.41982, 37.71452], [-121.41974, 37.71457], [-121.41934, 37.71457], [-121.41934, 37.71428], [-121.42023, 37.71427]]]} | Open Access 1 | Clyde Abbott Park | 17449 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.541 | Clyde Abbott Park | ||
8741 | 8741 | 8740 | {"type": "Polygon", "coordinates": [[[-121.45127, 37.73155], [-121.45125, 37.73174], [-121.45054, 37.73168], [-121.45049, 37.73173], [-121.45037, 37.73172], [-121.45031, 37.73145], [-121.4506, 37.73144], [-121.4508, 37.73145], [-121.45121, 37.73149], [-121.45127, 37.73155]]]} | Open Access 1 | Rippin Park | 24400 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.569 | Rippin Park | ||
4224 | 4224 | 4223 | {"type": "Polygon", "coordinates": [[[-121.41719, 37.74334], [-121.41718, 37.74344], [-121.41714, 37.74354], [-121.41656, 37.74356], [-121.41656, 37.74296], [-121.41681, 37.74296], [-121.41712, 37.74322], [-121.41717, 37.74327], [-121.41719, 37.74334]]]} | Open Access 1 | Fine Park | 18901 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.743 | Fine Park | ||
6805 | 6805 | 6804 | {"type": "Polygon", "coordinates": [[[-121.45588, 37.74477], [-121.45584, 37.74546], [-121.45541, 37.74547], [-121.45521, 37.74542], [-121.45537, 37.74509], [-121.45541, 37.74483], [-121.45574, 37.74485], [-121.45581, 37.74483], [-121.45588, 37.74477]]]} | Open Access 1 | McCray Family Park | 22012 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.802 | McCray Family Park | ||
3701 | 3701 | 3700 | {"type": "Polygon", "coordinates": [[[-121.46131, 37.74542], [-121.4613, 37.74549], [-121.46114, 37.74564], [-121.46104, 37.7458], [-121.46064, 37.74569], [-121.46063, 37.74505], [-121.46067, 37.74505], [-121.4607, 37.74513], [-121.46077, 37.74517], [-121.46087, 37.74518], [-121.46098, 37.74516], [-121.46107, 37.74517], [-121.46118, 37.74526], [-121.46131, 37.74542]]]} | Open Access 1 | Dr Ralph Allen Park | 18265 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.812 | Dr Ralph Allen Park | ||
3978 | 3978 | 3977 | {"type": "Polygon", "coordinates": [[[-121.4577, 37.74148], [-121.45743, 37.74151], [-121.45714, 37.74151], [-121.45707, 37.74146], [-121.45704, 37.74121], [-121.45704, 37.74086], [-121.45711, 37.74081], [-121.45721, 37.74081], [-121.45736, 37.74082], [-121.45766, 37.74088], [-121.45766, 37.74117], [-121.4577, 37.74148]]]} | Open Access 1 | Fabian Park | 18781 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.012 | Fabian Park | ||
3663 | 3663 | 3662 | {"type": "Polygon", "coordinates": [[[-121.45657, 37.74687], [-121.45652, 37.74691], [-121.45595, 37.74691], [-121.45599, 37.74617], [-121.45652, 37.74613], [-121.45659, 37.74647], [-121.45657, 37.74687]]]} | Open Access 1 | Dorlane Thrasher Park | 18220 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.095 | Dorlane Thrasher Park | ||
1145 | 1145 | 1144 | {"type": "Polygon", "coordinates": [[[-121.43653, 37.68873], [-121.43601, 37.68921], [-121.43568, 37.68937], [-121.43565, 37.68851], [-121.43653, 37.6885], [-121.43653, 37.68873]]]} | Open Access 1 | American Legion Park | 15452 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.257 | American Legion Park | ||
4883 | 4883 | 4882 | {"type": "Polygon", "coordinates": [[[-121.46221, 37.73235], [-121.46069, 37.73235], [-121.46069, 37.73235], [-121.46074, 37.7321], [-121.46088, 37.73177], [-121.46096, 37.73174], [-121.46186, 37.73198], [-121.46176, 37.73224], [-121.46221, 37.73235]]]} | Open Access 1 | Hanson Park | 19653 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.341 | Hanson Park | ||
6808 | 6808 | 6807 | {"type": "MultiPolygon", "coordinates": [[[[-121.42658, 37.73042], [-121.42564, 37.73045], [-121.42563, 37.73015], [-121.42657, 37.73015], [-121.42658, 37.73042]]], [[[-121.42659, 37.7308], [-121.42566, 37.73083], [-121.42564, 37.73051], [-121.42658, 37.73048], [-121.42659, 37.7308]]]]} | Open Access 1 | McDonald Park | 22023 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.385 | McDonald Park | ||
5532 | 5532 | 5531 | {"type": "Polygon", "coordinates": [[[-121.41396, 37.71962], [-121.41392, 37.71982], [-121.41385, 37.72003], [-121.41374, 37.72023], [-121.4136, 37.72041], [-121.41306, 37.72012], [-121.41309, 37.72004], [-121.41307, 37.71999], [-121.41304, 37.71995], [-121.41303, 37.71942], [-121.4131, 37.71947], [-121.41317, 37.71948], [-121.41325, 37.71947], [-121.41332, 37.71943], [-121.41362, 37.7196], [-121.41396, 37.71962]]]} | Open Access 1 | Jim Raymond Park | 20413 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.493 | Jim Raymond Park | ||
9791 | 9791 | 9790 | {"type": "Polygon", "coordinates": [[[-121.47489, 37.74603], [-121.47425, 37.7458], [-121.47412, 37.74566], [-121.47354, 37.74546], [-121.47355, 37.74543], [-121.47372, 37.7453], [-121.47385, 37.74523], [-121.47399, 37.74519], [-121.47413, 37.74518], [-121.47428, 37.74518], [-121.47454, 37.74525], [-121.47465, 37.7453], [-121.47475, 37.74538], [-121.47484, 37.74548], [-121.47489, 37.74557], [-121.47493, 37.74568], [-121.47494, 37.7458], [-121.47493, 37.74591], [-121.47489, 37.74603]]]} | Open Access 1 | Souza Family Park North | 25707 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.578 | Souza Family Park North | ||
5752 | 5752 | 5751 | {"type": "Polygon", "coordinates": [[[-121.45599, 37.72415], [-121.45592, 37.72421], [-121.45585, 37.72441], [-121.4558, 37.72465], [-121.45552, 37.72465], [-121.45527, 37.72461], [-121.45507, 37.72452], [-121.45491, 37.72438], [-121.45483, 37.72427], [-121.45479, 37.72415], [-121.45512, 37.72411], [-121.45513, 37.72397], [-121.45531, 37.72375], [-121.45558, 37.72365], [-121.45579, 37.72399], [-121.45599, 37.72415]]]} | Open Access 1 | Kingsley Chadeayne Park | 20670 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.718 | Kingsley Chadeayne Park | ||
5536 | 5536 | 5535 | {"type": "Polygon", "coordinates": [[[-121.46126, 37.72127], [-121.46121, 37.72163], [-121.46006, 37.72163], [-121.46005, 37.72138], [-121.45993, 37.72118], [-121.46083, 37.72083], [-121.46105, 37.72115], [-121.46126, 37.72127]]]} | Open Access 1 | Joan Sparks Park | 20417 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.789 | Joan Sparks Park | ||
4094 | 4094 | 4093 | {"type": "MultiPolygon", "coordinates": [[[[-121.44523, 37.72254], [-121.44517, 37.72262], [-121.445, 37.72265], [-121.44446, 37.72266], [-121.44442, 37.72263], [-121.44514, 37.72238], [-121.44523, 37.72254]]], [[[-121.44617, 37.72219], [-121.44613, 37.72226], [-121.4455, 37.72251], [-121.44541, 37.72249], [-121.44532, 37.72231], [-121.44608, 37.72203], [-121.44617, 37.72219]]], [[[-121.44722, 37.72187], [-121.44718, 37.72194], [-121.44644, 37.72215], [-121.44635, 37.72213], [-121.44625, 37.72197], [-121.447, 37.72173], [-121.44715, 37.72179], [-121.44722, 37.72187]]], [[[-121.44868, 37.72149], [-121.44837, 37.72155], [-121.44748, 37.72184], [-121.44739, 37.72181], [-121.44724, 37.72154], [-121.44719, 37.72151], [-121.44711, 37.72149], [-121.44868, 37.72149]]]]} | Open Access 1 | Evans Park | 18754 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1.873 | Evans 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]);