Git Product home page Git Product logo

fusion-tables-drive-export's Introduction

Fusion Tables Drive Export

Description

Export Google Fusion Tables to Google Drive.

Links

Team

Development

Prerequisites

Make sure you have the following tools installed:

  • git
  • yarn

Installation

After cloning the repository, install all dependencies:

yarn # install dependencies

Install the Google Cloud SDK and initialize it by running:

gcloud init

Configuration

Setup the gcloud to your project ID like this:

gcloud config set project my-project-id

Define the visualizer url in an environment variable called VISUALIZER_BASE_URI like this:

export VISUALIZER_BASE_URI="https://visualizer.my-domain.com"

Setup Google Analytics and store your key in an environment variable called GOOGLE_ANALYTICS_KEY:

export GOOGLE_ANALYTICS_KEY="UA-XXXXXXXXX-X"

Define a secret key SECRET_KEY to create secure hashes for the log and progress:

export SECRET_KEY="my-secret-key"

Define two cookie keys COOKIE_KEY_1 and COOKIE_KEY_2 to create secure cookies:

export COOKIE_KEY_1="my-secret-key"
export COOKIE_KEY_2="my-secret-key"

To help with environment variable handling on a project level, check out direnv.

APIs

Various APIs are needed for this project to run. Enable the Fusion Tables API, the Drive API and the Sheets API in your Google Cloud Console. Those are needed to read Fusiontables from a user account and to store the export in Google Drive including an index sheet listing all exports. StackDriver needs to be activated for Error Reporting in the same Google Cloud Project.

Server credentials

You’ll need some credentials for OAuth2. Go to the Credentials page in your Google Cloud Project in the Google Cloud Console. Create some server side credentials with http://localhost:3000/auth/callback and https://YOUR_DOMAIN/auth/callback as the authorized redirect URIs. Download the credentials as a JSON file and save it as ./server-src/config/credentials.json.

Also, create some server credentials with the role Owner to use the Datastore during development. Download the corresponding JSON file and save it in the ./server-src/config/ folder. Store the path to that file in an env called GOOGLE_APPLICATION_CREDENTIALS. To setup the database index, run the following once before starting the project:

yarn run deploy:datastore-indexes

Develop

Run the following command to start the server on localhost:

yarn run start:dev # start the server

Deploy

Run the following command to deploy the application:

yarn run deploy

Hosting

The project is hosted at AppEngine

fusion-tables-drive-export's People

Contributors

donmccurdy avatar hundekoerper avatar pmast avatar ro-ka avatar russellquong avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar

fusion-tables-drive-export's Issues

Carry column name over to visualiser

The exporter has a more elaborate recognition of geometry columns. It tries to parse the fields of the first row. When found a valid KML or GeoJSON it accepts that as the geometry column.

This information is however lost on the way to the visualiser. That should not happen.

I URL field could do the trick.

But beware, and check how this behaves in relation with data driven styling.

Request entity not found

Exporting one or many fusion tables returns an error:

"Error! Requested entity was not found."

Reported by @briandavidthom

I have experienced the same issue. It does not depend on different tables. All tables are covered.
It happens after a long spinner, not our regular progress screen.
My guess is that has to do with the fusion tables API or the drive API.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.