superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 16 and PARK_NAME = "Manhattan County Beach"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6579 | 6579 | 6578 | {"type": "MultiPolygon", "coordinates": [[[[-118.41225, 33.88391], [-118.41199, 33.884], [-118.41173, 33.88354], [-118.41133, 33.88366], [-118.41018, 33.88154], [-118.40989, 33.88096], [-118.40823, 33.87745], [-118.40839, 33.87739], [-118.40924, 33.87918], [-118.40841, 33.87738], [-118.40916, 33.87712], [-118.40966, 33.87693], [-118.41175, 33.88137], [-118.411, 33.88164], [-118.41113, 33.88191], [-118.4115, 33.88254], [-118.41173, 33.883], [-118.41197, 33.88339], [-118.41218, 33.88381], [-118.41225, 33.88391]], [[-118.41001, 33.88078], [-118.40999, 33.88078], [-118.41033, 33.88148], [-118.41056, 33.88188], [-118.41001, 33.88078]]], [[[-118.42323, 33.90491], [-118.42228, 33.90523], [-118.42225, 33.90519], [-118.4221, 33.90523], [-118.42152, 33.90405], [-118.42166, 33.90401], [-118.42166, 33.90399], [-118.42164, 33.90397], [-118.4215, 33.90402], [-118.42092, 33.90283], [-118.42105, 33.90279], [-118.42106, 33.90276], [-118.42089, 33.9028], [-118.42035, 33.90165], [-118.42008, 33.90105], [-118.42007, 33.90101], [-118.42022, 33.90096], [-118.42049, 33.9016], [-118.42051, 33.9016], [-118.42057, 33.90175], [-118.42063, 33.90175], [-118.42001, 33.90033], [-118.42, 33.90022], [-118.41997, 33.90016], [-118.41992, 33.90017], [-118.41993, 33.90024], [-118.41975, 33.90028], [-118.4195, 33.89971], [-118.41965, 33.89966], [-118.41979, 33.89998], [-118.41985, 33.90004], [-118.4199, 33.90001], [-118.4198, 33.89983], [-118.41969, 33.89958], [-118.4184, 33.8966], [-118.41753, 33.89465], [-118.41668, 33.8929], [-118.41606, 33.89174], [-118.41602, 33.89177], [-118.41626, 33.89225], [-118.41611, 33.89231], [-118.41552, 33.89116], [-118.41567, 33.89111], [-118.41572, 33.89106], [-118.41344, 33.88697], [-118.4128, 33.88585], [-118.41274, 33.88585], [-118.41295, 33.88626], [-118.41295, 33.88627], [-118.41297, 33.88628], [-118.41359, 33.88737], [-118.41344, 33.88742], [-118.41282, 33.88633], [-118.41284, 33.88629], [-118.4128, 33.88622], [-118.41276, 33.88623], [-118.41227, 33.88536], [-118.41266, 33.88521], [-118.41227, 33.88449], [-118.41327, 33.88415], [-118.41391, 33.88545], [-118.41474, 33.88698], [-118.41574, 33.88877], [-118.41766, 33.89243], [-118.41943, 33.89618], [-118.42024, 33.89803], [-118.42108, 33.89989], [-118.42186, 33.90174], [-118.42323, 33.90491]]], [[[-118.41459, 33.88916], [-118.41443, 33.88922], [-118.41415, 33.88868], [-118.41413, 33.88867], [-118.41349, 33.88752], [-118.41365, 33.88747], [-118.41428, 33.88861], [-118.41427, 33.88863], [-118.41429, 33.88863], [-118.41459, 33.88916]]], [[[-118.41558, 33.89096], [-118.41543, 33.89101], [-118.4148, 33.88987], [-118.41481, 33.88985], [-118.41479, 33.88985], [-118.41449, 33.88932], [-118.41465, 33.88926], [-118.41493, 33.88981], [-118.41495, 33.88982], [-118.41528, 33.8904], [-118.41528, 33.89042], [-118.41558, 33.89096]]], [[[-118.41656, 33.89282], [-118.41642, 33.89287], [-118.41614, 33.89234], [-118.41628, 33.89228], [-118.41656, 33.89282]]], [[[-118.41687, 33.89344], [-118.41673, 33.89349], [-118.41646, 33.89297], [-118.41661, 33.89292], [-118.41687, 33.89344]]], [[[-118.41716, 33.89404], [-118.41704, 33.89408], [-118.41675, 33.89352], [-118.41688, 33.89347], [-118.41716, 33.89404]]], [[[-118.41746, 33.89466], [-118.41731, 33.89471], [-118.41709, 33.89418], [-118.41722, 33.89415], [-118.41746, 33.89466]]], [[[-118.41829, 33.89652], [-118.41814, 33.89657], [-118.4179, 33.89599], [-118.41788, 33.89599], [-118.41736, 33.89482], [-118.41751, 33.89477], [-118.41775, 33.89532], [-118.41777, 33.89532], [-118.41829, 33.89652]]], [[[-118.4191, 33.89838], [-118.41895, 33.89843], [-118.41819, 33.89667], [-118.41834, 33.89662], [-118.4191, 33.89838]]], [[[-118.41964, 33.89964], [-118.41949, 33.89969], [-118.419, 33.89853], [-118.41915, 33.89849], [-118.41964, 33.89964]]], [[[-118.42017, 33.90087], [-118.42002, 33.90091], [-118.4198, 33.90039], [-118.41995, 33.90035], [-118.42017, 33.90087]]]]} | Open Access 1 | Manhattan County Beach | 21746 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 96.071 | Manhattan County Beach |
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]);