superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, MNG_AGENCY = 713, MNG_AG_LEV = 3 and MNG_AG_TYP = 8
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- County Agency - Other · 2 ✖
MNG_AGENCY 1
- Los Angeles Department of Public Works, County of · 2 ✖
ACCESS_TYP 1
- Open Access · 2 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1109 | 1109 | 1108 | {"type": "Polygon", "coordinates": [[[-118.20389, 33.83208], [-118.20324, 33.83744], [-118.20316, 33.83872], [-118.20316, 33.83916], [-118.20311, 33.8393], [-118.20288, 33.84212], [-118.20281, 33.84232], [-118.20272, 33.84362], [-118.20264, 33.84403], [-118.20264, 33.84624], [-118.20261, 33.84653], [-118.20155, 33.84653], [-118.20155, 33.84626], [-118.20186, 33.84297], [-118.20215, 33.83915], [-118.20219, 33.83906], [-118.2025, 33.83476], [-118.2025, 33.83437], [-118.20269, 33.83211], [-118.20269, 33.83186], [-118.20277, 33.83167], [-118.20294, 33.83065], [-118.20296, 33.83039], [-118.20389, 33.83208]]]} | Open Access 1 | Dominguez Gap Wetlands | 32867 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | http://dpw.lacounty.gov/ | County 3 | 39.282 | Dominguez Gap Wetlands | 2008 | |
12743 | 12743 | 12742 | {"type": "MultiPolygon", "coordinates": [[[[-118.09001, 33.80323], [-118.08973, 33.80323], [-118.08972, 33.80318], [-118.08943, 33.79703], [-118.0896, 33.79703], [-118.08976, 33.79762], [-118.09001, 33.80323]]], [[[-118.09035, 33.80941], [-118.09002, 33.8094], [-118.08982, 33.80517], [-118.09014, 33.80517], [-118.09035, 33.80941]]], [[[-118.09387, 33.78866], [-118.09152, 33.79346], [-118.09128, 33.7941], [-118.09112, 33.79469], [-118.09104, 33.7952], [-118.09101, 33.79591], [-118.0914, 33.80399], [-118.09119, 33.80398], [-118.09109, 33.80402], [-118.09108, 33.80406], [-118.09077, 33.80406], [-118.09035, 33.79591], [-118.09068, 33.79589], [-118.09069, 33.79548], [-118.09072, 33.79515], [-118.09082, 33.79456], [-118.0909, 33.79422], [-118.091, 33.79389], [-118.09124, 33.79331], [-118.09351, 33.78865], [-118.09387, 33.78866]]], [[[-118.09172, 33.81023], [-118.09119, 33.81024], [-118.09091, 33.80678], [-118.09078, 33.80436], [-118.09109, 33.80437], [-118.0911, 33.80441], [-118.09119, 33.80445], [-118.09143, 33.80444], [-118.09172, 33.81023]]], [[[-118.09413, 33.83158], [-118.09346, 33.83146], [-118.093, 33.82842], [-118.09369, 33.82863], [-118.09413, 33.83158]]]]} | Open Access 1 | San Gabriel River Trail | 29917 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | http://dpw.lacounty.gov/ | County 3 | 41.912 | San Gabriel River Trail |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);