• PHP & MySQL

Hispanopedia is a site that provides statistical information on the communities, provinces and localities of Spain, was made with php and mysql, using Boostrap for the design of both the frontend and backend. Designed for fast information processing, we prioritized a minimalist and responsive design.

The statistical information displayed on the site is obtained through the api provided by the National Institute of Statistics of Spain (INE), through the daily execution of a series of php scripts that store the information in a database to avoid having to constantly access the INE api.

The information was organized in pages of communities, provinces and localities. A backend was created to organize and manage the information obtained from the INE and from other sources through the denomination of information modules. Certain panels were also created for information that needs to be updated or managed without being obtained from external sources.

A panel was implemented to manage the display of the modules, as well as the order of priority to be shown in the different pages. Users’ interest in the modules displayed is also controlled, since the clicks emitted in the index table at the top of the pages are registered.

There is a section to manage the variables to be displayed in each module, it is necessary to know that the statistical information obtained by the INE is in the form of tables, so it is sometimes convenient to have the possibility of hiding certain information that is not of interest.

An additional text administration panel was created in the modules, in which a shortcode system was implemented to show the value of the variables in the added complementary text.

Information is also extracted from Wikipedia using the api of the latter, for the extracted images an administration panel was generated to show or hide at the client’s interest.

As additional modules, maps using Google Maps and Openstreet apis were added through the Leaflet library; and for weather estimation of the localities we used the api of the Spanish State Meteorological Agency (AESMET).

A series of rankings were created at the client’s request, with an administration to supplement information on these rankings.

Enter hispanopedia to get first-hand knowledge of what is stated here.