superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 6 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11070 | 11070 | 11069 | {"type": "Polygon", "coordinates": [[[-117.71629, 34.09672], [-117.71629, 34.09699], [-117.71572, 34.09699], [-117.71572, 34.09672], [-117.71629, 34.09672]]]} | Open Access 1 | Shelton Park | 29626 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 0.393 | Shelton Park | ||
10169 | 10169 | 10168 | {"type": "MultiPolygon", "coordinates": [[[[-117.71952, 34.13049], [-117.7186, 34.1311], [-117.71847, 34.13118], [-117.71945, 34.13043], [-117.71952, 34.13049]]], [[[-117.72709, 34.13638], [-117.72444, 34.13638], [-117.72444, 34.13638], [-117.72445, 34.13619], [-117.72708, 34.13622], [-117.72709, 34.13638]]]]} | Open Access 1 | Sycamore Canyon Park | 26118 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1.302 | Sycamore Canyon Park | ||
10334 | 10334 | 10333 | {"type": "MultiPolygon", "coordinates": [[[[-117.72891, 34.12757], [-117.72854, 34.12771], [-117.72573, 34.12824], [-117.72463, 34.1285], [-117.72352, 34.1287], [-117.72259, 34.1289], [-117.72174, 34.12905], [-117.72157, 34.12909], [-117.72122, 34.12922], [-117.72087, 34.12946], [-117.71954, 34.13056], [-117.71947, 34.13066], [-117.7185, 34.13148], [-117.71821, 34.13175], [-117.71794, 34.13203], [-117.71746, 34.13263], [-117.71717, 34.13305], [-117.71697, 34.1334], [-117.7168, 34.13373], [-117.71625, 34.13511], [-117.71615, 34.1353], [-117.71595, 34.13554], [-117.71577, 34.1358], [-117.71507, 34.1364], [-117.71464, 34.13672], [-117.71093, 34.13672], [-117.7074, 34.13893], [-117.70739, 34.13852], [-117.71081, 34.1364], [-117.71492, 34.13639], [-117.71578, 34.13566], [-117.71579, 34.13424], [-117.71646, 34.13422], [-117.71683, 34.13329], [-117.71766, 34.13222], [-117.71759, 34.1322], [-117.71847, 34.13118], [-117.71951, 34.1305], [-117.71951, 34.13048], [-117.71946, 34.13043], [-117.72071, 34.12947], [-117.7207, 34.12946], [-117.72024, 34.12935], [-117.72021, 34.12924], [-117.72022, 34.129], [-117.72018, 34.12899], [-117.72019, 34.12883], [-117.72034, 34.12884], [-117.72036, 34.12876], [-117.72177, 34.12877], [-117.72217, 34.12875], [-117.72474, 34.12824], [-117.72483, 34.12841], [-117.72568, 34.12815], [-117.72568, 34.12806], [-117.72615, 34.12795], [-117.72677, 34.12783], [-117.7268, 34.12777], [-117.72705, 34.12776], [-117.72889, 34.1274], [-117.72891, 34.12757]]], [[[-117.7365, 34.12352], [-117.73571, 34.12405], [-117.73539, 34.12439], [-117.73469, 34.12526], [-117.73435, 34.12552], [-117.73408, 34.12568], [-117.7337, 34.12585], [-117.7334, 34.12595], [-117.73338, 34.12598], [-117.73211, 34.12641], [-117.73188, 34.12651], [-117.73092, 34.12708], [-117.73078, 34.12708], [-117.73059, 34.1272], [-117.73017, 34.12735], [-117.73009, 34.1274], [-117.73009, 34.12746], [-117.72911, 34.12766], [-117.72911, 34.12749], [-117.72923, 34.12749], [-117.73009, 34.12731], [-117.73009, 34.12708], [-117.73036, 34.12708], [-117.7305, 34.12702], [-117.7312, 34.12658], [-117.73135, 34.12674], [-117.7317, 34.1265], [-117.73199, 34.12636], [-117.73403, 34.12566], [-117.73421, 34.12556], [-117.73458, 34.12529], [-117.73547, 34.1242], [-117.73562, 34.12406], [-117.73575, 34.12395], [-117.7365, 34.12346], [-117.7365, 34.12352]]], [[[-117.74199, 34.11776], [-117.74198, 34.11797], [-117.74194, 34.11802], [-117.74173, 34.11802], [-117.74199, 34.11776]]]]} | Open Access 1 | Thompson Creek & Trail | 26313 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 19.627 | Thompson Creek & Trail | ||
11165 | 11165 | 11164 | {"type": "Polygon", "coordinates": [[[-117.72465, 34.08661], [-117.72463, 34.08664], [-117.72459, 34.08665], [-117.72308, 34.08666], [-117.72309, 34.08499], [-117.72459, 34.08499], [-117.72463, 34.085], [-117.72465, 34.08503], [-117.72465, 34.08661]]]} | Open Access 1 | Wheeler Park | 27453 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 6.578 | Wheeler Park |
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]);