Bone metabolism is regulated by endocrine and paracrine signalling molecules influencing bone cells in the continuously remodelling bone tissue. These molecules include a variety of osteotropic stimulatory and inhibitory cytokines. Degradation of alveolar bone in periodontal disease is believed to be a result of local release of such osteotropic cytokines, although the relative importance of particular cytokines and their cellular origin is currently unknown. The aim of the present project was to study if, and how, pro-inflammatory cytokines in the interleukin-6 (IL-6) family of cytokines, and anti-inflammatory IL-4 and IL-13 type of cytokines, can affect osteoclast differentiation and bone resorption. Additionally, the objective was to study if gingival fibroblasts may influence alveolar bone resorption through secretion of IL-6 type cytokine release and if the secretion is regulated by pro-inflammatory as well as anti-inflammatory mediators such as IL-4 and IL-13. IL-6 in combination with its soluble receptor (sIL-6R) was found to stimulate mouse calvarial bone resorption. Similarly, two other IL-6 family members, leukemia inhibitory factor (LIF) and oncostatin M (OSM) were found to stimulate bone resorption. The stimulatory effect on bone resorption induced by the three cytokines was associated with increased expression of receptor activator of NF- κB ligand (RANKL), a cytokine which is essential in osteoclast formation and activation through binding to receptor activator of NF- κB (RANK) on osteoclastic cells. The interaction between RANKL and RANK can be inhibited by binding of the decoy receptor osteoprotegerin (OPG) to RANKL, and the expression of OPG was also regulated by IL-6, LIF and OSM (Paper I). The two related cytokines IL-4 and IL-13 were found to inhibit osteoclastogenesis and mouse calvarial bone resorption by mechanisms involving a decreased RANKL/OPG ratio in osteoblasts and decreased RANK expression in osteoclastic cells. The results further demonstrated that IL-4 and IL-13 exert their effects on both osteoblasts and osteoclasts by a mechanism involving the transcription factor signal transducer and activator of transcription 6 (STAT6) (Paper II). Constitutional expression of IL-6, LIF and another member of the IL-6 family of cytokines, IL-11, was demonstrated in human gingival fibroblasts. IL-6 type cytokine expression levels were found to be enhanced by IL-1β and tumour necrosis factor-α (TNF-α) (Paper III), whereas IL-4 and IL-13 inhibited IL 11 and LIF release from gingival fibroblasts (Paper IV). In conclusion, IL 6 type cytokines were found to be stimulators and IL-4 and IL-13 inhibitors of bone resorption in vitro via mechanisms involving RANK/RANKL/OPG interactions. Additionally, gingival fibroblasts were able to secrete several cytokines in the IL-6 family. Secretion was further enhanced by pro-inflammatory mediators and inhibited by IL-4 and IL- 13. These findings support the view that resident cells may influence the pathogenesis of periodontal disease through osteotropic cytokine production.

<p>For all organisms, the ability to sense and react to noxious environments is fundamental to their survival. For multi-celled organisms this process generally involves a nervous system and an extensive network of signal transduction pathways. TRPV ion channels have been shown to participate in signal transduction in response to noxious stimuli. At the cellular level these channels function in sensing of mechanical, thermal, and osmotic stimuli, and at the organismal level they function in homeostasis and nociception. TRPV ion channels participate in nociceptive signal transduction via cation influx, but exactly how these channels function at a mechanistic level and lead to activation of the cell or induction of a specific behavior is elusive. Previous research has shown that the pore-forming unit of an ion channel is critical for channel regulation, gating, ion selectivity, and ion permeation. Various regulatory domains have been identified to date in the pore-forming unit of TRP channels and a clearer picture of channel gating is beginning to emerge, but less is known about ion permeation. </p><p>To better understand the specific domains that are critical to ion capture, selectivity, and permeation in TRPV channels, we investigated the function of these regions using the <italic>C. elegans</italic> TRPV channel OSM-9 <italic>in vivo</italic>, and the mammalian TRPV channel TRPV4 in heterologous cell culture. OSM-9 is the functional ortholog of mammalian TRPV4 and it is likely that critical domains identified in OSM-9 are functionally conserved in TRPV4 and play a similar role in other TRPV channels. OSM-9 is expressed in the ASH neurons and is responsible for all of the behaviors initiated by that cell. The stereotypical avoidance behavior mediated by ASH, in response to noxious stimuli, serves as a model for nociception in vertebrates. As OSM-9 is necessary for all of these behavioral responses, activation of ASH acts as a read-out for OSM-9 function.</p><p>Through targeted mutagenesis of the OSM-9 loop domains and transgenic expression directed to the ASH head sensory neurons in an <italic>osm-9</italic> null background, we discovered a critical role for the amino acids both N- and C- terminal to the pore helix in osmotic avoidance behavior. We confirmed the existence of a selectivity filter C-terminal to the pore helix and revealed that the turret is critical for channel function, possibly as a component of the inactivation gate.</p><p>We first identified the boundaries of the selectivity filter to be M601-F<super>609</super>. We also determined what properties of those residues were critical to Ca<super>2+</super> and Na<super>+</super> selectivity. <italic>In vivo</italic> Ca<super>2+</super> imaging strongly suggested that residues Y<super>604</super>, D<super>605</super>, and F<super>609</super> are critical for Ca<super>2+</super> entry into the cell. Patch-clamp electrophysiology of a chimeric ion channel consisting largely of rat TRPV4, but encompassing transmembranes 5 through 6 of OSM-9, revealed that OSM-9 conducts both Ca<super>2+</super> and Na<super>+</super>. Mutation Y604G disrupted both Ca<super>2+</super> and Na<super>+</super> conductance, whereas mutations Y604F and Y606A increased or maintained Na+ conductance and severely reduced Ca<super>2+</super> conductance, while maintaining avoidance behavior. Homology modeling of OSM-9, based on an alignment of OSM-9 to Kv1.2, suggests that Y<super>604</super> and F<super>609</super> serve structural roles in maintaining filter constraints. Thus, aromatic and negative residues in the OSM-9 selectivity filter are critical to ion permeation and selectivity. </p><p>Our studies involving the selectivity filter support previous research that the selectivity filter is critical for TRP channel function. We also provide evidence that the selectivity filter is critical for nocifensive animal behavior. Fewer studies, however, have investigated the TM5-pore helix linker, known as the turret. The turret is believed to function in the binding of ligands and toxins in K<super>+</super> channels, and more recently was suggested to be critical for temperature sensing in TRPV1. We investigated the function of the turret residues in several sensory submodalities of the OSM-9 channel and found that all deletions tested result in channel defects, including gain- and loss-of-function phenotypes. Several charge reversal mutations in the OSM-9 turret also resulted in partial defects. The discovery of a gain-of-function mutation indicates that the turret functions in gating. When the turret is mutated in this way, the channel is unable to enter into the inactivated state, allowing continued ion influx after repeated stimulation. The loss-of-function phenotypes indicate that the secondary structure of the turret is critical to the function of the channel, and perhaps gating. These findings, combined with the observed charge-reversal defects, support the conclusion that the turret is necessary for transducing conformational changes in response to stimuli.</p><p>Our <italic>in vivo</italic> findings on the external pore forming structures increase the understanding of ion permeation in TRP channels and clarify mechanisms of activation in nociceptor neurons <italic>in vivo</italic>. Furthermore, these studies enhance our insights into evolution of mammalian nociception in view of the established functional orthology of OSM-9 and TRPV4.</p> / Dissertation

