units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 24, MNG_AG_TYP = 2 and SUID_NMA = 21241
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6607 | 6607 | 6606 | {"type": "MultiPolygon", "coordinates": [[[[-118.5624, 34.29859], [-118.5621, 34.29879], [-118.55977, 34.29919], [-118.55739, 34.29924], [-118.55479, 34.29712], [-118.55443, 34.29657], [-118.55403, 34.29641], [-118.55102, 34.29681], [-118.55102, 34.29649], [-118.55105, 34.29626], [-118.55117, 34.29586], [-118.5512, 34.29584], [-118.55124, 34.29583], [-118.55209, 34.29611], [-118.55246, 34.2962], [-118.55281, 34.29626], [-118.55334, 34.29632], [-118.5548, 34.29637], [-118.55486, 34.29708], [-118.55743, 34.29917], [-118.55976, 34.29912], [-118.56206, 34.29873], [-118.56231, 34.29856], [-118.5624, 34.29859]]], [[[-118.56318, 34.28561], [-118.56276, 34.28589], [-118.56208, 34.28697], [-118.56224, 34.28742], [-118.56214, 34.28753], [-118.56186, 34.28773], [-118.5615, 34.28749], [-118.56017, 34.28848], [-118.55927, 34.28945], [-118.55884, 34.28955], [-118.55897, 34.29005], [-118.5587, 34.29007], [-118.5586, 34.29079], [-118.55847, 34.29107], [-118.55712, 34.29274], [-118.55641, 34.29285], [-118.55497, 34.29403], [-118.55201, 34.29579], [-118.55136, 34.29556], [-118.55135, 34.29552], [-118.55138, 34.29546], [-118.55165, 34.29512], [-118.5519, 34.29487], [-118.55219, 34.29465], [-118.55259, 34.29442], [-118.55352, 34.29404], [-118.5538, 34.29391], [-118.55413, 34.29372], [-118.55439, 34.29354], [-118.55462, 34.29335], [-118.55673, 34.29136], [-118.55705, 34.29101], [-118.55737, 34.29056], [-118.55756, 34.29023], [-118.55798, 34.28937], [-118.5581, 34.28917], [-118.55832, 34.2889], [-118.55852, 34.28868], [-118.56145, 34.28582], [-118.56178, 34.28543], [-118.56206, 34.28496], [-118.56213, 34.28494], [-118.56252, 34.28506], [-118.56273, 34.28516], [-118.56289, 34.28528], [-118.56301, 34.28532], [-118.56298, 34.28535], [-118.56309, 34.28547], [-118.56318, 34.28561]]], [[[-118.55976, 34.27431], [-118.55973, 34.27454], [-118.55871, 34.27446], [-118.55711, 34.27299], [-118.55733, 34.27304], [-118.5575, 34.27294], [-118.558, 34.27297], [-118.55804, 34.27317], [-118.55836, 34.27376], [-118.55844, 34.27382], [-118.55857, 34.27386], [-118.55885, 34.27383], [-118.55895, 34.27391], [-118.55916, 34.27392], [-118.55928, 34.27395], [-118.55969, 34.27421], [-118.55976, 34.27431]]], [[[-118.56496, 34.28693], [-118.56463, 34.28679], [-118.56397, 34.28597], [-118.56381, 34.2851], [-118.56356, 34.28491], [-118.56312, 34.28524], [-118.56294, 34.28509], [-118.56276, 34.28499], [-118.56255, 34.2849], [-118.5622, 34.28479], [-118.56216, 34.28476], [-118.56215, 34.28474], [-118.56228, 34.28435], [-118.56232, 34.28409], [-118.56272, 34.28412], [-118.56295, 34.28228], [-118.56191, 34.28125], [-118.5619, 34.28086], [-118.56216, 34.28053], [-118.56239, 34.27906], [-118.56176, 34.27887], [-118.56123, 34.27833], [-118.56121, 34.27808], [-118.56158, 34.27728], [-118.56031, 34.27607], [-118.55978, 34.27572], [-118.55952, 34.2757], [-118.55962, 34.27481], [-118.56112, 34.27494], [-118.56174, 34.27616], [-118.56262, 34.27662], [-118.56312, 34.2772], [-118.56296, 34.27818], [-118.5634, 34.27849], [-118.56352, 34.27849], [-118.56388, 34.27888], [-118.56393, 34.27935], [-118.5638, 34.27955], [-118.56365, 34.27952], [-118.56347, 34.28007], [-118.56365, 34.28012], [-118.56314, 34.28096], [-118.56426, 34.28198], [-118.56461, 34.28283], [-118.56468, 34.28434], [-118.56479, 34.28503], [-118.56496, 34.28526], [-118.56496, 34.28693]]]]} | Open Access 1 | 4167 | Limekiln Canyon Park | 21241 | 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 | 95.932 | Limekiln Canyon Park | 0 | Local Park 2 | 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]);