units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "31.363"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
DES_TP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7432 | 7432 | 7431 | {"type": "Polygon", "coordinates": [[[-118.33629, 34.11612], [-118.33546, 34.11612], [-118.33545, 34.11609], [-118.33234, 34.1161], [-118.33228, 34.11594], [-118.33232, 34.11551], [-118.33232, 34.11506], [-118.33189, 34.11472], [-118.33171, 34.11449], [-118.33202, 34.11411], [-118.33197, 34.11389], [-118.33217, 34.11348], [-118.33211, 34.11327], [-118.33207, 34.11327], [-118.33207, 34.11295], [-118.33225, 34.11309], [-118.33236, 34.11311], [-118.33244, 34.11309], [-118.33249, 34.11303], [-118.3325, 34.11294], [-118.33246, 34.11288], [-118.33256, 34.11293], [-118.33264, 34.1129], [-118.33265, 34.11288], [-118.33276, 34.11288], [-118.33277, 34.11291], [-118.3331, 34.11291], [-118.33312, 34.11289], [-118.3336, 34.11288], [-118.3337, 34.11284], [-118.33385, 34.1127], [-118.33385, 34.11246], [-118.3353, 34.11246], [-118.33544, 34.11286], [-118.33571, 34.11376], [-118.33573, 34.11419], [-118.33571, 34.1142], [-118.33571, 34.11434], [-118.3358, 34.115], [-118.33582, 34.11502], [-118.33587, 34.11502], [-118.33598, 34.11531], [-118.33606, 34.11543], [-118.33608, 34.11565], [-118.33617, 34.11575], [-118.3362, 34.11585], [-118.33619, 34.11589], [-118.33621, 34.11603], [-118.33628, 34.11609], [-118.33629, 34.11612]], [[-118.33577, 34.11531], [-118.33576, 34.11529], [-118.33567, 34.1153], [-118.33567, 34.11538], [-118.33577, 34.11538], [-118.33577, 34.11531]], [[-118.33392, 34.1135], [-118.33398, 34.11349], [-118.33403, 34.11346], [-118.33407, 34.11342], [-118.33409, 34.11337], [-118.33408, 34.11332], [-118.33404, 34.11327], [-118.33399, 34.11324], [-118.33393, 34.11322], [-118.33387, 34.11323], [-118.33381, 34.11326], [-118.33377, 34.1133], [-118.33376, 34.11335], [-118.33377, 34.11341], [-118.3338, 34.11345], [-118.33385, 34.11349], [-118.33392, 34.1135]]]} | Open Access 1 | 6906 | John Anson Ford Amphitheatre and County Parkland | 32478 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 31.363 | John Anson Ford Amphitheatre and County Parkland | 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]);