Made available in DSpace on 2014-12-17T14:05:23Z (GMT). No. of bitstreams: 1 UaskaBS_TESE.pdf: 2951660 bytes, checksum: 93152a3c6ea30c7f4eaa465f3f5d2969 (MD5) Previous issue date: 2013-04-16 / Conselho Nacional de Desenvolvimento Cient?fico e Tecnol?gico / The screening for genes in metagenomic libraries from soil creates opportunities to explore the enormous genetic and metabolic diversity of microorganisms. Rivers are ecosystems with high biological diversity, but few were examined using the metagenomic approach. With this objective, a metagenomic library was constructed from DNA soil samples collected at three different points along the Jundia?-river (Rio Grande do Norte-Brazil). The points sampled are from open area, rough terrain and with the direct incidence of sunlight. This library was analyzed functionally and based in sequence. For functional analysis Luria-Bertani solid medium (LB) with NaCl concentration varied from 0.17M to 0.85M was used for functional analysis. Positives clones resistant to hypersaline medium were obtained. The recombinant DNAs were extracted and transformed into Escherichia coli strain DH10B and survival curves were obtained for quantification of abiotic stress resistance. The sequences of clones were obtained and submitted to the BLASTX tool. Some clones were found to hypothetical proteins of microorganisms from both Archaea and Bacteria division. One of the clones showed a complete ORF with high similarity to glucose-6-phosphate isomerase which participates in the synthesis of glycerol pathway and serves as a compatible solute to balance the osmotic pressure inside and outside of cells. Subsequently, in order to identify genes encoding osmolytes or enzymes related halotolerance, environmental DNA samples from the river soil, from the water column of the estuary and ocean were collected and pyrosequenced. Sequences of osmolytes and enzymes of different microorganisms were obtained from the UniProt and used as RefSeqs for homology identification (TBLASTN) in metagenomic databases. The sequences were submitted to HMMER for the functional domains identification. Some enzymes were identified: alpha-trehalose-phosphate synthase, L-ectoina synthase (EctC), transaminase L-2 ,4-diaminobutyric acid (EctB), L-2 ,4-diaminobutyric acetyltransferase (EctA), L-threonine 3 dehydrogenase (sorbitol pathway), glycerol-3-phosphate dehydrogenase, inositol 3-phosphate dehydrogenase, chaperones, L-proline, glycine betaine binding ABC transporter, myo-inositol-1-phosphate synthase protein of proline simportadora / PutP sodium-and trehalose-6-phosphate phosphatase These proteins are commonly related to saline environments, however the identification of them in river environment is justified by the high salt concentration in the soil during prolonged dry seasons this river. Regarding the richness of the microbiota the river substrate has an abundance of halobacteria similar to the sea and more than the estuary. These data confirm the existence of a specialized response against salt stress by microorganisms in the environment of the Jundia? river / A busca por genes baseada na constru??o e an?lise de bibliotecas metagen?micas a partir de solo gera oportunidades para explorar uma enorme diversidade gen?tica e metab?lica de microrganismos. Os rios s?o ecossistemas com alta diversidade biol?gica, mas ainda pouco explorados por meio de metagen?mica. Com o objetivo de explorar a diversidade microbiana, uma biblioteca metagen?mica foi constru?da a partir de DNA extra?do de substrato de rio em tr?s pontos ao longo do rio Jundia? (Rio Grande do Norte-Brasil). Os pontos de amostragem s?o derivados de ?rea aberta, terreno acidentado e com a incid?ncia direta da luz solar. Esta biblioteca foi analisada funcionalmente e tamb?m com base em sequ?ncias. Para a an?lise funcional foi utilizado meio de cultura s?lido LB com concentra??o de NaCl variando de 0,17M a 0,85M. Foram obtidos 15 clones positivos com caracter?sticas halotolerantes. Os DNAs recombinantes foram extra?dos e retransformados em cepa de Escherichia coli DH10B e curvas de sobreviv?ncia foram obtidas para confirma??o e quantifica??o da resist?ncia ao estresse abi?tico. As sequ?ncias dos clones foram obtidas e submetidas a ferramenta BLASTX e assim foi comprovado que alguns clones codificavam prote?nas hipot?ticas. Um dos clones apresentou uma ORF completa com elevada similaridade de glucose-6-fosfato-isomerase que participa na s?ntese do precursor de glicerol, sendo um soluto compat?vel para equilibrar a press?o osm?tica no interior e no exterior das c?lulas. Posteriormente, para identifica??o de genes que codificam osm?litos relacionados com halotoler?ncia e identifica??o da diversidade microbiol?gica, amostras de DNA ambiental do substrato do rio e da coluna d??gua do estu?rio e oceano foram coletadas e pirosequenciadas. As sequ?ncias de osm?litos de diferentes microrganismos foram obtidas a partir do UniProt e utilizadas como RefSeqs para a identifica??o por homologia (TBLASTN) nos bancos de dados metagen?micos. As sequ?ncias identificadas nos bancos de dados ambientais foram submetidas ao programa HMMER com o fim de identificar dom?nios funcionais. Foram identificadas as enzimas: alfa-trealose-fosfato sintase, L-ectoina sintase (ectC), transaminase do ?cido L-2,4-diaminobut?rico (EctB), ?cido L-2 ,4-diaminobut?rico acetiltransferase (EctA), L-treonina 3-desidrogenase (via de s?ntese do sorbitol), Glicerol-3-fosfato desidrogenase, inositol-3-fosfato desidrogenase, chaperonas, L-prolina glicina beta?na liga??o transportador ABC, mio-inositol-1-fosfato sintase, a prote?na simportadora de prolina/s?dio -PutP e trealose-6-fosfato fosfatase. Estas s?o enzimas que participam da s?ntese de osm?litos comumente relacionados a ambientes salinos, no entanto a identifica??o desses solutos em ambiente de rio ? justificada pela elevada concentra??o salina no solo durante prolongadas esta??es de seca neste rio. Quanto ? riqueza da microbiota foi identificado que o substrato do rio possui uma abund?ncia de halobact?rias semelhante a do mar e superior a do estu?rio. Esses dados confirmam a exist?ncia de uma resposta especializada contra o estresse salino por microrganismos no ambiente do rio Jundia?

Cervical cancer still represents the fourth most common cause of cancer deaths in women worldwide. Human papilloma virus (HPV) infection plays a role in cervical carcinoma initiation, but other genomic changes are needed for pre-malignant abnormalities to fully develop to cancer. This often happens through genomic instability caused by the virus oncoproteins. Several integrative genomic analysis studies have found that one of the most common imbalances in cervical squamous cell carcinoma (SCC) is copy number gain and amplification of chromosome 5p. In this region, copy number gain of the OSMR gene was found to correlate significantly with adverse outcome independent of the tumour stage (p=0.046). Furthermore, this copy number gain correlated with Oncostatin M receptor (OSMR) overexpression and sensitised these cells to Oncostatin M (OSM) leading to increased Signal transducer and activator of transcription 3 (STAT3) phosphorylation, cell migration, invasion and proangiogenic signalling. The aim of this PhD project was to study the role of OSMR overexpression in the SCC tumour microenvironment (TME) and tumour growth in vivo and to study the role of hypoxia inducible factor driven hypoxia signalling in OSMR overexpressing SCC cells and their tumour microenvironment. OSMR overexpression was found to sensitise tumour cells to induce Hypoxia inducible factor 1a and 2a (HIF1a, HIF2a) signalling in normoxic conditions, to promote pro-angiogenic signalling. Furthermore, hypoxic conditions were found to enhance OSM signalling in OSMR overexpressing cells leading to increased expression of markers of epithelial to mesenchymal transition, angiogenesis and migration. In the SCC tumour microenvironment, OSMR overexpression was found to sensitise tumour cells to OSM secreted from macrophages and other immune cells leading to improved tumour growth, angiogenesis and STAT3 activation at the tumour site. Removal of OSMR from either tumour cells or tumour microenvironment led to reduced tumour growth and angiogenesis, along with increased tumour necrosis. I conclude that OSMR overexpression is an important driver of SCC tumour progression and malignancy via STAT3- and HIF-driven signalling and removal of it from either tumour cells or tumour microenvironment drastically hampers tumour growth in vivo. Based on the results of this study, OSMR blockade is a potential novel therapeutic option in advanced SCC.

