<commit_before><!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
  <meta name="description" content="<NAME> is a researcher at the Center for Spatial Research, at Columbia University. His research happens at the intersection of data, GIS, urbanism, architecture and the humanities.">
  <meta name="keywords" content="data visualization, mapping, GIS, data analysis, interactive, information, design, visualization, data mining, information design, information visualization, urban planning, architecture, humanities, center for spatial research, columbia university, gsapp, graduate school or architecture planning and preservation, humanities, new york">
  <meta name="author" content="<NAME>">
  <title>Juanfrans</title>

  <!-- Bootstrap -->
  <link href="css/bootstrap.min.css" rel="stylesheet">

  <!-- Custom styles for this template -->
  <link href="css/site-specific.css" rel="stylesheet" media="screen">

  <!-- Loading fonts from Adobe Typekit -->
  <script src="//use.typekit.net/uzk7kzt.js"></script>
  <script>try{Typekit.load();}catch(e){}</script>
  <!-- Google Analytics tracking code -->
<script>
  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,'script','https://www.google-analytics.com/analytics.js','ga');

  ga('create', 'UA-27897156-1', 'auto');
  ga('send', 'pageview');

</script>
  <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
  <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
      <![endif]-->
    </head>
    <body>

      <!-- *********** NAVBAR ************ -->
      <nav class="navbar navbar-default">
        <div class="container-fluid">
          <div class="container">
          <!-- Brand and toggle get grouped for better mobile display -->
          <div class="navbar-header">
            <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
              <span class="sr-only">Toggle navigation</span>
              <span class="icon-bar"></span>
              <span class="icon-bar"></span>
              <span class="icon-bar"></span>
            </button>
            <a class="navbar-brand" href="index.html"><NAME></a>
          </div>
          <!-- Collect the nav links, forms, and other content for toggling -->
          <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
            <ul class="nav navbar-nav navbar-right">
              <li><a href="index.html">home</a></li>
              <li><a href="projects.html">projects</a></li>
              <li class="active"><a href="about.html">about<span class="sr-only">(current)</span></a></li>
              <li><a href="news.html">news</a></li>
            </ul>
          </div><!-- /.navbar-collapse -->
        </div><!-- /.container-fluid -->
      </div>
      </nav>

      <!-- *********** REST ************* -->
      <div class="container">
        <div class="summary">
          <p>The short version is I am a researcher at the <a href="https://brown.columbia.edu/">Brown Institute for Media Innovation</a> at Columbia University.<p>
          <p>I work at the intersection of data, GIS, visualization, journalism, architecture, urbanism, and the humanities, and I teach graduate level <a href="https://github.com/juanfrans-courses">workshops and seminars</a> on mapping, advanced GIS and data visualization. In the past I've worked as a research scholar at the <a href="http://c4sr.columbia.edu/">Center for Spatial Research</a> and the <a href="http://spatialinformationdesignlab.org/">Spatial Information Design Lab</a>, as an architectural designer for <a href="http://www.cz-studio.com/">Carlos Zapata Studio</a> and D.G.T. Architects, and as the GIS project coordinator for the <a href="http://www.catholiccharitiesny.org/">Catholic Charities</a>.</p>
        </div>
        <div class="cv-section">
          <p class="intro-cv">Here's a more detailed version:</p>
          <p class="cv-subtitle">EDUCATION</p>
          <ul class="cv-list">
            <li><p class="cv-item"><b>Columbia University, Graduate School of Architecture, Planning and Preservation, New York, NY</b> - Masters in Architecture (2012) - Visual Studies Honor Award (Emphasis on Data Visualization)</p></li>
            <li><p class="cv-item"><b>Columbia University, Graduate School of Architecture, Planning and Preservation, New York, NY</b> - Masters of Science in Urban Planning (2008)</p></li>
            <li><p class="cv-item"><b>Universidad de Los Andes, Bogotá, Colombia</b> - Bachelors of Arts in Philosophy (2004)</p></li>
            <li><p class="cv-item"><b>Université de Paris IV, Sorbonne, Paris</b> - 1st Year of Deug in Philosophy (1999)</p></li>
          </ul>

          <p class="cv-subtitle">APPOINTMENTS</p>
          <ul class="cv-list">
            <li><p class="cv-item"><b>Associate Research Scholar</b> - <a href="https://brown.columbia.edu/">Brown Institute for Media Innovation</a>, Columbia University, New York, NY (2018 - Present)</p></li>
            <li><p class="cv-item"><b>Mellon Associate Research Scholar</b> - <a href="http://c4sr.columbia.edu/">Center for Spatial Research</a>, Columbia University, New York, NY (2015 - 2018)</p></li>
            <li><p class="cv-item"><b>Adjunct Assistant Professor</b> - <a href="http://www.arch.columbia.edu/">Graduate School of Architecture, Planning and Preservation</a>, Columbia University, New York, NY (2013 - Present)</p></li>
            <li><p class="cv-item"><b>Associate Research Scholar</b> - <a href="http://spatialinformationdesignlab.org/">Spatial Information Design Lab</a>, Columbia University, New York, NY (2013 - 2015)</p></li>
            <li><p class="cv-item"><b>Architectural Designer</b> - <a href="http://www.cz-studio.com/">Carlos Zapata Studio</a>, New York, NY (2012 - 2013)</p></li>
            <li><p class="cv-item"><b>GIS Project Coordinator</b> - <a href="http://catholiccharitiesny.org/">Catholic Charities, Archdioceses of New York</a>, New York, NY (2009)</p></li>
          </ul>

          <p class="cv-subtitle">PROJECTS</p>
          <ul class="cv-list">
            <li><p class="cv-item"><b><a href="http://c4sr.columbia.edu/projects/conflict-urbanism-colombia">Conflict Urbanism: Colombia</a></b> - An interactive mapping and spatial analysis project examining the Colombian conflict and its effect in the urban environment. <NAME>., <NAME>., <NAME>. (in progress).</p></li>
            <li><p class="cv-item"><b><a href="http://xpmethod.plaintext.in/embodied-space-lab/mapping-mughal-hindustan.html">Mapping Mughal Hindustan, 1500 - 1600 CE</a></b> - A scholarly and interactive mapping project which re-frames the various sites of early Mughal Hindustan as affective geography. <NAME>., <NAME>., <NAME>., <NAME>., <NAME>., 2017.</p></li>
            <li><p class="cv-item"><b><a href="https://science-surveyor.github.io/">Science Surveyor</a></b> - Context on Deadline - An interactive application providing context information for science journalists on a deadline. <NAME>., <NAME>., <NAME>., <NAME>., <NAME>., <NAME>., <NAME>. (in progress).</p></li>
            <li><p class="cv-item"><b>Trip Generation by Multiple Modes</b> - Combining data to measure demand from shared travel activities. <NAME>., <NAME>. (in progress).</p></li>
            <li><p class="cv-item"><b><a href="http://c4sr.columbia.edu/projects/banking-divide-taxi-access-evidence-new-york-city">Access to Taxicabs for Unbanked Households: An Exploratory Analysis in New York City</a></b> - A statistical analysis of taxicab payment methods and its correlation with banking service accessibility. <NAME>., <NAME>., 2015 - 2016.</p></li>
            <li><p class="cv-item"><b>Spatial Regulation of Taxicab Services: Measuring Excess Travel from New York City</b> - A statistical and mapping analysis of the environmental cost associated with the spatial regulation of taxicabs in New York City. Saldarriaga, J., King, D., 2016.</p></li>
            <li><p class="cv-item"><b><a href="http://spatialinformationdesignlab.org/project_sites/the-haven-project/">The Haven Project - Metrics</a></b> - An interactive data visualization project analyzing health and environmental metrics for New York City. <NAME>., <NAME>., <NAME>., New York Restoration Project, 2015.</p></li>
            <li><p class="cv-item"><b><a href="http://c4sr.columbia.edu/projects/citibike-rebalancing-study">Citibike Station Imbalances & Citibike Rides</a></b> - Data visualization and mapping projects studying Citibike usage, activity data and station imbalances. <NAME>., <NAME>., <NAME>., <NAME>., 2014.</p></li>
            <li><p class="cv-item"><b>Where Were Bike Share Trips Before Bike Share? Evidence From New York City</b> - A spatial analysis of the relationship between bike share and taxicab trips in New York City. <NAME>., <NAME>., 2014.</p></li>
            <li><p class="cv-item"><b>Modeling Social Justice Issues in Urban Zones Using Big Data: Evidence from Bikeshare and Taxicab Data</b> - A statistical analysis of the spatial distribution of bike share and taxicab trips and their relation to social justice issues. <NAME>., <NAME>., <NAME>., <NAME>., 2014.</p></li>
            <li><p class="cv-item"><b><a href="http://spatialinformationdesignlab.org/project_sites/port_to_port/">Port to Port</a></b> - An interactive data visualization and mapping analysis of 6 years of oil shipment routes to and from U.S. ports. <NAME>., <NAME>., <NAME>., <NAME>., 2014.</p></li>
            <li><p class="cv-item"><b><a href="http://cargocollective.com/juanfrans/NYC-TAXI-ACTIVITY">NYC Taxi Activity</a></b> - Data visualization animations illustrating movement and imbalance patterns in New York City taxicabs. <NAME>., <NAME>., <NAME>., 2012.</p></li>
            <li><p class="cv-item"><b><a href="http://c4sr.columbia.edu/projects/here-now-social-media-and-psychological-city">Here Now! Social Media And The Psychological City</a></b> - Data visualization and mapping project studying social media check-ins in New York City. <NAME>., <NAME>., <NAME>., <NAME>., <NAME>., 2011.</p></li>
          </ul>

          <p class="cv-subtitle">PUBLICATIONS</p>
          <ul class="cv-list">
            <li><p class="cv-item"><b><a href="https://www.sciencedirect.com/science/article/pii/S2210539517301219">Measuring changes in taxi trips near infill development and issues for curbside management of for-hire vehicles</a></b> - <NAME>., <NAME>. - Published in Research in Transportation Business & Management, November 2018.</p></li>
            <li><p class="cv-item"><b><a href="https://www.jtlu.org/index.php/jtlu/article/view/1063">Spatial Regulation of Taxicab Services: Measuring Excess Travel from New York City</a></b> - <NAME>., <NAME>. - Published in the Journal of Transport and Land Use, Volume 11, No 1, 2018.</p></li>
            <li><p class="cv-item"><b><a href="https://www.cogitatiopress.com/urbanplanning/article/view/880">Visualizing Conflict: Possibilities for Urban Research</a></b> - <NAME>., <NAME>., <NAME>. - Published in the Urban Planning Open Access Journal, Volume 2, No 1, 2017.</p></li>
            <li><p class="cv-item"><b>Displacement</b> - <NAME>. - Published in the <a href="http://www.yucamag.com/issue_i/"> Yuca Magazine</a>, The Architecture Alibi & Migrations Issue, 2017.</p></li>
            <li><p class="cv-item"><b><a href="https://scholarcommons.usf.edu/jpt/vol20/iss1/1/">Access to Taxicabs for Unbanked Households: An Exploratory Analysis in New York City</a></b> - <NAME>., <NAME>. - Published in the Journal of Public Transportation, Volume 20.1, March 2017.</p></li>
            <li><p class="cv-item"><b>The Haven Project - Metrics</b> - <NAME>., <NAME>., <NAME>., New York Restoration Project - Published in <a href="http://www.lafrontiers.com/">Landscape Architecture Frontiers</a>, issue 4, 2016.</p></li>
            <li><p class="cv-item"><b><a href="https://www.academia.edu/10511768/Policy_Brief_A_History_of_the_FAR_Limitation_Under_the_New_York_Multiple_Dwelling_Law">Policy Brief: A History of The FAR Limitation Under The New York Multiple Dwelling Law</a></b> - <NAME>., <NAME>. <NAME>. (Geospatial Information Systems Mapping), 2015.</p></li>
            <li><p class="cv-item"><b><a href="https://dl.dropboxusercontent.com/u/35674979/CFP/proceedings/bduic2014_submission_57.pdf">Modeling Social Justice Issues in Urban Zones Using Big Data: Evidence from Bikeshare and Taxicab Data</a></b> - <NAME>., <NAME>., <NAME>., <NAME>. Published in Proceedings of the Workshop on Big Data And Urban Informatics, 2014.</p></li>
            <li><p class="cv-item"><b>Here Now! Social Media And The Psychological City</b> - <NAME>., <NAME>., <NAME>., <NAME>., <NAME>. - Published in <a href="https://books.google.com/books?hl=en&lr=&id=6SLpAwAAQBAJ&oi=fnd&pg=PP1&dq=%22juan+francisco+saldarriaga%22&ots=vq9Ag8_Ez2&sig=ER_-I_13o8GdStr-j8ev0UdUc8s#v=onepage&q=%22juan%20francisco%20saldarriaga%22&f=false">The Sage Handbook of Human Geography, Volume 1, pp. 244.</a>, 2014.</p></li>
            <li><p class="cv-item"><b><a href="https://www.amazon.com/NYC-2040-Housing-Million-Yorkers/dp/1883584884">NYC 2040: Housing The Next One Million New Yorkers</a></b> - <NAME>., <NAME>., <NAME>. (Computational Simulation & Design), 2013.</p></li>
            <li><p class="cv-item"><b>Here Now! Social Media And The Psychological City</b> - <NAME>., <NAME>., <NAME>., <NAME>., <NAME>. - Published in <a href="http://atlasofdesign.org/2012/08/23/a-preview-of-the-selections/">NACIS Atlas of Design</a>, 2012.</p></li>
            <li><p class="cv-item"><b>Here Now! Social Media And The Psychological City</b> - <NAME>., <NAME>., <NAME>., <NAME>., <NAME>. - Featured in <a href="http://magazine.columbia.edu/features/summer-2012/dot-matrix">Columbia Magazine</a>, summer 2012.</p></li>
            <li><p class="cv-item"><b><a href="https://clio.columbia.edu/catalog/7008600?counter=1">Bicycle Commuting And Its Relation To Infrastructure And Demographics: New York City, 1990 - 2000</a></b> - Masters of Urban Planning Thesis, <NAME>., Columbia University, 2008.</p></li>
          </ul>

          <p class="cv-subtitle">LECTURES & PRESENTATIONS</p>
          <ul class="cv-list">
            <li><p class="cv-item"><b>Conflict Urbanism: Colombia & Aleppo</b> - <NAME>. - Presented at the <a href="https://nacis2017.sched.com/">NACIS Annual Conference</a>, Montreal, Canada, 2017 (<a href="https://speakerdeck.com/juanfrans/nacis-2017-conflict-urbanism-colombia-and-aleppo">slideshow</a>).</p></li>
            <li><p class="cv-item"><b>Spatial Regulation of Taxicab Services: Measuring Excess Travel from New York City</b> - <NAME>., <NAME>., - Presented at the <a href="http://wstlur.org/symposium/2017/">World Symposium on Transport and Land Use Research</a>, Brisbane, Australia, 2017.</p></li>
            <li><p class="cv-item"><b>Conflict Urbanism</b> - <NAME>. - Lecture for the <a href="https://las.depaul.edu/centers-and-institutes/studio-chi/Pages/news-events.aspx">Inaugural Programming "Foundations of the Digital, Foundations in the Humanities: Race, Gender, Class"</a> lecture series at Studio Chi, DePaul University, Chicago, 2017.</p></li>
            <li><p class="cv-item"><b>Conflict Urbanism: Visualizing Conflict Data Through Mapping and Spatial Analysis</b> - <NAME>. - Lecture and workshop for the <a href="http://library.columbia.edu/news/events/art-or-knowledge/dv_program.html">Art of Data Visualization: Art or Knowledge Conference</a> at Columbia University, New York, New York, 2017.</p></li>
            <li><p class="cv-item"><b>Research Through Visualization</b> - <NAME>. - Lecture for the Research Methods course at the Masters of Science of Architecture at Penn State University, State College, PA, 2017.</p></li>
            <li><p class="cv-item"><b>Conflict Urbanism: Colombia</b> - <NAME>., <NAME>., <NAME>. - Presented at the <a href="http://www.tapestryconference.com/">Tapestry</a> conference, St. Augustine, FL, 2017.</p></li>
            <li><p class="cv-item"><b>Environmental Costs of Spatial Regulation of Taxicabs</b> - <NAME>., <NAME>. - Accepted for presentation at the <a href="http://www.trb.org/AnnualMeeting/AnnualMeeting.aspx">Transportation Research Board 2017 Annual Meeting</a>, Washington, D.C., 2017.</p></li>
            <li><p class="cv-item"><b>Access to Taxicabs for Unbanked Households: An Exploratory Analysis in New York City</b> - <NAME>., <NAME>. - Presented at the <a href="https://c.ymcdn.com/sites/www.acsp.org/resource/resmgr/conference/2016_Book_of_Accepted_Abstra.pdf">ACSP 2016 56th Annual Conference</a>, Portland, Oregon, 2016.</p></li>
            <li><p class="cv-item"><b>Environmental Costs of Spatial Regulation of Taxicabs</b> - <NAME>., <NAME>. - Presented at the <a href="https://nacis2016.sched.org/">NACIS Annual Conference</a>, Colorado Springs, Colorado, 2016.</p></li>
            <li><p class="cv-item"><b>Access to Taxicabs for Unbanked Households: An Exploratory Analysis in New York City</b> - <NAME>., <NAME>. - Presented at <a href="https://www.bloomberg.com/company/d4gx/">Bloomberg's Data for Good Exchange conference</a>, New York, New York, 2016.</p></li>
            <li><p class="cv-item"><b>Environmental Costs of Spatial Regulation of Taxicabs</b> - <NAME>., <NAME>. - Presented at the <a href="https://www.buffalo.edu/transinfo/Events/2016Symposium.html">Second Annual Symposium on Transportation Informatics</a>, Arlington, Virginia, 2016.</p></li>
            <li><p class="cv-item"><b>Activity Mapping - Columbia Data Science Society</b> - <NAME>. - Lecture for the Columbia Data Science Society students at Columbia University, New York, New York, 2016.</p></li>
            <li><p class="cv-item"><b><a href="https://www.youtube.com/watch?v=XjW4mvMXTXg&feature=youtu.be">Activity Mapping - Art of Data Visualization</a></b> - <NAME>. - Lecture and workshop for the <a href="http://library.columbia.edu/news/events/data-visualization/dv_program.html">Art of Data Visualization Conference</a> at Columbia University, New York, New York, 2016.</p></li>
            <li><p class="cv-item"><b>Access to Taxicabs for Unbanked Households: An Exploratory Analysis in New York City</b> - <NAME>., <NAME>. - Presented at the <a href="http://amonline.trb.org/search-results/site-search-7.291302?tag_co=&tag_lo=&ev=&tr=&tag_or=&tag_ta=&ty=&pe=&q=david+king&tag_su=&pn=&tag_pe=&qr=1">95th Annual Meeting of the Transportation Research Board</a>, Washington D.C., 2016.</p></li>
            <li><p class="cv-item"><b>Activity Mapping</b> - <NAME>. - Lecture for the Urban Design Event Series at Columbia University, New York, New York, 2015.</p></li><commit_msg>corrected some errors<commit_after><!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
  <meta name="description" content="<NAME> is a researcher at the Center for Spatial Research, at Columbia University. His research happens at the intersection of data, GIS, urbanism, architecture and the humanities.">
  <meta name="keywords" content="data visualization, mapping, GIS, data analysis, interactive, information, design, visualization, data mining, information design, information visualization, urban planning, architecture, humanities, center for spatial research, columbia university, gsapp, graduate school or architecture planning and preservation, humanities, new york">
  <meta name="author" content="<NAME>">
  <title>Juanfrans</title>

  <!-- Bootstrap -->
  <link href="css/bootstrap.min.css" rel="stylesheet">

  <!-- Custom styles for this template -->
  <link href="css/site-specific.css" rel="stylesheet" media="screen">

  <!-- Loading fonts from Adobe Typekit -->
  <script src="//use.typekit.net/uzk7kzt.js"></script>
  <script>try{Typekit.load();}catch(e){}</script>
  <!-- Google Analytics tracking code -->
