units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, DES_TP = 2, MNG_AGENCY = 87 and YR_EST = 1973
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16839 | 16839 | 16838 | {"type": "MultiPolygon", "coordinates": [[[[-122.34696, 38.00316], [-122.34676, 38.00338], [-122.34652, 38.00353], [-122.34609, 38.00359], [-122.34583, 38.00369], [-122.34568, 38.00396], [-122.34544, 38.00404], [-122.34534, 38.0039], [-122.34534, 38.00367], [-122.34516, 38.00349], [-122.34495, 38.00343], [-122.34462, 38.00376], [-122.34454, 38.00404], [-122.34467, 38.00455], [-122.3448, 38.0049], [-122.34457, 38.00482], [-122.34436, 38.00449], [-122.34405, 38.00392], [-122.34379, 38.00352], [-122.3432, 38.00305], [-122.3432, 38.00298], [-122.34696, 38.00316]]], [[[-122.37548, 37.98802], [-122.37081, 37.99594], [-122.3681, 38.0077], [-122.36808, 38.008], [-122.36802, 38.00833], [-122.36788, 38.00868], [-122.36723, 38.01281], [-122.36617, 38.01363], [-122.3644, 38.01256], [-122.36422, 38.01242], [-122.36414, 38.01214], [-122.36411, 38.01189], [-122.36403, 38.01154], [-122.36393, 38.0113], [-122.36374, 38.01103], [-122.36372, 38.01085], [-122.36374, 38.01061], [-122.36348, 38.01014], [-122.36322, 38.00977], [-122.36281, 38.00939], [-122.3624, 38.00908], [-122.36216, 38.00898], [-122.36221, 38.0089], [-122.3625, 38.0089], [-122.36286, 38.00881], [-122.36298, 38.00865], [-122.36291, 38.00847], [-122.36265, 38.00835], [-122.3618, 38.00827], [-122.36149, 38.00821], [-122.36082, 38.00829], [-122.36041, 38.00827], [-122.36015, 38.00821], [-122.36012, 38.00799], [-122.36025, 38.00785], [-122.36053, 38.00768], [-122.36089, 38.00744], [-122.36092, 38.00727], [-122.36081, 38.00717], [-122.36056, 38.00711], [-122.3602, 38.00695], [-122.35983, 38.00697], [-122.35947, 38.00681], [-122.3595, 38.00667], [-122.35924, 38.00616], [-122.35916, 38.00593], [-122.35916, 38.00569], [-122.35903, 38.00544], [-122.35874, 38.00536], [-122.35849, 38.00541], [-122.35828, 38.00571], [-122.35803, 38.0059], [-122.35761, 38.00602], [-122.35749, 38.00629], [-122.35728, 38.00659], [-122.35692, 38.0068], [-122.35641, 38.00684], [-122.3561, 38.00684], [-122.35582, 38.00694], [-122.35584, 38.00723], [-122.35576, 38.00737], [-122.35559, 38.00733], [-122.35561, 38.007], [-122.35574, 38.0068], [-122.35597, 38.00651], [-122.35627, 38.00627], [-122.35627, 38.00594], [-122.35614, 38.00557], [-122.35588, 38.00537], [-122.35547, 38.00521], [-122.35529, 38.00531], [-122.35529, 38.00574], [-122.35514, 38.00613], [-122.35488, 38.00617], [-122.3546, 38.00631], [-122.35409, 38.00629], [-122.35383, 38.00599], [-122.35362, 38.00581], [-122.35308, 38.00526], [-122.35281, 38.00512], [-122.35269, 38.0052], [-122.35277, 38.00559], [-122.35274, 38.00595], [-122.35275, 38.00624], [-122.35288, 38.00658], [-122.35277, 38.00677], [-122.35252, 38.00683], [-122.35239, 38.00661], [-122.35225, 38.00618], [-122.35177, 38.00618], [-122.35159, 38.0063], [-122.35138, 38.00653], [-122.35133, 38.00692], [-122.35118, 38.00692], [-122.35087, 38.00669], [-122.35061, 38.00629], [-122.35019, 38.0059], [-122.3497, 38.00568], [-122.34826, 38.00533], [-122.34674, 38.0053], [-122.34674, 38.00501], [-122.34681, 38.00473], [-122.34715, 38.00448], [-122.34756, 38.00438], [-122.34792, 38.00434], [-122.34813, 38.00425], [-122.34824, 38.00407], [-122.34797, 38.00399], [-122.34774, 38.00381], [-122.34784, 38.00369], [-122.34807, 38.00358], [-122.3483, 38.00342], [-122.34828, 38.00323], [-122.3514, 38.00338], [-122.3584, 37.99815], [-122.35808, 37.995], [-122.35666, 37.9949], [-122.35736, 37.98888], [-122.37548, 37.98802]]], [[[-122.35673, 37.98877], [-122.35618, 37.9944], [-122.35594, 37.99456], [-122.35582, 37.99388], [-122.35596, 37.99227], [-122.35486, 37.99221], [-122.35486, 37.99204], [-122.35334, 37.98918], [-122.35673, 37.98877]]]]} | Open Access 1 | 18807 | Point Pinole Regional Shoreline | 3305 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/pt_pinole | Contra Costa 12 | 790.41 | Point Pinole Reg. Shoreline | 1973 | Local Park 2 | 4 |
16846 | 16846 | 16845 | {"type": "Polygon", "coordinates": [[[-122.3802, 37.98427], [-122.38018, 37.9843], [-122.38, 37.98779], [-122.37899, 38.01124], [-122.36814, 38.01604], [-122.36813, 38.01606], [-122.36705, 38.01651], [-122.36244, 38.01648], [-122.34305, 38.00892], [-122.34309, 38.00652], [-122.3432, 38.00305], [-122.34379, 38.00351], [-122.34405, 38.00392], [-122.34436, 38.00449], [-122.34457, 38.00481], [-122.34479, 38.00489], [-122.3448, 38.00488], [-122.34467, 38.00455], [-122.34454, 38.00404], [-122.34462, 38.00376], [-122.34495, 38.00343], [-122.34516, 38.00349], [-122.34534, 38.00367], [-122.34534, 38.00389], [-122.34545, 38.00404], [-122.34568, 38.00396], [-122.34583, 38.00369], [-122.34609, 38.00359], [-122.34652, 38.00353], [-122.34676, 38.00338], [-122.34696, 38.00316], [-122.34827, 38.00323], [-122.3483, 38.00342], [-122.34807, 38.00358], [-122.34784, 38.00369], [-122.34774, 38.00381], [-122.34797, 38.00399], [-122.34825, 38.00407], [-122.34813, 38.00425], [-122.34792, 38.00434], [-122.34756, 38.00438], [-122.34715, 38.00448], [-122.34682, 38.00473], [-122.34674, 38.00501], [-122.34674, 38.00529], [-122.34826, 38.00533], [-122.3497, 38.00568], [-122.35019, 38.0059], [-122.35061, 38.00629], [-122.35087, 38.00669], [-122.35118, 38.00692], [-122.35133, 38.00691], [-122.35138, 38.00653], [-122.35159, 38.0063], [-122.35177, 38.00618], [-122.35226, 38.00618], [-122.35239, 38.0066], [-122.35251, 38.00683], [-122.35277, 38.00677], [-122.35287, 38.00658], [-122.35275, 38.00624], [-122.35274, 38.00595], [-122.35277, 38.00559], [-122.35269, 38.0052], [-122.35282, 38.00512], [-122.35308, 38.00526], [-122.35362, 38.00581], [-122.35383, 38.00599], [-122.35409, 38.0063], [-122.3546, 38.00631], [-122.35488, 38.00617], [-122.35514, 38.00613], [-122.35529, 38.00574], [-122.35529, 38.00531], [-122.35547, 38.00521], [-122.35588, 38.00537], [-122.35614, 38.00558], [-122.35627, 38.00594], [-122.35627, 38.00627], [-122.35597, 38.00651], [-122.35574, 38.0068], [-122.35561, 38.007], [-122.35559, 38.00733], [-122.35576, 38.00737], [-122.35584, 38.00723], [-122.35582, 38.00694], [-122.3561, 38.00684], [-122.35641, 38.00684], [-122.35692, 38.00679], [-122.35728, 38.00659], [-122.35749, 38.00629], [-122.35761, 38.00602], [-122.35803, 38.0059], [-122.35828, 38.00571], [-122.35849, 38.00541], [-122.35874, 38.00536], [-122.35903, 38.00544], [-122.35916, 38.00569], [-122.35916, 38.00593], [-122.35924, 38.00616], [-122.3595, 38.00667], [-122.35948, 38.00681], [-122.35983, 38.00697], [-122.36019, 38.00695], [-122.36056, 38.00711], [-122.36081, 38.00717], [-122.36092, 38.00727], [-122.36089, 38.00744], [-122.36053, 38.00768], [-122.36025, 38.00785], [-122.36013, 38.00799], [-122.36015, 38.00821], [-122.36041, 38.00827], [-122.36082, 38.00829], [-122.36149, 38.00821], [-122.3618, 38.00827], [-122.36265, 38.00835], [-122.36291, 38.00847], [-122.36298, 38.00865], [-122.36286, 38.00882], [-122.3625, 38.0089], [-122.36222, 38.0089], [-122.36217, 38.00898], [-122.3624, 38.00908], [-122.36281, 38.00939], [-122.36322, 38.00977], [-122.36348, 38.01014], [-122.36374, 38.01061], [-122.36372, 38.01085], [-122.36374, 38.01103], [-122.36393, 38.0113], [-122.36403, 38.01154], [-122.36411, 38.01189], [-122.36414, 38.01214], [-122.36421, 38.01242], [-122.3644, 38.01256], [-122.36618, 38.01363], [-122.36723, 38.0128], [-122.36788, 38.00868], [-122.36802, 38.00833], [-122.36808, 38.008], [-122.3681, 38.0077], [-122.37081, 37.99594], [-122.37547, 37.98803], [-122.35736, 37.98888], [-122.35741, 37.98844], [-122.35748, 37.98816], [-122.36111, 37.98801], [-122.36254, 37.9879], [-122.36294, 37.9865], [-122.36416, 37.98461], [-122.36415, 37.98434], [-122.3802, 37.98427]]]} | Open Access 1 | 29400 | Point Pinole Regional Shoreline | 3305 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/pt_pinole | Contra Costa 12 | 1125.298 | Point Pinole Reg. Shoreline | 1973 | 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]);