units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 2, MNG_AG_TYP = 6 and SUID_NMA = 29636
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8512 | 8512 | 8511 | {"type": "MultiPolygon", "coordinates": [[[[-118.70449, 34.1163], [-118.69795, 34.11629], [-118.69794, 34.11445], [-118.70447, 34.11447], [-118.70449, 34.1163]]], [[[-118.69354, 34.12177], [-118.69136, 34.12176], [-118.69137, 34.1236], [-118.68938, 34.1236], [-118.68937, 34.11812], [-118.69352, 34.11812], [-118.69354, 34.12177]]], [[[-118.68074, 34.12528], [-118.68518, 34.12542], [-118.685, 34.12897], [-118.68922, 34.12902], [-118.68924, 34.13091], [-118.69359, 34.1309], [-118.69363, 34.13714], [-118.69804, 34.13714], [-118.69804, 34.13996], [-118.69384, 34.13998], [-118.69113, 34.13996], [-118.69113, 34.14309], [-118.6952, 34.14496], [-118.69662, 34.14494], [-118.69663, 34.14628], [-118.69651, 34.14647], [-118.69664, 34.14654], [-118.69664, 34.14734], [-118.69382, 34.14736], [-118.69382, 34.15041], [-118.69227, 34.15019], [-118.6918, 34.15036], [-118.68988, 34.15021], [-118.68977, 34.15006], [-118.68971, 34.15009], [-118.68968, 34.15019], [-118.68778, 34.15004], [-118.68661, 34.15015], [-118.68629, 34.15012], [-118.68567, 34.15025], [-118.68542, 34.15035], [-118.68465, 34.15048], [-118.68361, 34.15049], [-118.68322, 34.15071], [-118.68182, 34.15081], [-118.67986, 34.15054], [-118.67878, 34.15063], [-118.67784, 34.1503], [-118.67788, 34.15018], [-118.67531, 34.14908], [-118.67462, 34.14899], [-118.67429, 34.149], [-118.67356, 34.14872], [-118.67344, 34.14872], [-118.67331, 34.14846], [-118.67302, 34.14727], [-118.66786, 34.14728], [-118.66785, 34.14511], [-118.66834, 34.14492], [-118.6682, 34.14511], [-118.6682, 34.14538], [-118.6691, 34.14538], [-118.66942, 34.14478], [-118.66915, 34.14462], [-118.6704, 34.14415], [-118.67396, 34.14377], [-118.67382, 34.1431], [-118.67398, 34.14279], [-118.67428, 34.14252], [-118.6744, 34.14255], [-118.67479, 34.14234], [-118.67556, 34.14217], [-118.67589, 34.14213], [-118.67624, 34.14213], [-118.67661, 34.14217], [-118.67777, 34.14294], [-118.67756, 34.14382], [-118.6791, 34.14465], [-118.68036, 34.14508], [-118.68116, 34.14509], [-118.68153, 34.14463], [-118.68034, 34.14422], [-118.68018, 34.14369], [-118.68033, 34.14297], [-118.68161, 34.1419], [-118.68378, 34.14189], [-118.68382, 34.14108], [-118.6833, 34.14041], [-118.68364, 34.13962], [-118.68423, 34.13904], [-118.68452, 34.13885], [-118.68574, 34.13815], [-118.68629, 34.13815], [-118.68647, 34.13803], [-118.68572, 34.13734], [-118.6858, 34.1371], [-118.68602, 34.1358], [-118.68603, 34.13564], [-118.68603, 34.13547], [-118.68597, 34.13524], [-118.68589, 34.13507], [-118.68573, 34.13483], [-118.68556, 34.13467], [-118.68534, 34.13382], [-118.68469, 34.13369], [-118.68349, 34.1336], [-118.68246, 34.1332], [-118.68129, 34.13308], [-118.67984, 34.13266], [-118.67977, 34.13234], [-118.67941, 34.13104], [-118.68037, 34.13085], [-118.68037, 34.12903], [-118.67854, 34.12894], [-118.67847, 34.12882], [-118.67717, 34.12756], [-118.67547, 34.1271], [-118.67451, 34.1267], [-118.67363, 34.12644], [-118.67317, 34.12526], [-118.68074, 34.12528]], [[-118.68684, 34.13625], [-118.68683, 34.13626], [-118.68685, 34.13691], [-118.68932, 34.13692], [-118.6893, 34.13627], [-118.68684, 34.13625]], [[-118.68815, 34.13579], [-118.68815, 34.13541], [-118.68793, 34.13541], [-118.68757, 34.1353], [-118.68749, 34.13535], [-118.68767, 34.13551], [-118.68775, 34.13579], [-118.68815, 34.13579]]]]} | Open Access 1 | 13362 | Las Virgenes View Park | 29636 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 939.459 | Las Virgenes View 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]);