<script>
  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,'script','https://www.google-analytics.com/analytics.js','ga');

  ga('create', 'UA-27897156-1', 'auto');
  ga('send', 'pageview');

</script>
  <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
  <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
      <![endif]-->
    </head>
    <body>

      <!-- *********** NAVBAR ************ -->
      <nav class="navbar navbar-default">
        <div class="container-fluid">
          <div class="container">
          <!-- Brand and toggle get grouped for better mobile display -->
          <div class="navbar-header">
            <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
              <span class="sr-only">Toggle navigation</span>
              <span class="icon-bar"></span>
              <span class="icon-bar"></span>
              <span class="icon-bar"></span>
            </button>
            <a class="navbar-brand" href="index.html"><NAME></a>
          </div>
          <!-- Collect the nav links, forms, and other content for toggling -->
          <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
            <ul class="nav navbar-nav navbar-right">
              <li><a href="index.html">home</a></li>
              <li><a href="projects.html">projects</a></li>
              <li class="active"><a href="about.html">about<span class="sr-only">(current)</span></a></li>
              <li><a href="news.html">news</a></li>
            </ul>
          </div><!-- /.navbar-collapse -->
        </div><!-- /.container-fluid -->
      </div>
      </nav>

      <!-- *********** REST ************* -->
      <div class="container">
        <div class="summary">
          <p>The short version is I am a researcher at the <a href="https://brown.columbia.edu/">Brown Institute for Media Innovation</a> at Columbia University.<p>
          <p>I work at the intersection of data, GIS, visualization, journalism, architecture, urbanism, and the humanities, and I teach graduate level <a href="https://github.com/juanfrans-courses">workshops and seminars</a> on mapping, advanced GIS and data visualization. In the past I've worked as a research scholar at the <a href="http://c4sr.columbia.edu/">Center for Spatial Research</a> and the <a href="http://spatialinformationdesignlab.org/">Spatial Information Design Lab</a>, as an architectural designer for <a href="http://www.cz-studio.com/">Carlos Zapata Studio</a> and D.G.T. Architects, and as the GIS project coordinator for the <a href="http://www.catholiccharitiesny.org/">Catholic Charities</a>.</p>
        </div>
        <div class="cv-section">
          <p class="intro-cv">Here's a more detailed version:</p>
          <p class="cv-subtitle">EDUCATION</p>
          <ul class="cv-list">
            <li><p class="cv-item"><b>Columbia University, Graduate School of Architecture, Planning and Preservation, New York, NY</b> - Masters in Architecture (2012) - Visual Studies Honor Award (Emphasis on Data Visualization)</p></li>
            <li><p class="cv-item"><b>Columbia University, Graduate School of Architecture, Planning and Preservation, New York, NY</b> - Masters of Science in Urban Planning (2008)</p></li>
            <li><p class="cv-item"><b>Universidad de Los Andes, Bogotá, Colombia</b> - Bachelors of Arts in Philosophy (2004)</p></li>
            <li><p class="cv-item"><b>Université de Paris IV, Sorbonne, Paris</b> - 1st Year of Deug in Philosophy (1999)</p></li>
          </ul>

          <p class="cv-subtitle">APPOINTMENTS</p>
          <ul class="cv-list">
            <li><p class="cv-item"><b>Associate Research Scholar</b> - <a href="https://brown.columbia.edu/">Brown Institute for Media Innovation</a>, Columbia University, New York, NY (2018 - Present)</p></li>
            <li><p class="cv-item"><b>Mellon Associate Research Scholar</b> - <a href="http://c4sr.columbia.edu/">Center for Spatial Research</a>, Columbia University, New York, NY (2015 - 2018)</p></li>
            <li><p class="cv-item"><b>Adjunct Assistant Professor</b> - <a href="http://www.arch.columbia.edu/">Graduate School of Architecture, Planning and Preservation</a>, Columbia University, New York, NY (2013 - Present)</p></li>
            <li><p class="cv-item"><b>Associate Research Scholar</b> - <a href="http://spatialinformationdesignlab.org/">Spatial Information Design Lab</a>, Columbia University, New York, NY (2013 - 2015)</p></li>
            <li><p class="cv-item"><b>Architectural Designer</b> - <a href="http://www.cz-studio.com/">Carlos Zapata Studio</a>, New York, NY (2012 - 2013)</p></li>
            <li><p class="cv-item"><b>GIS Project Coordinator</b> - <a href="http://catholiccharitiesny.org/">Catholic Charities, Archdioceses of New York</a>, New York, NY (2009)</p></li>
          </ul>

          <p class="cv-subtitle">PROJECTS</p>
          <ul class="cv-list">
            <li><p class="cv-item"><b><a href="http://c4sr.columbia.edu/projects/conflict-urbanism-colombia">Conflict Urbanism: Colombia</a></b> - An interactive mapping and spatial analysis project examining the Colombian conflict and its effect in the urban environment. <NAME>., <NAME>., <NAME>. (in progress).</p></li>
            <li><p class="cv-item"><b><a href="http://xpmethod.plaintext.in/embodied-space-lab/mapping-mughal-hindustan.html">Mapping Mughal Hindustan, 1500 - 1600 CE</a></b> - A scholarly and interactive mapping project which re-frames the various sites of early Mughal Hindustan as affective geography. <NAME>., <NAME>., <NAME>., <NAME>., <NAME>., 2017.</p></li>
            <li><p class="cv-item"><b><a href="https://science-surveyor.github.io/">Science Surveyor</a></b> - Context on Deadline - An interactive application providing context information for science journalists on a deadline. <NAME>., <NAME>., <NAME>., <NAME>., <NAME>., <NAME>., <NAME>. (in progress).</p></li>
            <li><p class="cv-item"><b>Trip Generation by Multiple Modes</b> - Combining data to measure demand from shared travel activities. <NAME>., <NAME>. (in progress).</p></li>
            <li><p class="cv-item"><b><a href="http://c4sr.columbia.edu/projects/banking-divide-taxi-access-evidence-new-york-city">Access to Taxicabs for Unbanked Households: An Exploratory Analysis in New York City</a></b> - A statistical analysis of taxicab payment methods and its correlation with banking service accessibility. <NAME>., <NAME>., 2015 - 2016.</p></li>
            <li><p class="cv-item"><b>Spatial Regulation of Taxicab Services: Measuring Excess Travel from New York City</b> - A statistical and mapping analysis of the environmental cost associated with the spatial regulation of taxicabs in New York City. <NAME>., King, D., 2016.</p></li>
            <li><p class="cv-item"><b><a href="http://spatialinformationdesignlab.org/project_sites/the-haven-project/">The Haven Project - Metrics</a></b> - An interactive data visualization project analyzing health and environmental metrics for New York City. <NAME>., <NAME>., <NAME>., New York Restoration Project, 2015.</p></li>
            <li><p class="cv-item"><b><a href="http://c4sr.columbia.edu/projects/citibike-rebalancing-study">Citibike Station Imbalances & Citibike Rides</a></b> - Data visualization and mapping projects studying Citibike usage, activity data and station imbalances. <NAME>., <NAME>., <NAME>., <NAME>., 2014.</p></li>
            <li><p class="cv-item"><b>Where Were Bike Share Trips Before Bike Share? Evidence From New York City</b> - A spatial analysis of the relationship between bike share and taxicab trips in New York City. <NAME>., <NAME>., 2014.</p></li>
            <li><p class="cv-item"><b>Modeling Social Justice Issues in Urban Zones Using Big Data: Evidence from Bikeshare and Taxicab Data</b> - A statistical analysis of the spatial distribution of bike share and taxicab trips and their relation to social justice issues. <NAME>., <NAME>., <NAME>., <NAME>., 2014.</p></li>
            <li><p class="cv-item"><b><a href="http://spatialinformationdesignlab.org/project_sites/port_to_port/">Port to Port</a></b> - An interactive data visualization and mapping analysis of 6 years of oil shipment routes to and from U.S. ports. <NAME>., <NAME>., <NAME>., <NAME>., 2014.</p></li>
            <li><p class="cv-item"><b><a href="http://cargocollective.com/juanfrans/NYC-TAXI-ACTIVITY">NYC Taxi Activity</a></b> - Data visualization animations illustrating movement and imbalance patterns in New York City taxicabs. <NAME>., <NAME>., <NAME>., 2012.</p></li>
            <li><p class="cv-item"><b><a href="http://c4sr.columbia.edu/projects/here-now-social-media-and-psychological-city">Here Now! Social Media And The Psychological City</a></b> - Data visualization and mapping project studying social media check-ins in New York City. <NAME>., <NAME>., <NAME>., <NAME>., <NAME>., 2011.</p></li>
          </ul>

          <p class="cv-subtitle">PUBLICATIONS</p>
          <ul class="cv-list">
            <li><p class="cv-item"><b><a href="https://www.sciencedirect.com/science/article/pii/S2210539517301219">Measuring changes in taxi trips near infill development and issues for curbside management of for-hire vehicles</a></b> - <NAME>., <NAME>. - Published in Research in Transportation Business & Management, November 2018.</p></li>
            <li><p class="cv-item"><b><a href="https://www.jtlu.org/index.php/jtlu/article/view/1063">Spatial Regulation of Taxicab Services: Measuring Excess Travel from New York City</a></b> - <NAME>., <NAME>. - Published in the Journal of Transport and Land Use, Volume 11, No 1, 2018.</p></li>
            <li><p class="cv-item"><b><a href="https://www.cogitatiopress.com/urbanplanning/article/view/880">Visualizing Conflict: Possibilities for Urban Research</a></b> - <NAME>., <NAME>., <NAME>. - Published in the Urban Planning Open Access Journal, Volume 2, No 1, 2017.</p></li>
            <li><p class="cv-item"><b>Displacement</b> - <NAME>. - Published in <a href="http://www.yucamag.com/issue_i/"> Yuca Magazine</a>, The Architecture Alibi & Migrations Issue, 2017.</p></li>
            <li><p class="cv-item"><b><a href="https://scholarcommons.usf.edu/jpt/vol20/iss1/1/">Access to Taxicabs for Unbanked Households: An Exploratory Analysis in New York City</a></b> - <NAME>., <NAME>. - Published in the Journal of Public Transportation, Volume 20.1, March 2017.</p></li>
            <li><p class="cv-item"><b>The Haven Project - Metrics</b> - <NAME>., <NAME>., <NAME>., New York Restoration Project - Published in <a href="http://www.lafrontiers.com/">Landscape Architecture Frontiers</a>, issue 4, 2016.</p></li>
            <li><p class="cv-item"><b><a href="https://www.academia.edu/10511768/Policy_Brief_A_History_of_the_FAR_Limitation_Under_the_New_York_Multiple_Dwelling_Law">Policy Brief: A History of The FAR Limitation Under The New York Multiple Dwelling Law</a></b> - <NAME>., <NAME>. <NAME>. (Geospatial Information Systems Mapping), 2015.</p></li>
            <li><p class="cv-item"><b><a href="https://urbanbigdata.uic.edu/proceedings/">Modeling Social Justice Issues in Urban Zones Using Big Data: Evidence from Bikeshare and Taxicab Data</a></b> - <NAME>., <NAME>., <NAME>., <NAME>. Published in Proceedings of the Workshop on Big Data And Urban Informatics, 2014.</p></li>
            <li><p class="cv-item"><b>Here Now! Social Media And The Psychological City</b> - <NAME>., <NAME>., <NAME>., <NAME>., <NAME>. - Published in <a href="https://books.google.com/books?hl=en&lr=&id=6SLpAwAAQBAJ&oi=fnd&pg=PP1&dq=%22juan+francisco+saldarriaga%22&ots=vq9Ag8_Ez2&sig=ER_-I_13o8GdStr-j8ev0UdUc8s#v=onepage&q=%22juan%20francisco%20saldarriaga%22&f=false">The Sage Handbook of Human Geography, Volume 1, pp. 244.</a>, 2014.</p></li>
            <li><p class="cv-item"><b><a href="https://www.amazon.com/NYC-2040-Housing-Million-Yorkers/dp/1883584884">NYC 2040: Housing The Next One Million New Yorkers</a></b> - <NAME>., <NAME>., <NAME>. (Computational Simulation & Design), 2013.</p></li>
            <li><p class="cv-item"><b>Here Now! Social Media And The Psychological City</b> - <NAME>., <NAME>., <NAME>., <NAME>., <NAME>. - Published in <a href="http://atlasofdesign.org/2012/08/23/a-preview-of-the-selections/">NACIS Atlas of Design</a>, 2012.</p></li>
            <li><p class="cv-item"><b>Here Now! Social Media And The Psychological City</b> - <NAME>., <NAME>., <NAME>., <NAME>., <NAME>. - Featured in <a href="http://magazine.columbia.edu/features/summer-2012/dot-matrix">Columbia Magazine</a>, summer 2012.</p></li>
            <li><p class="cv-item"><b><a href="https://clio.columbia.edu/catalog/7008600?counter=1">Bicycle Commuting And Its Relation To Infrastructure And Demographics: New York City, 1990 - 2000</a></b> - Masters of Urban Planning Thesis, <NAME>., Columbia University, 2008.</p></li>
          </ul>

          <p class="cv-subtitle">LECTURES & PRESENTATIONS</p>
          <ul class="cv-list">
            <li><p class="cv-item"><b>Conflict Urbanism: Colombia & Aleppo</b> - <NAME>. - Presented at the <a href="https://nacis2017.sched.com/">NACIS Annual Conference</a>, Montreal, Canada, 2017 (<a href="https://speakerdeck.com/juanfrans/nacis-2017-conflict-urbanism-colombia-and-aleppo">slideshow</a>).</p></li>
            <li><p class="cv-item"><b>Spatial Regulation of Taxicab Services: Measuring Excess Travel from New York City</b> - <NAME>., <NAME>., - Presented at the <a href="http://wstlur.org/symposium/2017/">World Symposium on Transport and Land Use Research</a>, Brisbane, Australia, 2017.</p></li>
            <li><p class="cv-item"><b>Conflict Urbanism</b> - <NAME>. - Lecture for the <a href="https://las.depaul.edu/centers-and-institutes/studio-chi/Pages/news-events.aspx">Inaugural Programming "Foundations of the Digital, Foundations in the Humanities: Race, Gender, Class"</a> lecture series at Studio Chi, DePaul University, Chicago, 2017.</p></li>
            <li><p class="cv-item"><b>Conflict Urbanism: Visualizing Conflict Data Through Mapping and Spatial Analysis</b> - <NAME>. - Lecture and workshop for the <a href="http://library.columbia.edu/news/events/art-or-knowledge/dv_program.html">Art of Data Visualization: Art or Knowledge Conference</a> at Columbia University, New York, New York, 2017.</p></li>
            <li><p class="cv-item"><b>Research Through Visualization</b> - <NAME>. - Lecture for the Research Methods course at the Masters of Science of Architecture at Penn State University, State College, PA, 2017.</p></li>
            <li><p class="cv-item"><b>Conflict Urbanism: Colombia</b> - <NAME>., <NAME>., <NAME>. - Presented at the <a href="http://www.tapestryconference.com/">Tapestry</a> conference, St. Augustine, FL, 2017.</p></li>
            <li><p class="cv-item"><b>Environmental Costs of Spatial Regulation of Taxicabs</b> - <NAME>., <NAME>. - Accepted for presentation at the <a href="http://www.trb.org/AnnualMeeting/AnnualMeeting.aspx">Transportation Research Board 2017 Annual Meeting</a>, Washington, D.C., 2017.</p></li>
            <li><p class="cv-item"><b>Access to Taxicabs for Unbanked Households: An Exploratory Analysis in New York City</b> - <NAME>., <NAME>. - Presented at the <a href="https://c.ymcdn.com/sites/www.acsp.org/resource/resmgr/conference/2016_Book_of_Accepted_Abstra.pdf">ACSP 2016 56th Annual Conference</a>, Portland, Oregon, 2016.</p></li>
            <li><p class="cv-item"><b>Environmental Costs of Spatial Regulation of Taxicabs</b> - <NAME>., <NAME>. - Presented at the <a href="https://nacis2016.sched.org/">NACIS Annual Conference</a>, Colorado Springs, Colorado, 2016.</p></li>
            <li><p class="cv-item"><b>Access to Taxicabs for Unbanked Households: An Exploratory Analysis in New York City</b> - <NAME>., <NAME>. - Presented at <a href="https://www.bloomberg.com/company/d4gx/">Bloomberg's Data for Good Exchange conference</a>, New York, New York, 2016.</p></li>
            <li><p class="cv-item"><b>Environmental Costs of Spatial Regulation of Taxicabs</b> - <NAME>., <NAME>. - Presented at the <a href="https://www.buffalo.edu/transinfo/Events/2016Symposium.html">Second Annual Symposium on Transportation Informatics</a>, Arlington, Virginia, 2016.</p></li>
            <li><p class="cv-item"><b>Activity Mapping - Columbia Data Science Society</b> - <NAME>. - Lecture for the Columbia Data Science Society students at Columbia University, New York, New York, 2016.</p></li>
            <li><p class="cv-item"><b><a href="https://www.youtube.com/watch?v=XjW4mvMXTXg&feature=youtu.be">Activity Mapping - Art of Data Visualization</a></b> - <NAME>. - Lecture and workshop for the <a href="http://library.columbia.edu/news/events/data-visualization/dv_program.html">Art of Data Visualization Conference</a> at Columbia University, New York, New York, 2016.</p></li>
            <li><p class="cv-item"><b>Access to Taxicabs for Unbanked Households: An Exploratory Analysis in New York City</b> - <NAME>., <NAME>. - Presented at the <a href="http://amonline.trb.org/search-results/site-search-7.291302?tag_co=&tag_lo=&ev=&tr=&tag_or=&tag_ta=&ty=&pe=&q=david+king&tag_su=&pn=&tag_pe=&qr=1">95th Annual Meeting of the Transportation Research Board</a>, Washington D.C., 2016.</p></li>
            <li><p class="cv-item"><b>Activity Mapping</b> - <NAME>. - Lecture for the Urban Design Event Series at Columbia University, New York, New York, 2015.</p></li>
{'fraction_non_alphanumeric': 0.17571572139047079, 'fraction_numerical': 0.021851727781070425, 'mean_word_length': 3.788155459592844, 'pattern_counts': {'":': 0, '<': 1250, '<?xml version=': 0, '>': 1250, 'https://': 48, 'lorem ipsum': 0, 'www.': 36, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1135374', 'n_tokens_mistral': 13047, 'n_tokens_neox': 11875, 'n_words': 3295}