units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where ACCESS_TYP = 4 and MNG_AG_TYP = 2 sorted by map
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4946 | 4946 | 4945 | {"type": "Polygon", "coordinates": [[[-119.7272, 34.4336], [-119.72698, 34.43445], [-119.72664, 34.43545], [-119.72639, 34.43526], [-119.72657, 34.43483], [-119.72679, 34.43462], [-119.72695, 34.43445], [-119.72702, 34.43416], [-119.72681, 34.43413], [-119.72683, 34.43397], [-119.72706, 34.43399], [-119.72716, 34.43359], [-119.7272, 34.4336]]]} | Unknown Access 4 | 14659 | El Mission Creek | 18514 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.719 | El Mission Creek | 0 | Local Other or Unknown 14 | 4 | |
1986 | 1986 | 1985 | {"type": "Polygon", "coordinates": [[[-119.79036, 36.76947], [-119.78888, 36.76947], [-119.78887, 36.7687], [-119.78891, 36.76869], [-119.78909, 36.7686], [-119.79, 36.76854], [-119.79001, 36.76798], [-119.79035, 36.76797], [-119.79036, 36.76947]]]} | Unknown Access 4 | 15187 | Ratcliffe Stadium | 24192 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 3.753 | Ratcliffe Stadium | None 158 | |||
13234 | 13234 | 13233 | {"type": "Polygon", "coordinates": [[[-120.57752, 34.96378], [-120.57752, 34.96399], [-120.57714, 34.96399], [-120.57714, 34.96377], [-120.57752, 34.96378]]]} | Unknown Access 4 | 35278 | Guadalupe holding 9 | 19554 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.206 | Guadalupe holding 9 | 0 | Local Other or Unknown 14 | 4 | ||
2134 | 2134 | 2133 | {"type": "Polygon", "coordinates": [[[-121.32208, 36.402], [-121.32178, 36.40221], [-121.32097, 36.40256], [-121.31938, 36.40316], [-121.31871, 36.40382], [-121.31838, 36.40545], [-121.318, 36.40469], [-121.31752, 36.40383], [-121.31755, 36.40364], [-121.31762, 36.40347], [-121.31775, 36.40326], [-121.31788, 36.40313], [-121.3181, 36.40297], [-121.31862, 36.40285], [-121.31927, 36.40262], [-121.31975, 36.40242], [-121.32168, 36.40147], [-121.32188, 36.40139], [-121.32208, 36.402]]]} | Unknown Access 4 | 17419 | Los Coches Adobe | 21512 | 1336 | Soledad, City of 485 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | Monterey 14 | 10.355 | Los Coches Adobe | None 173 | |||
11085 | 11085 | 11084 | {"type": "Polygon", "coordinates": [[[-121.5949, 38.15797], [-121.59472, 38.15807], [-121.592, 38.16102], [-121.59186, 38.16102], [-121.58624, 38.15878], [-121.58673, 38.15797], [-121.5871, 38.1577], [-121.58783, 38.15763], [-121.58864, 38.15775], [-121.59014, 38.15777], [-121.59087, 38.15761], [-121.59142, 38.15729], [-121.59198, 38.15656], [-121.5949, 38.15797]]]} | Unknown Access 4 | 21327 | Delta Protection | 18076 | 1150 | Isleton, City of 964 | City 2 | City Agency 2 | http://www.isletoncoc.org/ | City 2 | 1150 | Isleton, City of 932 | City 2 | City Agency 2 | Sacramento 41 | 46.487 | Delta Protection | None 962 | |||
12711 | 12711 | 12710 | {"type": "Polygon", "coordinates": [[[-121.72875, 38.64797], [-121.72864, 38.65335], [-121.72639, 38.65334], [-121.72639, 38.65153], [-121.71965, 38.65152], [-121.71964, 38.65159], [-121.7104, 38.65156], [-121.7105, 38.64787], [-121.72282, 38.64792], [-121.72283, 38.649], [-121.7259, 38.649], [-121.72593, 38.64795], [-121.72875, 38.64797]]]} | Unknown Access 4 | 29718 | Spring Lake | 25739 | 1665 | Woodland, City of 547 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | Yolo 33 | 160.694 | Spring Lake | None 1108 | |||
14697 | 14697 | 14696 | {"type": "Polygon", "coordinates": [[[-121.80876, 39.76798], [-121.80871, 39.76806], [-121.80871, 39.76814], [-121.80873, 39.76815], [-121.80863, 39.76821], [-121.80864, 39.76851], [-121.80763, 39.76852], [-121.8071, 39.76788], [-121.80738, 39.76769], [-121.8079, 39.76741], [-121.8081, 39.76735], [-121.80827, 39.76733], [-121.80829, 39.76733], [-121.8083, 39.76746], [-121.80846, 39.76763], [-121.80856, 39.76768], [-121.80866, 39.76792], [-121.80876, 39.76798]]]} | Unknown Access 4 | 45027 | Wildwood Estate Preserve | 27518 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 3.11 | Wildwood Estate Preserve | 0 | Local Conservation Area 4 | 2 | |
3996 | 3996 | 3995 | {"type": "Polygon", "coordinates": [[[-124.06854, 40.86404], [-124.0684, 40.86405], [-124.06846, 40.86466], [-124.06734, 40.86467], [-124.06703, 40.86377], [-124.06672, 40.86309], [-124.06685, 40.86302], [-124.06697, 40.86297], [-124.06725, 40.86295], [-124.06737, 40.86291], [-124.06748, 40.86283], [-124.06753, 40.86276], [-124.06754, 40.86269], [-124.06804, 40.86252], [-124.06795, 40.8623], [-124.0683, 40.86229], [-124.06839, 40.86331], [-124.06844, 40.86361], [-124.06854, 40.86404]]]} | Unknown Access 4 | 46793 | Arcata Ridge Trail | 30248 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 6.431 | Arcata Ridge Trail | 0 | Local Recreation Area 3 | 4 | |
4769 | 4769 | 4768 | {"type": "Polygon", "coordinates": [[[-124.10344, 40.4928], [-124.10326, 40.49301], [-124.10325, 40.49313], [-124.10297, 40.49314], [-124.10296, 40.49296], [-124.103, 40.49297], [-124.10313, 40.4928], [-124.10344, 40.4928]]]} | Unknown Access 4 | 46929 | Unnamed site - Rio Dell, City of | 30545 | 1435 | Rio Dell, City of 642 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | Humboldt 45 | 0.236 | 0 | Local Other or Unknown 14 | 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]);