units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 24 and SUID_NMA = 17487
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7424 | 7424 | 7423 | {"type": "Polygon", "coordinates": [[[-118.40761, 34.1304], [-118.40519, 34.13076], [-118.40519, 34.13116], [-118.3999, 34.13098], [-118.39998, 34.1308], [-118.40103, 34.13095], [-118.40127, 34.13097], [-118.40144, 34.13097], [-118.40145, 34.13093], [-118.4019, 34.13094], [-118.40199, 34.13092], [-118.402, 34.13091], [-118.402, 34.13088], [-118.40191, 34.13019], [-118.40189, 34.13018], [-118.40181, 34.13022], [-118.40077, 34.1304], [-118.40061, 34.13041], [-118.40054, 34.13039], [-118.40046, 34.13034], [-118.40037, 34.13026], [-118.40031, 34.13014], [-118.40031, 34.13006], [-118.40043, 34.12962], [-118.40042, 34.12954], [-118.40037, 34.12949], [-118.40026, 34.12944], [-118.40007, 34.12943], [-118.39974, 34.1295], [-118.39963, 34.12951], [-118.39949, 34.12945], [-118.39942, 34.12939], [-118.3994, 34.12934], [-118.40103, 34.12856], [-118.4018, 34.12844], [-118.40169, 34.12825], [-118.40163, 34.12785], [-118.40166, 34.12755], [-118.40187, 34.12724], [-118.40323, 34.12693], [-118.40354, 34.12725], [-118.40355, 34.12728], [-118.40356, 34.12733], [-118.4035, 34.12748], [-118.40348, 34.1276], [-118.40349, 34.12771], [-118.40335, 34.1277], [-118.40334, 34.1276], [-118.40329, 34.12754], [-118.40324, 34.1275], [-118.40314, 34.12746], [-118.40265, 34.12744], [-118.4025, 34.12751], [-118.4024, 34.12763], [-118.40239, 34.12772], [-118.40242, 34.12778], [-118.40251, 34.12782], [-118.4025, 34.12785], [-118.40266, 34.12835], [-118.4028, 34.12837], [-118.40292, 34.12845], [-118.40301, 34.12847], [-118.40324, 34.12848], [-118.40331, 34.1285], [-118.40338, 34.12853], [-118.40343, 34.12859], [-118.40347, 34.12858], [-118.40347, 34.12886], [-118.4035, 34.12893], [-118.40356, 34.12895], [-118.40384, 34.12896], [-118.40397, 34.129], [-118.40409, 34.12905], [-118.40419, 34.12906], [-118.40435, 34.12902], [-118.40451, 34.12892], [-118.40466, 34.12887], [-118.40517, 34.12886], [-118.40518, 34.12869], [-118.40603, 34.12874], [-118.40603, 34.12783], [-118.4061, 34.12783], [-118.40634, 34.12813], [-118.40637, 34.12819], [-118.40657, 34.129], [-118.40672, 34.12926], [-118.40686, 34.12942], [-118.40705, 34.12956], [-118.40718, 34.12963], [-118.4073, 34.12967], [-118.40738, 34.12972], [-118.40757, 34.1298], [-118.40761, 34.1304]]]} | Open Access 1 | 6862 | Coldwater Canyon Park | 17487 | 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 | 41.789 | Coldwater 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]);