units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
164 rows where DES_TP = 3 and MNG_AG_TYP = 4 sorted by MNG_AG_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, PARK_URL, COUNTY, YR_EST
MNG_AGENCY >30
- East Bay Regional Park District 28
- Conejo Recreation and Park District 14
- Sunrise Recreation and Park District 12
- Rancho Simi Recreation and Park District 11
- Valley-Wide Recreation and Park District 9
- Hayward Area Recreation and Park District 7
- Isla Vista Recreation and Park District 6
- Desert Recreation District 6
- Southgate Recreation and Park District 5
- Monterey Peninsula Regional Park District 4
- Tuolumne Park and Recreation District 4
- Miraleste Recreation and Park District 4
- Pleasant Valley Recreation and Park District 3
- Apple Valley Recreation and Park District 3
- Pleasant Hill Recreation and Park District 3
- Durham Recreation and Park District 3
- Barstow Recreation and Park District 2
- Jurupa Area Recreation and Park District 2
- North of the River Recreation and Park District 2
- Auburn Area Recreation and Park District 2
- West Side Recreation and Park District 2
- Truckee-Donner Recreation and Park District 2
- Hesperia Recreation and Park District 2
- Orangevale Recreation and Park District 2
- Weed Recreation and Parks District 2
- Rim of the World Recreation and Park District 1
- Feather River Recreation and Park District 1
- Greater Vallejo Recreation and Park District 1
- Shafter Recreation and Park District 1
- Wasco Recreation and Park District 1
- …
ACCESS_TYP 3
MNG_AG_TYP 1
- Recreation/Parks District · 164 ✖
DES_TP 1
- Local Recreation Area · 164 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6713 | 6713 | 6712 | {"type": "Polygon", "coordinates": [[[-121.2326, 40.30976], [-121.23197, 40.31049], [-121.23162, 40.31034], [-121.23162, 40.31029], [-121.23127, 40.31012], [-121.23133, 40.31004], [-121.23107, 40.30991], [-121.23167, 40.30916], [-121.23253, 40.30955], [-121.2326, 40.30976]]]} | Open Access 1 | 48415 | Truman Collins Sports Complex | 33012 | 7030 | Collins Pine Company 841 | Private 7 | Commericial 30 | http://www.collinsco.com/ | Private 14 | 2427 | Almanor Recreation and Park District 818 | Special District 4 | Recreation/Parks District 4 | https://ceqanet.opr.ca.gov/2003038103 | Plumas 57 | 2.653 | Truman Collins Sports Complex | 0 | Local Recreation Area 3 | 4 |
14329 | 14329 | 14328 | {"type": "Polygon", "coordinates": [[[-122.38715, 41.43835], [-122.38702, 41.43886], [-122.38616, 41.43867], [-122.38561, 41.43852], [-122.38556, 41.43846], [-122.38554, 41.43836], [-122.38559, 41.43811], [-122.38715, 41.43835]]]} | Open Access 1 | 48856 | Weed Skate Park | 33576 | 2352 | Weed Recreation and Parks District 1109 | Special District 4 | Recreation/Parks District 4 | http://weedrec.org/?page_id=45 | Special District 4 | 2352 | Weed Recreation and Parks District 1063 | Special District 4 | Recreation/Parks District 4 | https://www.northwestskater.com/weed.html | Siskiyou 28 | 1.645 | Weed Skate Park | 0 | Local Recreation Area 3 | 4 |
15010 | 15010 | 15009 | {"type": "Polygon", "coordinates": [[[-122.37462, 41.42859], [-122.37445, 41.42883], [-122.37449, 41.43002], [-122.37448, 41.43012], [-122.37445, 41.43022], [-122.37434, 41.43039], [-122.37363, 41.43074], [-122.37282, 41.43009], [-122.37198, 41.42915], [-122.37413, 41.42841], [-122.37462, 41.42859]]]} | Open Access 1 | 45662 | Sons Park and Lobis Field | 28478 | 2352 | Weed Recreation and Parks District 1109 | Special District 4 | Recreation/Parks District 4 | http://weedrec.org/?page_id=45 | Special District 4 | 2352 | Weed Recreation and Parks District 1063 | Special District 4 | Recreation/Parks District 4 | http://weedrec.org/?page_id=45 | Siskiyou 28 | 8.3 | Sons Park and Lobis Field | 0 | Local Recreation Area 3 | 4 |
12155 | 12155 | 12154 | {"type": "Polygon", "coordinates": [[[-121.34341, 38.63191], [-121.3434, 38.63221], [-121.34306, 38.63222], [-121.34306, 38.63252], [-121.34314, 38.63271], [-121.34314, 38.63313], [-121.34317, 38.63314], [-121.34314, 38.63542], [-121.33905, 38.63534], [-121.33907, 38.63187], [-121.34341, 38.63191]]]} | Open Access 1 | 48738 | La Sierra Community Center | 33458 | 2306 | Carmichael Recreation and Park District 671 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | https://www.carmichaelpark.com/la-sierra-community-center | Sacramento 41 | 34.204 | La Sierra Community Ctr. | 0 | Local Recreation Area 3 | 4 |
17038 | 17038 | 17037 | {"type": "Polygon", "coordinates": [[[-121.38028, 38.71566], [-121.37876, 38.71566], [-121.37877, 38.71427], [-121.37896, 38.71426], [-121.37894, 38.71421], [-121.37891, 38.71418], [-121.3788, 38.71416], [-121.3788, 38.71329], [-121.38008, 38.71329], [-121.38006, 38.71389], [-121.38001, 38.71466], [-121.38007, 38.71497], [-121.38027, 38.71498], [-121.38028, 38.71566]]]} | Open Access 1 | 28341 | Capehart Youth Center | 16833 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 7.519 | Capehart Youth Ctr. | 0 | Local Recreation Area 3 | 4 | |
3023 | 3023 | 3022 | {"type": "Polygon", "coordinates": [[[-120.16008, 39.33028], [-120.15264, 39.33027], [-120.15263, 39.32975], [-120.15173, 39.32975], [-120.15093, 39.32976], [-120.15107, 39.32712], [-120.15331, 39.32747], [-120.1564, 39.32873], [-120.15785, 39.32925], [-120.1591, 39.32944], [-120.15954, 39.3294], [-120.16008, 39.33028]]]} | Open Access 1 | 24336 | River View Sports Park | 24428 | 2263 | Truckee-Donner Recreation and Park District 576 | Special District 4 | Recreation/Parks District 4 | http://www.tdrpd.com/ | Special District 4 | 2263 | Truckee-Donner Recreation and Park District 568 | Special District 4 | Recreation/Parks District 4 | Nevada 30 | 38.78 | River View Sports Park | 0 | Local Recreation Area 3 | 4 | |
13724 | 13724 | 13723 | {"type": "Polygon", "coordinates": [[[-120.17941, 39.32762], [-120.17921, 39.32765], [-120.17868, 39.32779], [-120.17807, 39.328], [-120.17663, 39.3284], [-120.17621, 39.32854], [-120.17576, 39.32861], [-120.17494, 39.32881], [-120.17459, 39.32886], [-120.17441, 39.32887], [-120.17439, 39.32922], [-120.17428, 39.32923], [-120.17213, 39.32983], [-120.17007, 39.32978], [-120.17011, 39.32617], [-120.1705, 39.32637], [-120.17072, 39.32608], [-120.17274, 39.32608], [-120.17309, 39.32618], [-120.1738, 39.32632], [-120.17431, 39.32639], [-120.17473, 39.32641], [-120.17941, 39.32642], [-120.17941, 39.32762]]]} | Open Access 1 | 36144 | Truckee-Donner Recreation and Park District 1 | 26552 | 2263 | Truckee-Donner Recreation and Park District 576 | Special District 4 | Recreation/Parks District 4 | http://www.tdrpd.com/ | Special District 4 | 2263 | Truckee-Donner Recreation and Park District 568 | Special District 4 | Recreation/Parks District 4 | Nevada 30 | 57.79 | Truckee-Donner Rec. and Park District 1 | 0 | Local Recreation Area 3 | 4 | |
12353 | 12353 | 12352 | {"type": "MultiPolygon", "coordinates": [[[[-123.01059, 38.48345], [-123.01015, 38.48391], [-123.00931, 38.48364], [-123.00931, 38.48303], [-123.01059, 38.48345]]], [[[-123.01075, 38.48424], [-123.01068, 38.48437], [-123.01059, 38.48435], [-123.01053, 38.48446], [-123.01034, 38.4843], [-123.01049, 38.48402], [-123.01075, 38.48424]]], [[[-123.01166, 38.4834], [-123.01106, 38.48346], [-123.01091, 38.48354], [-123.01092, 38.48356], [-123.01119, 38.48364], [-123.01093, 38.48417], [-123.01056, 38.48386], [-123.01054, 38.48387], [-123.01049, 38.48383], [-123.01078, 38.48354], [-123.01103, 38.48341], [-123.01165, 38.48335], [-123.01166, 38.4834]]]]} | Open Access 1 | 26077 | Vacation Beach Playground | 26752 | 2254 | Russian River Recreation and Park District 1020 | Special District 4 | Recreation/Parks District 4 | http://russianriverrecpark.org/ | Special District 4 | 2254 | Russian River Recreation and Park District 982 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 2.431 | Vacation Beach Playground | 0 | Local Recreation Area 3 | 4 | |
16901 | 16901 | 16900 | {"type": "Polygon", "coordinates": [[[-121.99742, 37.3099], [-121.99742, 37.31032], [-121.99733, 37.31095], [-121.99727, 37.311], [-121.99717, 37.311], [-121.99687, 37.31043], [-121.99662, 37.31014], [-121.99673, 37.31007], [-121.99654, 37.30984], [-121.99704, 37.30983], [-121.99736, 37.30986], [-121.9974, 37.3099], [-121.99742, 37.3099]]]} | Open Access 1 | 24310 | Rancho Rinconada Recreation Center | 24167 | 2251 | Rancho Rinconada Recreation and Park District 1180 | Special District 4 | Recreation/Parks District 4 | http://www.ranchoreccenter.com/ | Special District 4 | 2251 | Rancho Rinconada Recreation and Park District 1119 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 1.514 | Rancho Rinconada Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
11847 | 11847 | 11846 | {"type": "Polygon", "coordinates": [[[-121.62355, 39.75978], [-121.62353, 39.75986], [-121.62305, 39.7606], [-121.62223, 39.76218], [-121.62185, 39.76218], [-121.62186, 39.76168], [-121.62184, 39.75954], [-121.62328, 39.75953], [-121.62339, 39.75957], [-121.62347, 39.75962], [-121.62353, 39.7597], [-121.62355, 39.75978]]]} | Open Access 1 | 24232 | Terry Ashe Recreation Center | 26267 | 2250 | Paradise Recreation and Park District 580 | Special District 4 | Recreation/Parks District 4 | http://www.paradiseprpd.com/ | Special District 4 | 2250 | Paradise Recreation and Park District 572 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 6.683 | Terry Ashe Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
11625 | 11625 | 11624 | {"type": "Polygon", "coordinates": [[[-121.22526, 38.68849], [-121.22521, 38.69119], [-121.22305, 38.69116], [-121.2231, 38.68846], [-121.22368, 38.68846], [-121.22368, 38.68855], [-121.22395, 38.68855], [-121.22396, 38.68847], [-121.22526, 38.68849]]]} | Open Access 1 | 23899 | Orangevale Community Center & Pool Complex | 23180 | 2248 | Orangevale Recreation and Park District 928 | Special District 4 | Recreation/Parks District 4 | http://www.orangevalecommunitycenter.com/ | Special District 4 | 2248 | Orangevale Recreation and Park District 901 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 13.892 | Orangevale Community Ctr. & Pool Complex | 0 | Local Recreation Area 3 | 4 | |
11849 | 11849 | 11848 | {"type": "Polygon", "coordinates": [[[-121.21603, 38.68469], [-121.21601, 38.68554], [-121.21259, 38.68548], [-121.21264, 38.68378], [-121.21382, 38.6838], [-121.21381, 38.68467], [-121.21603, 38.68469]]]} | Open Access 1 | 24283 | Orangevale Sports Fields | 23183 | 2248 | Orangevale Recreation and Park District 928 | Special District 4 | Recreation/Parks District 4 | http://www.orangevalecommunitycenter.com/ | Special District 4 | 2248 | Orangevale Recreation and Park District 901 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.309 | Orangevale Sports Fields | 0 | Local Recreation Area 3 | 4 | |
15039 | 15039 | 15038 | {"type": "Polygon", "coordinates": [[[-122.30851, 41.31947], [-122.30843, 41.31955], [-122.30841, 41.31962], [-122.30842, 41.31974], [-122.30626, 41.31974], [-122.30623, 41.31611], [-122.30662, 41.31612], [-122.3068, 41.31648], [-122.30752, 41.31721], [-122.30817, 41.31723], [-122.30818, 41.31871], [-122.3083, 41.31872], [-122.3083, 41.31933], [-122.30833, 41.31934], [-122.30833, 41.31938], [-122.30836, 41.31939], [-122.30837, 41.31946], [-122.30851, 41.31947]]]} | Open Access 1 | 45695 | Youth Sports Park | 28504 | 2244 | Mt. Shasta Recreation and Park District 628 | Special District 4 | Recreation/Parks District 4 | http://www.msrec.org/ | Special District 4 | 2244 | Mt. Shasta Recreation and Park District 617 | Special District 4 | Recreation/Parks District 4 | http://msrec.org/city-park/youth-sports-field/ | Siskiyou 28 | 13.519 | Youth Sports Park | 0 | Local Recreation Area 3 | 4 |
12475 | 12475 | 12474 | {"type": "Polygon", "coordinates": [[[-123.01051, 38.46415], [-123.0105, 38.46416], [-123.0102, 38.46403], [-123.01009, 38.46418], [-123.00969, 38.46411], [-123.00947, 38.46411], [-123.00923, 38.46412], [-123.00899, 38.46416], [-123.00876, 38.46422], [-123.00858, 38.46429], [-123.0084, 38.46439], [-123.00833, 38.46398], [-123.00833, 38.46379], [-123.00835, 38.4636], [-123.00844, 38.46333], [-123.00849, 38.46321], [-123.00877, 38.46319], [-123.00949, 38.46353], [-123.00979, 38.46345], [-123.00989, 38.46339], [-123.01042, 38.4637], [-123.01021, 38.46402], [-123.01051, 38.46415]]]} | Open Access 1 | 28246 | Amphitheater Park / Youth Center | 15462 | 2241 | Monte Rio Recreation and Park District 573 | Special District 4 | Recreation/Parks District 4 | http://www.mrrpd.org/ | Special District 4 | 2241 | Monte Rio Recreation and Park District 565 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 3.656 | Amphitheater Park / Youth Ctr. | 0 | Local Recreation Area 3 | 4 | |
16900 | 16900 | 16899 | {"type": "Polygon", "coordinates": [[[-122.19908, 37.40441], [-122.19859, 37.40468], [-122.19843, 37.40469], [-122.19797, 37.40388], [-122.19864, 37.40363], [-122.19908, 37.40441]]]} | Open Access 1 | 24309 | Ladera Recreation Center | 20823 | 2233 | Ladera Recreation District 1179 | Special District 4 | Recreation/Parks District 4 | http://www.lrdrec.com/ | Special District 4 | 2233 | Ladera Recreation District 1118 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 1.613 | Ladera Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
13204 | 13204 | 13203 | {"type": "Polygon", "coordinates": [[[-116.31502, 34.13125], [-116.31407, 34.13125], [-116.31373, 34.1311], [-116.314, 34.13093], [-116.3143, 34.13079], [-116.31462, 34.1307], [-116.31496, 34.13065], [-116.315, 34.13067], [-116.31502, 34.1307], [-116.31502, 34.13125]]]} | Open Access 1 | 35207 | Joshua Tree Park and Recreation District 1 | 20507 | 2230 | Joshua Tree Park and Recreation District 627 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.384 | Joshua Tree Park and Rec. District 1 | 0 | Local Recreation Area 3 | 4 | ||
16899 | 16899 | 16898 | {"type": "Polygon", "coordinates": [[[-122.34743, 37.51955], [-122.34676, 37.52049], [-122.34572, 37.52008], [-122.34668, 37.51877], [-122.34722, 37.51902], [-122.34701, 37.51936], [-122.34743, 37.51955]]]} | Open Access 1 | 24308 | Highlands Recreation Center | 19949 | 2228 | Highlands Recreation District 1178 | Special District 4 | Recreation/Parks District 4 | http://www.highlandsrec.com/ | Special District 4 | 2228 | Highlands Recreation District 1117 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 3.66 | Highlands Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6591 | 6591 | 6590 | {"type": "Polygon", "coordinates": [[[-117.30782, 34.40725], [-117.30744, 34.40904], [-117.30711, 34.409], [-117.30688, 34.41009], [-117.30473, 34.40977], [-117.30544, 34.40652], [-117.30551, 34.4065], [-117.30775, 34.40682], [-117.30766, 34.40722], [-117.30782, 34.40725]]]} | Open Access 1 | 4164 | Lime Street Park/ Community Center | 21240 | 2227 | Hesperia Recreation and Park District 609 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 19.974 | Lime Street Park/ Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
11860 | 11860 | 11859 | {"type": "Polygon", "coordinates": [[[-117.36835, 34.41034], [-117.36627, 34.41034], [-117.36624, 34.40859], [-117.36742, 34.40859], [-117.36745, 34.4089], [-117.36698, 34.40923], [-117.36756, 34.40966], [-117.36759, 34.40963], [-117.36766, 34.40967], [-117.3679, 34.40948], [-117.36798, 34.40949], [-117.36798, 34.40955], [-117.36834, 34.40953], [-117.36835, 34.41034]]]} | Open Access 1 | 24297 | Rick Novack Community Center & Gym & Palm Street Park | 24344 | 2227 | Hesperia Recreation and Park District 609 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 6.603 | Rick Novack Community Ctr. & Gym & Palm Street Park | 0 | Local Recreation Area 3 | 4 | |
16228 | 16228 | 16227 | {"type": "Polygon", "coordinates": [[[-122.23984, 38.08159], [-122.23866, 38.08224], [-122.23769, 38.08125], [-122.23729, 38.08071], [-122.23832, 38.08009], [-122.23845, 38.08038], [-122.23855, 38.08055], [-122.23866, 38.08071], [-122.2388, 38.08088], [-122.23926, 38.0813], [-122.23948, 38.08144], [-122.23979, 38.08152], [-122.23984, 38.08156], [-122.23984, 38.08159]]]} | Open Access 1 | 44211 | Norman C. King South Vallejo Community Center | 22796 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=South_Vallejo_Community_Center | Solano 26 | 5.63 | Norman C. King South Vallejo Community Ctr. | 0 | Local Recreation Area 3 | 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]);