units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where AGNCY_NAME = 43 and PARK_URL = "http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches"
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME
MNG_AG_TYP 1
MNG_AGENCY 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219 | 219 | 218 | {"type": "Polygon", "coordinates": [[[-117.29114, 33.03378], [-117.29094, 33.03383], [-117.29088, 33.0337], [-117.29105, 33.03363], [-117.29114, 33.03378]]]} | Open Access 1 | 708 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.079 | Swami's Bluff Parcels | None 23 | ||
255 | 255 | 254 | {"type": "Polygon", "coordinates": [[[-117.29084, 33.0333], [-117.2907, 33.03336], [-117.29031, 33.03261], [-117.29033, 33.03255], [-117.29053, 33.03288], [-117.29071, 33.03315], [-117.29084, 33.0333]]]} | Open Access 1 | 709 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.184 | Swami's Bluff Parcels | None 27 | ||
2174 | 2174 | 2173 | {"type": "Polygon", "coordinates": [[[-117.30158, 33.05598], [-117.30134, 33.05605], [-117.30127, 33.05586], [-117.30122, 33.05575], [-117.30097, 33.05535], [-117.30078, 33.05482], [-117.30076, 33.05468], [-117.30103, 33.05461], [-117.30138, 33.05554], [-117.30158, 33.05598]]]} | Open Access 1 | 16270 | Stone Steps Beach | 25877 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 1.07 | Stone Steps Beach | 0 | Local Park 2 | 4 |
6149 | 6149 | 6148 | {"type": "Polygon", "coordinates": [[[-117.31046, 33.07653], [-117.30964, 33.07651], [-117.30962, 33.07645], [-117.31043, 33.07647], [-117.31046, 33.07653]]]} | Open Access 1 | 1160 | Grandview | 19428 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.131 | Grandview | None 495 | ||
7949 | 7949 | 7948 | {"type": "Polygon", "coordinates": [[[-117.29603, 33.03791], [-117.29483, 33.03802], [-117.29481, 33.0378], [-117.29594, 33.0377], [-117.29603, 33.03791]]]} | Open Access 1 | 12338 | J Street Viewpoint | 20290 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.676 | J Street Viewpoint | None 661 | ||
8136 | 8136 | 8135 | {"type": "Polygon", "coordinates": [[[-117.2968, 33.04049], [-117.29618, 33.04056], [-117.29616, 33.04042], [-117.29669, 33.04039], [-117.2968, 33.04049]]]} | Open Access 1 | 12319 | H Street Viewpoint | 19582 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.181 | H Street Viewpoint | None 678 | ||
8140 | 8140 | 8139 | {"type": "Polygon", "coordinates": [[[-117.29635, 33.03919], [-117.2957, 33.03926], [-117.29568, 33.03904], [-117.29629, 33.03898], [-117.29635, 33.03919]]]} | Open Access 1 | 12335 | I Street Viewpoint | 20169 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.357 | I Street Viewpoint | None 679 | ||
8281 | 8281 | 8280 | {"type": "Polygon", "coordinates": [[[-117.29747, 33.04483], [-117.29745, 33.04483], [-117.29732, 33.04423], [-117.29724, 33.04395], [-117.29724, 33.04372], [-117.29715, 33.04331], [-117.29707, 33.04312], [-117.29708, 33.0429], [-117.29704, 33.04258], [-117.29695, 33.04237], [-117.2969, 33.04217], [-117.29686, 33.04195], [-117.29686, 33.04186], [-117.29681, 33.0416], [-117.29663, 33.0408], [-117.29663, 33.04067], [-117.29658, 33.04052], [-117.29678, 33.04049], [-117.29678, 33.04048], [-117.29669, 33.04039], [-117.29652, 33.0404], [-117.2965, 33.04035], [-117.2965, 33.0402], [-117.29646, 33.03997], [-117.29646, 33.03974], [-117.29636, 33.03948], [-117.29629, 33.03938], [-117.29625, 33.0392], [-117.29635, 33.03919], [-117.29629, 33.03898], [-117.29631, 33.0389], [-117.29616, 33.0387], [-117.29608, 33.03852], [-117.29601, 33.03843], [-117.29595, 33.03831], [-117.29588, 33.03807], [-117.29583, 33.03793], [-117.29602, 33.03792], [-117.29602, 33.0379], [-117.29594, 33.0377], [-117.29584, 33.03771], [-117.29579, 33.03752], [-117.29551, 33.03684], [-117.29536, 33.03653], [-117.29517, 33.03633], [-117.29459, 33.03587], [-117.29451, 33.03574], [-117.29427, 33.03552], [-117.29399, 33.0353], [-117.29383, 33.03523], [-117.29343, 33.03521], [-117.29333, 33.03517], [-117.29321, 33.03511], [-117.29293, 33.03491], [-117.29268, 33.03479], [-117.29248, 33.03506], [-117.29227, 33.03498], [-117.29158, 33.03506], [-117.29142, 33.03477], [-117.29147, 33.03478], [-117.29154, 33.03464], [-117.29196, 33.03416], [-117.29216, 33.0343], [-117.2923, 33.03437], [-117.29249, 33.03444], [-117.29262, 33.03451], [-117.29284, 33.03458], [-117.29298, 33.03466], [-117.29315, 33.03479], [-117.29329, 33.03493], [-117.29348, 33.03502], [-117.29393, 33.03512], [-117.2942, 33.03524], [-117.29441, 33.03538], [-117.29458, 33.03561], [-117.29488, 33.03596], [-117.29503, 33.03609], [-117.29511, 33.0362], [-117.29545, 33.03645], [-117.29551, 33.03655], [-117.29561, 33.03663], [-117.29569, 33.03675], [-117.29572, 33.03686], [-117.29588, 33.0372], [-117.29602, 33.03737], [-117.29613, 33.03746], [-117.29626, 33.03766], [-117.29626, 33.03778], [-117.29631, 33.03789], [-117.29634, 33.03814], [-117.29642, 33.03826], [-117.29646, 33.03842], [-117.29652, 33.03856], [-117.29664, 33.03907], [-117.29684, 33.03977], [-117.2968, 33.04015], [-117.29692, 33.04064], [-117.29692, 33.04082], [-117.297, 33.04112], [-117.29725, 33.04237], [-117.29724, 33.04257], [-117.29727, 33.04284], [-117.29726, 33.04298], [-117.29727, 33.04302], [-117.29725, 33.04311], [-117.29747, 33.04483]]]} | Open Access 1 | 12670 | Swami's Beach | 26093 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 8.916 | Swami's Beach | 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]);