units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,925 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 2 sorted by COUNTY descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 9,925 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13052 | 13052 | 13051 | {"type": "Polygon", "coordinates": [[[-120.24958, 39.68178], [-120.24797, 39.68179], [-120.24795, 39.68118], [-120.24692, 39.68118], [-120.24691, 39.68182], [-120.24567, 39.68182], [-120.24567, 39.68073], [-120.24958, 39.68072], [-120.24958, 39.68178]]]} | Open Access 1 | 34905 | Loyalton Park | 21571 | 1669 | Loyalton, City of 1040 | City 2 | City Agency 2 | http://www.cityofloyalton.com/ | City 2 | 1669 | Loyalton, City of 1002 | City 2 | City Agency 2 | Sierra 58 | 8.349 | Loyalton Park | 0 | Local Park 2 | 4 | |
12424 | 12424 | 12423 | {"type": "Polygon", "coordinates": [[[-120.46646, 39.8064], [-120.4655, 39.80642], [-120.46531, 39.80634], [-120.46485, 39.8061], [-120.46454, 39.80602], [-120.4642, 39.80597], [-120.46385, 39.80599], [-120.46339, 39.80605], [-120.46378, 39.80554], [-120.46349, 39.80538], [-120.46379, 39.80504], [-120.46357, 39.80482], [-120.46349, 39.80484], [-120.46315, 39.80507], [-120.46279, 39.80499], [-120.46276, 39.80495], [-120.46377, 39.80408], [-120.46384, 39.80406], [-120.46403, 39.80426], [-120.46435, 39.80441], [-120.46472, 39.80457], [-120.46496, 39.80483], [-120.46646, 39.8064]]]} | Open Access 1 | 27030 | Portola City Park | 23905 | 1457 | Portola, City of 1024 | City 2 | City Agency 2 | http://www.ci.portola.ca.us/parks-and-recreation.htm | City 2 | 1457 | Portola, City of 986 | City 2 | City Agency 2 | Plumas 57 | 8.545 | Portola City Park | 0 | Local Park 2 | 4 | |
4362 | 4362 | 4361 | {"type": "Polygon", "coordinates": [[[-120.55441, 41.49085], [-120.54983, 41.49087], [-120.54974, 41.48774], [-120.55051, 41.48775], [-120.55051, 41.48741], [-120.55279, 41.48741], [-120.55283, 41.48932], [-120.5544, 41.48932], [-120.55441, 41.49085]]]} | Open Access 1 | 48505 | Alturas Park | 33216 | 1431 | Alturas, City of 754 | City 2 | City Agency 2 | http://www.cityofalturas.org/ | City 2 | 1431 | Alturas, City of 740 | City 2 | City Agency 2 | http://www.cityofalturas.us/City%20Facility%20Use%20Area.jpg | Modoc 56 | 28.986 | Alturas Park | 0 | Local Park 2 | 4 |
12188 | 12188 | 12187 | {"type": "Polygon", "coordinates": [[[-120.54228, 41.47925], [-120.54227, 41.47998], [-120.54008, 41.47995], [-120.54008, 41.47923], [-120.54228, 41.47925]]]} | Open Access 1 | 25385 | Rachel Dorris Pioneer Park | 24066 | 1431 | Alturas, City of 754 | City 2 | City Agency 2 | http://www.cityofalturas.org/ | City 2 | 1431 | Alturas, City of 740 | City 2 | City Agency 2 | Modoc 56 | 3.657 | Rachel Dorris Pioneer Park | 0 | Local Park 2 | 4 | |
3119 | 3119 | 3118 | {"type": "Polygon", "coordinates": [[[-122.19199, 39.75275], [-122.19197, 39.75436], [-122.1904, 39.75436], [-122.1898, 39.75407], [-122.18755, 39.75307], [-122.18756, 39.75147], [-122.18867, 39.75147], [-122.18868, 39.75108], [-122.19022, 39.75107], [-122.19022, 39.75273], [-122.19199, 39.75275]]]} | Open Access 1 | 25424 | Vinsonhaler Park | 27144 | 1441 | Orland, City of 588 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | City 2 | 1441 | Orland, City of 578 | City 2 | City Agency 2 | Glenn 55 | 21.88 | Vinsonhaler Park | 0 | Local Park 2 | 4 | |
3120 | 3120 | 3119 | {"type": "Polygon", "coordinates": [[[-122.19389, 39.75222], [-122.19389, 39.75309], [-122.19289, 39.75309], [-122.1929, 39.75221], [-122.19389, 39.75222]]]} | Open Access 1 | 25431 | Spence Park | 25719 | 1441 | Orland, City of 588 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | City 2 | 1441 | Orland, City of 578 | City 2 | City Agency 2 | Glenn 55 | 2.05 | Spence Park | 0 | Local Park 2 | 4 | |
3135 | 3135 | 3134 | {"type": "Polygon", "coordinates": [[[-122.1988, 39.76147], [-122.19852, 39.7617], [-122.19829, 39.76149], [-122.19798, 39.76125], [-122.19747, 39.76098], [-122.19751, 39.76094], [-122.19762, 39.76095], [-122.19773, 39.76092], [-122.19777, 39.76085], [-122.19778, 39.7608], [-122.19776, 39.76075], [-122.19853, 39.76076], [-122.19853, 39.76101], [-122.19856, 39.76116], [-122.19866, 39.76135], [-122.1988, 39.76147]]]} | Open Access 1 | 48038 | Heartland Park | 32531 | 1441 | Orland, City of 588 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | City 2 | 1441 | Orland, City of 578 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | Glenn 55 | 1.394 | Heartland Park | 2015 | Local Park 2 | 4 |
8219 | 8219 | 8218 | {"type": "Polygon", "coordinates": [[[-122.17218, 39.7377], [-122.17216, 39.73975], [-122.16882, 39.73975], [-122.16886, 39.73637], [-122.17218, 39.7377]]]} | Open Access 1 | 48037 | Lely Park | 32530 | 1441 | Orland, City of 588 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | City 2 | 1441 | Orland, City of 578 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | Glenn 55 | 21.3 | Lely Park | 1980 | Local Park 2 | 4 |
11654 | 11654 | 11653 | {"type": "Polygon", "coordinates": [[[-122.20871, 39.51772], [-122.20669, 39.51777], [-122.20663, 39.51685], [-122.20675, 39.51683], [-122.20681, 39.51669], [-122.20669, 39.51658], [-122.20869, 39.51658], [-122.20871, 39.51772]]]} | Open Access 1 | 24477 | Central Park | 17066 | 1424 | Willows, City of 986 | City 2 | City Agency 2 | http://www.cityofwillows.org/index.asp?Type=B_BASIC&SEC={015394F5-8E1E-4589-8D14-61CADB23BEE6} | City 2 | 1424 | Willows, City of 950 | City 2 | City Agency 2 | Glenn 55 | 5.545 | Central Park | 0 | Local Park 2 | 4 | |
11871 | 11871 | 11870 | {"type": "Polygon", "coordinates": [[[-122.20464, 39.51264], [-122.1967, 39.51272], [-122.19669, 39.5116], [-122.20463, 39.5116], [-122.20464, 39.51264]]]} | Open Access 1 | 24478 | Jensen Park | 20396 | 1424 | Willows, City of 986 | City 2 | City Agency 2 | http://www.cityofwillows.org/index.asp?Type=B_BASIC&SEC={015394F5-8E1E-4589-8D14-61CADB23BEE6} | City 2 | 1424 | Willows, City of 950 | City 2 | City Agency 2 | Glenn 55 | 20.29 | Jensen Park | 0 | Local Park 2 | 4 | |
11872 | 11872 | 11871 | {"type": "Polygon", "coordinates": [[[-122.20452, 39.52046], [-122.20244, 39.52043], [-122.20242, 39.51893], [-122.20184, 39.51891], [-122.20182, 39.51795], [-122.20446, 39.51791], [-122.20452, 39.52046]]]} | Open Access 1 | 24480 | Sycamore Park | 26140 | 1424 | Willows, City of 986 | City 2 | City Agency 2 | http://www.cityofwillows.org/index.asp?Type=B_BASIC&SEC={015394F5-8E1E-4589-8D14-61CADB23BEE6} | City 2 | 1424 | Willows, City of 950 | City 2 | City Agency 2 | Glenn 55 | 13.591 | Sycamore Park | 0 | Local Park 2 | 4 | |
14253 | 14253 | 14252 | {"type": "Polygon", "coordinates": [[[-122.19401, 39.74396], [-122.194, 39.74508], [-122.19296, 39.74508], [-122.19297, 39.74396], [-122.19401, 39.74396]]]} | Open Access 1 | 44173 | Library Park | 21223 | 1441 | Orland, City of 588 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | City 2 | 1441 | Orland, City of 578 | City 2 | City Agency 2 | Glenn 55 | 2.726 | Library Park | 0 | Local Park 2 | 4 | |
12222 | 12222 | 12221 | {"type": "Polygon", "coordinates": [[[-120.65746, 40.41862], [-120.65737, 40.41884], [-120.65689, 40.41872], [-120.65681, 40.41889], [-120.65676, 40.41889], [-120.65671, 40.41903], [-120.65723, 40.41917], [-120.65707, 40.41957], [-120.65304, 40.41858], [-120.65356, 40.4172], [-120.65359, 40.41718], [-120.65691, 40.41799], [-120.65709, 40.41757], [-120.65715, 40.41759], [-120.65699, 40.418], [-120.65714, 40.41805], [-120.65712, 40.41811], [-120.65504, 40.41759], [-120.65487, 40.41798], [-120.65746, 40.41862]]]} | Open Access 1 | 25416 | Memorial Park | 22140 | 1437 | Susanville, City of 1013 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | Lassen 54 | 11.523 | Memorial Park | 0 | Local Park 2 | 4 | |
12223 | 12223 | 12222 | {"type": "Polygon", "coordinates": [[[-120.65267, 40.41073], [-120.6516, 40.41196], [-120.65146, 40.4118], [-120.65132, 40.41167], [-120.65058, 40.41121], [-120.65046, 40.41058], [-120.65049, 40.41027], [-120.65078, 40.40988], [-120.65179, 40.41035], [-120.65181, 40.41033], [-120.65267, 40.41073]]]} | Open Access 1 | 25417 | Riverside Park | 24458 | 1437 | Susanville, City of 1013 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | Lassen 54 | 5.83 | Riverside Park | 0 | Local Park 2 | 4 | |
12224 | 12224 | 12223 | {"type": "Polygon", "coordinates": [[[-120.65866, 40.41492], [-120.65846, 40.41525], [-120.65785, 40.41487], [-120.65713, 40.4142], [-120.65694, 40.41415], [-120.65669, 40.41415], [-120.65642, 40.41419], [-120.65538, 40.41461], [-120.65454, 40.41459], [-120.65442, 40.4145], [-120.65445, 40.41416], [-120.6546, 40.41418], [-120.65461, 40.41429], [-120.65474, 40.41429], [-120.65475, 40.41419], [-120.65542, 40.41425], [-120.65545, 40.41398], [-120.65556, 40.41398], [-120.65559, 40.41368], [-120.65758, 40.41388], [-120.65784, 40.41394], [-120.65802, 40.41405], [-120.65815, 40.41423], [-120.6582, 40.41433], [-120.65828, 40.41468], [-120.65831, 40.41475], [-120.65839, 40.4148], [-120.65866, 40.41492]]]} | Open Access 1 | 25418 | Susan River Park | 26079 | 1437 | Susanville, City of 1013 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | Lassen 54 | 5.128 | Susan River Park | 0 | Local Park 2 | 4 | |
13043 | 13043 | 13042 | {"type": "Polygon", "coordinates": [[[-120.64976, 40.41359], [-120.64933, 40.41358], [-120.64902, 40.41334], [-120.64894, 40.41443], [-120.64785, 40.41413], [-120.64787, 40.41406], [-120.64746, 40.41393], [-120.64746, 40.41391], [-120.64718, 40.41378], [-120.6472, 40.41372], [-120.64686, 40.41359], [-120.64682, 40.41365], [-120.64671, 40.41361], [-120.64675, 40.41353], [-120.64674, 40.4135], [-120.6464, 40.41308], [-120.64605, 40.41271], [-120.64614, 40.41239], [-120.64652, 40.41262], [-120.64737, 40.41246], [-120.64744, 40.41243], [-120.64902, 40.41302], [-120.64976, 40.41356], [-120.64976, 40.41359]]]} | Open Access 1 | 34885 | Little Leage Park | 21342 | 1437 | Susanville, City of 1013 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | Lassen 54 | 8.66 | Little Leage Park | 0 | Local Park 2 | 4 | |
12124 | 12124 | 12123 | {"type": "Polygon", "coordinates": [[[-120.54359, 38.07252], [-120.54304, 38.0731], [-120.54208, 38.0718], [-120.54247, 38.07163], [-120.5426, 38.07159], [-120.54268, 38.07162], [-120.54292, 38.07186], [-120.54308, 38.07205], [-120.54312, 38.07228], [-120.54312, 38.07241], [-120.54324, 38.07242], [-120.54346, 38.07234], [-120.54359, 38.07252]]]} | Open Access 1 | 25078 | Utica Park | 26748 | 1447 | Angels Camp, City of 1006 | City 2 | City Agency 2 | http://www.angelscamp.gov/ | City 2 | 1447 | Angels Camp, City of 969 | City 2 | City Agency 2 | Calaveras 53 | 2.27 | Utica Park | 0 | Local Park 2 | 4 | |
12388 | 12388 | 12387 | {"type": "Polygon", "coordinates": [[[-120.53873, 38.07164], [-120.53868, 38.07165], [-120.53863, 38.07162], [-120.53822, 38.07175], [-120.53815, 38.07167], [-120.53812, 38.0715], [-120.53793, 38.0709], [-120.53812, 38.07088], [-120.53813, 38.07116], [-120.53823, 38.07134], [-120.53873, 38.07164]]]} | Open Access 1 | 26532 | Tyron Park | 26632 | 1447 | Angels Camp, City of 1006 | City 2 | City Agency 2 | http://www.angelscamp.gov/ | City 2 | 1447 | Angels Camp, City of 969 | City 2 | City Agency 2 | Calaveras 53 | 0.487 | Tyron Park | 0 | Local Park 2 | 4 | |
14956 | 14956 | 14955 | {"type": "Polygon", "coordinates": [[[-120.55955, 38.07348], [-120.55892, 38.07348], [-120.55892, 38.07354], [-120.55864, 38.07366], [-120.5587, 38.07358], [-120.55857, 38.07303], [-120.55837, 38.07291], [-120.55911, 38.07285], [-120.55944, 38.07326], [-120.55955, 38.07348]]]} | Open Access 1 | 45562 | Gateway Park | 28390 | 1447 | Angels Camp, City of 1006 | City 2 | City Agency 2 | http://www.angelscamp.gov/ | City 2 | 1447 | Angels Camp, City of 969 | City 2 | City Agency 2 | http://angelscamp.gov/files/12_Parks%20&%20Recreation.pdf | Calaveras 53 | 1.194 | Gateway Park | 0 | Local Park 2 | 4 |
3273 | 3273 | 3272 | {"type": "Polygon", "coordinates": [[[-120.94658, 38.35284], [-120.94638, 38.35318], [-120.94631, 38.35338], [-120.94598, 38.35337], [-120.94565, 38.35342], [-120.9456, 38.35326], [-120.94566, 38.35301], [-120.9457, 38.35306], [-120.94579, 38.3531], [-120.94591, 38.35308], [-120.94594, 38.35306], [-120.94599, 38.35299], [-120.94598, 38.3529], [-120.94594, 38.35283], [-120.94599, 38.35268], [-120.94658, 38.35284]]]} | Open Access 1 | 48723 | Perry Earl Park | 33445 | 1445 | Ione, City of 610 | City 2 | City Agency 2 | http://ione-ca.com | City 2 | 1445 | Ione, City of 599 | City 2 | City Agency 2 | https://www.ione-ca.com/things-to-do/parks | Amador 52 | 0.989 | Perry Earl 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]);