Submitted by Automa??o e Estat?stica (sst@bczm.ufrn.br) on 2017-04-24T18:20:13Z No. of bitstreams: 1 AntonioDeAnchietaCamaraJunior_DISSERT.pdf: 21070528 bytes, checksum: bc9c34ff6fd37e4d09b586b82e55c977 (MD5) / Approved for entry into archive by Monica Paiva (monicalpaiva@hotmail.com) on 2017-04-24T18:29:24Z (GMT) No. of bitstreams: 1 AntonioDeAnchietaCamaraJunior_DISSERT.pdf: 21070528 bytes, checksum: bc9c34ff6fd37e4d09b586b82e55c977 (MD5) / Made available in DSpace on 2017-04-24T18:29:24Z (GMT). No. of bitstreams: 1 AntonioDeAnchietaCamaraJunior_DISSERT.pdf: 21070528 bytes, checksum: bc9c34ff6fd37e4d09b586b82e55c977 (MD5) Previous issue date: 2014-10-07 / Conselho Nacional de Desenvolvimento Cient?fico e Tecnol?gico (CNPq) / Mol?culas bioativas tais como flavonoides, antioxidantes e vitaminas podem ser incorporadas a produtos aliment?cios com apelo funcional. No entanto, flavonoides lipossol?veis como a fisetina possuem biodisponibilidade reduzida quando submetidos ao pH do trato gastrointestinal humano. Nesse caso, a microencapsula??o desse tipo de bioativo em c?lulas de levedura Saccharomyces cerevisiae atrav?s de choque osm?tico ? uma estrat?gia promissora para proteger e transportar essas subst?ncias in vivo. Contudo, at? o presente n?o havia sido relatado estudo quantitativo sobre esse processo. Desse modo, este trabalho avaliou a efici?ncia do processo de encapsula??o (EE) e o teor de fisetina internalizada (FI) nas c?lulas da levedura atrav?s de dois m?todos de quantifica??o: (1) cromatografia l?quida de alta efici?ncia (CLAE) e (2) espectrofotometria UV-Vis?vel. Os par?metros operacionais foram determinados por meio do delineamento composto central rotacional 23. As vari?veis analisadas foram a concentra??o de fisetina (C), a press?o osm?tica de desidrata??o (P) e a temperatura do processo (T). A caracteriza??o das c?lulas foi realizada atrav?s de microscopia confocal a laser (MCL), microscopia eletr?nica de varredura (MEV) e viabilidade celular. Os melhores resultados foram obtidos pelo m?todo 2 nas condi??es dos pontos centrais (C = 2,00 mg.mL-1, P = 30 MPa e T = 25 ?C), onde a EE = 33,30 % e teor de FI = 1,20 mg. Os ensaios de MCL mostraram que a etapa de lavagem com etanol, indispens?vel no m?todo 1, influenciou negativamente a EE e o teor de FI. As imagens em alta resolu??o capturadas pela MEV mostraram que o choque osm?tico n?o afetou a estrutura encapsulante do envelope celular da levedura. A manuten??o das c?lulas em solu??es com P ? 30 MPa reduziu ligeiramente a viabilidade celular (84 % vi?veis) e a compara??o com a amostra controle n?o mostrou diferen?a significativa (p.< 0,05). Os resultados encontrados demonstram o forte potencial do uso das leveduras como matrizes encapsulantes para componentes bioativos sens?veis. Estes resultados demonstram que essa t?cnica pode ser aplicada com sucesso na produ??o de produtos aliment?cios com alto teor de compostos bioativos. / Mol?culas bioativas tais como flavonoides, antioxidantes e vitaminas podem ser incorporadas a produtos aliment?cios com apelo funcional. No entanto, flavonoides lipossol?veis como a fisetina possuem biodisponibilidade reduzida quando submetidos ao pH do trato gastrointestinal humano. Nesse caso, a microencapsula??o desse tipo de bioativo em c?lulas de levedura Saccharomyces cerevisiae atrav?s de choque osm?tico ? uma estrat?gia promissora para proteger e transportar essas subst?ncias in vivo. Contudo, at? o presente n?o havia sido relatado estudo quantitativo sobre esse processo. Desse modo, este trabalho avaliou a efici?ncia do processo de encapsula??o (EE) e o teor de fisetina internalizada (FI) nas c?lulas da levedura atrav?s de dois m?todos de quantifica??o: (1) cromatografia l?quida de alta efici?ncia (CLAE) e (2) espectrofotometria UV-Vis?vel. Os par?metros operacionais foram determinados por meio do delineamento composto central rotacional 23. As vari?veis analisadas foram a concentra??o de fisetina (C), a press?o osm?tica de desidrata??o (P) e a temperatura do processo (T). A caracteriza??o das c?lulas foi realizada atrav?s de microscopia confocal a laser (MCL), microscopia eletr?nica de varredura (MEV) e viabilidade celular. Os melhores resultados foram obtidos pelo m?todo 2 nas condi??es dos pontos centrais (C = 2,00 mg.mL-1, P = 30 MPa e T = 25 ?C), onde a EE = 33,30 % e teor de FI = 1,20 mg. Os ensaios de MCL mostraram que a etapa de lavagem com etanol, indispens?vel no m?todo 1, influenciou negativamente a EE e o teor de FI. As imagens em alta resolu??o capturadas pela MEV mostraram que o choque osm?tico n?o afetou a estrutura encapsulante do envelope celular da levedura. A manuten??o das c?lulas em solu??es com P ? 30 MPa reduziu ligeiramente a viabilidade celular (84 % vi?veis) e a compara??o com a amostra controle n?o mostrou diferen?a significativa (p.< 0,05). Os resultados encontrados demonstram o forte potencial do uso das leveduras como matrizes encapsulantes para componentes bioativos sens?veis. Estes resultados demonstram que essa t?cnica pode ser aplicada com sucesso na produ??o de produtos aliment?cios com alto teor de compostos bioativos.

Transport simulation models play a crucial role in transportation planning, design, and operations, allowing for the replication of various scenarios through the incorporation of real-world data and parameters. Recently, agent-based transport models have gained prominence for their ability to simulate intricate metropolitan transport systems. These models take into account the distinct characteristics, decision-making processes, and interactions of individual agents. Among the array of agent-based transport models, MATSim stands out as a potent and adaptable tool for modeling transportation systems. A critical aspect of MATSim’s input preparation involves assigning activity location points using land use raster data. However, the characteristics of land use raster data present limitations in certain urban case studies such as Stockholm. In response, some researchers have turned their attention to buildings shapefile data, a commonly used geospatial data format. This study aims to improve the activity location assignment model by developing an evaluation workflow of model uncertainty for different geospatial input data in MATSim and empirically analyzing their impacts on simulation outcomes. Despite acknowledging data availability and activity representation limitations, the study’s results demonstrate that utilizingbuildings shapefiles as input data yields more consistent outcomes with reduced uncertainty. This suggests the promising potential of buildings shapefiles as a favorable data source for transportation modeling and planning within the studied scenarios.

