superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where MNG_AGENCY = 827, MNG_AG_ID = 378 and MNG_AG_TYP = 8
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- County Agency - Other · 4 ✖
MNG_AGENCY 1
- Los Angeles County Department of Beaches and Harbors, County of · 4 ✖
ACCESS_TYP 1
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12359 | 12359 | 12358 | {"type": "Polygon", "coordinates": [[[-118.74257, 34.03285], [-118.74156, 34.03296], [-118.73843, 34.03315], [-118.73603, 34.03334], [-118.73258, 34.03315], [-118.73256, 34.03316], [-118.73223, 34.0332], [-118.7308, 34.03308], [-118.72999, 34.033], [-118.73003, 34.03275], [-118.72998, 34.03271], [-118.72974, 34.03268], [-118.72822, 34.03245], [-118.72662, 34.03222], [-118.72427, 34.03197], [-118.72278, 34.03177], [-118.7223, 34.03172], [-118.7215, 34.03167], [-118.72061, 34.03152], [-118.71939, 34.03135], [-118.71848, 34.0314], [-118.71785, 34.03146], [-118.71648, 34.03156], [-118.71599, 34.03156], [-118.71554, 34.03158], [-118.71503, 34.03154], [-118.71434, 34.03147], [-118.71321, 34.03118], [-118.71225, 34.03096], [-118.71116, 34.03074], [-118.7102, 34.03048], [-118.7093, 34.03026], [-118.70891, 34.03019], [-118.70841, 34.03002], [-118.70794, 34.02989], [-118.70726, 34.02975], [-118.70682, 34.02968], [-118.70661, 34.02967], [-118.70651, 34.02923], [-118.70685, 34.02927], [-118.70751, 34.02941], [-118.70787, 34.02954], [-118.70806, 34.02966], [-118.70854, 34.02981], [-118.70941, 34.03004], [-118.70977, 34.03009], [-118.71028, 34.03011], [-118.71096, 34.03028], [-118.7112, 34.03038], [-118.7117, 34.0305], [-118.71225, 34.03059], [-118.7125, 34.03066], [-118.71291, 34.03088], [-118.71325, 34.03102], [-118.71349, 34.03114], [-118.71434, 34.03135], [-118.71464, 34.03139], [-118.71488, 34.03138], [-118.71514, 34.03142], [-118.71541, 34.03136], [-118.71581, 34.03141], [-118.7162, 34.03143], [-118.71653, 34.03138], [-118.71692, 34.03138], [-118.71766, 34.03127], [-118.71866, 34.03109], [-118.71905, 34.03098], [-118.71935, 34.03093], [-118.71968, 34.03097], [-118.71994, 34.03107], [-118.7203, 34.03111], [-118.7224, 34.03144], [-118.72307, 34.03166], [-118.72372, 34.03175], [-118.72518, 34.03187], [-118.72521, 34.03182], [-118.72546, 34.03187], [-118.7275, 34.03214], [-118.72806, 34.03228], [-118.72847, 34.03231], [-118.72882, 34.03239], [-118.73039, 34.0325], [-118.73173, 34.03267], [-118.73322, 34.03281], [-118.73401, 34.03287], [-118.73542, 34.03301], [-118.7359, 34.03304], [-118.73608, 34.03301], [-118.73625, 34.033], [-118.73651, 34.03307], [-118.737, 34.03305], [-118.73735, 34.03309], [-118.73764, 34.0331], [-118.73798, 34.03308], [-118.73897, 34.03295], [-118.73966, 34.03291], [-118.74017, 34.03286], [-118.74111, 34.03282], [-118.74171, 34.03275], [-118.74224, 34.03264], [-118.74252, 34.03255], [-118.74257, 34.03285]]]} | Open Access 1 | Puerco Beach | 32408 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | http://dpw.lacounty.gov/dbh/ | County 3 | 24.245 | Puerco Beach | ||
15140 | 15140 | 15139 | {"type": "MultiPolygon", "coordinates": [[[[-118.80898, 34.00167], [-118.80844, 34.00168], [-118.80836, 34.00194], [-118.80839, 34.00212], [-118.80832, 34.00218], [-118.8085, 34.00262], [-118.80779, 34.00333], [-118.80764, 34.00318], [-118.80753, 34.00313], [-118.80741, 34.0031], [-118.80721, 34.00309], [-118.80709, 34.00312], [-118.80699, 34.00317], [-118.8068, 34.00334], [-118.80494, 34.00517], [-118.80356, 34.0046], [-118.80388, 34.00424], [-118.8039, 34.00424], [-118.80434, 34.00367], [-118.80467, 34.00312], [-118.80476, 34.00286], [-118.80492, 34.00255], [-118.80497, 34.00249], [-118.80498, 34.00229], [-118.80497, 34.00221], [-118.8049, 34.0021], [-118.80488, 34.00191], [-118.80483, 34.00167], [-118.80481, 34.00149], [-118.80483, 34.00124], [-118.80486, 34.0011], [-118.80492, 34.00097], [-118.805, 34.00089], [-118.80511, 34.00052], [-118.80516, 34.00041], [-118.80533, 34.0003], [-118.80561, 34.00019], [-118.8058, 34.00015], [-118.80622, 34.00019], [-118.80646, 34.0001], [-118.8066, 34.00006], [-118.80683, 34.00012], [-118.80712, 34.00026], [-118.80747, 34.00048], [-118.80755, 34.00051], [-118.80783, 34.00078], [-118.80801, 34.00088], [-118.80854, 34.00135], [-118.80874, 34.00148], [-118.80898, 34.00167]]], [[[-118.81723, 34.01059], [-118.81678, 34.01091], [-118.81662, 34.01077], [-118.81653, 34.01093], [-118.8164, 34.0107], [-118.81631, 34.01073], [-118.81614, 34.01041], [-118.81637, 34.01031], [-118.81671, 34.01008], [-118.81723, 34.01059]]]]} | Open Access 1 | Point Dume State Beach | http://www.parks.ca.gov/?page_id=623 | 30686 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | http://dpw.lacounty.gov/dbh/ | County 3 | 34.968 | Point Dume SB | 1958 |
15176 | 15176 | 15175 | {"type": "MultiPolygon", "coordinates": [[[[-118.45649, 33.96106], [-118.4539, 33.96225], [-118.45386, 33.96218], [-118.45386, 33.96216], [-118.45342, 33.96152], [-118.45334, 33.96153], [-118.45045, 33.95737], [-118.45047, 33.95734], [-118.44895, 33.95484], [-118.44899, 33.9548], [-118.44838, 33.95368], [-118.44808, 33.9538], [-118.44804, 33.95374], [-118.448, 33.95375], [-118.44755, 33.95303], [-118.44749, 33.95304], [-118.44736, 33.95271], [-118.44722, 33.95245], [-118.44704, 33.95251], [-118.4429, 33.9455], [-118.44281, 33.94549], [-118.44162, 33.94339], [-118.43925, 33.93909], [-118.43838, 33.93743], [-118.43516, 33.931], [-118.4348, 33.93032], [-118.43426, 33.92916], [-118.43381, 33.92809], [-118.42773, 33.91632], [-118.42962, 33.91633], [-118.42973, 33.91659], [-118.42999, 33.91685], [-118.43044, 33.91711], [-118.4313, 33.91921], [-118.43228, 33.92105], [-118.43304, 33.9221], [-118.43452, 33.92501], [-118.43532, 33.92696], [-118.43556, 33.92749], [-118.43596, 33.92826], [-118.43648, 33.92933], [-118.43669, 33.92984], [-118.43695, 33.93038], [-118.4377, 33.93169], [-118.43814, 33.93271], [-118.43825, 33.93303], [-118.43856, 33.9337], [-118.43878, 33.93406], [-118.43935, 33.93521], [-118.43954, 33.93568], [-118.43975, 33.9361], [-118.4402, 33.93693], [-118.44039, 33.93724], [-118.44084, 33.93823], [-118.44155, 33.9395], [-118.44195, 33.94017], [-118.44217, 33.94043], [-118.44232, 33.94051], [-118.44263, 33.94044], [-118.44296, 33.94034], [-118.44308, 33.94069], [-118.4432, 33.9409], [-118.44334, 33.94121], [-118.44367, 33.9417], [-118.44376, 33.94192], [-118.44381, 33.94212], [-118.44396, 33.94242], [-118.44416, 33.94266], [-118.44456, 33.94334], [-118.44541, 33.94489], [-118.44554, 33.94511], [-118.4458, 33.94546], [-118.44669, 33.947], [-118.44707, 33.94754], [-118.44738, 33.94819], [-118.44801, 33.94931], [-118.44839, 33.94989], [-118.44869, 33.95022], [-118.44873, 33.95065], [-118.44883, 33.95089], [-118.44923, 33.9516], [-118.44935, 33.95184], [-118.45076, 33.95404], [-118.451, 33.95433], [-118.45164, 33.95539], [-118.45195, 33.95585], [-118.4524, 33.95642], [-118.4523, 33.95655], [-118.45272, 33.9573], [-118.4533, 33.95802], [-118.45373, 33.95875], [-118.4544, 33.95934], [-118.4548, 33.95974], [-118.45514, 33.95998], [-118.45547, 33.9603], [-118.45582, 33.96055], [-118.45614, 33.96073], [-118.45649, 33.96106]]], [[[-118.45189, 33.95952], [-118.45155, 33.95965], [-118.45148, 33.95971], [-118.45127, 33.95915], [-118.45156, 33.95904], [-118.45189, 33.95952]]]]} | Open Access 1 | Dockweiler State Beach | http://www.parks.ca.gov/?page_id=617 | 30635 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | http://dpw.lacounty.gov/dbh/ | County 3 | 279.247 | Dockweiler SB | 1948 |
15187 | 15187 | 15186 | {"type": "MultiPolygon", "coordinates": [[[[-118.55583, 34.03798], [-118.55572, 34.03834], [-118.55517, 34.03833], [-118.55476, 34.03835], [-118.55393, 34.03844], [-118.55365, 34.03853], [-118.55269, 34.0388], [-118.55086, 34.03926], [-118.55047, 34.03934], [-118.55001, 34.03938], [-118.54954, 34.03937], [-118.54848, 34.03928], [-118.54787, 34.03929], [-118.54787, 34.03919], [-118.54536, 34.03872], [-118.54393, 34.03887], [-118.54391, 34.03921], [-118.54177, 34.0386], [-118.54124, 34.03842], [-118.54064, 34.03816], [-118.53918, 34.03738], [-118.53794, 34.03677], [-118.53794, 34.03674], [-118.53598, 34.03579], [-118.53541, 34.03543], [-118.53468, 34.03487], [-118.5344, 34.0347], [-118.5341, 34.03456], [-118.52867, 34.03231], [-118.52815, 34.03215], [-118.52686, 34.03188], [-118.52657, 34.03176], [-118.52654, 34.03177], [-118.52486, 34.03107], [-118.52441, 34.03083], [-118.5219, 34.02944], [-118.52067, 34.02865], [-118.52039, 34.02851], [-118.51971, 34.02825], [-118.51943, 34.02808], [-118.51941, 34.028], [-118.51917, 34.02783], [-118.51907, 34.02783], [-118.51818, 34.02729], [-118.51707, 34.02675], [-118.51792, 34.02557], [-118.51861, 34.02602], [-118.51897, 34.02622], [-118.51932, 34.02639], [-118.51971, 34.02665], [-118.52001, 34.02686], [-118.52008, 34.02703], [-118.5201, 34.02722], [-118.52027, 34.02748], [-118.52039, 34.0275], [-118.52057, 34.02756], [-118.52113, 34.02756], [-118.52161, 34.02782], [-118.52185, 34.02803], [-118.52209, 34.02818], [-118.52234, 34.0284], [-118.52258, 34.02854], [-118.52283, 34.02862], [-118.52392, 34.02934], [-118.52482, 34.02988], [-118.52574, 34.0304], [-118.52622, 34.03076], [-118.52699, 34.03109], [-118.52718, 34.03109], [-118.52751, 34.03113], [-118.5281, 34.03131], [-118.52834, 34.03145], [-118.52868, 34.03169], [-118.52961, 34.03226], [-118.53042, 34.03258], [-118.53069, 34.03241], [-118.5309, 34.03248], [-118.5313, 34.03266], [-118.53192, 34.03299], [-118.53255, 34.03326], [-118.53291, 34.03344], [-118.53402, 34.03391], [-118.53482, 34.03431], [-118.53539, 34.03453], [-118.53588, 34.03479], [-118.5365, 34.035], [-118.53687, 34.03506], [-118.53715, 34.03518], [-118.53784, 34.03539], [-118.53811, 34.03551], [-118.53835, 34.0357], [-118.53857, 34.03584], [-118.53882, 34.03596], [-118.53909, 34.03605], [-118.53939, 34.03618], [-118.53973, 34.0363], [-118.54037, 34.03661], [-118.5409, 34.03697], [-118.54185, 34.03732], [-118.54249, 34.03762], [-118.54277, 34.03781], [-118.54308, 34.03797], [-118.54365, 34.03813], [-118.54399, 34.03819], [-118.5442, 34.03826], [-118.54444, 34.0383], [-118.54486, 34.03848], [-118.54487, 34.03851], [-118.54521, 34.03846], [-118.54588, 34.03865], [-118.54639, 34.03877], [-118.54736, 34.03894], [-118.54794, 34.03903], [-118.54881, 34.03909], [-118.54997, 34.0391], [-118.55042, 34.03906], [-118.55141, 34.03889], [-118.55269, 34.03862], [-118.55302, 34.03848], [-118.55385, 34.03797], [-118.55415, 34.03788], [-118.55472, 34.0378], [-118.55512, 34.03779], [-118.55568, 34.03785], [-118.55568, 34.03788], [-118.55583, 34.03798]]], [[[-118.56722, 34.04165], [-118.5663, 34.0415], [-118.56567, 34.04136], [-118.56518, 34.04127], [-118.56419, 34.04122], [-118.56383, 34.04116], [-118.56349, 34.04108], [-118.56299, 34.0409], [-118.56244, 34.0406], [-118.56207, 34.04043], [-118.56005, 34.03982], [-118.55953, 34.03964], [-118.55896, 34.03942], [-118.55764, 34.03883], [-118.55706, 34.03859], [-118.5564, 34.0384], [-118.55601, 34.03836], [-118.55601, 34.03826], [-118.55621, 34.03794], [-118.55636, 34.03797], [-118.55682, 34.0382], [-118.5576, 34.03848], [-118.55785, 34.03861], [-118.55814, 34.03869], [-118.55846, 34.03884], [-118.5589, 34.03899], [-118.55955, 34.03916], [-118.5601, 34.03938], [-118.5605, 34.03959], [-118.56097, 34.03979], [-118.56121, 34.03986], [-118.56173, 34.04004], [-118.56201, 34.04011], [-118.56227, 34.04024], [-118.56256, 34.04031], [-118.56281, 34.04041], [-118.56333, 34.04056], [-118.56392, 34.04065], [-118.5643, 34.0407], [-118.56541, 34.04096], [-118.56562, 34.04093], [-118.5668, 34.04117], [-118.56682, 34.04132], [-118.56714, 34.04138], [-118.56714, 34.04156], [-118.56722, 34.04165]]]]} | Open Access 1 | Will Rogers State Beach | http://www.parks.ca.gov/?page_id=625 | 30714 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | http://dpw.lacounty.gov/dbh/ | County 3 | 90.643 | Will Rogers SB | 1931 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);