Welcome!

Jingyi Li

Geospatial Analytics ☀︎ Web Development ✤ Data Engineering ☆ Planning and Community Engagement ☀︎ Distributed System Programming ☆ Computer Graphics & Computer Vision ☺︎ Digital Heritage ... ✨ I am passionate about using technologies to solve problems in cultural heritages, cities, the built environment ... and really, just everyday life 🌼

Resume

Projects

A Prototype for Community-Centered Preservation Planning

A Full-Stack Web App Prototype Developed for Crowdsourcing Cultural Resources of a Neighborhood Including Personal Stories, Old Photos and Oral Histories for the Community-Centered Preservation of 7th Ward in Philadelphia.

  • Web Dev
  • Geospatial Data Viz
  • Historic Preservation
  • Javascript
  • Node.js
  • Express
  • RESTful
  • HTML
  • CSS
  • JQuery
  • MongoDB
  • Bootstrap

Geospatial Analysis & GIS

Mapping Flood Susceptibility for Historic Properties and Districts in Philadelphia

  • Geospatial Analysis & GIS
  • ArcGIS Pro
  • Model Builder
  • Raster Calculation
  • Public-Sourced Data
  • Hydrological Analysis

Geospatial Cloud Computing & Data Engineering

Philadelphia Computer-Assisted Mass Appraisal - A Data-Centric Cloud Computing Full-Stack App (In-class Collaboration Project. My work includes: ETL Scripting, Cloud Infrastructure, DevOps, SQL Queries, Vetor Tiles, UI & Dashboard)

  • Geospatial Analysis & GIS
  • Web Dev
  • ETL
  • Cloud Services
  • SASS
  • PostgreSQL + PostGIS
  • Vetor Tiles

A Handy Tool for Preservation Researchers

A Frontend Web App Built for Filtering Preservation Geospatial database and Visualizing Preservation-Related Datasets of Philadelphia

  • Web Dev
  • Geospatial Data Viz
  • Historic Preservation
  • Javascript
  • Leaflet
  • HTML
  • CSS

Geospatial Analysis & GIS

Grading System of Locating a Community Garden in Rio de Janeiro, Brazil

  • Geospatial Analysis & GIS
  • ArcGIS Pro
  • Raster Calculation
  • Data Normalization

Samples for ETL Scripting and Spatial SQL Queries

A Repo Containing some Scripts (Python & NodeJS) for ETL and SQL Queries (Postgres + PostGIS) for Sptial Analytics.

  • Geospatial Analysis & GIS
  • ETL
  • PostgresSQL+PostGIS
  • Cloud Computing

Mini Minescraft Game

An Interactive 3D World Exploration and Alteration Program in the Style of the Popular Computer Game Minecraft From Scratch (Built in C++).

  • Computer Graphics
  • C++
  • OpenGL
  • GLSL
  • Shaders
  • Concurrency Programming

Penn Cloud

A Cloud Platform Supporting Webmail and Storage Server Based on Distributed Key-value Store (Built in C, Contact Me For a Private Share of the Code)

  • Distributed System Programming
  • C/C++
  • gRPC
  • Software Systems
  • Server Design
  • NoSQL Database
  • VMWare
Report

Master Thesis

AI in Reconstructing Cultural Heritage Sites: A Study on the Comparison between NeRF (Neural Radiance Fields) and Photogrammetry in Historic Preservation

  • Historic Preservation
  • Deep Learning
  • Neural Rendering
  • AI
  • 3D Reconstruction
  • Digital Heritage

SMTP and POP3 Email Servers

Implementation of SMTP and POP3 Email Servers for a Real Email Client (Supporting Local and Non-local users/Mail Relay, Built in C, Contact Me For a Private Share of the Code)

  • Distributed System Programming
  • C/C++
  • Linux
  • TCP/Stream Socket Programming
  • Server Design
  • RFC-style Protocol Implementation
  • Multithread Server Architecture
  • Thunderburd

Distributed Multicasting Chat Servers

Implementation of a Distributed Multicasting Chat Servers which Supports for Unordered, FIFO and Total Ordering Multicast with More Than 15 Servers/Nodes and 300 Clients (Built in C, Contact Me For a Private Share of the Code)

  • Distributed System Programming
  • C/C++
  • Linux
  • UDP/Datagram Socket Programming
  • Server Design
  • Unordered, FIFO & Total Ordering
Report

Mini Maya

Implementation of a 3D Modeling Software (Maya) Including: Half-edge Mesh, Catmull-Clark Subdivision, Skeleton & Skinning

  • Computer Graphics
  • C++
  • OpenGL
  • 3D Modeling Software Development
  • Object Oriented Programming

OpenGL Shader Fun

Program Portions Of Opengl’s Graphics Pipeline By Writing Different Vertex And Fragment Shaders To Apply Different Coloration Effects To The Surface Of 3d Models.

  • Computer Graphics
  • OpenGL
  • GLSL
  • Qt Creator
  • Shader

3D Reconstruction From 2D Images

Implementation of Structure-From-Motion, Two-View-Stereo, Multi-View-Stereo and the Photogrammetry Pipeline in Python (Contact me for a private share of the code)

  • Computer Vision
  • OpenCV
  • Ptyhon
  • SFM
  • SFM
  • COLMAP
  • Photogrammetry

Architectural Design

SURPRISE !!!!! Yes, I actually have an architecture portfolio!

  • Design
  • Computer Aided Design
  • Rhino
  • Sketchup
  • Vray
  • Lumion
  • Photoshop
  • Illustrator
  • Indesign

Skills

Contact

Email me