Today, “zoomable” maps are a state-of-the-art way to explore the world, available to anyone with Internet access. However, the process of creating this visualization has been rather loosely investigated and documented. Nevertheless, with an increasing amount of available data, interactive maps have become a more integral approach to visualizing and exploring big datasets and user-generated data. OpenStreetMap and online platforms such as Twitter and Flickr offer application programming interfaces (APIs) with geographic information. They are well-known examples of this visualization challenge and are often used as examples. In addition, an increasing number of public administrations collect open data and publish their data sets, which makes the task of visualization even more relevant. This dissertation deals with the visualization of user-generated geodata as a multiscale map. The basics of today’s multiscale maps—their history, technologies, and possibilities—are explored and abstracted. This work introduces two new multiscale-focused visualization approaches for point data from volunteered geographic information (VGI) and location-based social media (LBSM). One contribution of this effort is a visualization methodology for spatially referenced information in the form of point geometries, using nominally scaled data from social media such as Twitter or Flickr. Typical for this data is a high number of social media posts in different categories—a post on social media corresponds to a point in a specific category. Due to the sheer quantity and similar characteristics, the posts appear generic rather than unique. This type of dataset can be explored using the new method of micro diagrams to visualize the dataset on multiple scales and resolutions. The data is aggregated into small grid cells, and the numerical proportion is shown with small diagrams, which can visually merge into heterogenous areas through colors depicting a specific category. The diagram sizes allow the user to estimate the overall number of aggregated points in a grid cell. A different visualization approach is proposed for more unique points, considered points of interest (POI), based on the selection method. The goal is to identify more locally relevant points from the data set, considered more important compared to other points in the neighborhood, which are then compared by numerical attribute. The method, derived from topographic isolation and called discrete isolation, is the distance from one point to the next with a higher attribute value. By using this measure, the most essential points can be easily selected by choosing a minimum distance and producing a homogenous spatial of the selected points within the chosen dataset. The two newly developed approaches are applied to multiscale mapping by constructing example workflows that produce multiscale maps. The publicly available multiscale mapping workflows OpenMapTiles and OpenStreetMap Carto, using OpenStreetMap data, are systematically explored and analyzed. The result is a general workflow for multiscale map production and a short overview of the toolchain software. In particular, the generalization approaches in the example projects are discussed and these are classified into cartographic theories on the basis of literature. The workflow is demonstrated by building a raster tile service for the micro diagrams and a vector tile service for the discrete isolation, able to be used with just a web browser. In conclusion, these new approaches for point data using VGI and LBSM allow better qualitative visualization of geodata. While analyzing vast global datasets is challenging, exploring and analyzing hidden data patterns is fruitful. Creating this degree of visualization and producing maps on multiple scales is a complicated task. The workflows and tools provided in this thesis will make map production on a worldwide scale easier.:1 Introduction 1 1.1 Motivation .................................................................................................. 3 1.2 Visualization of crowdsourced geodata on multiple scales ............ 5 1.2.1 Research objective 1: Visualization of point collections ......... 6 1.2.2 Research objective 2: Visualization of points of interest ......... 7 1.2.3 Research objective 3: Production of multiscale maps ............. 7 1.3 Reader’s guide ......................................................................................... 9 1.3.1 Structure ........................................................................................... 9 1.3.2 Related Publications ....................................................................... 9 1.3.3 Formatting and layout ................................................................. 10 1.3.4 Online examples ........................................................................... 10 2 Foundations of crowdsourced mapping on multiple scales 11 2.1 Types and properties of crowdsourced data .................................. 11 2.2 Currents trends in cartography ......................................................... 11 2.3 Definitions .............................................................................................. 12 2.3.1 VGI .................................................................................................. 12 2.3.2 LBSM .............................................................................................. 13 2.3.3 Space, place, and location......................................................... 13 2.4 Visualization approaches for crowdsourced geodata ................... 14 2.4.1 Review of publications and visualization approaches ........... 14 2.4.2 Conclusions from the review ...................................................... 15 2.4.3 Challenges mapping crowdsourced data ................................ 17 2.5 Technologies for serving multiscale maps ...................................... 17 2.5.1 Research about multiscale maps .............................................. 17 2.5.2 Web Mercator projection ............................................................ 18 2.5.3 Tiles and zoom levels .................................................................. 19 2.5.4 Raster tiles ..................................................................................... 21 2.5.5 Vector tiles .................................................................................... 23 2.5.6 Tiling as a principle ..................................................................... 25 3 Point collection visualization with categorized attributes 26 3.1 Target users and possible tasks ....................................................... 26 3.2 Example data ......................................................................................... 27 3.3 Visualization approaches .................................................................... 28 3.3.1 Common techniques .................................................................... 28 3.3.2 The micro diagram approach .................................................... 30 3.4 The micro diagram and its parameters ............................................ 33 3.4.1 Aggregating points into a regular structure ............................ 33 3.4.2 Visualizing the number of data points ...................................... 35 3.4.3 Grid and micro diagrams ............................................................ 36 3.4.4 Visualizing numerical proportions with diagrams .................. 37 3.4.5 Influence of color and color brightness ................................... 38 3.4.6 Interaction options with micro diagrams .................................. 39 3.5 Application and user-based evaluation ............................................ 39 3.5.1 Micro diagrams in a multiscale environment ........................... 39 3.5.2 The micro diagram user study ................................................... 41 3.5.3 Point collection visualization discussion .................................. 47 4 Selection of POIs for visualization 50 4.1 Approaches for point selection .......................................................... 50 4.2 Methods for point selection ................................................................ 51 4.2.1 Label grid approach .................................................................... 52 4.2.2 Functional importance approach .............................................. 53 4.2.3 Discrete isolation approach ....................................................... 54 4.3 Functional evaluation of selection methods .................................... 56 4.3.1 Runtime comparison .................................................................... 56 4.3.2 Use cases for discrete isolation ................................................ 57 4.4 Discussion of the selection approaches .......................................... 61 4.4.1 A critical view of the use cases ................................................. 61 4.4.2 Comparing the approaches ........................................................ 62 4.4.3 Conclusion ..................................................................................... 64 5 Creating multiscale maps 65 5.1 Examples of multiscale map production .......................................... 65 5.1.1 OpenStreetMap Infrastructure ................................................... 66 5.1.2 OpenStreetMap Carto ................................................................. 67 5.1.3 OpenMapTiles ............................................................................... 73 5.2 Methods of multiscale map production ............................................ 80 5.2.1 OpenStreetMap tools ................................................................... 80 5.2.2 Geoprocessing .............................................................................. 80 5.2.3 Database ........................................................................................ 80 5.2.4 Creating tiles ................................................................................. 82 5.2.5 Caching .......................................................................................... 82 5.2.6 Styling tiles .................................................................................... 82 5.2.7 Viewing tiles ................................................................................... 83 5.2.8 The stackless approach to tile creation ................................... 83 5.3 Example workflows for creating multiscale maps ........................... 84 5.3.1 Raster tiles: OGC services and micro diagrams .................... 84 5.3.2 Vector tiles: Slippy map and vector tiles ................................. 87 5.4 Discussion of approaches and workflows ....................................... 90 5.4.1 Map production as a rendering pipeline .................................. 90 5.4.2 Comparison of OpenStreetMap Carto and OpenMapTiles .. 92 5.4.3 Discussion of the implementations ........................................... 93 5.4.4 Generalization in map production workflows .......................... 95 5.4.5 Conclusions ................................................................................. 101 6 Discussion 103 6.1 Development for web mapping ........................................................ 103 6.1.1 The role of standards in map production .............................. 103 6.1.2 Technological development ..................................................... 103 6.2 New data, new mapping techniques? ............................................. 104 7 Conclusion 106 7.1 Visualization of point collections ..................................................... 106 7.2 Visualization of points of interest ................................................... 107 7.3 Production of multiscale maps ........................................................ 107 7.4 Synthesis of the research questions .............................................. 108 7.5 Contributions ....................................................................................... 109 7.6 Limitations ............................................................................................ 110 7.7 Outlook ................................................................................................. 111 8 References 113 9 Appendix 130 9.1 Zoom levels and Scale ...................................................................... 130 9.3 Full information about selected UGC papers ................................ 131 9.4 Timeline of mapping technologies .................................................. 133 9.5 Timeline of map providers ................................................................ 133 9.6 Code snippets from own map production workflows .................. 134 9.6.1 Vector tiles workflow ................................................................. 134 9.6.2 Raster tiles workflow.................................................................. 137 / Heute sind zoombare Karten Alltag für jeden Internetznutzer. Die Erstellung interaktiv zoombarer Karten ist allerdings wenig erforscht, was einen deutlichen Gegensatz zu ihrer aktuellen Bedeutung und Nutzungshäufigkeit darstellt. Die Forschung in diesem Bereich ist also umso notwendiger. Steigende Datenmengen und größere Regionen, die von Karten abgedeckt werden sollen, unterstreichen den Forschungsbedarf umso mehr. Beispiele für stetig wachsende Datenmengen sind Geodatenquellen wie OpenStreetMap aber auch freie amtliche Geodatensätze (OpenData), aber auch die zunehmende Zahl georeferenzierter Inhalte auf Internetplatformen wie Twitter oder Flickr zu nennen. Das Thema dieser Arbeit ist die Visualisierung eben dieser nutzergenerierten Geodaten mittels zoombarer Karten. Dafür wird die Entwicklung der zugrundeliegenden Technologien über die letzten zwei Jahr-zehnte und die damit verbundene Möglichkeiten vorgestellt. Weitere Beiträge sind zwei neue Visualisierungsmethoden, die sich besonders für die Darstellung von Punktdaten aus raumbezogenen nutzergenerierten Daten und georeferenzierte Daten aus Sozialen Netzwerken eignen. Ein Beitrag dieser Arbeit ist eine neue Visualisierungsmethode für raumbezogene Informationen in Form von Punktgeometrien mit nominal skalierten Daten aus Sozialen Medien, wie beispielsweise Twitter oder Flickr. Typisch für diese Daten ist eine hohe Anzahl von Beiträgen mit unterschiedlichen Kategorien. Wobei die Beiträge, bedingt durch ihre schiere Menge und ähnlicher Ei-genschaften, eher generisch als einzigartig sind. Ein Beitrag in den So-zia len Medien entspricht dabei einem Punkt mit einer bestimmten Katego-rie. Ein solcher Datensatz kann mit der neuen Methode der „micro diagrams“ in verschiedenen Maßstäben und Auflösungen visualisiert und analysiert werden. Dazu werden die Daten in kleine Gitterzellen aggregiert. Die Menge und Verteilung der über die Kategorien aggregierten Punkte wird durch kleine Diagramme dargestellt, wobei die Farben die verschiedenen Kategorien visualisieren. Durch die geringere Größe der einzelnen Diagramme verschmelzen die kleinen Diagramme visuell, je nach der Verteilung der Farben für die Kategorien. Bei genauerem Hinsehen ist die Schätzung der Menge der aggregierten Punkte über die Größe der Diagramme die Menge und die Verteilung über die Kategorien möglich. Für einzigartigere Punkte, die als Points of Interest (POI) angesehen werden, wird ein anderer Visualisierungsansatz vorgeschlagen, der auf einer Auswahlmethode basiert. Ziel ist es dabei lokal relevantere Punkte aus dem Datensatz zu identifizieren, die im Vergleich zu anderen Punkten in der Nachbarschaft des Punktes verglichen nach einem numerischen Attribut wichtiger sind. Die Methode ist von dem geographischen Prinzip der Dominanz von Bergen abgeleitet und wird „discrete isolation“ genannt. Es handelt sich dabei um die Distanz von einem Punkt zum nächsten mit einem höheren Attributwert. Durch die Verwendung dieses Maßes können lokal bedeutende Punkte leicht ausgewählt werden, indem ein minimaler Abstand gewählt und so räumlich gleichmäßig verteilte Punkte aus dem Datensatz ausgewählt werden. Die beiden neu vorgestellten Methoden werden in den Kontext der zoombaren Karten gestellt, indem exemplarische Arbeitsabläufe erstellt werden, die als Er-gebnis eine zoombare Karte liefern. Dazu werden die frei verfügbaren Beispiele zur Herstellung von weltweiten zoombaren Karten mit nutzergenerierten Geo-daten von OpenStreetMap, anhand der Kartenprojekte OpenMapTiles und O-penStreetMap Carto analysiert und in Arbeitsschritte gegliedert. Das Ergebnis ist ein wiederverwendbarer Arbeitsablauf zur Herstellung zoombarer Karten, ergänzt durch eine Auswahl von passender Software für die einzelnen Arbeits-schritte. Dabei wird insbesondere auf die Generalisierungsansätze in den Beispielprojekten eingegangen und diese anhand von Literatur in die kartographische Theorie eingeordnet. Zur Demonstration des Workflows wird je ein Raster Tiles Dienst für die „micro diagrams“ und ein Vektor Tiles Dienst für die „discrete isolation“ erstellt. Beide Dienste lassen sich mit einem aktuellen Webbrowser nutzen. Zusammenfassend ermöglichen diese neuen Visualisierungsansätze für Punkt-daten aus VGI und LBSM eine bessere qualitative Visualisierung der neuen Geodaten. Die Analyse riesiger globaler Datensätze ist immer noch eine Herausforderung, aber die Erforschung und Analyse verborgener Muster in den Daten ist lohnend. Die Erstellung solcher Visualisierungen und die Produktion von Karten in verschiedenen Maßstäben ist eine komplexe Aufgabe. Die in dieser Arbeit vorgestellten Arbeitsabläufe und Werkzeuge erleichtern die Erstellung von Karten in globalem Maßstab.:1 Introduction 1 1.1 Motivation .................................................................................................. 3 1.2 Visualization of crowdsourced geodata on multiple scales ............ 5 1.2.1 Research objective 1: Visualization of point collections ......... 6 1.2.2 Research objective 2: Visualization of points of interest ......... 7 1.2.3 Research objective 3: Production of multiscale maps ............. 7 1.3 Reader’s guide ......................................................................................... 9 1.3.1 Structure ........................................................................................... 9 1.3.2 Related Publications ....................................................................... 9 1.3.3 Formatting and layout ................................................................. 10 1.3.4 Online examples ........................................................................... 10 2 Foundations of crowdsourced mapping on multiple scales 11 2.1 Types and properties of crowdsourced data .................................. 11 2.2 Currents trends in cartography ......................................................... 11 2.3 Definitions .............................................................................................. 12 2.3.1 VGI .................................................................................................. 12 2.3.2 LBSM .............................................................................................. 13 2.3.3 Space, place, and location......................................................... 13 2.4 Visualization approaches for crowdsourced geodata ................... 14 2.4.1 Review of publications and visualization approaches ........... 14 2.4.2 Conclusions from the review ...................................................... 15 2.4.3 Challenges mapping crowdsourced data ................................ 17 2.5 Technologies for serving multiscale maps ...................................... 17 2.5.1 Research about multiscale maps .............................................. 17 2.5.2 Web Mercator projection ............................................................ 18 2.5.3 Tiles and zoom levels .................................................................. 19 2.5.4 Raster tiles ..................................................................................... 21 2.5.5 Vector tiles .................................................................................... 23 2.5.6 Tiling as a principle ..................................................................... 25 3 Point collection visualization with categorized attributes 26 3.1 Target users and possible tasks ....................................................... 26 3.2 Example data ......................................................................................... 27 3.3 Visualization approaches .................................................................... 28 3.3.1 Common techniques .................................................................... 28 3.3.2 The micro diagram approach .................................................... 30 3.4 The micro diagram and its parameters ............................................ 33 3.4.1 Aggregating points into a regular structure ............................ 33 3.4.2 Visualizing the number of data points ...................................... 35 3.4.3 Grid and micro diagrams ............................................................ 36 3.4.4 Visualizing numerical proportions with diagrams .................. 37 3.4.5 Influence of color and color brightness ................................... 38 3.4.6 Interaction options with micro diagrams .................................. 39 3.5 Application and user-based evaluation ............................................ 39 3.5.1 Micro diagrams in a multiscale environment ........................... 39 3.5.2 The micro diagram user study ................................................... 41 3.5.3 Point collection visualization discussion .................................. 47 4 Selection of POIs for visualization 50 4.1 Approaches for point selection .......................................................... 50 4.2 Methods for point selection ................................................................ 51 4.2.1 Label grid approach .................................................................... 52 4.2.2 Functional importance approach .............................................. 53 4.2.3 Discrete isolation approach ....................................................... 54 4.3 Functional evaluation of selection methods .................................... 56 4.3.1 Runtime comparison .................................................................... 56 4.3.2 Use cases for discrete isolation ................................................ 57 4.4 Discussion of the selection approaches .......................................... 61 4.4.1 A critical view of the use cases ................................................. 61 4.4.2 Comparing the approaches ........................................................ 62 4.4.3 Conclusion ..................................................................................... 64 5 Creating multiscale maps 65 5.1 Examples of multiscale map production .......................................... 65 5.1.1 OpenStreetMap Infrastructure ................................................... 66 5.1.2 OpenStreetMap Carto ................................................................. 67 5.1.3 OpenMapTiles ............................................................................... 73 5.2 Methods of multiscale map production ............................................ 80 5.2.1 OpenStreetMap tools ................................................................... 80 5.2.2 Geoprocessing .............................................................................. 80 5.2.3 Database ........................................................................................ 80 5.2.4 Creating tiles ................................................................................. 82 5.2.5 Caching .......................................................................................... 82 5.2.6 Styling tiles .................................................................................... 82 5.2.7 Viewing tiles ................................................................................... 83 5.2.8 The stackless approach to tile creation ................................... 83 5.3 Example workflows for creating multiscale maps ........................... 84 5.3.1 Raster tiles: OGC services and micro diagrams .................... 84 5.3.2 Vector tiles: Slippy map and vector tiles ................................. 87 5.4 Discussion of approaches and workflows ....................................... 90 5.4.1 Map production as a rendering pipeline .................................. 90 5.4.2 Comparison of OpenStreetMap Carto and OpenMapTiles .. 92 5.4.3 Discussion of the implementations ........................................... 93 5.4.4 Generalization in map production workflows .......................... 95 5.4.5 Conclusions ................................................................................. 101 6 Discussion 103 6.1 Development for web mapping ........................................................ 103 6.1.1 The role of standards in map production .............................. 103 6.1.2 Technological development ..................................................... 103 6.2 New data, new mapping techniques? ............................................. 104 7 Conclusion 106 7.1 Visualization of point collections ..................................................... 106 7.2 Visualization of points of interest ................................................... 107 7.3 Production of multiscale maps ........................................................ 107 7.4 Synthesis of the research questions .............................................. 108 7.5 Contributions ....................................................................................... 109 7.6 Limitations ............................................................................................ 110 7.7 Outlook ................................................................................................. 111 8 References 113 9 Appendix 130 9.1 Zoom levels and Scale ...................................................................... 130 9.3 Full information about selected UGC papers ................................ 131 9.4 Timeline of mapping technologies .................................................. 133 9.5 Timeline of map providers ................................................................ 133 9.6 Code snippets from own map production workflows .................. 134 9.6.1 Vector tiles workflow ................................................................. 134 9.6.2 Raster tiles workflow.................................................................. 137

