![]() There are a number of missing pieces and unsolved problems to the approach taken above. The key features in the SPARQL query itself are that we’re able to query event names, dates, location data, and links to additional resources the results of this query can then easily be inserted into a database table with the same fields: PREFIX dbo: PREFIX n1: SELECT (?Event_69 AS ?event) (?date_89 AS ?date) (AVG(?place_lat_158) AS ?latitude) (AVG(?place_long_159) AS ?longitude) WHERE services: mysql: image: mysql:5.7 environment: ” in your browser after executing these commands should display the running app. The code for this step, implemented in Python and loaded into a MySQL database, can be found here. ![]() This means that not only can the data be scraped once to build out an initial database, but our app’s back end can also refresh the database as new events are added to the public records. So how does one acquire a large amount of highly structured data about historical events and populate a database with those entities? Fortunately, a project called DBpedia provides a public database built on top of Wikipedia entries that can be queried with a SQL-like language called SPARQL. The easiest way to structure this requirement is to create a model around historical events, which fit nicely into a database model and are easy to enumerate programmatically. While exploring any given time period, a user needs the app to return data about that period, with high-level information, links, and other attributes immediately available. The Back Endįor an application like this to be successful, the first requirement is data - and a lot of it. ![]() The full code is available in this github repo. Easily navigate to finer-grain detail if desiredīelow I’ll describe the app I came up with - it’s very much a work in progress, but hopefully you’ll find the code, the APIs used, or any of the design decisions made so far useful.Control the returned information chronologically.At a high level, I wanted to make something that enables a user to: I’m a visual learner, so I’ve been thinking about the sorts of web apps that could help engage with history in a more interactive and scalable way. Students learn about individual events and figures in great detail, but few are able to simultaneously describe the state of the world across geographies in a given era. One of the biggest flaws with how schools teach history is that they’re rarely able to tie things together into a cohesive global picture.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |