units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where COUNTY = 12, DES_TP = 2, LAYER = 5 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3271 | 3271 | 3270 | {"type": "Polygon", "coordinates": [[[-121.96963, 38.04434], [-121.96963, 38.04843], [-121.96528, 38.04832], [-121.96268, 38.04843], [-121.96269, 38.04202], [-121.9663, 38.04288], [-121.96623, 38.04318], [-121.96849, 38.0443], [-121.96963, 38.04434]]]} | Open Access 1 | 29409 | Bay Point Regional Shoreline | 32664 | 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 | https://www.ebparks.org/parks/bay_point/default.htm | Contra Costa 12 | 86.981 | Bay Point Reg. Shoreline | 1996 | Local Park 2 | 4 |
3621 | 3621 | 3620 | {"type": "Polygon", "coordinates": [[[-122.13468, 38.02843], [-122.13427, 38.02977], [-122.13074, 38.03157], [-122.13026, 38.02906], [-122.13025, 38.02905], [-122.12946, 38.02945], [-122.12902, 38.02716], [-122.12945, 38.02692], [-122.13129, 38.02602], [-122.13153, 38.02637], [-122.13293, 38.02824], [-122.13468, 38.02843]]]} | Open Access 1 | 29404 | Martinez Regional Shoreline | 21926 | 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 | Contra Costa 12 | 38.97 | Martinez Reg. Shoreline | 1979 | Local Park 2 | 4 | |
12258 | 12258 | 12257 | {"type": "Polygon", "coordinates": [[[-122.29218, 38.01568], [-122.29031, 38.01802], [-122.28912, 38.01718], [-122.28922, 38.01688], [-122.28938, 38.0167], [-122.28977, 38.01698], [-122.29009, 38.01702], [-122.29019, 38.01671], [-122.2906, 38.0165], [-122.2905, 38.01637], [-122.29193, 38.01586], [-122.29218, 38.01568]]]} | Open Access 1 | 25796 | San Pablo Bay Regional Shoreline | 24965 | 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 | Contra Costa 12 | 5.337 | San Pablo Bay Reg. Shoreline | 0 | Local Park 2 | 4 | |
14016 | 14016 | 14015 | {"type": "Polygon", "coordinates": [[[-122.24273, 38.04095], [-122.24052, 38.04205], [-122.23951, 38.04221], [-122.2386, 38.04314], [-122.23869, 38.0438], [-122.23841, 38.0441], [-122.23718, 38.04447], [-122.23672, 38.0448], [-122.23549, 38.04464], [-122.23425, 38.04336], [-122.23416, 38.04336], [-122.23416, 38.03632], [-122.23583, 38.03721], [-122.2362, 38.03709], [-122.23681, 38.03857], [-122.23851, 38.03866], [-122.23956, 38.03929], [-122.24273, 38.04095]]]} | No Public Access 3 | 46991 | Crockett Hills Regional Park | 17828 | 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 | Contra Costa 12 | 91.433 | Crockett Hills RP | 2006 | Local Park 2 | 4 | |
14840 | 14840 | 14839 | {"type": "Polygon", "coordinates": [[[-122.29906, 38.01601], [-122.2989, 38.01618], [-122.29856, 38.0164], [-122.29806, 38.01657], [-122.29759, 38.01661], [-122.29719, 38.01659], [-122.29698, 38.01653], [-122.29624, 38.01624], [-122.29604, 38.01624], [-122.29585, 38.01631], [-122.29558, 38.01677], [-122.29522, 38.01711], [-122.29479, 38.01739], [-122.29463, 38.0176], [-122.29443, 38.01801], [-122.29424, 38.01817], [-122.29281, 38.01923], [-122.29062, 38.01816], [-122.29249, 38.0158], [-122.29332, 38.01483], [-122.2936, 38.01454], [-122.2931, 38.01518], [-122.2931, 38.01523], [-122.29767, 38.01516], [-122.29906, 38.01601]]]} | No Public Access 3 | 45329 | San Pablo Bay Regional Shoreline | 24967 | 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 | Contra Costa 12 | 38.47 | San Pablo Bay Reg. Shoreline | 1976 | Local Park 2 | 4 | |
16836 | 16836 | 16835 | {"type": "Polygon", "coordinates": [[[-121.88013, 38.03876], [-121.8799, 38.03947], [-121.87888, 38.03985], [-121.87938, 38.04057], [-121.87831, 38.04152], [-121.87674, 38.04095], [-121.8754, 38.04202], [-121.87585, 38.04277], [-121.87563, 38.04308], [-121.87538, 38.04357], [-121.87321, 38.04374], [-121.87163, 38.04436], [-121.86986, 38.04524], [-121.86868, 38.04556], [-121.86677, 38.04663], [-121.86586, 38.04647], [-121.86463, 38.04548], [-121.86456, 38.04549], [-121.86457, 38.04022], [-121.869, 38.04023], [-121.86901, 38.03651], [-121.86606, 38.03563], [-121.85991, 38.03561], [-121.85989, 38.04021], [-121.8644, 38.04022], [-121.86438, 38.04552], [-121.8629, 38.0458], [-121.86169, 38.04609], [-121.86089, 38.04681], [-121.86099, 38.04761], [-121.86205, 38.04829], [-121.86179, 38.04832], [-121.86114, 38.04802], [-121.86065, 38.04767], [-121.86064, 38.04741], [-121.86029, 38.04715], [-121.85877, 38.04615], [-121.85643, 38.04435], [-121.85513, 38.04328], [-121.85323, 38.04205], [-121.85256, 38.04052], [-121.85138, 38.03899], [-121.85147, 38.03731], [-121.85092, 38.03582], [-121.85024, 38.03499], [-121.85207, 38.03389], [-121.85368, 38.03368], [-121.85526, 38.03272], [-121.85876, 38.03221], [-121.8607, 38.03229], [-121.86306, 38.03258], [-121.86702, 38.03277], [-121.86921, 38.03335], [-121.87099, 38.03432], [-121.87408, 38.03568], [-121.87734, 38.03749], [-121.87896, 38.03836], [-121.88013, 38.03876]]]} | Restricted Access 2 | 3883 | Browns Island Regional Shoreline | 16445 | 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 | Contra Costa 12 | 600.69 | Browns Island Reg. Shoreline | 0 | 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 |
16851 | 16851 | 16850 | {"type": "Polygon", "coordinates": [[[-122.30221, 38.01043], [-122.30218, 38.01147], [-122.29662, 38.01164], [-122.29722, 38.01107], [-122.29759, 38.01082], [-122.29803, 38.0106], [-122.29837, 38.01048], [-122.29871, 38.01038], [-122.29928, 38.01029], [-122.29965, 38.01027], [-122.30075, 38.0103], [-122.30221, 38.01038], [-122.30221, 38.01043]]]} | Open Access 1 | 29547 | San Pablo Bay Regional Shoreline | 24965 | 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 | Contra Costa 12 | 13.84 | San Pablo Bay Reg. Shoreline | 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]);