OpenStreetMap (OSM) konnte sich seit der Gründung 2004 sehr schnell etablieren und stellt mittlerweile eine konkrete Alternative gegenüber vergleichbaren kommerziellen Anwendungen dar. Dieser Erfolg ist eindeutig auf das revolutionäre Grundkonzept des Projektes zurückzuführen. Weltweit werden räumliche Daten durch Mitglieder erhoben und dem Projekt OSM zur Verfügung gestellt. Über die zugrunde liegenden Lizenzbestimmungen wird sichergestellt, dass OSM-Daten frei verfügbar und kostenfrei weiter verwendbar sind. Vor allem die Vorstellung der Unabhängigkeit von proprietären Daten hat zu starker, weiterhin zunehmender globaler Beteiligung geführt. Resultierend daraus erreichen die verfügbaren Daten inzwischen hohe Dichte sowie Genauigkeit. Visualisierungen in Form von interaktiven, frei skalierbaren Weltkarten, welche über die vollständig automatisierten Softwarelösungen Mapnik und Osmarender erstellt werden, sind am weitesten verbreitet. Infolgedessen müssen kartographische Grundsätze und Regeln formalisiert und implementiert werden. Insbesondere in Bezug auf kartographische Generalisierung treten teils erhebliche Mängel in den entsprechenden Umsetzungen auf. Dies bildet den Ausgangspunkt der Untersuchung. Ausgehend von einer Ist-Analyse werden vorhandene Defizite identifiziert und anschließend Möglichkeiten zur Integration von Generalisierungsfunktionalitäten untersucht. Aktuelle Entwicklungen streben die Anwendung interoperabler Systeme im Kontext kartographischer Generalisierung an, mit dem Ziel Generalisierungsfunktionalitäten über das Internet bereitzustellen. Grundlage hierfür bilden die vom Open Geospatial Consortium (OGC) spezifizierten Web Processing Services (WPS). Sie ermöglichen die Analyse und Verarbeitung räumlicher Daten. In diesem Zusammenhang werden Web Generalization Services (WebGen-WPS) auf mögliche Integration in die Softwarelösungen untersucht und bilden somit einen zentralen Untersuchungsgegenstand der vorliegenden Arbeit. Mapnik stellt, nicht zuletzt durch dessen offengelegten Quelltext („Open Source“), optimale Voraussetzungen für jene Implementierungen zur Verfügung. Zur Verarbeitung von OSM-Daten verwendet Mapnik die freie Geodatenbank PostGIS, welche ebenfalls Funktionalitäten zur Analyse und Verarbeitung räumlicher Daten liefert. In diesem Kontext wird zusätzlich untersucht, inwiefern PostGIS-Funktionen Potential zur Anwendung kartographischer Generalisierung aufweisen. / OpenStreetMap (OSM) has established very quickly since its founding in 2004 and has become a suitable alternative to similar commercial applications. This success is clearly due to the revolutionary concept of the project. Spatial data is collected by members world-wide and is provided to the project OSM. The underlying license aggreement ensures that OSM-Data is freely available and can be used free of charge. Primarily, the idea of independence from proprietary data has led to strong, still growing, global participation. Resulting from that, the available data is now achieving high density and accuracy. Visualizations in form of interactive, freely scalable maps of the world, which are constructed by the fully automated software solutions Mapnik and Osmarender are most common. In consequence cartographic principles and rules must be formalized and implemented. Particularly with respect to cartographic generalization, some serious faults appear in the corresponding implementations. This is the starting point of this diploma thesis. Based on an analysis of the current state, actual existing deficiencies are identified and then examined for possibilities to integrate generalization functionalities. Recent developments aim at the deployment of interoperable systems in the context of cartographic generalization, with the intention of providing generalization functionalities over the Internet. This is based on Web Processing Services (WPS) that where developed by the Open Geospatial Consortium (OGC). They enable the analysis and processing of spatial data. In this context, Web Generalization Services (Webgen-WPS) are examined for possible integration into the software solutions and represent therefore a central object of investigation within that examination. Mapnik provides, not least through its “open source” code, ideal conditions for those implementations. Mapnik uses the “open source” spatial database PostGIS for the processing of OSM-Data, which also provides capabilities to analyze and process spatial data. In this context is examined in addition, to what extent the features have potential for implementation of cartographic generalization.

