units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
704 rows where DES_TP = 2 and MNG_AG_TYP = 4 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- East Bay Regional Park District 74
- Hayward Area Recreation and Park District 73
- Valley-Wide Recreation and Park District 55
- Rancho Simi Recreation and Park District 42
- Cordova Recreation and Park District 36
- Southgate Recreation and Park District 34
- Greater Vallejo Recreation and Park District 28
- Conejo Recreation and Park District 25
- Pleasant Valley Recreation and Park District 24
- Sunrise Recreation and Park District 24
- North of the River Recreation and Park District 23
- Jurupa Area Recreation and Park District 15
- Mission Oaks Recreation and Park District 14
- Isla Vista Recreation and Park District 12
- Apple Valley Recreation and Park District 10
- Carmichael Recreation and Park District 10
- North Highland Recreation and Park District 10
- Auburn Area Recreation and Park District 9
- Pleasant Hill Recreation and Park District 9
- Hesperia Recreation and Park District 9
- Monterey Peninsula Regional Park District 8
- Desert Recreation District 8
- Fair Oaks Recreation and Park District 8
- Rio Linda Elverta Recreation and Park District 7
- Big Bear Valley Recreation and Park District 7
- Feather River Recreation and Park District 6
- Livermore Area Recreation and Park District 6
- Boulder Creek Recreation and Park District 5
- Miraleste Recreation and Park District 5
- Coalinga-Huron Recreation and Park District 4
- …
ACCESS_TYP 3
- Open Access 640
- No Public Access 26
- Restricted Access 18
MNG_AG_TYP 1
- Recreation/Parks District · 684 ✖
DES_TP 1
- Local Park · 684 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11851 | 11851 | 11850 | {"type": "Polygon", "coordinates": [[[-121.33726, 38.65614], [-121.33715, 38.65638], [-121.33713, 38.65702], [-121.33698, 38.65713], [-121.33701, 38.65735], [-121.33685, 38.65747], [-121.3347, 38.65745], [-121.33473, 38.65612], [-121.3349, 38.65612], [-121.33507, 38.65607], [-121.33528, 38.65609], [-121.33543, 38.656], [-121.33567, 38.65597], [-121.33594, 38.65596], [-121.33594, 38.65586], [-121.33626, 38.65586], [-121.33595, 38.65586], [-121.33594, 38.65605], [-121.33612, 38.65605], [-121.33612, 38.65613], [-121.33625, 38.65614], [-121.33627, 38.65622], [-121.33674, 38.65623], [-121.33726, 38.65614]]]} | Open Access 1 | 24286 | Arcade Creek Park | 15563 | 2201 | Arcade Creek Recreation and Park District 739 | Special District 4 | Recreation/Parks District 4 | http://www.acrpd.com/ | Special District 4 | 2201 | Arcade Creek Recreation and Park District 724 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 7.726 | Arcade Creek Park | 0 | Local Park 2 | 4 | |
6983 | 6983 | 6982 | {"type": "Polygon", "coordinates": [[[-121.23921, 38.55639], [-121.23932, 38.5566], [-121.23943, 38.55694], [-121.23949, 38.55728], [-121.23948, 38.55731], [-121.23944, 38.55734], [-121.2391, 38.55736], [-121.23686, 38.55732], [-121.23682, 38.55731], [-121.2368, 38.55729], [-121.2368, 38.5567], [-121.23679, 38.55666], [-121.23676, 38.55663], [-121.23683, 38.55659], [-121.23683, 38.55631], [-121.23921, 38.55639]]]} | Open Access 1 | 47556 | Argonaut Park | 31273 | 2193 | Cordova Recreation and Park District 307 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://crpd.com/parks/argonaut-park/ | Sacramento 41 | 6.115 | Argonaut Park | 0 | Local Park 2 | 4 |
9001 | 9001 | 9000 | {"type": "Polygon", "coordinates": [[[-119.03884, 34.23056], [-119.03843, 34.23056], [-119.03842, 34.23061], [-119.03835, 34.23061], [-119.03835, 34.23056], [-119.03797, 34.23056], [-119.03796, 34.23097], [-119.03758, 34.23097], [-119.03757, 34.23102], [-119.03751, 34.23102], [-119.0375, 34.23097], [-119.03671, 34.23097], [-119.0367, 34.23102], [-119.03664, 34.23102], [-119.03662, 34.23097], [-119.0359, 34.23097], [-119.0359, 34.23006], [-119.03662, 34.23006], [-119.03663, 34.23002], [-119.03669, 34.23002], [-119.0367, 34.23006], [-119.03748, 34.23006], [-119.03749, 34.23001], [-119.03755, 34.23001], [-119.03756, 34.23006], [-119.03795, 34.23006], [-119.03796, 34.23045], [-119.03834, 34.23045], [-119.03835, 34.23041], [-119.03841, 34.23041], [-119.03842, 34.23045], [-119.03884, 34.23045], [-119.03884, 34.23056]]]} | Open Access 1 | 14882 | Arneill Ranch Park | 15600 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 5.027 | Arneill Ranch Park | 0 | Local Park 2 | 4 | |
9505 | 9505 | 9504 | {"type": "Polygon", "coordinates": [[[-118.79202, 34.27444], [-118.79152, 34.27402], [-118.79102, 34.27366], [-118.79083, 34.27355], [-118.79093, 34.27342], [-118.791, 34.27328], [-118.79202, 34.27328], [-118.79202, 34.27444]]]} | Open Access 1 | 15917 | Arroyo Park | 15622 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 2.006 | Arroyo Park | 0 | Local Park 2 | 4 | |
9046 | 9046 | 9045 | {"type": "Polygon", "coordinates": [[[-118.68263, 34.26869], [-118.68195, 34.26869], [-118.68192, 34.26875], [-118.68186, 34.26874], [-118.6818, 34.26875], [-118.68176, 34.26869], [-118.6811, 34.26869], [-118.6811, 34.26856], [-118.68112, 34.26847], [-118.68111, 34.2684], [-118.68105, 34.2683], [-118.68095, 34.26824], [-118.68106, 34.26798], [-118.68214, 34.26828], [-118.68263, 34.26838], [-118.68263, 34.26869]]]} | Open Access 1 | 16634 | Arroyostow Park | 15638 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 2.019 | Arroyostow Park | 0 | Local Park 2 | 4 | |
11223 | 11223 | 11222 | {"type": "Polygon", "coordinates": [[[-121.06468, 38.91873], [-121.06431, 38.91933], [-121.06366, 38.91966], [-121.06329, 38.91982], [-121.063, 38.91991], [-121.063, 38.91944], [-121.0622, 38.91748], [-121.06238, 38.91737], [-121.06257, 38.91741], [-121.06446, 38.91859], [-121.06446, 38.91872], [-121.06468, 38.91873]]]} | Open Access 1 | 21559 | Ashford Park | 15650 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_ashford.php | Placer 35 | 7.059 | Ashford Park | 0 | Local Park 2 | 4 |
9143 | 9143 | 9142 | {"type": "Polygon", "coordinates": [[[-122.10782, 37.69342], [-122.10723, 37.69384], [-122.107, 37.69365], [-122.10684, 37.69376], [-122.1067, 37.69364], [-122.10697, 37.69343], [-122.10661, 37.69311], [-122.10689, 37.6929], [-122.10691, 37.69291], [-122.10694, 37.69288], [-122.10694, 37.69286], [-122.10699, 37.69283], [-122.10782, 37.69342]]]} | Open Access 1 | 15171 | Ashland Park | 15654 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.486 | Ashland Park | 0 | Local Park 2 | 4 | |
13106 | 13106 | 13105 | {"type": "Polygon", "coordinates": [[[-121.36647, 38.57697], [-121.36491, 38.57743], [-121.36468, 38.57747], [-121.36465, 38.57737], [-121.36465, 38.57714], [-121.36415, 38.57728], [-121.36363, 38.57713], [-121.36368, 38.57704], [-121.36372, 38.57694], [-121.36374, 38.57674], [-121.3637, 38.57661], [-121.36346, 38.576], [-121.36344, 38.57586], [-121.36347, 38.57573], [-121.36562, 38.5751], [-121.36647, 38.57697]]]} | Open Access 1 | 35024 | Ashton Park | 15656 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 11.243 | Ashton Park | 0 | Local Park 2 | 4 | |
1984 | 1984 | 1983 | {"type": "Polygon", "coordinates": [[[-118.75367, 34.28776], [-118.75324, 34.28777], [-118.75323, 34.28789], [-118.752, 34.28789], [-118.752, 34.28642], [-118.75365, 34.28642], [-118.75365, 34.28723], [-118.75367, 34.28776]]]} | Open Access 1 | 16797 | Atherwood Park | 15668 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 6.024 | Atherwood Park | 0 | Local Park 2 | 4 | |
15950 | 15950 | 15949 | {"type": "Polygon", "coordinates": [[[-121.10732, 38.95626], [-121.10451, 38.95631], [-121.10406, 38.95183], [-121.10279, 38.95142], [-121.10144, 38.95043], [-121.1013, 38.94998], [-121.10036, 38.94996], [-121.09999, 38.94985], [-121.09987, 38.94957], [-121.10027, 38.9497], [-121.10121, 38.94971], [-121.10121, 38.9497], [-121.10115, 38.94947], [-121.10127, 38.94963], [-121.10135, 38.9497], [-121.10149, 38.94977], [-121.10199, 38.94994], [-121.10238, 38.95], [-121.10269, 38.94999], [-121.10324, 38.94992], [-121.10364, 38.94996], [-121.1071, 38.94987], [-121.10711, 38.94998], [-121.10731, 38.94996], [-121.10731, 38.95207], [-121.10735, 38.95531], [-121.10733, 38.9556], [-121.10732, 38.95626]]]} | Open Access 1 | 36157 | Auburn Regional Park | 33689 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_regional.php | Placer 35 | 56.324 | Auburn RP | 0 | Local Park 2 | 4 |
8397 | 8397 | 8396 | {"type": "Polygon", "coordinates": [[[-119.15641, 35.40372], [-119.1562, 35.40376], [-119.15599, 35.40383], [-119.15575, 35.40394], [-119.15557, 35.40405], [-119.15225, 35.40133], [-119.15324, 35.40133], [-119.15325, 35.40155], [-119.1544, 35.40155], [-119.15447, 35.4017], [-119.15459, 35.40192], [-119.15485, 35.40226], [-119.15497, 35.40238], [-119.15505, 35.40233], [-119.1562, 35.40328], [-119.15628, 35.40338], [-119.15635, 35.40348], [-119.15641, 35.40372]]]} | Open Access 1 | 12999 | Austin Creek Park | 15711 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | https://norfun.org/construction/austin-creek-park/ | Kern 36 | 9.344 | Austin Creek Park | 0 | Local Park 2 | 4 |
14071 | 14071 | 14070 | {"type": "Polygon", "coordinates": [[[-117.16253, 33.66383], [-117.16252, 33.66493], [-117.16247, 33.66497], [-117.16218, 33.66497], [-117.16213, 33.66493], [-117.16211, 33.66466], [-117.16205, 33.66446], [-117.16195, 33.66425], [-117.16181, 33.66408], [-117.16181, 33.66403], [-117.16204, 33.6639], [-117.1621, 33.66382], [-117.16253, 33.66383]]]} | Open Access 1 | 39108 | Autumn Breeze Park | 15715 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 1.484 | Autumn Breeze Park | 0 | Local Park 2 | 4 | |
6859 | 6859 | 6858 | {"type": "Polygon", "coordinates": [[[-117.39388, 34.01558], [-117.39303, 34.01723], [-117.39281, 34.01754], [-117.39105, 34.01644], [-117.39205, 34.01531], [-117.39225, 34.01543], [-117.39257, 34.01508], [-117.39254, 34.01505], [-117.39262, 34.0148], [-117.39388, 34.01558]]]} | Open Access 1 | 5493 | Avalon Park | 15722 | 2051 | Jurupa Area Recreation and Park District 364 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.ssf.net/377/Parks-Recreation | Riverside 10 | 10.008 | Avalon Park | 0 | Local Park 2 | 4 |
14551 | 14551 | 14550 | {"type": "Polygon", "coordinates": [[[-117.11078, 33.59922], [-117.11047, 33.59922], [-117.11042, 33.59918], [-117.11042, 33.59883], [-117.11047, 33.59862], [-117.11044, 33.59855], [-117.11077, 33.59833], [-117.11078, 33.59922]]]} | Open Access 1 | 48277 | Avignon Park | 32832 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 0.671 | Avignon Park | 0 | Local Park 2 | 4 | |
11612 | 11612 | 11611 | {"type": "Polygon", "coordinates": [[[-121.44526, 38.70242], [-121.44525, 38.7037], [-121.44303, 38.70368], [-121.44304, 38.7024], [-121.44526, 38.70242]]]} | Open Access 1 | 23892 | Babe Best Park | 15746 | 2190 | Rio Linda Elverta Recreation and Park District 546 | Special District 4 | Recreation/Parks District 4 | http://rleparks.com/ | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.785 | Babe Best Park | 0 | Local Park 2 | 4 | |
9693 | 9693 | 9692 | {"type": "Polygon", "coordinates": [[[-122.06313, 39.01813], [-122.06254, 39.01813], [-122.06198, 39.01814], [-122.06199, 39.01614], [-122.06312, 39.01613], [-122.06313, 39.01813]]]} | Open Access 1 | 16378 | Ball Four Park | 15784 | 2301 | Arbuckle Parks and Recreation District 918 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | Colusa 49 | 5.419 | Ball Four Park | 0 | Local Park 2 | 4 | |
11665 | 11665 | 11664 | {"type": "Polygon", "coordinates": [[[-121.28701, 38.63469], [-121.28548, 38.63471], [-121.28524, 38.63296], [-121.28538, 38.633], [-121.28549, 38.63297], [-121.28699, 38.63292], [-121.28701, 38.63469]]]} | Open Access 1 | 23958 | Bannister Park | 15799 | 2221 | Fair Oaks Recreation and Park District 975 | Special District 4 | Recreation/Parks District 4 | http://www.fairoakspark.org/ | Special District 4 | 2221 | Fair Oaks Recreation and Park District 940 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.872 | Bannister Park | 0 | Local Park 2 | 4 | |
2022 | 2022 | 2021 | {"type": "Polygon", "coordinates": [[[-118.95258, 34.15965], [-118.95191, 34.15988], [-118.95174, 34.15957], [-118.9516, 34.15941], [-118.95136, 34.15924], [-118.95118, 34.15915], [-118.95127, 34.15911], [-118.95136, 34.15904], [-118.95142, 34.15891], [-118.95142, 34.15885], [-118.95126, 34.15851], [-118.95089, 34.15712], [-118.94997, 34.15676], [-118.94971, 34.15665], [-118.94978, 34.15661], [-118.95097, 34.15694], [-118.95211, 34.15752], [-118.95204, 34.15762], [-118.95258, 34.15965]]]} | Open Access 1 | 17010 | Banyan Park | 15803 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 6.96 | Banyan Park | 0 | Local Park 2 | 4 | |
13188 | 13188 | 13187 | {"type": "Polygon", "coordinates": [[[-122.11963, 37.1255], [-122.11902, 37.12573], [-122.11902, 37.12573], [-122.11903, 37.12536], [-122.11963, 37.1255]]]} | Open Access 1 | 35178 | Barbara Day Park | 28528 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.272 | Barbara Day Park | 0 | Local Park 2 | 4 | |
9122 | 9122 | 9121 | {"type": "MultiPolygon", "coordinates": [[[[-119.34483, 35.58715], [-119.34481, 35.58877], [-119.34272, 35.58876], [-119.34274, 35.58715], [-119.34483, 35.58715]]], [[[-119.34698, 35.58716], [-119.34695, 35.58877], [-119.34494, 35.58876], [-119.34496, 35.58715], [-119.34698, 35.58716]]]]} | Open Access 1 | 15122 | Barker Park | 15817 | 2175 | Wasco Recreation and Park District 465 | Special District 4 | Recreation/Parks District 4 | http://www.wascoparks.com/ | Special District 4 | 2175 | Wasco Recreation and Park District 458 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 16.438 | Barker 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]);