Bestand wählen
Merken

Anchoring and PostGIS cure Post-Polygon Stress Disorder

Zitierlink des Filmsegments
Embed Code

Automatisierte Medienanalyse

Beta
Erkannte Entitäten
Sprachtranskript
well thank you for staying for my talk the this morning I went to 2 great talks wise followed their tool-making the other 1 so for keeping things uh simple I have some specific cases what it can do using tools and there would we can what we should do 40 keeping things simple I there
are some specific cases both I using a
polygons and the kind of problems can be caused by by having polygons in map compilation updating and the integration and I will give you some specific cases which cause something I called post polygon our stress disorder PTSD and if you stay with my talk hopefully afterward they're going to be true at all and how DST anymore but so so just to the background on cases and they're not specific cases are and then all solutions I'm a
geologist by training and there we do a lot of a automatic Our for the yeah province of British Columbia in the sea and they just few examples we we do need a polygon so we need a polygons to define all the guy to capture all features and we do need a polygons to represent the final of MAP products and therefore the province of a
British Columbia we got from Gryffindor this maps covering the province and I just by the way the size of of British Columbia is the a Washington Oregon and California combined it's almost 4 times bigger than UK and so over the years we have
been compiling and integrating those individual maps and come with this on single integrated seamless Digital cover up coverage for the province not a use
case right now here is we've done our 1st was napping now we want to opted 1 of areas so because of makes sense you would do a cookie cutter for the sun that area you know take a copy about and the Mapper always geologists or take it into the field all 40 in a year or 2 years he finished his while he's mapping and the updated enough for this
area but ideally we can just drop to the back to the provincial database same without any pain or in work but it doesn't happen that way so the
it does all kind things could happen along the out map acts but also you even format for updating the the map with an area there's all kinds I . cases were why use polygons to update the because what problem will have are there many many problems but will
focus on just 2 1 is what we call a shared a boundaries the other otherwise coder edge matching remembering this our earlier 19 nineties the 1st yeah yeah cause I took others lot of flood as PP PP chapters on on edge matching and after the and my my my talk you will find out the edge matching for me as a history the similarity measure anymore
so for sure boundary just the some examples to show the a specific cases this is a are a part of a joint map now we have a unit at a and you that B share a common bond in in between but this could that have to be better geology right it could be land use could be catasta could the be minutes what boundaries you name it and what happened here is not only to lines share the same boundary for the 2 polygons In this case we also have a fault cut through here so the the contact between you need a and you know the be is really a is also fall to the contact right so also here really we have 3 minimum 3 features come at all Cubans in space no the a more
I went ahead ahead of myself a little bit here so well we need to update 1 the
features so this is the fault has been remapped and we know these fault is the boundary for you need a and you know the be so right away they're going to
find some problems here doesn't matter what you do you can spend all their time manually tried it just to the but the the GII the geometry for the for polygon guy a and full polygon B up quite often what what you can find out is but in the end of the day you have gaps you have overlaps along the boundary but both between the polygons and also between the polygons and the line work so that's the that's the 1st case the
2nd phase is something already matching on so we could have met a something we mapped earlier and we mapped at the at the edges in the area of area we have well that the obviously obviously you see some differences there in in terms of geometry but also the actually used and ideally we can't get them to resolve all the boundary issues given the map merged seamlessly by doesn't really happen that way often in the in the
real real world so what we what will
half year along the boundary b to the polygons you don't have gaps Our overlaps the delivers and the lines may not join could have overlapped good how about this is joint ended the ash views in terms the map units in the not too be consistent across the board
so I have seen places where people purchase expensive tools and a higher team of techni ITS technicians working on this day in day out weeks months on adjusting those kind of a in trying to resolve those kind of problems and and when I thought about it you know was the results there's of people spend so much time doing that and as a low productivity when you have when you have your hands on your mouse on the for the whole day it got the injury to arrest your shoulder right so it's not too far down into the obvious ESTA so the the the big question
here is again just related to what I here in the morning I there that you can you can spend all your time or span your money to purchase to develop tools but sometimes you have to ask the question what do we need you can we can we avoid these problems in the 1st place and
that so to try to avoid this kind problems where to find the the cost for these problems but it's not it's not to 2 different in terms of mapping geology what we do is we we recorded point location we defined but we identify the boundary and from loss of point locations we join the dots will form the language and all of the language you mention what would you created this up bedrock geology uniform polygons call them traitors I mentioned and other graphically handset in heaven them published by we ought to we actually story with points lines so the polygons is not not not there in the 1st place so really I think the polygon is the cause of the problem and we should carry the polygons in map compilation now updating adding and also integration so the
solution we pro and we can develop to this idea again perhaps nothing new for what we you know what we always do really in the back In the at the at the source of the data what are we really need to keep up i maintaining is the language and that the points representing the out the joint units so this is only 2 things we need so I I put in this term framework it doesn't have to be called out a way for like about terminology and a framework means so a lot of different things to different people by just for the sake we knew some name here so we just call him like I t 50 for sure so are the lines can be Joe the contact could it be false so you some odd cases could be the at the boundary for land use land parcel I could be the at the at the boundary for the for the river for the municipal whatever and the points of the same choice representing the some active use describing the land use land cover um so essentially we just knew that these 2 type of geometry Our geometries to represent all over again so by the time you
need to creating a final products you can easily converge lines into a greater created polygons from line work end up populated . ask use from this point so just give you a quick exam decimal example in the province of British Columbia we have 1 million Myrtice's to define the geology so so our of the 1 million verses we have our high and result in flung work and then it it take us there less than 3 minutes to create a 32 solemn polygons we've been post yes so thinking from the from the what have on the rat on the left to the right is really really simple process is really great it doesn't take vertical all our knowledge in the early nineties you know when form part of felons polygons we have to run this is over the weekend so the idea
of the the out this so the frame get a model with the lines on the only lines in part points also analyzed to develop another process which we call or the out the anchoring a ankara mechanism this is the date that the process we can told they avoid a new problems In the edge matching than the I explain some detail here so the first one is the error
checking checking out so as a of very similar that you checking out a book from a library so before our geologists head into the field he will you know 1 of them will us the at the study area as outlined by the thought it there are the black started the the lines so from those out from the study area boundary we're going to select not only the geology we thing area but we're going to use that want to select
all the polygons has something to do with the with this study updating area and the from this that extended context whether the form of poly of form a buffer a attend a buffer and about the new cis buffer To
select all were framework Dana which are lines and the centroids so polygons I useful here right we need a polygons for the initial filtering but but once we did that filled in with the other way so we center we needed is a buffer To select everything we can area so this and this selfish step the next step it is to OK to fly it when it to my had I'm a simple example here the if you take the data out from here take it out and run some of round-trip putting projective energy as packages you some are on the table fanatic projection and the reader the debtor back here and if you don't have a precision model or some kind of control I can guarantee you the map you return together like the frame will get a return from this it for this area they're not going to be they're not and match what we had there before so this is a kind of wealth there are some kind of well known and this and stood there well understood the phenomenon what we call that a coordinated to the so essentially if you take a piece of but I gather right through multiple processes interest map projection loading to different systems the better 1 come out of that process that all according a supportive around so and as you can you can you can you have some magic otherwise so that you can award this so let alone get going to do some editing so how
to control this lifting so we borrow some nautical terms something called anchor line road line hook and the anchor point so wrote our ODE actually is a term describing the lines between the boat to the entropy others
liberties with the summer specified description for each of the terms and that's OK if you if a this is the but much work too much about script that much worse here I you will see the at actual um definition from some graphics leader so
what we have here on the database site we can automatically anchoring so the outermost line that the 1 shown up in red is something what we're going to catch as and growing so any lines connected connected to this angle of and you have no and on the world of the on and the and the end of the bring up this is the kind of make sense you have some of just a few of pointer here the so the century or you and so on and so on the on the and you will see what why we why do we need a cactus from some example so let's say so the that that the
next step is really taking all the stand out but before take we tag right just anger line and the point FIL relying whatever and that this is the package weapon the key to all matters so it could be the same same kind scenario this immediate need to update that after so you need if you run this kind of process still be some additional that I need to be taken out package it package it and therefore the added yes technician to update
if so you know our use case I the map will be taken out and it gets updated by Joe August this could take 6 months a year 2 years depending how big is the area some has could go up to 3 years so by the end of the end of the update will have a new map coming back again we don't really care about the polygons they have what we do here other language and the same choice representing the the attitudes so before we return this back to the province but with the drop the angle on behalf so the anchor line for then it's really just something a boundary some limit those are the lines you don't want to touch the water modified if you do need to modify that means the your mapping out your mapping area extended you need to come back we can get you another another check not process just extend their even even even for the so this so on what we want
not back to the provincial database this could be your corporate database so the 1st thing we're going to do here is a we can be a cooperated database is a weapon retire everything has had been checked out and the next step as
we get we're going to job the update as you would expect because the drifting right so sometimes could be some modification as well the real relying were it so is supposedly connected to the angle it could be some some drifting causing not disconnect overlaps whatever so
this is aware this process would work our assuming the anchor line on the on the road or line was initially are connected to the anchor line at the point of what they're showing as as who after 2 for the way our we can snap them back so if you feel not uncomfortable you fit you forgot like thousands is cases we can use use something like a marriage the marriage certificate so we can by using ID by using whatever so these raw line is connected to this book is going to go back to this place does matter how how many meters you drift away all verses In most cases depend on the mapping of but the skill for mapping i.e. you most cases the drifting might be by centimeters by meters or tens of meters but won't be hundreds if you do you do get in cases where something something away 400 meters maybe there's something different anyway so he they can you can parent a up so you know for sure this particular anchor our point is going to be snapped to this article Is there something you can do it over is just that apply some simple geometric snap and
their soul after have done that the you can now everything is connected you can form a
new polygon ask for the whole area or you can just form the form you polygons of 4 the updated area what I want to make a point here is in life because this is the more all of these a lot of the people I know you the the all my also the problems the the the 1st of all I have thank you there also the so far of the the 1st of the century the only thing we need to do here is right some really really simple geometric snap or using the pairing process so basically replacing the the coordinates at the at the point 0 5 the hawk on the angle of but so essentially the edge matching it's a fully automated there's no human intervention and here are here at all so let's have done
that obviously you can port produce new polygons output on labels you can run some kind of flat kind of graphic value has meant to produce the final products so to you know all cases essentially in the back-end everything's lines and the centroids so the polygons become become a view of the dead as a as a final product as a product facing the at the end the client so the client doesn't really actually see everything the back like the this enjoys if the whole
process was developed impose grass post yes so the process so flood checking out anchoring and that integration go fully automated just a few message
messages of these problems can be told awarded by not having polygons In the map compilation updating and the integration process and also the next message is why you have have the funds to purchase expensive tools our I would dare suggest take a good look sometimes ascorbate our question do we really need to be so expensive to all do we really need have what do we really have a problem here and then so the framework model the anchoring of process they're fairly easy they're really simple you might be in any way because right now we only deal with Allianz point right what can be more complex than that of and that the whole thing can be are developed implemented India unit in open source database and therefore us the PBS-T is over is cured we don't have it Henry much at the any questions chance what happens if you're the outline is within the the red area yeah
and it goes out outside of it to write steady segment yes we in you know where am framework database everything is a fully segmented that means anywhere others say intersection along I was really it will be known only thank you 1 example of yeah like here this is all in 1st all the the best example of this the that yeah I the I don't think so that means there will be no it at the I think a lot of right the but you have to be here the of the is what the users that's not and that is not and yet ch because touched upon the school that of earlier did you has some sort of a threshold or a tolerance when you're doing this of and X meters away from my hope that I don't touch it or fire disclose study will attaches like that the yeah I the other kind of foreigners in all cases because our geologic map an the could someone could be mapped at the 110 solvent scale but in general there mapping out the 1 250 southern scale so asked at a 150 southern scale and don't you know I you know map like this you many give like 10 meters 20 meters that'd be that'd be fine but I what I've found in the modern days they were using the kind of GAS tools after run the trip if you if we check the get out like this usually the shouldn't see hundreds meters sulfite 50 but we did have a special case where all we have it really large area the map been taken out and a from burst project at you UTM and we the UTM even a single line used to be I aligned with when this right and the 1 coming into you die UTM and a cop somewhere in the middle didn't do anything but this is really large area so when they return the map there's a 200 meters drift and does so so sometimes let's say time as you know the the you how do I do that we can do about that so we want to know more about this and I think the real thing here is that you have heard this and that some of the the the the end of the day and the of of so if you would the you all that story the other half of the population and you can be the set all on the other so it was always on what we were going to be more of a 2nd time on the ball that was and we call that the set of and you have a the out and what was originally compiled so so anyway shorter to NCO question but because 1 map at 1 2 4 hour 50 cell into 1 cells so we can accept that meters or up to 20 meters 2nd porous but if you map that 1 to half a million or 1 2 5 thousand than those who need to be adjusted yes and no did you elaborate on how unicentroid approach compares to classical topologies we you define the points and then define a line that connects these points and then a pony dynasty find as as of this at some more the the sequence of certain lines men and then you can't have diverging the world anymore
OK and yet is that all we we didn't look at that bringing some kind of topology way to to to manage our dad and dad everything we have looked at a height and the previous so it's so complex so what we have here actually I don't topology for state so all I'm going to get but we do right we have to make sure any work as this and and all of as we say well not only when the polygons all of the so we have a lot of social you on that the only work we have processed the nature on all matters they happened we that the what such and some of you have the sort by 2 years of sentences you you run the process time the and if they not the working world people enjoy as well no I don't want that because these are the big apple pie and the like don't want to operate that you have to say this case what is it about centimeter thing is that the you the you the process of getting the right of course the so what about the rest of the universe is all about something you also problems so so the answer is no we don't have any knowledge we try to this the reason and so this is not always well before I was the quality of and is a way to to evaluate you I have to think about what you or you can give rest the what so of the century there is a lot of on side of the room what essentially and you can use you have to say because on the last time in so that's the way you evaluate each other for what we have here but we really try to bidder really really simple the the group but will shortly markets put you if % the appeared the smallness of your mention over proper wrote a data model which was popular in the nineties wanted to this this also it's used back in 4 of us a coverage importers no used by cross so if you're using such programs I think it's would be written as the same sort of theorist or industry programs also have a polygon is defined present lines in the center of such polygons that define a central yeah put it on susceptible affordable on on this defined as the centroids and the the from a piece of different was alliance which is surrounding this sentence that's a topological data model in which is very common in this respect model programs OK I will give you many many more examples of you you have to you did notice it's supposed to source code union control improve by the life of a are part of it all and then in the whole of the all the time the the more I think anything else yeah this is the kind of what we want the of the of hi what do I have any more of this case you are the following there are more the word this is model to you have to get up with some of these cases when we start talking we find more on the more you the so my and also small volumes and online using the following us OK the thing is I know this the view of 1 right writing of line and you can that would lead to mark was smart invention of by it's a peachy durable this review or singular acceptable logical data model that's when you went with in the multitude just and then also Jewish a century of churches to going into field so wanted execute through its agreements right this idea of what it what it is that they are the way that we got the right part of the of the of the of the of we want you to make notice that the you can and not on the the right 1 and you know what would you ask again and again and they would get all of you the study of you set the as you what to to and was not and that is the last time we met the the what did you do something work and the rest of the i is a complex and you 1 was and many of you know what happened inside already so in the case which you will the I of finding a small what do you think some small ones the more I don't want to be there but it's only if there is a lot of what is 1 the so and the 2nd kind of all the but not more than some of the the sum of the log of of the loss of the year the maybe and the I think it was on the and the and you and what because this is a provincial report the free all the geology so essentially we're trying to accommodate but the map at at different mapping scale so it's a single map if this is not a final product it's a Our it's an integrated report repository all the provincial geology so we could have area mapped at quarter million half a million versus some area map at every detail because we have some a good neural potential someone could be mapping out the 1 consultant so versus you your you and adjacent areas map at 0 you know 1 quarter million so so the difference could be used that's were that's why we we don't we not only having geometric get a boundary problem but also we have geological Vondra problem we could have a the at border the we thing here you have all the details beyond their there's no detail so you know some is alright so we have created some boundary jolt bonded Corabella boundary you know it's not real it's just in the limit of mapping so we just map to the year we know the geology b the i've within this quarter beyond we don't know but we have to we have to know respect you what would happen in L historical because the area has not been updated that's just the case where you better away I of right the we of the the yeah we do have metadata keep track of who who do the mapping when and what was the scale here we do have some we do have details here are some details if well if no further questions 3 much for in and of
Mapping <Computergraphik>
Digitalsignal
Polygon
Sampler <Musikinstrument>
Compiler
Entropie
Entropie
Normalspannung
Polygon
Computeranimation
Normalspannung
Integral
Mapping <Computergraphik>
Wellenpaket
Biprodukt
Polygon
Computeranimation
Endlicher Graph
Datenfeld
Flächeninhalt
Cookie <Internet>
Computeranimation
Mapping <Computergraphik>
Flächeninhalt
Dateiformat
Polygon
Computeranimation
DoS-Attacke
Randwert
Gemeinsamer Speicher
Physikalischer Effekt
Gemeinsamer Speicher
Ähnlichkeitsgeometrie
Matching
Fokalpunkt
Polygon
Raum-Zeit
Computeranimation
Mapping <Computergraphik>
Randwert
Einheit <Mathematik>
Rechter Winkel
Mereologie
Schnitt <Graphentheorie>
Einflussgröße
Gerade
Randwert
Vektorgraphik
Bit
Räumliche Anordnung
Räumliche Anordnung
Polygon
Computeranimation
Matching
Mapping <Computergraphik>
Randwert
Subtraktion
Flächeninhalt
Räumliche Anordnung
Term
Phasenumwandlung
Computeranimation
Resultante
Sichtenkonzept
Randwert
Übergang
Biprodukt
Term
Polygon
Gerade
Whiteboard
Computeranimation
Mapping <Computergraphik>
Randwert
Einheit <Mathematik>
Rechter Winkel
Einheit <Mathematik>
Gerade
Einfügungsdämpfung
Punkt
Physikalischer Effekt
Compiler
Formale Sprache
Polygon
Term
Computeranimation
Integral
Mapping <Computergraphik>
Randwert
Skalarprodukt
Uniforme Struktur
URL
Gerade
Resultante
Subtraktion
Punkt
Prozess <Physik>
Räumliche Anordnung
Term
Polygon
Gerichteter Graph
Framework <Informatik>
Computeranimation
Überlagerung <Mathematik>
Vektorgraphik
Bildschirmmaske
Einheit <Mathematik>
Datentyp
Auswahlaxiom
Gerade
Biprodukt
Gerade
Randwert
Dezimalsystem
Framework <Informatik>
Rechter Winkel
COM
Mereologie
Beobachtungsstudie
Kraftfahrzeugmechatroniker
Prozess <Physik>
Punkt
Prozess <Informatik>
Datenmodell
Matching
Framework <Informatik>
Computeranimation
Randwert
Datenfeld
Flächeninhalt
Mereologie
Programmbibliothek
Flächeninhalt
Gerade
Fehlermeldung
Beobachtungsstudie
Prozess <Physik>
Datenmodell
Physikalisches System
Kontextbezogenes System
Polygon
Kontextbezogenes System
Framework <Informatik>
Computeranimation
Mapping <Computergraphik>
Energiedichte
Puffer <Netzplantechnik>
Multiplikation
Bildschirmmaske
Digitalsignal
Polygon
Flächeninhalt
Gamecontroller
Projektive Ebene
PCMCIA
Gerade
Tabelle <Informatik>
Deskriptive Statistik
Punkt
Hook <Programmierung>
Skript <Programm>
Term
Mechanismus-Design-Theorie
Gerade
Computeranimation
Gewöhnliche Differentialgleichung
Web Site
Punkt
Prozess <Physik>
Datenhaltung
Zeiger <Informatik>
Schlüsselverwaltung
Gerade
Computeranimation
Datenhaltung
Wasserdampftafel
Winkel
Formale Sprache
Euler-Winkel
Polygon
Mapping <Computergraphik>
Randwert
Flächeninhalt
Inverser Limes
Tropfen
Auswahlaxiom
Gerade
Digitales Zertifikat
Punkt
Prozess <Physik>
Zehn
Rechter Winkel
Winkel
Vererbungshierarchie
Meter
Gerade
Computeranimation
Videospiel
Bildschirmmaske
Punkt
Flächeninhalt
Polygon
Gerade
Computeranimation
DoS-Attacke
Sichtenkonzept
Prozess <Physik>
Krümmung
Biprodukt
Polygon
Computeranimation
Integral
Client
Front-End <Software>
GRASS <Programm>
Gerade
Message-Passing
Funktion <Mathematik>
Maschinenschreiben
Folge <Mathematik>
Prozess <Physik>
Punkt
Compiler
Zellularer Automat
Polygon
Framework <Informatik>
Computeranimation
Netzwerktopologie
Einheit <Mathematik>
Unified Threat Management
Font
Meter
Gerade
Beobachtungsstudie
Zentrische Streckung
Schwellwertverfahren
Datenhaltung
Open Source
Datenmodell
Gerade
Quick-Sort
Integral
Mapping <Computergraphik>
Menge
Flächeninhalt
Rechter Winkel
Kommensurabilität
Projektive Ebene
Hill-Differentialgleichung
Message-Passing
Einfügungsdämpfung
Subtraktion
Prozess <Physik>
Gewichtete Summe
Natürliche Zahl
Gruppenkeim
Maßstab
EDV-Beratung
Schreiben <Datenverarbeitung>
Polygon
Mathematische Logik
Physikalische Theorie
Eins
Netzwerktopologie
Metadaten
Weg <Topologie>
Pi <Zahl>
Inverser Limes
Optimierung
Grundraum
Gerade
Beobachtungsstudie
Zentrische Streckung
Videospiel
Sichtenkonzept
Dokumentenserver
Datenmodell
Quellcode
Biprodukt
Quick-Sort
Chipkarte
Mapping <Computergraphik>
Teilmenge
Singularität <Mathematik>
Randwert
Datenfeld
Flächeninhalt
Rechter Winkel
Mereologie
Gamecontroller
Wort <Informatik>
Verkehrsinformation
Aggregatzustand