OpenStreetMap (OSM) konnte sich seit der Gründung 2004 sehr schnell etablieren und stellt mittlerweile eine konkrete Alternative gegenüber vergleichbaren kommerziellen Anwendungen dar. Dieser Erfolg ist eindeutig auf das revolutionäre Grundkonzept des Projektes zurückzuführen. Weltweit werden räumliche Daten durch Mitglieder erhoben und dem Projekt OSM zur Verfügung gestellt. Über die zugrunde liegenden Lizenzbestimmungen wird sichergestellt, dass OSM-Daten frei verfügbar und kostenfrei weiter verwendbar sind. Vor allem die Vorstellung der Unabhängigkeit von proprietären Daten hat zu starker, weiterhin zunehmender globaler Beteiligung geführt. Resultierend daraus erreichen die verfügbaren Daten inzwischen hohe Dichte sowie Genauigkeit. Visualisierungen in Form von interaktiven, frei skalierbaren Weltkarten, welche über die vollständig automatisierten Softwarelösungen Mapnik und Osmarender erstellt werden, sind am weitesten verbreitet. Infolgedessen müssen kartographische Grundsätze und Regeln formalisiert und implementiert werden. Insbesondere in Bezug auf kartographische Generalisierung treten teils erhebliche Mängel in den entsprechenden Umsetzungen auf. Dies bildet den Ausgangspunkt der Untersuchung. Ausgehend von einer Ist-Analyse werden vorhandene Defizite identifiziert und anschließend Möglichkeiten zur Integration von Generalisierungsfunktionalitäten untersucht. Aktuelle Entwicklungen streben die Anwendung interoperabler Systeme im Kontext kartographischer Generalisierung an, mit dem Ziel Generalisierungsfunktionalitäten über das Internet bereitzustellen. Grundlage hierfür bilden die vom Open Geospatial Consortium (OGC) spezifizierten Web Processing Services (WPS). Sie ermöglichen die Analyse und Verarbeitung räumlicher Daten. In diesem Zusammenhang werden Web Generalization Services (WebGen-WPS) auf mögliche Integration in die Softwarelösungen untersucht und bilden somit einen zentralen Untersuchungsgegenstand der vorliegenden Arbeit. Mapnik stellt, nicht zuletzt durch dessen offengelegten Quelltext („Open Source“), optimale Voraussetzungen für jene Implementierungen zur Verfügung. Zur Verarbeitung von OSM-Daten verwendet Mapnik die freie Geodatenbank PostGIS, welche ebenfalls Funktionalitäten zur Analyse und Verarbeitung räumlicher Daten liefert. In diesem Kontext wird zusätzlich untersucht, inwiefern PostGIS-Funktionen Potential zur Anwendung kartographischer Generalisierung aufweisen.:Inhaltsverzeichnis Aufgabenstellung ii Zusammenfassung iii Abstract iv Abbildungsverzeichnis viii Tabellenverzeichnis ix Abkürzungsverzeichnis x 1 Einleitung 1 1.1 Motivation 1 1.2 Aufbau der Arbeit 4 2 Grundlagen 5 2.1 OpenStreetMap 5 2.1.1 Ablauf der Erstellung von OSM-Karten 6 2.1.2 Mapnik 9 2.2 Web Services 12 2.2.1 OGC Web Processing Services 12 2.2.2 Web Generalization Services 14 2.2.3 Verkettung von OGC Web Services 16 2.3 Kartographische Generalisierung 17 2.3.1 Konzeptionelle Modellvorstellungen 18 2.3.2 Generalisierungsoperatoren 22 3 OpenStreetMap & Generalisierung – aktueller Stand 24 3.1 Allgemeine Analyse und Kritik 25 3.2 OSM & konzeptionelle Modelle 28 4 Theoretische Überlegungen 31 4.1 Einbindung des WebGen-WPS 32 4.1.1 Direkteinbindung des WebGen-WPS 32 4.1.2 Einbindung von WebGen-WPS für „MRDB-OSM“ 34 4.2 PostGIS-Funktionen 36 4.3 OpenStreetMap - Generalisierungscommunity 38 5 Implementierungen & Ergebnisse 40 5.1 Technische Voraussetzungen 41 5.1.1 Systemvoraussetzungen 41 5.1.2 Testgebiet 41 5.2 Einbindung des WebGen-WPS in Mapnik 42 5.2.1 Einbindung in den automatischen Prozess 42 5.2.1.1 Allgemeiner Programmablauf 43 5.2.1.2 Implementierungsansätze 44 5.2.2 Praktische Umsetzung einer „MRDB-OSM“ 47 5.2.2.1 Verfahrensablauf 48 5.2.2.2 Polygonvereinfachung 51 5.2.2.3 Linienvereinfachung 57 5.3 Implementierung von PostGIS-Funktionen 59 5.3.1 Auswahl 59 5.3.2 Betonung 60 5.3.3 Linienvereinfachung 61 5.3.4 Polygonvereinfachung 61 6 Schlussfolgerungen und Ausblicke 65 6.1 Diskussion der Ergebnisse 65 6.2 Fazit 71 7 Quellennachweise 72 7.1 Literaturverzeichnis 72 7.2 Internetquellennachweis (ohne eindeutige Autoren) 77 8 Anhang 79 / OpenStreetMap (OSM) has established very quickly since its founding in 2004 and has become a suitable alternative to similar commercial applications. This success is clearly due to the revolutionary concept of the project. Spatial data is collected by members world-wide and is provided to the project OSM. The underlying license aggreement ensures that OSM-Data is freely available and can be used free of charge. Primarily, the idea of independence from proprietary data has led to strong, still growing, global participation. Resulting from that, the available data is now achieving high density and accuracy. Visualizations in form of interactive, freely scalable maps of the world, which are constructed by the fully automated software solutions Mapnik and Osmarender are most common. In consequence cartographic principles and rules must be formalized and implemented. Particularly with respect to cartographic generalization, some serious faults appear in the corresponding implementations. This is the starting point of this diploma thesis. Based on an analysis of the current state, actual existing deficiencies are identified and then examined for possibilities to integrate generalization functionalities. Recent developments aim at the deployment of interoperable systems in the context of cartographic generalization, with the intention of providing generalization functionalities over the Internet. This is based on Web Processing Services (WPS) that where developed by the Open Geospatial Consortium (OGC). They enable the analysis and processing of spatial data. In this context, Web Generalization Services (Webgen-WPS) are examined for possible integration into the software solutions and represent therefore a central object of investigation within that examination. Mapnik provides, not least through its “open source” code, ideal conditions for those implementations. Mapnik uses the “open source” spatial database PostGIS for the processing of OSM-Data, which also provides capabilities to analyze and process spatial data. In this context is examined in addition, to what extent the features have potential for implementation of cartographic generalization.:Inhaltsverzeichnis Aufgabenstellung ii Zusammenfassung iii Abstract iv Abbildungsverzeichnis viii Tabellenverzeichnis ix Abkürzungsverzeichnis x 1 Einleitung 1 1.1 Motivation 1 1.2 Aufbau der Arbeit 4 2 Grundlagen 5 2.1 OpenStreetMap 5 2.1.1 Ablauf der Erstellung von OSM-Karten 6 2.1.2 Mapnik 9 2.2 Web Services 12 2.2.1 OGC Web Processing Services 12 2.2.2 Web Generalization Services 14 2.2.3 Verkettung von OGC Web Services 16 2.3 Kartographische Generalisierung 17 2.3.1 Konzeptionelle Modellvorstellungen 18 2.3.2 Generalisierungsoperatoren 22 3 OpenStreetMap & Generalisierung – aktueller Stand 24 3.1 Allgemeine Analyse und Kritik 25 3.2 OSM & konzeptionelle Modelle 28 4 Theoretische Überlegungen 31 4.1 Einbindung des WebGen-WPS 32 4.1.1 Direkteinbindung des WebGen-WPS 32 4.1.2 Einbindung von WebGen-WPS für „MRDB-OSM“ 34 4.2 PostGIS-Funktionen 36 4.3 OpenStreetMap - Generalisierungscommunity 38 5 Implementierungen & Ergebnisse 40 5.1 Technische Voraussetzungen 41 5.1.1 Systemvoraussetzungen 41 5.1.2 Testgebiet 41 5.2 Einbindung des WebGen-WPS in Mapnik 42 5.2.1 Einbindung in den automatischen Prozess 42 5.2.1.1 Allgemeiner Programmablauf 43 5.2.1.2 Implementierungsansätze 44 5.2.2 Praktische Umsetzung einer „MRDB-OSM“ 47 5.2.2.1 Verfahrensablauf 48 5.2.2.2 Polygonvereinfachung 51 5.2.2.3 Linienvereinfachung 57 5.3 Implementierung von PostGIS-Funktionen 59 5.3.1 Auswahl 59 5.3.2 Betonung 60 5.3.3 Linienvereinfachung 61 5.3.4 Polygonvereinfachung 61 6 Schlussfolgerungen und Ausblicke 65 6.1 Diskussion der Ergebnisse 65 6.2 Fazit 71 7 Quellennachweise 72 7.1 Literaturverzeichnis 72 7.2 Internetquellennachweis (ohne eindeutige Autoren) 77 8 Anhang 79

