units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 24, MNG_AG_TYP = 2 and PARK_URL = "http://www.laparks.org/dos/parks/facility/occidentalParkwayPk.htm"
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
MNG_AG_TYP 1
- City Agency · 1 ✖
MNG_AGENCY 1
- Los Angeles, City of · 1 ✖
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15060 | 15060 | 15059 | {"type": "MultiPolygon", "coordinates": [[[[-118.28236, 34.06725], [-118.28241, 34.06724], [-118.28243, 34.06726], [-118.28244, 34.06728], [-118.28224, 34.06759], [-118.28219, 34.06761], [-118.28217, 34.06759], [-118.28217, 34.06756], [-118.28236, 34.06725]]], [[[-118.28248, 34.06718], [-118.28245, 34.06718], [-118.28244, 34.06715], [-118.28245, 34.06713], [-118.28248, 34.06712], [-118.28251, 34.06713], [-118.28252, 34.06715], [-118.28251, 34.06717], [-118.28248, 34.06718]]], [[[-118.28271, 34.06671], [-118.28276, 34.06669], [-118.28279, 34.06671], [-118.28279, 34.06674], [-118.28259, 34.06705], [-118.28254, 34.06706], [-118.28252, 34.06704], [-118.28252, 34.06702], [-118.28271, 34.06671]]], [[[-118.28283, 34.06664], [-118.2828, 34.06663], [-118.28279, 34.06661], [-118.2828, 34.06658], [-118.28283, 34.06657], [-118.28285, 34.06658], [-118.28287, 34.0666], [-118.28286, 34.06663], [-118.28283, 34.06664]]], [[[-118.28306, 34.06616], [-118.28311, 34.06614], [-118.28314, 34.06616], [-118.28314, 34.06619], [-118.28294, 34.0665], [-118.28289, 34.06651], [-118.28287, 34.06649], [-118.28287, 34.06647], [-118.28306, 34.06616]]], [[[-118.28318, 34.06609], [-118.28315, 34.06608], [-118.28313, 34.06606], [-118.28314, 34.06604], [-118.28317, 34.06602], [-118.2832, 34.06603], [-118.28322, 34.06606], [-118.28321, 34.06608], [-118.28318, 34.06609]]], [[[-118.28341, 34.06561], [-118.28346, 34.0656], [-118.28348, 34.06562], [-118.28348, 34.06564], [-118.28329, 34.06595], [-118.28323, 34.06597], [-118.28321, 34.06595], [-118.28321, 34.06592], [-118.28341, 34.06561]]], [[[-118.28352, 34.06555], [-118.2835, 34.06554], [-118.28348, 34.06551], [-118.28349, 34.06549], [-118.28352, 34.06548], [-118.28355, 34.06549], [-118.28356, 34.06551], [-118.28355, 34.06554], [-118.28352, 34.06555]]], [[[-118.28376, 34.06506], [-118.28381, 34.06506], [-118.28383, 34.0651], [-118.28363, 34.06541], [-118.28358, 34.06542], [-118.28356, 34.06538], [-118.28376, 34.06506]]], [[[-118.28387, 34.065], [-118.28384, 34.06499], [-118.28383, 34.06496], [-118.28384, 34.06494], [-118.28387, 34.06493], [-118.28389, 34.06494], [-118.28391, 34.06496], [-118.2839, 34.06498], [-118.28387, 34.065]]], [[[-118.28411, 34.06451], [-118.28416, 34.06451], [-118.28418, 34.06452], [-118.28418, 34.06455], [-118.28398, 34.06487], [-118.28393, 34.06488], [-118.28391, 34.06483], [-118.28411, 34.06451]]]]} | Open Access 1 | 45818 | Occidental Parkway | 28837 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/parks/facility/occidentalParkwayPk.htm | Los Angeles 6 | 0.539 | Occidental Parkway | 0 | Local Recreation Area 3 | 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]);