units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 24 and UNIT_NAME = "Point Fermin Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7013 | 7013 | 7012 | {"type": "MultiPolygon", "coordinates": [[[[-118.28571, 33.70795], [-118.28557, 33.70813], [-118.28545, 33.70824], [-118.28531, 33.70832], [-118.28513, 33.7085], [-118.28504, 33.70839], [-118.28553, 33.7081], [-118.28558, 33.70795], [-118.28571, 33.70795]]], [[[-118.30561, 33.71193], [-118.30525, 33.71265], [-118.30517, 33.71261], [-118.30177, 33.71122], [-118.29937, 33.71073], [-118.29871, 33.71067], [-118.29868, 33.71063], [-118.29868, 33.7106], [-118.29891, 33.71015], [-118.2989, 33.71013], [-118.2987, 33.71012], [-118.29845, 33.71064], [-118.29755, 33.71043], [-118.29633, 33.70937], [-118.29561, 33.70905], [-118.29491, 33.70831], [-118.29436, 33.70704], [-118.29206, 33.70604], [-118.29175, 33.70592], [-118.29138, 33.70582], [-118.29113, 33.70577], [-118.29062, 33.70571], [-118.29009, 33.70572], [-118.28951, 33.70579], [-118.28926, 33.70585], [-118.28878, 33.70601], [-118.28776, 33.70645], [-118.28776, 33.70673], [-118.28737, 33.70689], [-118.28713, 33.70649], [-118.287, 33.70659], [-118.28685, 33.70664], [-118.28652, 33.7067], [-118.2863, 33.70676], [-118.28602, 33.70697], [-118.28586, 33.7072], [-118.28581, 33.70734], [-118.28576, 33.70761], [-118.28571, 33.70779], [-118.28562, 33.70779], [-118.28567, 33.70761], [-118.28575, 33.70719], [-118.28599, 33.70683], [-118.28634, 33.70666], [-118.28693, 33.70653], [-118.28743, 33.70623], [-118.28772, 33.70597], [-118.28875, 33.70543], [-118.29059, 33.70521], [-118.29106, 33.70521], [-118.29143, 33.70532], [-118.2925, 33.70517], [-118.29494, 33.70637], [-118.29516, 33.70697], [-118.29508, 33.7076], [-118.29556, 33.70845], [-118.29666, 33.70914], [-118.29765, 33.7097], [-118.29897, 33.70991], [-118.3006, 33.71011], [-118.3016, 33.71051], [-118.30274, 33.71118], [-118.30343, 33.71128], [-118.30448, 33.71172], [-118.30561, 33.71193]]]]} | Open Access 1 | 5951 | Point Fermin Park | 23850 | 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 | 33.584 | Point Fermin 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]);