superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_LEV = 3 and PARK_URL = "http://parks.lacounty.gov/wps/portal/dpr/Parks/Marshall_Canyon_Park_And_Nursery"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15114 | 15114 | 15113 | {"type": "Polygon", "coordinates": [[[-117.75013, 34.14351], [-117.74586, 34.14597], [-117.74647, 34.14969], [-117.74658, 34.15137], [-117.74663, 34.15274], [-117.74628, 34.15259], [-117.74564, 34.15221], [-117.74456, 34.15887], [-117.74294, 34.15888], [-117.7437, 34.16054], [-117.74533, 34.1654], [-117.73329, 34.16538], [-117.72455, 34.16539], [-117.72452, 34.15812], [-117.72886, 34.15813], [-117.72883, 34.15457], [-117.73459, 34.15451], [-117.73743, 34.15192], [-117.73789, 34.15168], [-117.73816, 34.15144], [-117.73891, 34.15057], [-117.73908, 34.14982], [-117.73966, 34.14857], [-117.73974, 34.14831], [-117.73973, 34.1483], [-117.73938, 34.1483], [-117.7392, 34.14822], [-117.73908, 34.14819], [-117.73927, 34.14726], [-117.7417, 34.14724], [-117.74166, 34.14359], [-117.74219, 34.14357], [-117.74218, 34.1431], [-117.74202, 34.14165], [-117.74237, 34.14117], [-117.74267, 34.13948], [-117.7428, 34.13912], [-117.74326, 34.13857], [-117.74346, 34.13762], [-117.7433, 34.13722], [-117.7433, 34.13685], [-117.74318, 34.1367], [-117.74395, 34.13669], [-117.74364, 34.13691], [-117.74373, 34.13798], [-117.74353, 34.13807], [-117.74352, 34.13806], [-117.74343, 34.13806], [-117.74338, 34.13832], [-117.74348, 34.13835], [-117.74347, 34.13851], [-117.74361, 34.13852], [-117.7436, 34.13825], [-117.74387, 34.13821], [-117.74428, 34.13805], [-117.74455, 34.1387], [-117.74436, 34.13937], [-117.7441, 34.13964], [-117.74414, 34.1403], [-117.74382, 34.14072], [-117.74406, 34.14148], [-117.74426, 34.14177], [-117.74376, 34.14178], [-117.74372, 34.14356], [-117.75013, 34.14351]]]} | Open Access 1 | Marshall Canyon Regional Park | http://parks.lacounty.gov/wps/portal/dpr/Parks/Marshall_Canyon_Park_And_Nursery | 29278 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 734.871 | Marshall Canyon RP |
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]);