units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where ACCESS_TYP = 1, COUNTY = 39 and MNG_AGENCY = 527
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
- City Agency 20
ACCESS_TYP 1
- Open Access · 20 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2540 | 2540 | 2539 | {"type": "Polygon", "coordinates": [[[-121.12833, 37.75029], [-121.12831, 37.75119], [-121.12623, 37.75121], [-121.12622, 37.75028], [-121.12697, 37.75028], [-121.12698, 37.74932], [-121.12822, 37.74933], [-121.12827, 37.74938], [-121.12827, 37.75028], [-121.12833, 37.75029]]]} | Open Access 1 | 17771 | Boesch Park | 16225 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 7.644 | Boesch Park | 0 | Local Park 2 | 4 | |
2543 | 2543 | 2542 | {"type": "Polygon", "coordinates": [[[-121.11347, 37.73833], [-121.11338, 37.74062], [-121.11124, 37.74063], [-121.11127, 37.7405], [-121.11129, 37.73974], [-121.11119, 37.7394], [-121.11099, 37.73905], [-121.11074, 37.73883], [-121.11052, 37.7385], [-121.11046, 37.7381], [-121.11006, 37.73706], [-121.10991, 37.73673], [-121.10984, 37.73618], [-121.10991, 37.73553], [-121.10984, 37.73529], [-121.11047, 37.73494], [-121.11062, 37.73538], [-121.11076, 37.73543], [-121.11127, 37.73602], [-121.1116, 37.73587], [-121.11164, 37.73592], [-121.11131, 37.73607], [-121.1114, 37.73618], [-121.11154, 37.73655], [-121.1116, 37.73689], [-121.11161, 37.73726], [-121.11152, 37.73801], [-121.11146, 37.73833], [-121.11347, 37.73833]]]} | Open Access 1 | 17787 | Mavis Stouffer Park | 21962 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 23.245 | Mavis Stouffer Park | 0 | Local Park 2 | 4 | |
2546 | 2546 | 2545 | {"type": "Polygon", "coordinates": [[[-121.13629, 37.73478], [-121.13555, 37.73478], [-121.13544, 37.73442], [-121.13529, 37.73416], [-121.13577, 37.73397], [-121.13597, 37.73394], [-121.13626, 37.73394], [-121.13629, 37.73478]]]} | Open Access 1 | 17795 | Wilma Park | 27596 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 1.63 | Wilma Park | 0 | Local Park 2 | 4 | |
2681 | 2681 | 2680 | {"type": "Polygon", "coordinates": [[[-121.11665, 37.74984], [-121.11657, 37.74989], [-121.11496, 37.7499], [-121.11484, 37.74888], [-121.11655, 37.74887], [-121.11662, 37.74892], [-121.11665, 37.74984]]]} | Open Access 1 | 17791 | Vermeulen Park | 26996 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 4.286 | Vermeulen Park | 0 | Local Park 2 | 4 | |
3917 | 3917 | 3916 | {"type": "Polygon", "coordinates": [[[-121.14245, 37.7614], [-121.13919, 37.76142], [-121.13923, 37.76402], [-121.13825, 37.76402], [-121.13827, 37.76499], [-121.1359, 37.765], [-121.13596, 37.76744], [-121.13372, 37.76745], [-121.13357, 37.76127], [-121.13812, 37.76125], [-121.14244, 37.76126], [-121.14245, 37.7614]]]} | Open Access 1 | 36078 | Mistlin Sports Park | 22321 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 62.763 | Mistlin Sports Park | 0 | Local Recreation Area 3 | 4 | |
4080 | 4080 | 4079 | {"type": "Polygon", "coordinates": [[[-121.13806, 37.72898], [-121.13801, 37.72902], [-121.13798, 37.72906], [-121.13797, 37.7292], [-121.13763, 37.72921], [-121.13763, 37.72908], [-121.13769, 37.72901], [-121.13806, 37.72898]]]} | Open Access 1 | 44517 | Country Woods Tot Lot | 17706 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 0.171 | Country Woods Tot Lot | 0 | Local Recreation Area 3 | 4 | |
4088 | 4088 | 4087 | {"type": "Polygon", "coordinates": [[[-121.11871, 37.74005], [-121.11825, 37.74006], [-121.11824, 37.73956], [-121.11825, 37.73949], [-121.11832, 37.73947], [-121.11851, 37.73947], [-121.11862, 37.7395], [-121.11865, 37.73954], [-121.11871, 37.74005]]]} | Open Access 1 | 44519 | Mistlin Fountain Park | 22320 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 0.601 | Mistlin Fountain Park | 0 | Local Park 2 | 4 | |
10186 | 10186 | 10185 | {"type": "Polygon", "coordinates": [[[-121.13924, 37.74333], [-121.13916, 37.74339], [-121.13889, 37.74339], [-121.13889, 37.74345], [-121.13772, 37.74346], [-121.13769, 37.74236], [-121.13794, 37.74238], [-121.13825, 37.74246], [-121.13887, 37.74249], [-121.13888, 37.74262], [-121.13922, 37.74261], [-121.13924, 37.74333]]]} | Open Access 1 | 17779 | Harvest Estates Park | 19720 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 3.533 | Harvest Estates Park | 0 | Local Park 2 | 4 | |
12037 | 12037 | 12036 | {"type": "Polygon", "coordinates": [[[-121.11992, 37.74925], [-121.11961, 37.74925], [-121.11954, 37.74919], [-121.11954, 37.74898], [-121.11992, 37.74898], [-121.11992, 37.74925]]]} | Open Access 1 | 24713 | Magnolia Park | 21680 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 0.246 | Magnolia Park | 0 | Local Park 2 | 4 | |
12898 | 12898 | 12897 | {"type": "Polygon", "coordinates": [[[-121.12848, 37.73487], [-121.12639, 37.73485], [-121.1264, 37.73394], [-121.12796, 37.73396], [-121.12797, 37.73439], [-121.12847, 37.7344], [-121.12848, 37.73487]]]} | Open Access 1 | 36301 | Ripon holding 3 | 24399 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 4.033 | Ripon holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13664 | 13664 | 13663 | {"type": "Polygon", "coordinates": [[[-121.14987, 37.7348], [-121.14889, 37.73481], [-121.14867, 37.73482], [-121.14839, 37.73487], [-121.14774, 37.73502], [-121.14738, 37.73505], [-121.14736, 37.73317], [-121.14984, 37.73316], [-121.14987, 37.7348]]]} | Open Access 1 | 36068 | Lan Park | 20996 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 10.306 | Lan Park | 0 | Local Park 2 | 4 | |
13667 | 13667 | 13666 | {"type": "Polygon", "coordinates": [[[-121.12797, 37.73351], [-121.12796, 37.73396], [-121.1264, 37.73394], [-121.12642, 37.73349], [-121.12797, 37.73351]]]} | Open Access 1 | 36332 | Ripon holding 1 | 24397 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 1.702 | Ripon holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13695 | 13695 | 13694 | {"type": "Polygon", "coordinates": [[[-121.11327, 37.7334], [-121.10984, 37.73528], [-121.10967, 37.73473], [-121.10951, 37.7345], [-121.10905, 37.73412], [-121.10863, 37.73385], [-121.10834, 37.73319], [-121.10802, 37.7323], [-121.10808, 37.73179], [-121.1084, 37.73144], [-121.10933, 37.73075], [-121.10974, 37.73046], [-121.11327, 37.7334]]]} | Open Access 1 | 36066 | Army Corps Park | 15598 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 32.184 | Army Corps Park | 0 | Local Park 2 | 4 | |
13696 | 13696 | 13695 | {"type": "Polygon", "coordinates": [[[-121.12387, 37.73211], [-121.12376, 37.73211], [-121.12368, 37.72773], [-121.12288, 37.72775], [-121.12216, 37.72782], [-121.12169, 37.72795], [-121.11986, 37.72879], [-121.11963, 37.72876], [-121.11954, 37.72865], [-121.11948, 37.72856], [-121.11854, 37.726], [-121.11728, 37.72564], [-121.11729, 37.72558], [-121.11721, 37.72533], [-121.11702, 37.72507], [-121.11675, 37.72498], [-121.11641, 37.72477], [-121.11637, 37.7246], [-121.11664, 37.7243], [-121.11705, 37.72404], [-121.11817, 37.72372], [-121.11862, 37.72371], [-121.11907, 37.7238], [-121.1195, 37.72392], [-121.12004, 37.72444], [-121.12025, 37.72458], [-121.12057, 37.72457], [-121.12098, 37.72444], [-121.12112, 37.72425], [-121.12116, 37.72403], [-121.12088, 37.72324], [-121.1207, 37.72296], [-121.12061, 37.72274], [-121.12056, 37.72254], [-121.12061, 37.72241], [-121.12081, 37.72222], [-121.12117, 37.72204], [-121.12159, 37.72196], [-121.12203, 37.72195], [-121.12231, 37.72202], [-121.12303, 37.72236], [-121.12314, 37.72255], [-121.12311, 37.72266], [-121.12287, 37.72288], [-121.12276, 37.72295], [-121.12249, 37.72305], [-121.12215, 37.72388], [-121.1223, 37.72412], [-121.12238, 37.72418], [-121.12288, 37.72413], [-121.12331, 37.72419], [-121.12364, 37.7243], [-121.12386, 37.7243], [-121.12387, 37.73211]]]} | Open Access 1 | 36067 | Oak Grove Park | 22974 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 67.161 | Oak Grove Park | 0 | Local Park 2 | 4 | |
13769 | 13769 | 13768 | {"type": "Polygon", "coordinates": [[[-121.12812, 37.73486], [-121.12811, 37.73568], [-121.12638, 37.73567], [-121.12639, 37.73485], [-121.12812, 37.73486]]]} | Open Access 1 | 36352 | Ripon holding 2 | 24398 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 3.441 | Ripon holding 2 | 0 | Local Other or Unknown 14 | 4 | |
14321 | 14321 | 14320 | {"type": "Polygon", "coordinates": [[[-121.14551, 37.73399], [-121.14517, 37.73399], [-121.14516, 37.73392], [-121.14482, 37.73393], [-121.14482, 37.73373], [-121.14516, 37.73373], [-121.14518, 37.73379], [-121.14548, 37.73378], [-121.14551, 37.73388], [-121.14551, 37.73399]]]} | Open Access 1 | 44514 | De Jong Mini Park | 17970 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 0.331 | De Jong MP | 0 | Local Park 2 | 4 | |
14356 | 14356 | 14355 | {"type": "Polygon", "coordinates": [[[-121.14233, 37.72863], [-121.14218, 37.72863], [-121.14209, 37.72857], [-121.14208, 37.72819], [-121.14233, 37.72818], [-121.14233, 37.72863]]]} | Open Access 1 | 44516 | Postma Mini Park | 23917 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 0.253 | Postma MP | 0 | Local Park 2 | 4 | |
14383 | 14383 | 14382 | {"type": "Polygon", "coordinates": [[[-121.13756, 37.74219], [-121.13694, 37.74219], [-121.1369, 37.74096], [-121.13752, 37.74097], [-121.13756, 37.74219]]]} | Open Access 1 | 44483 | Curt Pernice Skate Park | 17863 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 1.841 | Curt Pernice Skate Park | 0 | Local Recreation Area 3 | 4 | |
14400 | 14400 | 14399 | {"type": "Polygon", "coordinates": [[[-121.14285, 37.73938], [-121.14247, 37.73938], [-121.1424, 37.73932], [-121.14239, 37.73898], [-121.14274, 37.73897], [-121.14278, 37.73905], [-121.14285, 37.73909], [-121.14285, 37.73938]]]} | Open Access 1 | 44518 | Dutch Meadows Park | 18319 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 0.419 | Dutch Meadows Park | 0 | Local Park 2 | 4 | |
14406 | 14406 | 14405 | {"type": "Polygon", "coordinates": [[[-121.14296, 37.7305], [-121.14279, 37.73057], [-121.14273, 37.73044], [-121.14271, 37.73031], [-121.14278, 37.73023], [-121.14295, 37.73023], [-121.14296, 37.7305]]]} | Open Access 1 | 44515 | Zumstein Park | 27870 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 0.158 | Zumstein 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]);