superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where MNG_AGENCY = 390 and MNG_AG_TYP = 2 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3051 | 3051 | 3050 | {"type": "Polygon", "coordinates": [[[-121.4747, 37.74883], [-121.47108, 37.75046], [-121.47055, 37.74971], [-121.4706, 37.7496], [-121.47262, 37.74865], [-121.47268, 37.74866], [-121.47276, 37.74864], [-121.47341, 37.74834], [-121.4747, 37.74883]]]} | Open Access 1 | Clyde Bland Park | 17450 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 8.606 | Clyde Bland Park | ||
9840 | 9840 | 9839 | {"type": "Polygon", "coordinates": [[[-121.4741, 37.74227], [-121.47427, 37.7423], [-121.47443, 37.74235], [-121.47455, 37.74243], [-121.47467, 37.74251], [-121.47477, 37.74264], [-121.47484, 37.74277], [-121.47487, 37.74288], [-121.47488, 37.74301], [-121.47485, 37.74316], [-121.47479, 37.74328], [-121.4747, 37.7434], [-121.47458, 37.7435], [-121.47447, 37.74357], [-121.47427, 37.74365], [-121.47411, 37.74368], [-121.47394, 37.74369], [-121.47397, 37.74306], [-121.47409, 37.74271], [-121.4741, 37.74227]]]} | Open Access 1 | Souza Family Park South | 25708 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.289 | Souza Family Park South | ||
4957 | 4957 | 4956 | {"type": "Polygon", "coordinates": [[[-121.47108, 37.74402], [-121.47101, 37.74408], [-121.47043, 37.74404], [-121.46951, 37.74386], [-121.46946, 37.74379], [-121.46972, 37.74302], [-121.4698, 37.74298], [-121.46999, 37.743], [-121.47047, 37.74301], [-121.47068, 37.74306], [-121.47086, 37.74316], [-121.47101, 37.74331], [-121.47109, 37.74349], [-121.47111, 37.7436], [-121.47108, 37.74402]]]} | Open Access 1 | Hastie Park | 19732 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 3.404 | Hastie Park | ||
776 | 776 | 775 | {"type": "Polygon", "coordinates": [[[-121.46933, 37.73897], [-121.46926, 37.73902], [-121.46447, 37.73903], [-121.4644, 37.73898], [-121.4644, 37.73676], [-121.46924, 37.73675], [-121.4693, 37.73708], [-121.46932, 37.73731], [-121.46933, 37.73897]]]} | Open Access 1 | Busch Park | 16537 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 27.01 | Busch 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 | ||
3435 | 3435 | 3434 | {"type": "Polygon", "coordinates": [[[-121.46404, 37.74007], [-121.46402, 37.7402], [-121.46398, 37.74035], [-121.4638, 37.74082], [-121.46369, 37.74103], [-121.46354, 37.74122], [-121.46326, 37.74106], [-121.46298, 37.74106], [-121.46297, 37.74002], [-121.46397, 37.74002], [-121.46404, 37.74007]]]} | Open Access 1 | Daniel Busch Park | 17919 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.397 | Daniel Busch Park | ||
10793 | 10793 | 10792 | {"type": "Polygon", "coordinates": [[[-121.46221, 37.73283], [-121.46197, 37.73283], [-121.46156, 37.73288], [-121.4607, 37.73307], [-121.46069, 37.73235], [-121.46221, 37.73235], [-121.46221, 37.73283]]]} | Open Access 1 | Vernor Hanson Park | 27004 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.094 | Vernor Hanson 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 | ||
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 | ||
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 | ||
4468 | 4468 | 4467 | {"type": "Polygon", "coordinates": [[[-121.46065, 37.74795], [-121.45958, 37.74796], [-121.45957, 37.74823], [-121.4595, 37.74823], [-121.45948, 37.74796], [-121.45841, 37.74796], [-121.4584, 37.74716], [-121.45933, 37.74714], [-121.4601, 37.74705], [-121.46065, 37.74703], [-121.46065, 37.74795]]]} | Open Access 1 | Galli Family Park | 19176 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.681 | Galli Family Park | ||
8224 | 8224 | 8223 | {"type": "Polygon", "coordinates": [[[-121.45925, 37.73898], [-121.45645, 37.73897], [-121.45529, 37.73893], [-121.45515, 37.7389], [-121.45501, 37.73885], [-121.454, 37.73807], [-121.45375, 37.73775], [-121.45365, 37.73739], [-121.45378, 37.73749], [-121.45465, 37.73749], [-121.45466, 37.73714], [-121.45923, 37.73713], [-121.45924, 37.73765], [-121.45925, 37.73898]]]} | Open Access 1 | Plasencia Fields | 23770 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 21.699 | Plasencia Fields | ||
5550 | 5550 | 5549 | {"type": "Polygon", "coordinates": [[[-121.45903, 37.73485], [-121.4581, 37.73486], [-121.45808, 37.73516], [-121.45791, 37.73516], [-121.4577, 37.73511], [-121.45751, 37.73502], [-121.45736, 37.73489], [-121.45723, 37.73468], [-121.45726, 37.73461], [-121.45766, 37.73446], [-121.45792, 37.73438], [-121.45847, 37.73427], [-121.45903, 37.73423], [-121.45903, 37.73485]]]} | Open Access 1 | John Erb Park | 20435 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.508 | John Erb 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 | ||
6703 | 6703 | 6702 | {"type": "Polygon", "coordinates": [[[-121.45704, 37.72677], [-121.45695, 37.72681], [-121.45695, 37.72733], [-121.45562, 37.72733], [-121.45555, 37.72727], [-121.45554, 37.72632], [-121.4556, 37.72627], [-121.45595, 37.7262], [-121.4562, 37.72617], [-121.45694, 37.72616], [-121.45695, 37.72668], [-121.45704, 37.72672], [-121.45704, 37.72677]]]} | Open Access 1 | Marlow Park | 21882 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 3.878 | Marlow Park | ||
8289 | 8289 | 8288 | {"type": "Polygon", "coordinates": [[[-121.45662, 37.75152], [-121.4565, 37.7517], [-121.45623, 37.75198], [-121.45597, 37.75189], [-121.45592, 37.75184], [-121.45592, 37.75159], [-121.45604, 37.75155], [-121.45612, 37.75158], [-121.4562, 37.75157], [-121.4563, 37.75152], [-121.45662, 37.75152]]]} | Open Access 1 | Pombo Family Park | 23877 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.505 | Pombo Family 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 | ||
5697 | 5697 | 5696 | {"type": "Polygon", "coordinates": [[[-121.45642, 37.74867], [-121.45604, 37.74868], [-121.45602, 37.74858], [-121.45565, 37.74858], [-121.45565, 37.74832], [-121.45593, 37.74833], [-121.45636, 37.74841], [-121.45642, 37.74845], [-121.45642, 37.74867]]]} | Open Access 1 | Kelly Park | 20589 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.503 | Kelly Park | ||
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 |
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]);