superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 301, MNG_AG_TYP = 2 and PARK_NAME = "Marshall Creek Open Space"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14899 | 14899 | 14898 | {"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.13454], [-117.77106, 34.13558], [-117.77083, 34.13559], [-117.77075, 34.13557], [-117.77064, 34.13557], [-117.77069, 34.13539], [-117.77056, 34.13528], [-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.1345], [-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.77096, 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.13413], [-117.77115, 34.13422], [-117.77152, 34.13381], [-117.77163, 34.13365], [-117.77173, 34.13325], [-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.13036], [-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.77278, 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.13249], [-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.77319, 34.13156], [-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 | Marshall Creek Open Space | 21896 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 9.309 | Marshall Creek OS |
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]);