units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 42 and SUID_NMA = 26093
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]);