units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where AGNCY_LEV = 4 and MNG_AGENCY = 459
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Pleasant Hill Recreation and Park District · 12 ✖
ACCESS_TYP 1
- Open Access 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1981 | 1981 | 1980 | {"type": "Polygon", "coordinates": [[[-122.07151, 37.97879], [-122.07142, 37.97897], [-122.07125, 37.97917], [-122.07104, 37.97933], [-122.07091, 37.97958], [-122.06983, 37.97949], [-122.0696, 37.97961], [-122.06947, 37.97975], [-122.06947, 37.97991], [-122.06951, 37.98001], [-122.06963, 37.98011], [-122.06992, 37.97999], [-122.06988, 37.98031], [-122.06969, 37.98022], [-122.06959, 37.98022], [-122.06949, 37.98025], [-122.06938, 37.98033], [-122.06932, 37.98064], [-122.06886, 37.97959], [-122.07036, 37.97926], [-122.07077, 37.97914], [-122.07132, 37.97886], [-122.07151, 37.97879]]]} | Open Access 1 | 15154 | Shadowood Park | 25343 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 2.483 | Shadowood Park | 0 | Local Park 2 | 4 | |
3364 | 3364 | 3363 | {"type": "Polygon", "coordinates": [[[-122.06821, 37.96242], [-122.06779, 37.96243], [-122.06778, 37.96239], [-122.06715, 37.9624], [-122.06651, 37.96247], [-122.06646, 37.96233], [-122.06626, 37.96208], [-122.06625, 37.96193], [-122.06635, 37.96168], [-122.06738, 37.96154], [-122.06818, 37.96148], [-122.06821, 37.96242]]]} | Open Access 1 | 31033 | Pleasant Hill Community Center / Frank Salfingere Park | 23794 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 3.829 | Pleasant Hill Community Ctr. / Frank Salfingere Park | 0 | Local Recreation Area 3 | 4 | |
5289 | 5289 | 5288 | {"type": "Polygon", "coordinates": [[[-122.09801, 37.95417], [-122.09793, 37.95431], [-122.09779, 37.95437], [-122.0975, 37.95437], [-122.09697, 37.95431], [-122.09675, 37.95434], [-122.0967, 37.95451], [-122.0958, 37.95456], [-122.09576, 37.95409], [-122.09611, 37.9541], [-122.09648, 37.95405], [-122.09776, 37.95382], [-122.0979, 37.95384], [-122.098, 37.95403], [-122.09801, 37.95417]]]} | Open Access 1 | 15139 | Shannon Hills Park | 25358 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 2.405 | Shannon Hills Park | 0 | Local Park 2 | 4 | |
5291 | 5291 | 5290 | {"type": "Polygon", "coordinates": [[[-122.0789, 37.9493], [-122.07888, 37.9497], [-122.07834, 37.94968], [-122.07834, 37.94934], [-122.07844, 37.94935], [-122.0785, 37.94932], [-122.07854, 37.94929], [-122.0789, 37.9493]]]} | Open Access 1 | 15142 | Pinewood Park | 23695 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 0.501 | Pinewood Park | 0 | Local Park 2 | 4 | |
5292 | 5292 | 5291 | {"type": "Polygon", "coordinates": [[[-122.07585, 37.95631], [-122.07582, 37.96109], [-122.07561, 37.9611], [-122.07477, 37.95927], [-122.07458, 37.95916], [-122.07418, 37.95897], [-122.07407, 37.95887], [-122.07404, 37.95874], [-122.0741, 37.95856], [-122.0742, 37.95845], [-122.07494, 37.95802], [-122.07566, 37.95736], [-122.07566, 37.95724], [-122.07549, 37.95674], [-122.07554, 37.95661], [-122.07585, 37.95631]]]} | Open Access 1 | 15144 | Las Juntas Park | 21055 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 8.74 | Las Juntas Park | 0 | Local Park 2 | 4 | |
5293 | 5293 | 5292 | {"type": "Polygon", "coordinates": [[[-122.06741, 37.97231], [-122.06681, 37.97235], [-122.06681, 37.97255], [-122.06594, 37.97257], [-122.06679, 37.97165], [-122.0674, 37.97163], [-122.06741, 37.97231]]]} | Open Access 1 | 15147 | Chilpancingo Park | 17201 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 1.966 | Chilpancingo Park | 0 | Local Park 2 | 4 | |
6744 | 6744 | 6743 | {"type": "Polygon", "coordinates": [[[-122.08972, 37.96617], [-122.08947, 37.96661], [-122.08863, 37.96886], [-122.08827, 37.96905], [-122.08778, 37.9691], [-122.08737, 37.96908], [-122.08689, 37.96899], [-122.08676, 37.96923], [-122.08641, 37.96913], [-122.0861, 37.969], [-122.08584, 37.96887], [-122.08629, 37.96887], [-122.08634, 37.9687], [-122.08717, 37.96887], [-122.08791, 37.96887], [-122.08791, 37.96753], [-122.08281, 37.96414], [-122.0827, 37.96209], [-122.08604, 37.96205], [-122.08656, 37.96382], [-122.08674, 37.96398], [-122.08693, 37.96407], [-122.0872, 37.9644], [-122.08736, 37.96462], [-122.08765, 37.96514], [-122.08791, 37.96532], [-122.08851, 37.96556], [-122.08886, 37.96572], [-122.08922, 37.96591], [-122.08948, 37.966], [-122.0897, 37.96611], [-122.08972, 37.96617]]]} | Open Access 1 | 5085 | Paso Nogal Park | 23501 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 48.878 | Paso Nogal Park | 0 | Local Park 2 | 4 | |
6745 | 6745 | 6744 | {"type": "Polygon", "coordinates": [[[-122.06771, 37.94807], [-122.06758, 37.95021], [-122.06717, 37.95021], [-122.06716, 37.95018], [-122.06531, 37.95018], [-122.06502, 37.95016], [-122.06441, 37.95016], [-122.06438, 37.9481], [-122.06439, 37.94808], [-122.06442, 37.94807], [-122.06771, 37.94807]]]} | Open Access 1 | 5088 | Pleasant Hill Park | 23795 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 16.546 | Pleasant Hill Park | 0 | Local Park 2 | 4 | |
11862 | 11862 | 11861 | {"type": "Polygon", "coordinates": [[[-122.09727, 37.96835], [-122.09717, 37.96862], [-122.09485, 37.96935], [-122.09203, 37.969], [-122.092, 37.96452], [-122.09276, 37.96373], [-122.09296, 37.96333], [-122.093, 37.96256], [-122.09383, 37.96217], [-122.09419, 37.96211], [-122.09448, 37.96223], [-122.09467, 37.9622], [-122.09489, 37.96209], [-122.09533, 37.96201], [-122.09572, 37.96197], [-122.09637, 37.96319], [-122.09604, 37.96332], [-122.09595, 37.96369], [-122.09583, 37.96389], [-122.09567, 37.96404], [-122.09538, 37.96418], [-122.0947, 37.96427], [-122.09443, 37.96422], [-122.09396, 37.96436], [-122.09374, 37.96447], [-122.0936, 37.96466], [-122.0936, 37.96496], [-122.09385, 37.96515], [-122.09405, 37.96526], [-122.09418, 37.96538], [-122.09401, 37.96587], [-122.0937, 37.96661], [-122.09358, 37.96706], [-122.09401, 37.96735], [-122.09441, 37.96727], [-122.09466, 37.96712], [-122.09476, 37.96666], [-122.09485, 37.96614], [-122.09485, 37.9656], [-122.09496, 37.96529], [-122.09588, 37.96527], [-122.09727, 37.96835]]]} | Open Access 1 | 31035 | Ridgeview Open Space | 24358 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 58.402 | Ridgeview OS | 0 | Local Recreation Area 3 | 4 | |
11864 | 11864 | 11863 | {"type": "Polygon", "coordinates": [[[-122.08599, 37.95319], [-122.0867, 37.95368], [-122.08696, 37.95388], [-122.08706, 37.95399], [-122.0871, 37.95408], [-122.08712, 37.95418], [-122.08711, 37.95427], [-122.08708, 37.95436], [-122.08703, 37.95444], [-122.08696, 37.95451], [-122.08668, 37.95472], [-122.08599, 37.95516], [-122.08599, 37.95319]]]} | Open Access 1 | 31034 | Winslow Center | 27650 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 3.264 | Winslow Ctr. | 0 | Local Recreation Area 3 | 4 | |
11865 | 11865 | 11864 | {"type": "Polygon", "coordinates": [[[-122.07008, 37.93781], [-122.07004, 37.93796], [-122.06971, 37.93798], [-122.06978, 37.93811], [-122.06822, 37.93819], [-122.06817, 37.93572], [-122.06846, 37.93583], [-122.06878, 37.93586], [-122.06907, 37.93584], [-122.06937, 37.93568], [-122.0696, 37.93544], [-122.06984, 37.93531], [-122.07004, 37.93528], [-122.07008, 37.93555], [-122.06995, 37.93582], [-122.06999, 37.93641], [-122.06994, 37.93706], [-122.06998, 37.93734], [-122.07008, 37.93781]]]} | Open Access 1 | 31032 | Pleasant Oaks Park | 23798 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 10.648 | Pleasant Oaks Park | 0 | Local Park 2 | 4 | |
13003 | 13003 | 13002 | {"type": "Polygon", "coordinates": [[[-122.0907, 37.93537], [-122.09006, 37.93597], [-122.08958, 37.93676], [-122.08725, 37.93693], [-122.08666, 37.93695], [-122.08659, 37.93683], [-122.08671, 37.93614], [-122.08678, 37.93596], [-122.08696, 37.93579], [-122.08743, 37.93547], [-122.08755, 37.9354], [-122.08806, 37.93523], [-122.08837, 37.93516], [-122.08957, 37.93499], [-122.09047, 37.93499], [-122.0907, 37.93537]]]} | Open Access 1 | 31031 | Dinosaur Hill Park | 18156 | 2112 | Pleasant Hill Recreation and Park District 466 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 13.411 | Dinosaur Hill 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]);