units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where COUNTY = 4, MNG_AGENCY = 47 and YR_EST = 1949
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, PARK_URL, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8098 | 8098 | 8097 | {"type": "MultiPolygon", "coordinates": [[[[-117.28072, 33.01369], [-117.2807, 33.01369], [-117.28063, 33.01356], [-117.28072, 33.01369], [-117.28072, 33.01369]]], [[[-117.28063, 33.01356], [-117.28045, 33.01326], [-117.28026, 33.01287], [-117.28008, 33.01244], [-117.27991, 33.01197], [-117.27956, 33.01203], [-117.27926, 33.01079], [-117.27908, 33.01002], [-117.27893, 33.00928], [-117.27874, 33.00818], [-117.27846, 33.00623], [-117.27838, 33.00492], [-117.27806, 33.0039], [-117.27784, 33.00333], [-117.27751, 33.00264], [-117.27729, 33.00228], [-117.27657, 33.00125], [-117.27671, 33.00128], [-117.27704, 33.00097], [-117.27745, 33.00082], [-117.2777, 33.00067], [-117.27798, 33.00055], [-117.27817, 33.00055], [-117.2781, 33.00006], [-117.27798, 33.00005], [-117.27798, 33.00001], [-117.2778, 32.99993], [-117.27767, 32.99954], [-117.27738, 32.99917], [-117.2774, 32.99916], [-117.27784, 32.99911], [-117.27799, 32.99932], [-117.27817, 32.99965], [-117.2783, 32.99995], [-117.27839, 33.00025], [-117.27846, 33.00067], [-117.27848, 33.00173], [-117.27849, 33.00175], [-117.27851, 33.00234], [-117.27855, 33.00446], [-117.27861, 33.00551], [-117.27867, 33.006], [-117.27882, 33.00684], [-117.27909, 33.00803], [-117.27933, 33.00876], [-117.27993, 33.01114], [-117.28063, 33.01356]]], [[[-117.28192, 33.01539], [-117.28192, 33.01545], [-117.28187, 33.01556], [-117.28179, 33.01567], [-117.28138, 33.0157], [-117.2813, 33.01547], [-117.28049, 33.01418], [-117.28033, 33.01395], [-117.28016, 33.01376], [-117.28076, 33.01375], [-117.28192, 33.01539]]]]} | Open Access 1 | 12170 | Cardiff State Beach | 1461 | 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/default.asp?page_id=656 | San Diego 4 | 23.131 | Cardiff SB | 1949 | State Park 15 | 4 |
8347 | 8347 | 8346 | {"type": "MultiPolygon", "coordinates": [[[[-117.30949, 33.07645], [-117.30906, 33.07644], [-117.30901, 33.0763], [-117.30937, 33.07619], [-117.30949, 33.07645]]], [[[-117.31306, 33.0869], [-117.31259, 33.08702], [-117.31202, 33.08552], [-117.31186, 33.08522], [-117.31168, 33.08496], [-117.31141, 33.08466], [-117.31004, 33.08339], [-117.30942, 33.08286], [-117.30979, 33.08247], [-117.31009, 33.08239], [-117.3103, 33.0823], [-117.3105, 33.08229], [-117.3109, 33.08238], [-117.31107, 33.08245], [-117.31125, 33.0826], [-117.31161, 33.08247], [-117.31163, 33.08195], [-117.31193, 33.08194], [-117.31186, 33.08282], [-117.31306, 33.0869]]], [[[-117.334, 33.12842], [-117.33311, 33.12887], [-117.33086, 33.12566], [-117.32925, 33.12395], [-117.3289, 33.12345], [-117.32878, 33.12323], [-117.32867, 33.12327], [-117.32824, 33.12303], [-117.32759, 33.12179], [-117.3274, 33.12126], [-117.32724, 33.12067], [-117.3269, 33.11982], [-117.327, 33.11979], [-117.32701, 33.11977], [-117.32694, 33.11962], [-117.32682, 33.11965], [-117.32546, 33.11637], [-117.32519, 33.11564], [-117.32475, 33.1147], [-117.32459, 33.1144], [-117.3237, 33.11288], [-117.32273, 33.11199], [-117.32028, 33.10596], [-117.3193, 33.10344], [-117.31719, 33.09833], [-117.31575, 33.09511], [-117.31524, 33.09404], [-117.31291, 33.08829], [-117.3135, 33.08802], [-117.31402, 33.08952], [-117.31415, 33.08983], [-117.31442, 33.09034], [-117.31467, 33.09088], [-117.31521, 33.09214], [-117.31594, 33.09368], [-117.31699, 33.09615], [-117.31736, 33.09698], [-117.31829, 33.09875], [-117.31867, 33.0996], [-117.31903, 33.10036], [-117.31937, 33.10131], [-117.31995, 33.10275], [-117.32081, 33.10475], [-117.3221, 33.10788], [-117.32265, 33.10937], [-117.32288, 33.10989], [-117.32316, 33.11041], [-117.3234, 33.11089], [-117.32369, 33.11151], [-117.32389, 33.11198], [-117.32498, 33.11505], [-117.3254, 33.11605], [-117.32564, 33.11655], [-117.3279, 33.12066], [-117.32803, 33.12066], [-117.32893, 33.12229], [-117.3291, 33.12265], [-117.32959, 33.12357], [-117.32972, 33.12377], [-117.33025, 33.12446], [-117.33082, 33.12505], [-117.33114, 33.12515], [-117.33139, 33.12538], [-117.33263, 33.12684], [-117.33394, 33.12836], [-117.334, 33.12842]]], [[[-117.33126, 33.1309], [-117.33063, 33.13121], [-117.32643, 33.12292], [-117.32652, 33.12293], [-117.32683, 33.12311], [-117.3273, 33.12345], [-117.32768, 33.12357], [-117.3277, 33.12377], [-117.32765, 33.1242], [-117.32847, 33.12498], [-117.3288, 33.1252], [-117.32918, 33.12537], [-117.32941, 33.12544], [-117.33003, 33.12559], [-117.33033, 33.12569], [-117.33067, 33.12592], [-117.33096, 33.12634], [-117.32917, 33.12724], [-117.33004, 33.12859], [-117.33126, 33.1309]]], [[[-117.32945, 33.1245], [-117.32941, 33.12451], [-117.32858, 33.12388], [-117.32862, 33.12374], [-117.32871, 33.12358], [-117.32901, 33.12401], [-117.32945, 33.1245]]]]} | Open Access 1 | 12899 | South Carlsbad State Beach | 1752 | 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=660 | San Diego 4 | 117.377 | South Carlsbad SB | 1949 | State Park 15 | 4 |
11340 | 11340 | 11339 | {"type": "Polygon", "coordinates": [[[-117.29351, 33.0127], [-117.28215, 33.01572], [-117.28063, 33.01356], [-117.27993, 33.01114], [-117.2788, 33.00672], [-117.27857, 33.00476], [-117.27851, 33.00234], [-117.27849, 33.00175], [-117.27848, 33.00174], [-117.27846, 33.00067], [-117.27843, 33.00048], [-117.27835, 33.00009], [-117.27817, 32.99964], [-117.27799, 32.99932], [-117.27783, 32.9991], [-117.2793, 32.99887], [-117.27931, 32.9989], [-117.28762, 32.99758], [-117.29351, 33.0127]]]} | Open Access 1 | 28052 | Cardiff State Beach | 1461 | 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/default.asp?page_id=656 | San Diego 4 | 485.781 | Cardiff SB | 1949 | 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]);