units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Peacock Ridge OS" and MNG_AGENCY = 310
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16075 | 16075 | 16074 | {"type": "MultiPolygon", "coordinates": [[[[-118.71979, 34.12897], [-118.71548, 34.12899], [-118.71547, 34.13256], [-118.71514, 34.13263], [-118.71507, 34.13267], [-118.71503, 34.13274], [-118.715, 34.13297], [-118.71496, 34.13302], [-118.71475, 34.13273], [-118.71425, 34.13298], [-118.71417, 34.13283], [-118.71413, 34.13269], [-118.7141, 34.13232], [-118.71406, 34.13221], [-118.714, 34.13213], [-118.71344, 34.1315], [-118.71338, 34.13142], [-118.71331, 34.13103], [-118.71321, 34.13074], [-118.71302, 34.13042], [-118.71298, 34.13032], [-118.71296, 34.13015], [-118.71289, 34.13002], [-118.71278, 34.1299], [-118.7127, 34.12984], [-118.71271, 34.12982], [-118.71254, 34.12969], [-118.7127, 34.12948], [-118.71271, 34.12922], [-118.71267, 34.12909], [-118.71231, 34.12877], [-118.71172, 34.12863], [-118.71103, 34.12873], [-118.71054, 34.12934], [-118.70999, 34.12975], [-118.70985, 34.12963], [-118.70997, 34.12953], [-118.71001, 34.1294], [-118.70961, 34.12889], [-118.70947, 34.12883], [-118.70951, 34.1285], [-118.70944, 34.12839], [-118.70912, 34.12825], [-118.70873, 34.12831], [-118.70855, 34.12837], [-118.70831, 34.12829], [-118.70813, 34.12834], [-118.708, 34.12805], [-118.70783, 34.12774], [-118.70902, 34.12689], [-118.709, 34.12542], [-118.71978, 34.12534], [-118.71979, 34.12897]]], [[[-118.7178, 34.13575], [-118.7178, 34.13628], [-118.71547, 34.13628], [-118.71547, 34.13606], [-118.71507, 34.13586], [-118.71473, 34.13593], [-118.71416, 34.13558], [-118.71308, 34.13561], [-118.7138, 34.13422], [-118.71378, 34.13376], [-118.71412, 34.13356], [-118.71397, 34.13312], [-118.71351, 34.13282], [-118.71318, 34.13314], [-118.71281, 34.13297], [-118.7128, 34.13258], [-118.71263, 34.13227], [-118.71233, 34.13206], [-118.71208, 34.13165], [-118.71215, 34.1309], [-118.71205, 34.13064], [-118.71232, 34.12982], [-118.71261, 34.12992], [-118.71265, 34.12989], [-118.71279, 34.13003], [-118.71286, 34.13013], [-118.71293, 34.13042], [-118.71313, 34.13076], [-118.71322, 34.13101], [-118.7133, 34.13142], [-118.71339, 34.13156], [-118.71397, 34.13222], [-118.71401, 34.1323], [-118.71405, 34.13272], [-118.71414, 34.13296], [-118.7142, 34.13306], [-118.71467, 34.13371], [-118.71531, 34.13439], [-118.7154, 34.13444], [-118.71553, 34.13445], [-118.7159, 34.13432], [-118.71609, 34.13432], [-118.71641, 34.13445], [-118.71684, 34.13452], [-118.71721, 34.13467], [-118.71727, 34.13504], [-118.71738, 34.13531], [-118.71747, 34.13545], [-118.71756, 34.13555], [-118.7178, 34.13575]]], [[[-118.71982, 34.13261], [-118.7198, 34.13628], [-118.71846, 34.13628], [-118.71846, 34.13573], [-118.7179, 34.13573], [-118.71764, 34.13553], [-118.71749, 34.13534], [-118.71738, 34.13513], [-118.71733, 34.1349], [-118.71731, 34.13469], [-118.71726, 34.13462], [-118.71689, 34.13446], [-118.71671, 34.13442], [-118.71656, 34.13441], [-118.71638, 34.13437], [-118.71612, 34.13425], [-118.71594, 34.13425], [-118.71576, 34.13429], [-118.71569, 34.13415], [-118.71543, 34.13425], [-118.71549, 34.13439], [-118.71541, 34.13437], [-118.71473, 34.13367], [-118.71524, 34.13342], [-118.715, 34.13307], [-118.71505, 34.133], [-118.71507, 34.13294], [-118.7151, 34.13272], [-118.71515, 34.13269], [-118.71544, 34.13262], [-118.71982, 34.13261]]]]} | Open Access 1 | 7097 | Peacock Ridge Open Space | 23545 | 1040 | Calabasas, City of 313 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation.html | City 2 | 1040 | Calabasas, City of 310 | City 2 | City Agency 2 | Los Angeles 6 | 180.231 | Peacock Ridge OS | 0 | Local Recreation Area 3 | 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]);