Extending the Intermediate Data Structure (IDS) for longitudinal historical databases to include geographic data

Finn Hedefalk; Lars Harrie; Patrick Svensson

doi:10.51964/hlcs9289

Author(s)

Finn Hedefalk
Lars Harrie
Patrick Svensson

DOI:

https://doi.org/10.51964/hlcs9289

Keywords:

XML, Data model, Standardisation, Longitudinal historical data, Geographic data, IDS-Geo, IDS

Abstract

The Intermediate Data Structure (IDS) is a standardised database structure for longitudinal historical databases. Such a common structure facilitates data sharing and comparative research. In this study, we propose an extended version of IDS, named IDS-Geo, that also includes geographic data. The geographic data that will be stored in IDS-Geo are primarily buildings and/or property units, and the purpose of these geographic data is mainly to link individuals to places in space. When we want to assign such detailed spatial locations to individuals (in times before there were any detailed house addresses available), we often have to create tailored geographic datasets. In those cases, there are benefits of storing geographic data in the same structure as the demographic data. Moreover, we propose the export of data from IDS-Geo using an eXtensible Markup Language (XML) Schema. IDS-Geo is implemented in a case study using historical property units, for the period 1804 to 1913, stored in a geographically extended version of the Scanian Economic Demographic Database (SEDD). To fit into the IDS-Geo data structure, we included an object lifeline representation of all of the property units (based on the snapshot time representation of single historical maps and poll-tax registers). The case study verifies that the IDS-Geo model is capable of handling geographic data that can be linked to demographic data.

Downloads

Download data is not yet available.

References

Alter, G., Mandemakers, K. & Gutmann, M. (2009). Defining and Distributing Longitudinal Historical Data in a General Way Through an Intermediate Structure. Historical Social Research, 34(3), 78–114.

Alter, G. & Mandemakers, K. (2012). The Intermediate Data Structure (IDS) for Longitudinal Historical Microdata, version 3, dated 12 July 2012. Working paper published on the EHPS collaboratory.

Alter, G., & Mandemakers, K. (2014). The Intermediate Data Structure (IDS) for Longitudinal Historical Microdata, version 4. Historical Life Course Studies, 1, 1–26.

Armstrong, M. P. (1988). Temporality in spatial databases. Proceedings from GIS/LIS, 88(2), 880–889. San Antonio, Texas.

Bengtsson, T., Dribe, M. & Svensson, P. (2012). The Scanian Economic Demographic Database. Version 2.0 (Machine-readable database). Lund: Lund University, Centre for Economic Demography.

Berman, M. L. (2003). A Data Model for Historical GIS: The CHGIS Time Series. Cambridge, MA: Harvard Yenching Institute.

Cox, S. (Ed.). (2010). OGC Abstract Specification: Geographic information — Observations and measurements (OGC Abstract Specification).

Dam, P. (2013). Integrating time and space in a digital-historical administrative atlas. Unpublished manuscript.

European Commission (EC). (2009). Commission Regulation (EC) No 976/2009 of 19 October 2009 implementing Directive 2007/2/EC of the European Parliament and of the Council as regards the Network Services. Official Journal of the European Union, 52.

European Commission (EC). (2014). INSPIRE code list register, dated February 03, 2014.

European Historical Population Samples Network (EHPS-Net). (2009). Proposal for an ESF Research Networking Programme – Call 2009.

Fitch, C. A. & Ruggles, S. (2003). Building the national historical geographic information system. Historical Methods: A Journal of Quantitative and Interdisciplinary History, 36(1), 41–51.

Gregory, I. & Southall, H. (2005). The Great Britain Historical GIS. Historical Geography, 33, 132–134.

Grenon, P. & Smith, B. (2004). SNAP and SPAN: Towards dynamic spatial ontology. Spatial Cognition and Computation, 4(1), 69–104.

Herring, R. J. (Ed.). (2011). OpenGIS Implementation Specification for Geographic Information – Simple Feature Access – Part 1: Common Architecture (OpenGIS Implementation Standard).

INSPIRE Data Specifications Drafting Team. (2013). D2.5: Generic Conceptual Model, Version 3.4rc3 (Framework Document).

ISO (2004). ISO 8601:2004 Data elements and interchange formats — Information interchange — Representation of dates and times. Geneva: ISO.

ISO (2011). ISO 19156:2011 Geographic information — Observation and Measurements. Geneva: ISO.

ISO/IEC (2011). ISO/IEC 13249-3:2011 Standard, Information technology — Database languages — SQL multimedia and application packages — Part 3: Spatial. Geneva: ISO/IEC.

ISO/IEC (2014). ISO/IEC Directives, Part 1: Procedures for the Technical Work, 11th edition. Geneva.

Lake, R., Burggraf, D. S., Trninic, M., & Rae, L. (2004). Geography Mark-Up Language: Foundation for the Geo-Web. Chichester: John Wiley & Sons.

Lantmäteriet (LM). (2012). Two-dimensional systems — SWEREF 99, projections.

Lu, C. T., Dos Santos Jr, R. F., Sripada, L. N., & Kou, Y. (2007). Advances in GML for geospatial applications. Geoinformatica, 11(1), 131–157.

Portele, C. (Ed.). (2007). OGC Implementation Specification 07-036: OpenGIS Geography Markup Language (GML) Encoding Standard (OpenGIS Standard).

Sheth, A. P. & Larson, J. A. (1990). Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Computing Surveys (CSUR), 22(3), 183–236.

Southall, H., Mostern, R. & Berman, M. L. (2011). On Historical Gazetteers. International Journal of Humanities and Arts Computing, 5(2), 127–145. https://doi.org/10.3366/ijhac.2011.0028

Vanhaute, E. (2003). Construction of a GIS for the territorial structure of Belgium. Ghent: Ghent University.

Walker, G., Taylor, P., Cox, S. & Sheahan, P. (2009). Water data transfer format (WDTF): Guiding principles, technical challenges and the future. In R. Anderssen, R. Braddock, & L. Newham (Eds.), Proceedings from 18th IMACS World Congress & MODSIM 2009 International Congress on Modelling and Simulation, 4381–4387. Cairns: Modelling and Simulation Society of Australia and New Zealand and International Association for Mathematics and Computers in Simulation.

Worboys, M., & Duckham, M. (2004). GIS: A computing perspective. Boca Raton: CRC Press.

Worboys, M. (2005). Event-oriented approaches to geographic phenomena. International Journal of Geographical Information Science, 19(1), 1–28.

World Wide Web Consortium (W3C). (2010). XML Linking Language (XLink) Version 1.1: W3C Recommendation 06 May 2010.

Yeung, A. & Hall, G. (2007). Spatial database systems: Design, implementation and project management. Dordrecht: Springer.

Yuan, M. & Hornsby, K. S. (2008). Computation and visualization for understanding dynamics in geographic domains: a research agenda. Boca Raton: CRC Press.