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 ACRES 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
3849 | 3849 | 3848 | {"type": "Polygon", "coordinates": [[[-121.43046, 37.7577], [-121.42818, 37.75771], [-121.42817, 37.75587], [-121.42952, 37.75575], [-121.42952, 37.75433], [-121.43045, 37.75433], [-121.43046, 37.7577]]]} | Open Access 1 | El Pescadero Park | 18528 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 13.777 | El Pescadero Park | ||
6202 | 6202 | 6201 | {"type": "Polygon", "coordinates": [[[-121.42572, 37.74329], [-121.42567, 37.74331], [-121.42566, 37.74341], [-121.42126, 37.74341], [-121.42125, 37.74213], [-121.42571, 37.74214], [-121.42572, 37.74329]]]} | Open Access 1 | Lincoln Park | 21273 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 13.731 | Lincoln Park | ||
3700 | 3700 | 3699 | {"type": "Polygon", "coordinates": [[[-121.43981, 37.74807], [-121.43977, 37.74811], [-121.43934, 37.74813], [-121.43852, 37.74809], [-121.43803, 37.74802], [-121.4365, 37.74774], [-121.43583, 37.74769], [-121.43517, 37.74768], [-121.43516, 37.74692], [-121.4398, 37.74691], [-121.43981, 37.74807]]]} | Open Access 1 | Dr Powers Park | 18264 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 11.137 | Dr Powers Park | ||
10435 | 10435 | 10434 | {"type": "MultiPolygon", "coordinates": [[[[-121.43492, 37.7531], [-121.43371, 37.7531], [-121.43368, 37.75309], [-121.43335, 37.75287], [-121.43327, 37.75284], [-121.43318, 37.75283], [-121.43317, 37.75056], [-121.43362, 37.75055], [-121.43362, 37.75015], [-121.43442, 37.75015], [-121.43442, 37.75042], [-121.43437, 37.75044], [-121.43437, 37.75081], [-121.43491, 37.75082], [-121.43492, 37.7531]]], [[[-121.43368, 37.75324], [-121.43318, 37.75324], [-121.43318, 37.75297], [-121.43326, 37.75299], [-121.43356, 37.7532], [-121.43368, 37.75324]]]]} | Open Access 1 | Tracy Ball Park | 26504 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 11.083 | Tracy Ball Park | ||
2722 | 2722 | 2721 | {"type": "Polygon", "coordinates": [[[-121.44704, 37.73359], [-121.44559, 37.7336], [-121.44554, 37.73245], [-121.44403, 37.73247], [-121.4439, 37.73253], [-121.44375, 37.73255], [-121.44368, 37.73219], [-121.44367, 37.73171], [-121.44369, 37.73154], [-121.44484, 37.73154], [-121.44513, 37.73156], [-121.44546, 37.73164], [-121.44566, 37.73167], [-121.44593, 37.73168], [-121.44703, 37.7317], [-121.44704, 37.73359]]]} | Open Access 1 | Ceciliani Park | 16992 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 10.932 | Ceciliani Park | ||
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 | ||
10832 | 10832 | 10831 | {"type": "Polygon", "coordinates": [[[-121.42552, 37.69643], [-121.42551, 37.69738], [-121.42467, 37.69738], [-121.42451, 37.69728], [-121.42431, 37.69719], [-121.4241, 37.69713], [-121.42389, 37.6971], [-121.42199, 37.6971], [-121.42179, 37.69706], [-121.42168, 37.69709], [-121.4216, 37.69715], [-121.42115, 37.69714], [-121.42115, 37.69644], [-121.42552, 37.69643]]]} | Open Access 1 | Veterans Park | 27050 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 7.873 | Veterans Park | ||
4730 | 4730 | 4729 | {"type": "Polygon", "coordinates": [[[-121.44518, 37.71351], [-121.44518, 37.714], [-121.44389, 37.71402], [-121.4439, 37.7154], [-121.44286, 37.7154], [-121.44256, 37.71538], [-121.44254, 37.71376], [-121.44283, 37.71371], [-121.443, 37.71366], [-121.44387, 37.71366], [-121.44389, 37.71351], [-121.44518, 37.71351]]]} | Open Access 1 | Gretchen Talley Park | 19502 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 7.145 | Gretchen Talley Park | ||
5279 | 5279 | 5278 | {"type": "MultiPolygon", "coordinates": [[[[-121.42324, 37.73007], [-121.42312, 37.73043], [-121.42304, 37.73054], [-121.42293, 37.73066], [-121.42281, 37.73075], [-121.42269, 37.73092], [-121.42244, 37.73144], [-121.42236, 37.73146], [-121.42037, 37.73086], [-121.4205, 37.7306], [-121.42046, 37.73032], [-121.42052, 37.7303], [-121.42058, 37.73025], [-121.42063, 37.73028], [-121.42096, 37.73028], [-121.42242, 37.73027], [-121.42243, 37.73], [-121.42317, 37.73], [-121.42324, 37.73007]]], [[[-121.42395, 37.72957], [-121.42373, 37.73018], [-121.42344, 37.73014], [-121.4235, 37.73005], [-121.4235, 37.72995], [-121.42347, 37.72989], [-121.42342, 37.72985], [-121.42328, 37.72981], [-121.42327, 37.72957], [-121.42395, 37.72957]]]]} | Open Access 1 | Hoyt Park | 20127 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 6.465 | Hoyt Park | ||
5708 | 5708 | 5707 | {"type": "Polygon", "coordinates": [[[-121.45063, 37.75672], [-121.45057, 37.75678], [-121.45031, 37.75683], [-121.45007, 37.75691], [-121.44987, 37.757], [-121.44955, 37.75719], [-121.44932, 37.75727], [-121.44902, 37.75734], [-121.44873, 37.75737], [-121.44873, 37.75595], [-121.44894, 37.75594], [-121.44894, 37.75568], [-121.44929, 37.75568], [-121.44929, 37.75575], [-121.44942, 37.75584], [-121.44972, 37.75589], [-121.45019, 37.75569], [-121.45061, 37.75569], [-121.45063, 37.75672]]]} | Open Access 1 | Kenner Park | 20607 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 6.013 | Kenner Park | ||
10326 | 10326 | 10325 | {"type": "Polygon", "coordinates": [[[-121.43988, 37.70742], [-121.43876, 37.70743], [-121.43861, 37.70742], [-121.43836, 37.70735], [-121.43816, 37.70722], [-121.43876, 37.70671], [-121.43904, 37.70634], [-121.43905, 37.70513], [-121.43919, 37.70513], [-121.43946, 37.70527], [-121.43968, 37.70546], [-121.43975, 37.70557], [-121.43982, 37.7057], [-121.43986, 37.70587], [-121.43988, 37.70742]]]} | Open Access 1 | Thoming Park | 26311 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 5.417 | Thoming Park | ||
6007 | 6007 | 6006 | {"type": "Polygon", "coordinates": [[[-121.43013, 37.72105], [-121.42976, 37.72105], [-121.42963, 37.72102], [-121.42947, 37.72103], [-121.4282, 37.72103], [-121.42812, 37.72097], [-121.42811, 37.71999], [-121.43012, 37.71998], [-121.43013, 37.72105]]]} | Open Access 1 | Larson Park | 21038 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 5.105 | Larson Park | ||
11503 | 11503 | 11502 | {"type": "Polygon", "coordinates": [[[-121.4498, 37.74505], [-121.44971, 37.74505], [-121.44874, 37.74425], [-121.44865, 37.74416], [-121.44859, 37.74406], [-121.44854, 37.74394], [-121.44853, 37.74383], [-121.44853, 37.74372], [-121.44856, 37.74363], [-121.44868, 37.74344], [-121.44885, 37.74332], [-121.44898, 37.74325], [-121.44914, 37.74321], [-121.44933, 37.7432], [-121.44948, 37.74321], [-121.44964, 37.74325], [-121.44981, 37.74334], [-121.44993, 37.74344], [-121.45002, 37.74356], [-121.45007, 37.74368], [-121.45009, 37.74379], [-121.45009, 37.74464], [-121.45005, 37.74477], [-121.45, 37.74486], [-121.44991, 37.74496], [-121.4498, 37.74505]]]} | Open Access 1 | Zanussi Park | 27855 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.965 | Zanussi Park | ||
1127 | 1127 | 1126 | {"type": "Polygon", "coordinates": [[[-121.44091, 37.7344], [-121.44095, 37.73455], [-121.44096, 37.73472], [-121.44085, 37.73529], [-121.44084, 37.73547], [-121.44084, 37.73572], [-121.44051, 37.73576], [-121.44056, 37.73608], [-121.44064, 37.7364], [-121.44069, 37.73664], [-121.44071, 37.73705], [-121.44062, 37.73748], [-121.44047, 37.73784], [-121.44019, 37.73776], [-121.44033, 37.73739], [-121.44036, 37.7372], [-121.44039, 37.73693], [-121.44038, 37.73674], [-121.44035, 37.73659], [-121.44036, 37.73657], [-121.44023, 37.73603], [-121.4402, 37.73581], [-121.44021, 37.73574], [-121.43998, 37.73566], [-121.43988, 37.7356], [-121.43976, 37.7355], [-121.43968, 37.73539], [-121.43963, 37.73527], [-121.43962, 37.73509], [-121.43966, 37.73494], [-121.43974, 37.7348], [-121.43984, 37.7347], [-121.43995, 37.73463], [-121.44015, 37.73455], [-121.44055, 37.73449], [-121.44091, 37.7344]]]} | Open Access 1 | Alden Park | 15345 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.929 | Alden Park | ||
11239 | 11239 | 11238 | {"type": "Polygon", "coordinates": [[[-121.44027, 37.70235], [-121.43919, 37.70235], [-121.43919, 37.70066], [-121.43925, 37.7006], [-121.43978, 37.70057], [-121.44027, 37.70049], [-121.44027, 37.70235]]]} | Open Access 1 | William Adams Park | 27538 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.702 | William Adams 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 | ||
5693 | 5693 | 5692 | {"type": "Polygon", "coordinates": [[[-121.40427, 37.71437], [-121.40422, 37.71452], [-121.40414, 37.71465], [-121.40387, 37.71489], [-121.40375, 37.71505], [-121.40367, 37.71508], [-121.40345, 37.71506], [-121.4029, 37.71505], [-121.40271, 37.71503], [-121.40249, 37.71498], [-121.40226, 37.71489], [-121.40213, 37.71481], [-121.402, 37.71469], [-121.40192, 37.71456], [-121.40197, 37.71449], [-121.40237, 37.7144], [-121.40278, 37.71424], [-121.40301, 37.7141], [-121.40327, 37.71391], [-121.40336, 37.71391], [-121.40379, 37.71416], [-121.404, 37.71424], [-121.40422, 37.7143], [-121.40427, 37.71437]]]} | Open Access 1 | Kellogg Park | 20585 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.088 | Kellogg Park | ||
5607 | 5607 | 5606 | {"type": "Polygon", "coordinates": [[[-121.41139, 37.71795], [-121.41016, 37.71795], [-121.41016, 37.71656], [-121.41048, 37.71659], [-121.41138, 37.7166], [-121.41139, 37.71795]]]} | Open Access 1 | Joseph Tiago Park | 20501 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 4.023 | Joseph Tiago 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]);