Trying to extract city data of city lights location?

Question

Here is a website: http://geodesy.net/webmaps/milpitas/gedit2/gedit.htm?map=base

I believe they are using Google Map API and Fusion Table(deprecated 2016).

I just wanted to extract the data to a text format.

Answer 1

If you inspect the source of the site you linked to, you can see they send a query off to an address, and this returns IDs of four Google Fusion Tables (column 3 in the rows array of the result). Three of them work, see below:

• Easement boundaries
• Street Lights
• Hydrants

Please ensure that you use the data under the license that the city releases the data under. The fact that you can access the data doesn't mean that it's freely available!