units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, AGNCY_LEV = 3 and PARK_URL = "http://beaches.lacounty.gov/wps/portal/dbh/home/detail/?current=true&urile=wcm:path:/dbh+content/dbh+site/home/home+detail/white+royal+1"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7004 | 7004 | 7003 | {"type": "Polygon", "coordinates": [[[-118.32186, 33.71749], [-118.32052, 33.7186], [-118.31999, 33.71824], [-118.31996, 33.71825], [-118.31965, 33.71805], [-118.31936, 33.71782], [-118.31912, 33.71757], [-118.31834, 33.71661], [-118.31875, 33.71671], [-118.31882, 33.71653], [-118.31125, 33.71456], [-118.3116, 33.71398], [-118.31356, 33.71465], [-118.31722, 33.71379], [-118.31765, 33.71477], [-118.31982, 33.71592], [-118.31964, 33.71652], [-118.32082, 33.71758], [-118.32186, 33.71749]]]} | Open Access 1 | 5945 | White Point County Beach | 27462 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://beaches.lacounty.gov/wps/portal/dbh/home/detail/?current=true&urile=wcm:path:/dbh+content/dbh+site/home/home+detail/white+royal+1 | Los Angeles 6 | 32.053 | White Point County Beach | 0 | Local Park 2 | 4 |
7005 | 7005 | 7004 | {"type": "Polygon", "coordinates": [[[-118.33306, 33.72184], [-118.33278, 33.72229], [-118.33223, 33.72195], [-118.33116, 33.72161], [-118.33036, 33.72101], [-118.32995, 33.72084], [-118.32954, 33.72068], [-118.32932, 33.72063], [-118.32869, 33.72046], [-118.32848, 33.72038], [-118.32826, 33.72032], [-118.32782, 33.72021], [-118.32758, 33.72017], [-118.32718, 33.72003], [-118.32693, 33.72001], [-118.32661, 33.71988], [-118.32634, 33.71971], [-118.32595, 33.71955], [-118.32577, 33.71945], [-118.3256, 33.71934], [-118.32541, 33.71927], [-118.32508, 33.71925], [-118.32471, 33.71927], [-118.32449, 33.71934], [-118.32394, 33.71936], [-118.32378, 33.71943], [-118.32346, 33.71926], [-118.32317, 33.71919], [-118.32302, 33.71934], [-118.32248, 33.71905], [-118.32218, 33.71897], [-118.32251, 33.71859], [-118.322, 33.71826], [-118.32205, 33.71806], [-118.32179, 33.71787], [-118.32172, 33.71807], [-118.32145, 33.71803], [-118.32138, 33.71805], [-118.3213, 33.7181], [-118.32128, 33.71814], [-118.3212, 33.71845], [-118.32092, 33.71856], [-118.32074, 33.71841], [-118.3219, 33.71745], [-118.32217, 33.71731], [-118.32252, 33.71692], [-118.32257, 33.71689], [-118.32249, 33.71704], [-118.32242, 33.71711], [-118.32243, 33.71717], [-118.32249, 33.71718], [-118.32215, 33.71735], [-118.32204, 33.71752], [-118.32213, 33.71775], [-118.32264, 33.71829], [-118.32332, 33.71872], [-118.325, 33.71873], [-118.32557, 33.71877], [-118.32665, 33.71911], [-118.33044, 33.72024], [-118.33051, 33.72028], [-118.33062, 33.7203], [-118.33109, 33.72064], [-118.33306, 33.72184]]]} | Open Access 1 | 5946 | Royal Palms County Beach | 24716 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://beaches.lacounty.gov/wps/portal/dbh/home/detail/?current=true&urile=wcm:path:/dbh+content/dbh+site/home/home+detail/white+royal+1 | Los Angeles 6 | 20.821 | Royal Palms County 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]);