units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where AGNCY_LEV = 2, DES_TP = 3 and MNG_AGENCY = 301
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7159 | 7159 | 7158 | {"type": "MultiPolygon", "coordinates": [[[[-117.77221, 34.13306], [-117.77221, 34.13324], [-117.77211, 34.13356], [-117.77199, 34.13387], [-117.77147, 34.13453], [-117.77144, 34.13453], [-117.77106, 34.13558], [-117.77083, 34.13559], [-117.77075, 34.13557], [-117.77064, 34.13557], [-117.7707, 34.13539], [-117.77056, 34.13527], [-117.77048, 34.13527], [-117.77044, 34.13515], [-117.77044, 34.13508], [-117.77048, 34.13506], [-117.77053, 34.13491], [-117.77062, 34.13487], [-117.77066, 34.13483], [-117.77072, 34.13462], [-117.77075, 34.13458], [-117.77078, 34.13457], [-117.77081, 34.13449], [-117.77074, 34.1344], [-117.77074, 34.13433], [-117.77078, 34.13433], [-117.77081, 34.13424], [-117.77087, 34.13416], [-117.77087, 34.13376], [-117.77093, 34.13359], [-117.77095, 34.13359], [-117.771, 34.13348], [-117.77105, 34.13345], [-117.77107, 34.13328], [-117.77104, 34.13309], [-117.7711, 34.13311], [-117.77112, 34.13322], [-117.77112, 34.13338], [-117.7711, 34.13349], [-117.77104, 34.13363], [-117.77104, 34.13371], [-117.77099, 34.13373], [-117.771, 34.13414], [-117.77115, 34.13422], [-117.77152, 34.13381], [-117.77164, 34.13364], [-117.77173, 34.13324], [-117.77173, 34.13311], [-117.7713, 34.13309], [-117.77134, 34.13306], [-117.77221, 34.13306]]], [[[-117.77094, 34.13575], [-117.77088, 34.13603], [-117.77047, 34.13603], [-117.77055, 34.13594], [-117.77059, 34.13583], [-117.7706, 34.13579], [-117.77055, 34.13577], [-117.77057, 34.13573], [-117.77094, 34.13575]]], [[[-117.77532, 34.12952], [-117.7753, 34.12981], [-117.77523, 34.13014], [-117.7752, 34.13035], [-117.77512, 34.1306], [-117.77506, 34.13074], [-117.77496, 34.13091], [-117.77482, 34.1311], [-117.77468, 34.13124], [-117.7744, 34.13145], [-117.77412, 34.1316], [-117.77371, 34.13174], [-117.77341, 34.1318], [-117.77291, 34.13194], [-117.77277, 34.13205], [-117.77272, 34.13214], [-117.77258, 34.13247], [-117.77255, 34.13267], [-117.77249, 34.1329], [-117.77194, 34.13289], [-117.77195, 34.13261], [-117.77202, 34.1325], [-117.77206, 34.13233], [-117.77223, 34.13201], [-117.77235, 34.13184], [-117.7725, 34.13168], [-117.77294, 34.13157], [-117.77298, 34.13159], [-117.77317, 34.13155], [-117.77318, 34.13157], [-117.77341, 34.13152], [-117.77359, 34.13141], [-117.77381, 34.13135], [-117.77401, 34.13126], [-117.77404, 34.13127], [-117.77423, 34.13116], [-117.7744, 34.13103], [-117.77454, 34.13088], [-117.77466, 34.13073], [-117.77482, 34.1304], [-117.77487, 34.13007], [-117.77495, 34.12977], [-117.77497, 34.12944], [-117.77516, 34.12946], [-117.77532, 34.12952]]]]} | Open Access 1 | 6800 | Marshall Creek Open Space | 21896 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 9.299 | Marshall Creek OS | 0 | Local Recreation Area 3 | 4 | |
8174 | 8174 | 8173 | {"type": "Polygon", "coordinates": [[[-117.7567, 34.1363], [-117.75656, 34.13663], [-117.75034, 34.13666], [-117.75036, 34.13633], [-117.7567, 34.1363]]]} | No Public Access 3 | 12354 | Live Oak Reservoir | 21375 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 5.291 | Live Oak Reservoir | 0 | Local Recreation Area 3 | 4 | |
16050 | 16050 | 16049 | {"type": "Polygon", "coordinates": [[[-117.75625, 34.14581], [-117.75608, 34.14612], [-117.75606, 34.1465], [-117.7559, 34.14671], [-117.75581, 34.14696], [-117.75576, 34.14718], [-117.75548, 34.14745], [-117.75534, 34.14782], [-117.75531, 34.14803], [-117.75533, 34.14808], [-117.7552, 34.14819], [-117.75524, 34.1484], [-117.75505, 34.14856], [-117.75487, 34.14857], [-117.75472, 34.14875], [-117.75482, 34.14892], [-117.75468, 34.1491], [-117.75476, 34.1493], [-117.75475, 34.14939], [-117.75466, 34.1496], [-117.75471, 34.14968], [-117.75464, 34.14969], [-117.75458, 34.14974], [-117.75457, 34.14983], [-117.75459, 34.14985], [-117.75438, 34.14997], [-117.75442, 34.15017], [-117.75466, 34.1503], [-117.75451, 34.15059], [-117.75447, 34.15064], [-117.75451, 34.15091], [-117.75458, 34.15112], [-117.75445, 34.15137], [-117.75433, 34.15133], [-117.75407, 34.15117], [-117.75396, 34.1511], [-117.75385, 34.15099], [-117.75392, 34.15094], [-117.75395, 34.15081], [-117.75387, 34.15066], [-117.75382, 34.1506], [-117.75382, 34.15048], [-117.75378, 34.15044], [-117.75373, 34.15045], [-117.75362, 34.15056], [-117.7536, 34.15065], [-117.75345, 34.1507], [-117.75345, 34.15073], [-117.75327, 34.1507], [-117.75307, 34.15074], [-117.75289, 34.15083], [-117.75266, 34.15101], [-117.7525, 34.15106], [-117.75235, 34.15105], [-117.75196, 34.15096], [-117.75076, 34.15095], [-117.75079, 34.15093], [-117.75273, 34.15092], [-117.75483, 34.1482], [-117.75553, 34.14714], [-117.75565, 34.14638], [-117.75574, 34.14624], [-117.75582, 34.1461], [-117.75587, 34.14597], [-117.75591, 34.14577], [-117.75625, 34.14581]]]} | Open Access 1 | 6792 | Lowell Brandt Open Space | 21554 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 8.271 | Lowell Brandt 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]);