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 = 26846
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7185 | 7185 | 7184 | {"type": "Polygon", "coordinates": [[[-118.46321, 33.9725], [-118.46393, 33.97357], [-118.46531, 33.97539], [-118.46644, 33.97666], [-118.46793, 33.97842], [-118.46925, 33.98006], [-118.47054, 33.98154], [-118.47096, 33.98197], [-118.47114, 33.98212], [-118.47133, 33.98207], [-118.47262, 33.9835], [-118.47349, 33.98435], [-118.47394, 33.98477], [-118.4744, 33.98509], [-118.47466, 33.98523], [-118.47491, 33.98539], [-118.47516, 33.98552], [-118.47544, 33.98559], [-118.47592, 33.98564], [-118.47631, 33.98558], [-118.4765, 33.98552], [-118.4769, 33.98527], [-118.47701, 33.98539], [-118.47681, 33.98556], [-118.47666, 33.98574], [-118.47657, 33.98602], [-118.4766, 33.98624], [-118.47663, 33.98639], [-118.4767, 33.98657], [-118.47678, 33.98674], [-118.47701, 33.98709], [-118.47832, 33.98875], [-118.47925, 33.99], [-118.48041, 33.99138], [-118.48324, 33.99462], [-118.48379, 33.99521], [-118.48354, 33.99537], [-118.48351, 33.99535], [-118.48257, 33.99589], [-118.48214, 33.99547], [-118.48172, 33.99575], [-118.48163, 33.99566], [-118.48155, 33.9957], [-118.48112, 33.99522], [-118.48123, 33.99515], [-118.4812, 33.9951], [-118.48115, 33.99506], [-118.48104, 33.99513], [-118.48059, 33.99464], [-118.48069, 33.99458], [-118.48059, 33.99445], [-118.48047, 33.99451], [-118.47997, 33.99394], [-118.48008, 33.99387], [-118.48001, 33.99378], [-118.47989, 33.99385], [-118.47935, 33.99323], [-118.47946, 33.99316], [-118.4794, 33.99307], [-118.47938, 33.99307], [-118.47927, 33.99315], [-118.47876, 33.99257], [-118.47886, 33.9925], [-118.47883, 33.99245], [-118.47879, 33.99241], [-118.47868, 33.99248], [-118.47818, 33.9919], [-118.47827, 33.99185], [-118.47822, 33.99175], [-118.4781, 33.99181], [-118.47759, 33.99124], [-118.47768, 33.99119], [-118.47768, 33.99117], [-118.4776, 33.9911], [-118.47751, 33.99115], [-118.47702, 33.99057], [-118.47712, 33.9905], [-118.47708, 33.99044], [-118.47704, 33.99042], [-118.47693, 33.99048], [-118.47652, 33.99002], [-118.4766, 33.98998], [-118.4766, 33.98997], [-118.47652, 33.98989], [-118.47644, 33.98993], [-118.47607, 33.9895], [-118.47613, 33.98946], [-118.47606, 33.98938], [-118.47599, 33.98941], [-118.4756, 33.98899], [-118.47568, 33.98893], [-118.47562, 33.98885], [-118.47553, 33.9889], [-118.47515, 33.98846], [-118.47522, 33.98841], [-118.47515, 33.98833], [-118.47506, 33.98837], [-118.47469, 33.98795], [-118.47463, 33.98797], [-118.47338, 33.98655], [-118.47338, 33.98651], [-118.47324, 33.98635], [-118.47321, 33.98636], [-118.46793, 33.98033], [-118.46643, 33.97854], [-118.46655, 33.97847], [-118.46656, 33.97845], [-118.46649, 33.97838], [-118.46636, 33.97845], [-118.466, 33.97802], [-118.46611, 33.97795], [-118.46608, 33.9779], [-118.46604, 33.97787], [-118.46593, 33.97794], [-118.46555, 33.97749], [-118.46566, 33.97744], [-118.46566, 33.97742], [-118.4656, 33.97735], [-118.46554, 33.97738], [-118.46517, 33.97695], [-118.46521, 33.9769], [-118.46514, 33.97682], [-118.46509, 33.97686], [-118.46471, 33.97642], [-118.46476, 33.97637], [-118.46469, 33.9763], [-118.46464, 33.97633], [-118.46426, 33.97589], [-118.46431, 33.97586], [-118.46428, 33.97581], [-118.46424, 33.97578], [-118.46418, 33.9758], [-118.46381, 33.97537], [-118.46386, 33.97534], [-118.46383, 33.97528], [-118.46378, 33.97525], [-118.46373, 33.97528], [-118.46335, 33.97484], [-118.4634, 33.97481], [-118.46337, 33.97477], [-118.46333, 33.97472], [-118.46328, 33.97475], [-118.4629, 33.97432], [-118.46295, 33.97428], [-118.46289, 33.9742], [-118.46284, 33.97423], [-118.46246, 33.97379], [-118.46251, 33.97375], [-118.46244, 33.97368], [-118.46238, 33.9737], [-118.46193, 33.97318], [-118.4616, 33.97274], [-118.46164, 33.97269], [-118.46158, 33.97261], [-118.46152, 33.97264], [-118.46119, 33.97218], [-118.46123, 33.97216], [-118.46123, 33.97215], [-118.46117, 33.97207], [-118.46111, 33.97209], [-118.46077, 33.97164], [-118.46082, 33.97161], [-118.46082, 33.9716], [-118.46076, 33.97152], [-118.4607, 33.97155], [-118.46036, 33.97109], [-118.46041, 33.97107], [-118.46041, 33.97105], [-118.46035, 33.97097], [-118.46029, 33.97099], [-118.46026, 33.97095], [-118.46043, 33.97085], [-118.46043, 33.97084], [-118.45845, 33.9682], [-118.4565, 33.9654], [-118.4594, 33.96398], [-118.45952, 33.9655], [-118.46155, 33.97022], [-118.46159, 33.97021], [-118.46254, 33.97163], [-118.46321, 33.9725]]]} | Open Access 1 | 6324 | Venice City Beach | 26846 | 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 | 172.621 | Venice City Beach | 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]);