Submitted by Leticia Schettini (leticia@ufrrj.br) on 2016-10-11T14:28:18Z No. of bitstreams: 1 2005 - Jonatas de Aguiar Ferreira.pdf: 582914 bytes, checksum: cf08766dd08ac2ba431524c048eecb30 (MD5) / Made available in DSpace on 2016-10-11T14:28:18Z (GMT). No. of bitstreams: 1 2005 - Jonatas de Aguiar Ferreira.pdf: 582914 bytes, checksum: cf08766dd08ac2ba431524c048eecb30 (MD5) Previous issue date: 2005-08-30 / Coordena??o de Aperfei?oamento de Pessoal de N?vel Superior-CAPES / In this research, the drying kinetics and equilibrium conditions during osmotic dehydration of chayote (Sechium edule, Sw.) were studied using 20, 30 and 40 % (w/v) sucrose solutions. A thermostatic bath was built to allow the experimental evaluation of osmotic dehydration kinetics and equilibrium moisture content determination. The experiments were carried out at three different temperatures (30 ?C, 40 ?C and 50 ?C) in order to evaluate the influence of temperature and sucrose concentration. Chayote fruits were washed and submerged in sodium hypochloride solution for ten minutes, for sanitization. Afterwards, the fruits were dried and cut into slices of about 0.5 cm thickness. Then, the slices were put into hypertonic sucrose solutions during preestablished time intervals. After osmotic dehydration, the solution was discarded and the slices were softly dried with absorbent paper to remove surface moisture. The moisture content was determined gravimetrically. Long time experiments up to 96 h were performed to provide information about the equilibrium moisture content. An specific equilibrium isotherm was selected by statistical methods. The correlation that better described equilibrium moisture content behavior was the Smith sorption isotherm, adapted to osmotic environment. The Overhults model was used to describe osmotic dehydration kinetics and estimate the drying constants k and n. Based on the results obtained in this research, it could be demonstrated that the equilibrium moisture content is strongly influenced by sucrose concentration and that k is a parameter dependent on the temperature and sucrose concentration, whereas n may be considered constant for the given experimental setup. / Neste trabalho foi feito um estudo da desidrata??o osm?tica de fatias de chuchu em um sistema que possibilitou a determina??o da umidade de equil?brio e dos coeficientes do modelo de Overhults para descrever a cin?tica de desidrata??o osm?tica das fatias. O procedimento experimental consistiu em lavar e escovar os frutos, para a remo??o de impurezas da casca, fatiar o chuchu, em fatias de 5 mm de espessura, num fatiador dom?stico de alimentos, submeter o material ? desidrata??o osm?tica em solu??o hipert?nica de sacarose a 20,30 e 40%, por at? 96 horas, tomando amostras em per?odos determinados para levantar a curva de desidrata??o do material e tamb?m determinar a umidade de equil?brio das fatias de chuchu como uma fun??o da concentra??o inicial da solu??o hipert?nica e da temperatura. Com base nos resultados obtidos foi poss?vel determinar os par?metros do modelo de Overhults para as fatias de chuchu, bem como a uma correla??o para a umidade de equil?brio do material e constatar que h? forte influ?ncia da temperatura e da concentra??o sobre a cin?tica de desidrata??o osm?tica do chuchu, que cerca de 50 % da umidade das amostras ? removida nas primeiras duas horas de imers?o, que a umidade de equil?brio ? atingida em cerca de 48 horas de imers?o e que o modelo de Overhults descreve satisfatoriamente as curvas de desidrata??o osm?tica.