units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where LAYER = 9 and SUID_NMA = 1761
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11336 | 11336 | 11335 | {"type": "Polygon", "coordinates": [[[-122.5722, 38.48217], [-122.57203, 38.48231], [-122.57203, 38.48233], [-122.57126, 38.4831], [-122.57107, 38.48361], [-122.57102, 38.48404], [-122.57104, 38.48421], [-122.57101, 38.48469], [-122.57095, 38.48496], [-122.57095, 38.48534], [-122.57098, 38.4857], [-122.57096, 38.48717], [-122.57058, 38.4879], [-122.56978, 38.48853], [-122.56939, 38.4889], [-122.56931, 38.48957], [-122.56892, 38.49018], [-122.56649, 38.49258], [-122.56657, 38.49371], [-122.55722, 38.49465], [-122.55671, 38.4877], [-122.55667, 38.48774], [-122.55666, 38.48768], [-122.54765, 38.48748], [-122.54777, 38.49106], [-122.5461, 38.49103], [-122.5459, 38.48742], [-122.5429, 38.48734], [-122.53923, 38.48511], [-122.53826, 38.48362], [-122.54059, 38.48146], [-122.53803, 38.48085], [-122.53528, 38.47475], [-122.536, 38.47259], [-122.53499, 38.47104], [-122.53511, 38.46823], [-122.53513, 38.46819], [-122.53518, 38.46721], [-122.53468, 38.46679], [-122.53333, 38.46651], [-122.52986, 38.46659], [-122.52922, 38.46657], [-122.52863, 38.46642], [-122.52646, 38.46702], [-122.52303, 38.4685], [-122.52011, 38.47042], [-122.51998, 38.47028], [-122.51986, 38.46761], [-122.52064, 38.46764], [-122.52066, 38.46709], [-122.52537, 38.46722], [-122.52559, 38.46286], [-122.52558, 38.46263], [-122.52988, 38.46251], [-122.52991, 38.46625], [-122.53999, 38.46599], [-122.53962, 38.46864], [-122.53955, 38.4687], [-122.53915, 38.47125], [-122.5435, 38.4714], [-122.54284, 38.4766], [-122.55635, 38.47683], [-122.55643, 38.48048], [-122.5635, 38.47967], [-122.56352, 38.4796], [-122.56437, 38.47953], [-122.56877, 38.47897], [-122.56896, 38.47949], [-122.56908, 38.47955], [-122.56915, 38.47964], [-122.56919, 38.47974], [-122.56935, 38.47988], [-122.56943, 38.47993], [-122.56967, 38.48005], [-122.56979, 38.4802], [-122.5699, 38.4803], [-122.57015, 38.48043], [-122.57043, 38.48071], [-122.5706, 38.48082], [-122.57083, 38.48083], [-122.57109, 38.48077], [-122.57123, 38.48076], [-122.57132, 38.48077], [-122.57148, 38.48076], [-122.57163, 38.48074], [-122.57183, 38.48079], [-122.57194, 38.48087], [-122.57192, 38.48137], [-122.5722, 38.48217]]]} | Open Access 1 | 22086 | Sugarloaf Ridge State Park | 1761 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=481 | Sonoma 16 | 1147.726 | Sugarloaf Ridge SP | 1920 | State Park 15 | 4 |
14452 | 14452 | 14451 | {"type": "Polygon", "coordinates": [[[-122.51122, 38.46753], [-122.51122, 38.46754], [-122.50786, 38.46768], [-122.50783, 38.46616], [-122.50805, 38.46617], [-122.50804, 38.46635], [-122.50829, 38.46668], [-122.5085, 38.46687], [-122.50879, 38.46703], [-122.50919, 38.46716], [-122.51001, 38.46737], [-122.51041, 38.46735], [-122.51064, 38.46739], [-122.51072, 38.46734], [-122.5108, 38.46743], [-122.51122, 38.46753]]]} | Open Access 1 | 47060 | Sugarloaf Ridge State Park | 1761 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=481 | Napa 11 | 3.946 | Sugarloaf Ridge SP | 1920 | State Park 15 | 4 |
16529 | 16529 | 16528 | {"type": "MultiPolygon", "coordinates": [[[[-122.5446, 38.44399], [-122.5446, 38.444], [-122.54375, 38.444], [-122.5446, 38.44399], [-122.5446, 38.44399]]], [[[-122.54373, 38.44399], [-122.54369, 38.444], [-122.54415, 38.45134], [-122.54085, 38.45145], [-122.54078, 38.45142], [-122.53959, 38.45144], [-122.54025, 38.45857], [-122.52597, 38.45883], [-122.52396, 38.45669], [-122.5238, 38.45628], [-122.52436, 38.45532], [-122.52737, 38.45522], [-122.52986, 38.45161], [-122.52978, 38.44934], [-122.53326, 38.44746], [-122.53314, 38.44409], [-122.52088, 38.44421], [-122.51105, 38.44507], [-122.51103, 38.4516], [-122.50915, 38.45185], [-122.50918, 38.45294], [-122.51103, 38.45268], [-122.51102, 38.45981], [-122.51949, 38.45895], [-122.5247, 38.45886], [-122.52477, 38.46261], [-122.52559, 38.4626], [-122.52558, 38.46264], [-122.52559, 38.46294], [-122.52537, 38.46722], [-122.52067, 38.46709], [-122.52064, 38.46764], [-122.51986, 38.46761], [-122.51981, 38.46652], [-122.5153, 38.46671], [-122.51519, 38.46358], [-122.51514, 38.46357], [-122.51517, 38.46317], [-122.51071, 38.46359], [-122.51079, 38.46734], [-122.51025, 38.46745], [-122.50959, 38.46728], [-122.5089, 38.46698], [-122.50817, 38.46621], [-122.50756, 38.46618], [-122.507, 38.4658], [-122.50699, 38.46563], [-122.50682, 38.46568], [-122.50666, 38.46531], [-122.50611, 38.4651], [-122.50594, 38.46496], [-122.50579, 38.46466], [-122.50613, 38.46417], [-122.50686, 38.46413], [-122.50693, 38.46416], [-122.50699, 38.46414], [-122.50698, 38.46411], [-122.50692, 38.46408], [-122.50654, 38.46406], [-122.50653, 38.46392], [-122.50656, 38.45718], [-122.50612, 38.45717], [-122.50479, 38.45702], [-122.50421, 38.45703], [-122.50368, 38.45701], [-122.50306, 38.45632], [-122.5021, 38.45614], [-122.50209, 38.4534], [-122.49716, 38.45331], [-122.49707, 38.45554], [-122.49706, 38.45692], [-122.48278, 38.45695], [-122.48286, 38.45331], [-122.48281, 38.45328], [-122.47827, 38.45342], [-122.47814, 38.44624], [-122.48295, 38.44602], [-122.48301, 38.44104], [-122.48579, 38.44071], [-122.4857, 38.44126], [-122.48499, 38.44141], [-122.48466, 38.44201], [-122.48437, 38.44203], [-122.48432, 38.44232], [-122.48466, 38.44226], [-122.4848, 38.44234], [-122.48483, 38.44232], [-122.48768, 38.44231], [-122.48765, 38.43787], [-122.49227, 38.43787], [-122.4922, 38.43385], [-122.49403, 38.43381], [-122.49409, 38.43384], [-122.50138, 38.43384], [-122.51278, 38.43342], [-122.51279, 38.4334], [-122.52462, 38.43314], [-122.52463, 38.43313], [-122.52442, 38.4295], [-122.52922, 38.42951], [-122.52962, 38.42966], [-122.53364, 38.43129], [-122.53365, 38.43131], [-122.53371, 38.4313], [-122.53405, 38.43147], [-122.53401, 38.44403], [-122.54372, 38.4439], [-122.54373, 38.44399]], [[-122.53944, 38.44865], [-122.53942, 38.44851], [-122.53934, 38.44849], [-122.53926, 38.44772], [-122.53745, 38.44762], [-122.53745, 38.44764], [-122.53695, 38.44763], [-122.53729, 38.44806], [-122.53734, 38.4485], [-122.53777, 38.44893], [-122.53828, 38.4493], [-122.53945, 38.4498], [-122.53972, 38.4498], [-122.53963, 38.44866], [-122.53944, 38.44865]]]]} | Open Access 1 | 1258 | Sugarloaf Ridge State Park | 1761 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=481 | Sonoma 16 | 2909.687 | Sugarloaf Ridge SP | 1920 | State Park 15 | 4 |
16612 | 16612 | 16611 | {"type": "Polygon", "coordinates": [[[-122.53326, 38.44746], [-122.52978, 38.44934], [-122.52986, 38.45161], [-122.52737, 38.45522], [-122.52436, 38.45532], [-122.5238, 38.45628], [-122.52396, 38.45669], [-122.52597, 38.45883], [-122.51949, 38.45895], [-122.51102, 38.45981], [-122.51105, 38.44507], [-122.52088, 38.44421], [-122.53314, 38.44409], [-122.53326, 38.44746]]]} | Open Access 1 | 25862 | Sugarloaf Ridge State Park | 1761 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=481 | Sonoma 16 | 640.189 | Sugarloaf Ridge SP | 1920 | State Park 15 | 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]);