Jorge Sanz jsanz

## index.html
<!DOCTYPE html>
<html lang="en">

<head>
    <title>CARTO VL: Switch the basemap</title>

    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=5.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <link rel="shortcut icon" href="https://carto.com/favicon.ico">

## pgdump+copy.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jsanz
                / pgdump+copy.md
            
            
              Last active
              April 24, 2019 18:14
            
              
                CARTO new COPY endpoint & ogr2ogr
              
          
    These are the steps to test the new CARTO COPY endpoint (more details here and here.

Downloaded a Brooklyn PLUTO shapefile from here as a data testing example.
Generated a 1 row dataset to upload to CARTO the definition of the shapefile
Uploaded it to CARTO using normal Import API (with a client I have for convenience)
Removed the row
Converted the original shapefile into a PGDump file
Generated the COPY command using the third line of  bkmappluto.txt
Removed first 4 and last 2 lines of the resulting $file.
Encoding the COPY command to be used on a URL, I run curl command to upload the dataset


## README.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jsanz
                / README.md
            
            
              Last active
              April 22, 2019 16:57
            
              
                Python: word cloud of FOSS4G 2019 submissions
              
          
    Notebook available at:
https://nbviewer.jupyter.org/gist/jsanz/22de75a321475485219d67a3740193f5
# coding: utf-8

# # Processing FOSS4G 2019 abstracts submitted

  
## ovafix.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              3 stars
            
          
                jsanz
                / ovafix.md
            
            
              Last active
              January 10, 2019 14:03
            
              
                Making a OVA file compatible with VMWare
              
          
    This is a recipe to fix this error when importing to VMWare an OVA file:

Download and install OVFTool (https://www.vmware.com/support/developer/ovf/)
Convert OVA to VMX using the command below (this will create example.vmx)
$ ovftool example.ova example.vmx


## index.html
<!DOCTYPE html>
<html lang="en">

<head>
    <title>CARTO VL: Selection by polygon example</title>

    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=5.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <link rel="shortcut icon" href="https://carto.com/favicon.ico">

## index.html
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=5.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <link rel="stylesheet" href="https://libs.cartocdn.com/airship-style/v1.0.3/airship.css">
    <script src="https://libs.cartocdn.com/airship-components/v1.0.3/airship.js"></script>
    <script src="https://libs.cartocdn.com/carto-vl/v1.0.0/carto-vl.min.js"></script>
    <script src="https://api.tiles.mapbox.com/mapbox-gl-js/v0.50.0/mapbox-gl.js"></script>

## .gitignore
*.carto

## README.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                jsanz
                / README.md
            
            
              Last active
              November 19, 2018 09:33
            
              
                14.000km to Dubai
              
          
    14.0000km to Dubai

This SQL is an experiment to play with Postgis ST_LineInterpolatePoint function and other SQL tricks to generate a points dataset that travels from a starting point in Dubai to several cities all over the world and under a distance similar the coverage of a long distance flight (between 14 an 15 thousand kilometres).
This SQL is the main part of this CartoDB Visualization.

The SQL is separated in several dataset constructions using the WITHclause so the approach is:

  
## index.html
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="UTF-8">
    <title>CARTO.js App</title>
    <link href="https://fonts.googleapis.com/css?family=Fira+Sans:200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">
    <!-- Include Leaflet 1.2.0 Library -->
    <link rel="stylesheet" href="https://unpkg.com/leaflet@1.2.0/dist/leaflet.css" />
    <script src="https://unpkg.com/leaflet@1.2.0/dist/leaflet.js"></script>
    <!-- Include cartodb.js Library -->

## app.css
* {
  margin: 0;
  padding: 0;
  box-sizing: border-box;
}
a {
  text-decoration: none;
  color: #4285F4;
}
.map {
	<!DOCTYPE html>
	<html lang="en">

	<head>
	<title>CARTO VL: Switch the basemap</title>

	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=5.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">
	<link rel="shortcut icon" href="https://carto.com/favicon.ico">
	* {
	margin: 0;
	padding: 0;
	box-sizing: border-box;
	}
	a {
	text-decoration: none;
	color: #4285F4;
	}
	.map {