NTerpo

Keybase proof

I hereby claim:

• I am nterpo on github.
• I am terpo (https://keybase.io/terpo) on keybase.
• I have a public key whose fingerprint is 8815 4DFE 4B39 31D2 8701 2A5B 73E1 F0BE 82D6 5F1D

To claim this, I am signing this object:

NTerpo

- DL data as GeoJSON from ODS
- $ ogr2ogr -f "ESRI Shapefile" foo.shp foo.geojson OGRGeoJSON
- $ shp2pgsql foo.shp foo > foo.sql
- $ createdb gp
- $ psql -d gp
- gp=# CREATE EXTENSION postgis;
- $ psql -f foo.sql -d gp
- gp=# create table merged as
	select id, ST_Union(geom)
	from foo

NTerpo

# Change extension for txt files to csv files
$ for f in *.txt
do
	[ -f "$f" ] && mv "$f" "${f%txt}csv"
done

# Remove first line every csv files
$ for f in *.csv
do
	[ -f "$f" ] && awk '{if (NR==1 || NR==2) next};1' "$f" >> "clean_$f"

NTerpo

User-agent: Twitterbot
Disallow:

User-agent: *
Disallow: /logout
Disallow: /login
Disallow: /publish
Disallow: /explore/dataset/*/download/
Disallow: /explore/dataset/*/rss/
Disallow: /explore/dataset/*/atom/

NTerpo

<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
	<url>
		<loc>http://opendata.paris.fr/explore/dataset/liste_des_sites_des_hotspots_paris_wifi/</loc>
		<lastmod>2014-06-16</lastmod>
	</url>
	<url>
		<loc>http://opendata.paris.fr/explore/dataset/points-de-vote-du-budget-participatif/</loc>
		<lastmod>2014-09-24</lastmod>
	</url>

NTerpo

{
"language": "en",
"name": "Paris Data",
"description": "City of Paris Open Data portal",
"url": "http://opendata.paris.fr/",
"linked_portals": ["http://data.gouv.fr", "http://data.iledefrance.fr"],
"data_language": ["fr"],
"modified": "2016-03-04T13:44:44+00:00",
"themes": ["Culture, Heritage", "Education, Training, Research, Teaching", "Environment", "Transport, Movements", "Spatial Planning, Town Planning, Buildings, Equipment, Housing", "Health", "Economy, Business, SME, Economic development, Employment", "Services, Social", "Administration, Government, Public finances, Citizenship", "Justice, Safety, Police, Crime", "Sports, Leisure", "Accommodation, Hospitality Industry"],
"links": [

NTerpo

$ git clone https://github.com/opensdmx/rsdmx.git
$ R

> install.packages("path/to/rsdmx", repos=NULL, type="source")
> packageVersion("rsdmx")
[1] ‘0.5.2’
> library(rsdmx)

> ulc.data <- readSDMX(file = "http://stats.oecd.org/restsdmx/sdmx.ashx/GetData/PDBI_I4/AUS+AUT+BEL+CAN+CHL+CZE+DNK+EST+FIN+FRA+DEU+GRC+HUN+IRL+ISR+ITA+JPN+KOR+LUX+MEX+NLD+NZL+NOR+POL+PRT+SVK+SVN+ESP+SWE+CHE+GBR+USA+EA19+EU28+NMEC+LVA+LTU+ZAF.I4_ANA_GVAHRS+I4_ANA_ULCH+I4_ANA_LCHRS.GRW+AVGRW.A_U+BNEXCL+B_E+BDE+C+F+GNEXCL+G_I+J+K+MN/all?startTime=2001&endTime=2015")
> ulc.dsd <- readSDMX(file = "http://stats.oecd.org/restsdmx/sdmx.ashx/GetDataStructure/PDBI_I4")

NTerpo

SELECT ?PermID ?hasPermId ?rank ?prefLabel ?hasReportedTitle ?hasHolder ?hasPositionType ?hasPublicationStatus ?isPositionIn ?to ?familyName ?givenName ?holdsPosition ?hasTenureInOrganization ?additionalName ?hasGender ?bday ?honorificPrefix ?from ?hasQualification ?preferredName ?honorificSuffix ?withDegree ?fromInstitutionName ?inSubject ?isTenureIn ?dateOfDeath
WHERE { OPTIONAL { ?PermID <http://permid.org/ontology/common/hasPermId> ?hasPermId }
        OPTIONAL { ?PermID <http://permid.org/ontology/person/rank> ?rank }
        OPTIONAL { ?PermID <http://www.w3.org/2004/02/skos/core#prefLabel> ?prefLabel }
        OPTIONAL { ?PermID <http://permid.org/ontology/person/hasReportedTitle> ?hasReportedTitle }
        OPTIONAL { ?PermID <http://permid.org/ontology/person/hasHolder> ?hasHolder }
        OPTIONAL { ?PermID <http://permid.org/ontology/person/hasPositionType> ?hasPositionType }
        OPTIONAL { ?PermID <http://permid.org/ontology/common/hasPublicationStatus> ?hasPublicationStatus }
        OPTIONA

NTerpo

<div class="container-fluid">
    <div class="the-map">
        <h1>
            The map!
        </h1>
        <div class="ods-box">
            <ods-dataset-context context="topmillionwebsites" 
                                 topmillionwebsites-dataset="top-million-websites">
                <ods-map no-refit="true" 
                         display-control="true" 

NTerpo

<iframe frameborder="0" height="600" width="100%" src="https://data.opendatasoft.com/map/rsf_2017/?headless=true"></iframe>