units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 573 and LAYER = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7014 | 7014 | 7013 | {"type": "MultiPolygon", "coordinates": [[[[-118.28693, 33.71159], [-118.2861, 33.71162], [-118.28607, 33.71185], [-118.28547, 33.71297], [-118.2858, 33.71362], [-118.28576, 33.71399], [-118.28593, 33.7142], [-118.28592, 33.71434], [-118.2845, 33.71434], [-118.28448, 33.71354], [-118.28427, 33.71353], [-118.28393, 33.71356], [-118.28384, 33.71359], [-118.28376, 33.71365], [-118.28375, 33.71371], [-118.28369, 33.71369], [-118.28368, 33.71364], [-118.28374, 33.71357], [-118.2839, 33.7135], [-118.2839, 33.71329], [-118.28383, 33.71326], [-118.28292, 33.71304], [-118.28287, 33.71306], [-118.28287, 33.71354], [-118.28283, 33.71357], [-118.28279, 33.71355], [-118.28278, 33.71303], [-118.28276, 33.71299], [-118.28245, 33.71291], [-118.28202, 33.71285], [-118.28199, 33.71281], [-118.28207, 33.71279], [-118.28276, 33.7129], [-118.28287, 33.71277], [-118.28297, 33.71259], [-118.28301, 33.71245], [-118.28304, 33.71221], [-118.28303, 33.71189], [-118.28296, 33.71127], [-118.28282, 33.71048], [-118.28271, 33.71009], [-118.28264, 33.71001], [-118.28247, 33.71], [-118.28239, 33.70996], [-118.28208, 33.70988], [-118.28192, 33.70989], [-118.28182, 33.70988], [-118.28176, 33.70985], [-118.28156, 33.70987], [-118.28146, 33.70992], [-118.28137, 33.70994], [-118.2813, 33.70995], [-118.28119, 33.70992], [-118.28073, 33.70968], [-118.28043, 33.70969], [-118.28016, 33.70962], [-118.27977, 33.70945], [-118.27942, 33.70926], [-118.27866, 33.70895], [-118.27818, 33.70878], [-118.27806, 33.70877], [-118.2779, 33.70871], [-118.27768, 33.7086], [-118.27759, 33.7085], [-118.27751, 33.70844], [-118.27743, 33.70842], [-118.27724, 33.70842], [-118.27721, 33.70845], [-118.27566, 33.70762], [-118.27559, 33.7077], [-118.2753, 33.70755], [-118.27534, 33.70746], [-118.27388, 33.70668], [-118.27395, 33.70659], [-118.27404, 33.70663], [-118.27402, 33.70667], [-118.27701, 33.70827], [-118.27859, 33.70622], [-118.2787, 33.70629], [-118.27774, 33.70754], [-118.27784, 33.70758], [-118.27799, 33.70771], [-118.27817, 33.70781], [-118.27829, 33.70794], [-118.27863, 33.70814], [-118.27868, 33.70814], [-118.27889, 33.70821], [-118.27892, 33.70824], [-118.27984, 33.70855], [-118.28018, 33.70857], [-118.28081, 33.70872], [-118.28084, 33.70874], [-118.2811, 33.70882], [-118.2816, 33.7089], [-118.28173, 33.70893], [-118.28231, 33.70894], [-118.28262, 33.70899], [-118.28312, 33.709], [-118.28318, 33.70894], [-118.28372, 33.70894], [-118.28396, 33.70885], [-118.28415, 33.70885], [-118.28433, 33.70882], [-118.28467, 33.70866], [-118.28479, 33.70862], [-118.28516, 33.70787], [-118.2856, 33.70787], [-118.28554, 33.7081], [-118.28497, 33.70844], [-118.2854, 33.70893], [-118.28543, 33.70901], [-118.28557, 33.71014], [-118.28548, 33.71022], [-118.28534, 33.71022], [-118.2845, 33.70991], [-118.28437, 33.70988], [-118.28424, 33.70987], [-118.28398, 33.7099], [-118.28388, 33.70994], [-118.28377, 33.71007], [-118.28375, 33.71014], [-118.28378, 33.71023], [-118.28386, 33.71032], [-118.28411, 33.71042], [-118.28421, 33.71051], [-118.2843, 33.71048], [-118.28429, 33.71043], [-118.28431, 33.71034], [-118.28439, 33.71022], [-118.28453, 33.71016], [-118.2847, 33.71015], [-118.28595, 33.71061], [-118.28657, 33.7114], [-118.28667, 33.71148], [-118.2868, 33.71155], [-118.28693, 33.71159]]], [[[-118.28443, 33.71005], [-118.28429, 33.71012], [-118.28422, 33.7102], [-118.28413, 33.71027], [-118.28402, 33.71027], [-118.28397, 33.71025], [-118.28392, 33.71021], [-118.28391, 33.71016], [-118.28392, 33.71008], [-118.28394, 33.71005], [-118.28399, 33.71001], [-118.28417, 33.70998], [-118.28434, 33.71], [-118.28442, 33.71002], [-118.28443, 33.71005]]]]} | Open Access 1 | 5953 | Cabrillo Beach & Marine Aquarium | 16634 | 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 | Los Angeles 6 | 51.192 | Cabrillo Beach & Marine Aquarium | None 573 |
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]);