Metadaten

Formale Metadaten

Titel Anchoring and PostGIS cure Post-Polygon Stress Disorder
Serientitel FOSS4G 2014 Portland
Autor Cui, Yao
Lizenz CC-Namensnennung 3.0 Deutschland:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen.
DOI 10.5446/31653
Herausgeber FOSS4G, Open Source Geospatial Foundation (OSGeo)
Erscheinungsjahr 2014
Sprache Englisch
Produzent FOSS4G
Open Source Geospatial Foundation (OSGeo)
Produktionsjahr 2014
Produktionsort Portland, Oregon, United States of America

Inhaltliche Metadaten

Fachgebiet Informatik
Abstract Polygons are great to have in digital maps, much like a canvas that we can render with beautiful colours. It is common that polygon boundaries are shared by linear features (e.g., municipalities divided by a river or a road). If polygons are used as part of the base to edit, update, and integrate digital maps, we have to reconcile the geometric differences among the shared boundaries and fix topological problems in edge matching. For many years we felt blessed that commercial software tools are available to reconcile shared boundaries, and to detect and fix topological problems. However, if wrestling with polygons leaves you feeling buried in slivers, discontinuities, gaps, and overlaps, you've got Post-Polygon Stress Disorder (PPSD). PostgreSQL/PostGIS presented British Columbia Geological Survey an opportunity to identify the causes of PPSD. As a result, we have developed a geologic framework data model and implemented an anchoring mechanism in PostGIS to simplify the process of editing, updating, and integrating digital geological maps. We have dispensed with polygons and eliminated the problems from shared boundaries and edge matching.Healing to PPSD is available in this poster:http://www.empr.gov.bc.ca/Mining/Geoscience/PublicationsCatalogue/GeoFiles/Pages/2014-9.aspx.
Schlagwörter PostGIS
data integration
edge matching
shared boundaries
digital geology

Ähnliche Filme

Loading...
Feedback