units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 7 and UNIT_NAME = "Los Angeles County Arboretum and Botanic Garden"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7495 | 7495 | 7494 | {"type": "MultiPolygon", "coordinates": [[[[-118.04992, 34.14679], [-118.04988, 34.14762], [-118.04982, 34.14767], [-118.04973, 34.14766], [-118.04973, 34.14726], [-118.04979, 34.14685], [-118.04979, 34.14674], [-118.04988, 34.14675], [-118.04992, 34.14679]]], [[[-118.04986, 34.14788], [-118.04984, 34.14816], [-118.04978, 34.14822], [-118.04973, 34.14822], [-118.04973, 34.14783], [-118.04979, 34.14783], [-118.04986, 34.14788]]], [[[-118.04998, 34.14568], [-118.04994, 34.14653], [-118.04989, 34.14658], [-118.0498, 34.14658], [-118.04977, 34.14608], [-118.04978, 34.14566], [-118.04993, 34.14565], [-118.04998, 34.14568]]], [[[-118.05004, 34.14442], [-118.04998, 34.14468], [-118.04994, 34.14545], [-118.04993, 34.14547], [-118.04991, 34.14548], [-118.04979, 34.14549], [-118.04993, 34.14439], [-118.05002, 34.14438], [-118.05004, 34.14442]]], [[[-118.05029, 34.1438], [-118.05012, 34.14417], [-118.05005, 34.1442], [-118.04996, 34.14422], [-118.05001, 34.14381], [-118.05029, 34.1438]]], [[[-118.05974, 34.13901], [-118.05967, 34.13975], [-118.05951, 34.14012], [-118.05927, 34.14038], [-118.0589, 34.1405], [-118.05812, 34.1406], [-118.05819, 34.14104], [-118.05804, 34.14108], [-118.05786, 34.14117], [-118.05774, 34.14128], [-118.05766, 34.1414], [-118.05759, 34.14158], [-118.05759, 34.14174], [-118.05763, 34.14186], [-118.05782, 34.14226], [-118.05785, 34.14243], [-118.05785, 34.14257], [-118.05781, 34.14278], [-118.0576, 34.14329], [-118.05758, 34.14331], [-118.05754, 34.14332], [-118.0573, 34.14328], [-118.05716, 34.14324], [-118.05706, 34.1432], [-118.05681, 34.14303], [-118.05658, 34.14293], [-118.05641, 34.14289], [-118.05516, 34.14273], [-118.05515, 34.14274], [-118.05515, 34.14289], [-118.0544, 34.14289], [-118.0543, 34.14387], [-118.05444, 34.14471], [-118.05447, 34.14526], [-118.05439, 34.14819], [-118.0508, 34.14821], [-118.05078, 34.14817], [-118.05077, 34.14742], [-118.05073, 34.14735], [-118.05067, 34.1473], [-118.05059, 34.14726], [-118.0505, 34.14726], [-118.05046, 34.14725], [-118.05043, 34.14721], [-118.05031, 34.14637], [-118.0503, 34.14624], [-118.05029, 34.14493], [-118.05033, 34.14461], [-118.0504, 34.14434], [-118.0506, 34.14388], [-118.0517, 34.14223], [-118.05192, 34.14177], [-118.05194, 34.14171], [-118.05192, 34.14155], [-118.05192, 34.14131], [-118.05194, 34.14102], [-118.05204, 34.14065], [-118.05222, 34.14024], [-118.05232, 34.14007], [-118.05255, 34.13977], [-118.0527, 34.13977], [-118.05392, 34.1382], [-118.05451, 34.13836], [-118.05405, 34.13914], [-118.05402, 34.13976], [-118.05508, 34.13974], [-118.05572, 34.13884], [-118.05718, 34.13844], [-118.05758, 34.13835], [-118.05797, 34.13829], [-118.0586, 34.13831], [-118.05898, 34.13839], [-118.05934, 34.13852], [-118.05959, 34.13874], [-118.05974, 34.13901]], [[-118.05182, 34.14799], [-118.05182, 34.14811], [-118.05192, 34.14812], [-118.05191, 34.148], [-118.05182, 34.14799]]]]} | Open Access 1 | 7017 | Los Angeles County Arboretum and Botanic Garden | 32488 | 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 | 120.875 | Los Angeles County Arboretum and Botanic Garden | 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]);