units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, COUNTY = 11 and DES_TP = 15
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 3 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 16523 | 16523 | 16522 | {"type": "MultiPolygon", "coordinates": [[[[-122.57677, 38.60348], [-122.56738, 38.60361], [-122.56739, 38.60719], [-122.56655, 38.60718], [-122.5627, 38.60724], [-122.56112, 38.60719], [-122.55798, 38.60729], [-122.55794, 38.60578], [-122.55793, 38.60287], [-122.55786, 38.60055], [-122.55783, 38.59852], [-122.55785, 38.59662], [-122.55784, 38.59636], [-122.5578, 38.59307], [-122.56249, 38.593], [-122.56249, 38.59162], [-122.56798, 38.59158], [-122.56806, 38.59507], [-122.57657, 38.59504], [-122.57654, 38.59602], [-122.57676, 38.60263], [-122.57677, 38.60348]]], [[[-122.59056, 38.66017], [-122.59056, 38.6575], [-122.58386, 38.65697], [-122.58386, 38.65616], [-122.57943, 38.65593], [-122.5795, 38.64979], [-122.57728, 38.64861], [-122.57727, 38.64841], [-122.575, 38.6471], [-122.57492, 38.64323], [-122.57486, 38.64131], [-122.57247, 38.64042], [-122.57245, 38.63948], [-122.56921, 38.63821], [-122.5675, 38.63578], [-122.56772, 38.63576], [-122.56715, 38.63492], [-122.56709, 38.63476], [-122.56386, 38.63178], [-122.56181, 38.6298], [-122.56046, 38.62857], [-122.55926, 38.62909], [-122.55559, 38.62524], [-122.55358, 38.62529], [-122.55304, 38.62529], [-122.55134, 38.62683], [-122.54904, 38.62816], [-122.54906, 38.62901], [-122.54448, 38.62912], [-122.5444, 38.62378], [-122.54431, 38.62189], [-122.5535, 38.62169], [-122.55351, 38.62107], [-122.55339, 38.6145], [-122.55805, 38.61443], [-122.55813, 38.62155], [-122.56285, 38.62144], [-122.5629, 38.62505], [-122.5676, 38.62492], [-122.56767, 38.62854], [-122.57713, 38.63555], [-122.57717, 38.63883], [-122.57941, 38.63885], [-122.58189, 38.64072], [-122.58246, 38.64129], [-122.5825, 38.64179], [-122.58246, 38.64293], [-122.58269, 38.64356], [-122.58161, 38.64497], [-122.58604, 38.64533], [-122.58603, 38.64582], [-122.58604, 38.64928], [-122.59221, 38.64974], [-122.59239, 38.65155], [-122.59455, 38.65184], [-122.59699, 38.64999], [-122.59699, 38.6493], [-122.59737, 38.64956], [-122.59776, 38.64971], [-122.59798, 38.64985], [-122.59822, 38.65004], [-122.59828, 38.65029], [-122.59845, 38.65054], [-122.59864, 38.65068], [-122.59881, 38.65085], [-122.59901, 38.65093], [-122.59927, 38.65093], [-122.59943, 38.65101], [-122.59954, 38.65115], [-122.59966, 38.65155], [-122.59974, 38.6517], [-122.59981, 38.6522], [-122.59977, 38.65267], [-122.59975, 38.65285], [-122.59962, 38.65328], [-122.5995, 38.65357], [-122.59933, 38.65382], [-122.59889, 38.65463], [-122.59872, 38.65486], [-122.59858, 38.65494], [-122.59843, 38.65498], [-122.59829, 38.655], [-122.59795, 38.65497], [-122.59753, 38.65488], [-122.59723, 38.65489], [-122.59712, 38.65494], [-122.59686, 38.65521], [-122.59676, 38.65524], [-122.59636, 38.65529], [-122.59616, 38.65528], [-122.59597, 38.65525], [-122.5957, 38.65528], [-122.59554, 38.65531], [-122.59539, 38.65539], [-122.59531, 38.65545], [-122.5952, 38.65561], [-122.59504, 38.65621], [-122.59502, 38.65663], [-122.59505, 38.65689], [-122.59505, 38.65707], [-122.59489, 38.65742], [-122.5947, 38.65776], [-122.59475, 38.65824], [-122.59486, 38.6586], [-122.59484, 38.65894], [-122.59479, 38.65916], [-122.59471, 38.65938], [-122.59473, 38.6598], [-122.59478, 38.66003], [-122.59504, 38.66055], [-122.59513, 38.66068], [-122.59531, 38.66085], [-122.59555, 38.66097], [-122.59573, 38.66104], [-122.59604, 38.66108], [-122.59627, 38.66109], [-122.59638, 38.66106], [-122.59654, 38.66095], [-122.59713, 38.66034], [-122.59731, 38.66023], [-122.59741, 38.66019], [-122.59764, 38.66019], [-122.59772, 38.66021], [-122.59797, 38.66038], [-122.59806, 38.6605], [-122.59817, 38.66092], [-122.59825, 38.66102], [-122.59845, 38.66113], [-122.59878, 38.6612], [-122.59885, 38.66124], [-122.59891, 38.6613], [-122.59892, 38.66142], [-122.59885, 38.66152], [-122.59867, 38.66162], [-122.59756, 38.6619], [-122.59687, 38.6621], [-122.59669, 38.66219], [-122.59663, 38.66232], [-122.59663, 38.66243], [-122.59667, 38.6625], [-122.59679, 38.66258], [-122.59691, 38.66262], [-122.59716, 38.6626], [-122.59828, 38.66236], [-122.59849, 38.66241], [-122.59887, 38.6626], [-122.59882, 38.66273], [-122.5952, 38.66285], [-122.59064, 38.66279], [-122.59056, 38.66017]], [[-122.57718, 38.64069], [-122.57688, 38.64068], [-122.57668, 38.64104], [-122.57718, 38.64104], [-122.57718, 38.64069]]], [[[-122.62751, 38.64498], [-122.62753, 38.64559], [-122.6272, 38.64642], [-122.62677, 38.64761], [-122.62662, 38.64796], [-122.6263, 38.64833], [-122.62586, 38.64877], [-122.62527, 38.64917], [-122.62527, 38.64893], [-122.62525, 38.64892], [-122.62495, 38.64913], [-122.6245, 38.64952], [-122.62412, 38.64992], [-122.624, 38.65014], [-122.62391, 38.65035], [-122.62375, 38.65082], [-122.62346, 38.65205], [-122.62325, 38.65264], [-122.62316, 38.65305], [-122.62314, 38.65341], [-122.62321, 38.65377], [-122.62324, 38.65417], [-122.62328, 38.65439], [-122.62339, 38.65466], [-122.62359, 38.65502], [-122.62385, 38.65519], [-122.62371, 38.65642], [-122.62394, 38.65685], [-122.62395, 38.65694], [-122.62412, 38.65737], [-122.62369, 38.65831], [-122.62363, 38.65861], [-122.62372, 38.65936], [-122.62283, 38.66194], [-122.62305, 38.6625], [-122.6233, 38.66302], [-122.62325, 38.66302], [-122.62325, 38.66304], [-122.62376, 38.66352], [-122.62428, 38.66447], [-122.62512, 38.66534], [-122.62664, 38.66611], [-122.62716, 38.66631], [-122.62277, 38.66646], [-122.6227, 38.66874], [-122.6044, 38.67308], [-122.60447, 38.66991], [-122.60467, 38.66269], [-122.6019, 38.66263], [-122.59932, 38.66272], [-122.59931, 38.66257], [-122.5992, 38.66242], [-122.59908, 38.66233], [-122.59886, 38.66222], [-122.5987, 38.66218], [-122.59855, 38.66215], [-122.59821, 38.66215], [-122.59799, 38.66218], [-122.5976, 38.66228], [-122.59752, 38.66229], [-122.59746, 38.66226], [-122.59747, 38.6622], [-122.59751, 38.66215], [-122.59878, 38.66183], [-122.59899, 38.66177], [-122.59909, 38.6617], [-122.59929, 38.66148], [-122.59938, 38.66134], [-122.59941, 38.66128], [-122.59942, 38.66122], [-122.59938, 38.66116], [-122.59886, 38.66101], [-122.5987, 38.66099], [-122.59853, 38.66089], [-122.59845, 38.66083], [-122.59838, 38.66059], [-122.59832, 38.66046], [-122.59818, 38.6603], [-122.59799, 38.66014], [-122.59781, 38.66004], [-122.59752, 38.66], [-122.59728, 38.66004], [-122.59713, 38.66013], [-122.5969, 38.66028], [-122.59676, 38.66041], [-122.59646, 38.66073], [-122.59628, 38.66086], [-122.59577, 38.66087], [-122.59552, 38.66076], [-122.59536, 38.6606], [-122.59524, 38.66044], [-122.59506, 38.6601], [-122.59497, 38.65987], [-122.59494, 38.65953], [-122.59508, 38.65888], [-122.59509, 38.65871], [-122.59507, 38.65857], [-122.59493, 38.65806], [-122.59491, 38.65793], [-122.59492, 38.6578], [-122.59495, 38.65771], [-122.5951, 38.65749], [-122.59517, 38.65733], [-122.59524, 38.65715], [-122.59526, 38.657], [-122.59525, 38.65635], [-122.59533, 38.65585], [-122.59541, 38.65565], [-122.59552, 38.65555], [-122.59567, 38.65548], [-122.59596, 38.65545], [-122.59639, 38.65545], [-122.59673, 38.65542], [-122.59688, 38.65537], [-122.59701, 38.6553], [-122.59712, 38.65519], [-122.59724, 38.65514], [-122.59737, 38.6551], [-122.59839, 38.6552], [-122.59859, 38.65515], [-122.59875, 38.65506], [-122.59903, 38.65483], [-122.59986, 38.65339], [-122.59996, 38.65313], [-122.59999, 38.65283], [-122.60006, 38.65252], [-122.60008, 38.6522], [-122.60003, 38.65186], [-122.59997, 38.65155], [-122.59988, 38.65121], [-122.59978, 38.65102], [-122.59965, 38.65087], [-122.59925, 38.65071], [-122.59904, 38.65083], [-122.59898, 38.65084], [-122.59873, 38.65051], [-122.59853, 38.65039], [-122.59835, 38.64985], [-122.59755, 38.6493], [-122.59718, 38.64901], [-122.59692, 38.64883], [-122.59697, 38.64747], [-122.59707, 38.64634], [-122.60075, 38.64631], [-122.60064, 38.64457], [-122.60404, 38.64454], [-122.60406, 38.64272], [-122.61332, 38.64278], [-122.6133, 38.63554], [-122.61577, 38.63551], [-122.61697, 38.63645], [-122.62751, 38.64498]], [[-122.61279, 38.65695], [-122.6128, 38.65696], [-122.61776, 38.65709], [-122.61786, 38.65361], [-122.61309, 38.65349], [-122.61279, 38.65695]]]]} | Open Access 1 | 214 | Robert Louis Stevenson State Park | 1712 | 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=472 | Napa 11 | 3420.129 | Robert Louis Stevenson SP | 1949 | State Park 15 | 4 |
| 16530 | 16530 | 16529 | {"type": "MultiPolygon", "coordinates": [[[[-122.50861, 38.54191], [-122.50773, 38.54206], [-122.50754, 38.54111], [-122.50843, 38.54101], [-122.50861, 38.54191]]], [[[-122.57127, 38.53514], [-122.57127, 38.53518], [-122.56449, 38.53511], [-122.56457, 38.53863], [-122.56428, 38.54219], [-122.55966, 38.54216], [-122.55976, 38.54093], [-122.55963, 38.54215], [-122.55047, 38.54186], [-122.55018, 38.54545], [-122.54591, 38.54531], [-122.54565, 38.54892], [-122.54568, 38.5501], [-122.54074, 38.54876], [-122.53631, 38.54875], [-122.5319, 38.54871], [-122.53179, 38.55234], [-122.53009, 38.55233], [-122.52904, 38.55231], [-122.52854, 38.55228], [-122.5271, 38.55228], [-122.52627, 38.55226], [-122.52575, 38.55331], [-122.52521, 38.5532], [-122.52466, 38.55313], [-122.52386, 38.55309], [-122.52372, 38.55295], [-122.52361, 38.55311], [-122.5231, 38.55313], [-122.52223, 38.55308], [-122.52216, 38.55288], [-122.52183, 38.55305], [-122.5214, 38.55297], [-122.52104, 38.55287], [-122.52101, 38.55289], [-122.51997, 38.5525], [-122.5169, 38.55158], [-122.51647, 38.55141], [-122.51628, 38.55131], [-122.51588, 38.55107], [-122.51536, 38.55068], [-122.51307, 38.54906], [-122.51213, 38.54833], [-122.514, 38.54701], [-122.51307, 38.54638], [-122.51213, 38.54708], [-122.51194, 38.54698], [-122.51112, 38.54759], [-122.51081, 38.54726], [-122.51059, 38.54697], [-122.51368, 38.54555], [-122.51377, 38.54295], [-122.51375, 38.54147], [-122.51301, 38.54141], [-122.51222, 38.54146], [-122.51149, 38.54147], [-122.51085, 38.54168], [-122.50994, 38.54164], [-122.50973, 38.54191], [-122.50914, 38.5424], [-122.50904, 38.54242], [-122.50894, 38.54153], [-122.50959, 38.54147], [-122.5096, 38.54146], [-122.50951, 38.54126], [-122.50988, 38.54123], [-122.50989, 38.54122], [-122.50983, 38.54111], [-122.50948, 38.54101], [-122.50918, 38.54103], [-122.5088, 38.54108], [-122.50874, 38.54096], [-122.50913, 38.54096], [-122.50949, 38.54095], [-122.50975, 38.541], [-122.50999, 38.54101], [-122.51015, 38.54037], [-122.51016, 38.54022], [-122.51011, 38.54019], [-122.51057, 38.53988], [-122.5111, 38.53963], [-122.51093, 38.53933], [-122.51045, 38.53908], [-122.5101, 38.53883], [-122.50814, 38.53926], [-122.50798, 38.53888], [-122.5075, 38.53758], [-122.50738, 38.53731], [-122.50725, 38.53697], [-122.50751, 38.537], [-122.50766, 38.53709], [-122.50812, 38.53716], [-122.50862, 38.53717], [-122.50868, 38.53719], [-122.50938, 38.53766], [-122.50995, 38.53757], [-122.51021, 38.53745], [-122.51082, 38.53713], [-122.51048, 38.53664], [-122.51219, 38.53636], [-122.51262, 38.53678], [-122.51271, 38.53692], [-122.51327, 38.53646], [-122.51305, 38.53616], [-122.51417, 38.53539], [-122.5146, 38.53485], [-122.51557, 38.53426], [-122.51556, 38.53345], [-122.51664, 38.53343], [-122.51657, 38.53135], [-122.50938, 38.53138], [-122.50937, 38.53097], [-122.51733, 38.53094], [-122.51734, 38.53126], [-122.52056, 38.53126], [-122.52064, 38.5306], [-122.52313, 38.53053], [-122.52314, 38.5309], [-122.53402, 38.53088], [-122.53405, 38.529], [-122.54146, 38.52939], [-122.54148, 38.53441], [-122.53154, 38.5344], [-122.53153, 38.53415], [-122.52797, 38.53418], [-122.52796, 38.53439], [-122.52458, 38.5344], [-122.52452, 38.53455], [-122.5231, 38.53455], [-122.52309, 38.53466], [-122.5225, 38.5348], [-122.52197, 38.53556], [-122.52204, 38.53601], [-122.52232, 38.53633], [-122.52291, 38.53751], [-122.52265, 38.5377], [-122.52266, 38.53792], [-122.52305, 38.53792], [-122.52304, 38.54144], [-122.53214, 38.54152], [-122.53228, 38.53793], [-122.54152, 38.53795], [-122.54148, 38.53853], [-122.54149, 38.53854], [-122.55519, 38.53847], [-122.55517, 38.53502], [-122.55988, 38.53499], [-122.5598, 38.5315], [-122.55983, 38.53139], [-122.56441, 38.53156], [-122.56434, 38.52802], [-122.56654, 38.52804], [-122.56654, 38.52807], [-122.5666, 38.52827], [-122.56675, 38.52842], [-122.56695, 38.52851], [-122.56756, 38.52852], [-122.56826, 38.52863], [-122.56872, 38.52877], [-122.56905, 38.52902], [-122.56927, 38.52935], [-122.5696, 38.52958], [-122.56996, 38.53003], [-122.56996, 38.53111], [-122.57012, 38.53163], [-122.57014, 38.53214], [-122.56992, 38.53244], [-122.56974, 38.53273], [-122.56976, 38.53299], [-122.57004, 38.53329], [-122.57019, 38.53338], [-122.5706, 38.53352], [-122.57076, 38.53365], [-122.57084, 38.53477], [-122.57108, 38.53501], [-122.57127, 38.53514]]]]} | Open Access 1 | 1853 | Bothe-Napa Valley State Park | 1446 | 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=477 | Napa 11 | 1688.482 | Bothe-Napa Valley SP | 1960 | 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]);