BEGIN:VCALENDAR PRODID;X-RICAL-TZSOURCE=TZINFO:-//Calagator//EN CALSCALE:GREGORIAN X-WR-CALNAME:Calagator METHOD:PUBLISH VERSION:2.0 BEGIN:VTIMEZONE TZID;X-RICAL-TZSOURCE=TZINFO:America/Los_Angeles BEGIN:DAYLIGHT DTSTART:20140309T020000 RDATE:20140309T020000 RDATE:20150308T020000 RDATE:20160313T020000 RDATE:20170312T020000 RDATE:20180311T020000 RDATE:20190310T020000 RDATE:20200308T020000 TZOFFSETFROM:-0800 TZOFFSETTO:-0700 TZNAME:PDT END:DAYLIGHT BEGIN:STANDARD DTSTART:20141102T020000 RDATE:20141102T020000 RDATE:20151101T020000 RDATE:20161106T020000 RDATE:20171105T020000 RDATE:20181104T020000 RDATE:20191103T020000 TZOFFSETFROM:-0700 TZOFFSETTO:-0800 TZNAME:PST END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140529T000506Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140624T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140624T193000 DTSTAMP;VALUE=DATE-TIME:20140529T000506Z LAST-MODIFIED;VALUE=DATE-TIME:20140616T175358Z UID:http://calagator.org/events/1250466328 DESCRIPTION:This month at MaptimeStJohns\, we will begin programming a ba sic web spatio-temporal visualization\, bring a computer if you have one . Ill bring the js library files for leaflet and the various plugins we will be using. If you have a temporal dataset\, bring it... Ill have a couple of datasets to choose from though. Our goal will be for everyon e to create at least one temporal point visualizations. An example woul d be the point locations of where floods occurred with the location\, si ze of flood and date of flood event. With this data we could create a t emporal proportional symbol map. The user will be able to click on the locations for specific locations and also use a slider to see when and where floods occurred over time. Let's create some cool web map visuali zations!\n\nTags: mapping\, osgeo\, open source\, geography\, spatio-tem poral\, Web mapping\, geogeek\, temporal\, spatial\, gis\, web visualiza tions\n\nImported from: http://calagator.org/events/1250466328 URL:http://www.meetup.com/MapTime_StJohns/events/185409982/ SUMMARY:Programming Open Source Web Spatio-Temporal Mapping Visualization s LOCATION:Anna Bannanas Cafe\, St Johns: 8716 N Lombard St\, Portland Oreg on 97203 US SEQUENCE:3 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140930T010446Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140930T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140930T193000 DTSTAMP;VALUE=DATE-TIME:20140930T010446Z LAST-MODIFIED;VALUE=DATE-TIME:20150207T225919Z UID:http://calagator.org/events/1250467071 DESCRIPTION:OSGeo Spatio-Temporal Web Visualizations\, Tuesday\, Septembe r 30\, 7:30pm to 9\, Anna Bananas\, 8716 N. Lombard\, Portland \;\n&# 13\;\nThis month at MaptimeStJohns\, we will be to continue programming web spatio-temporal visualizations\, bring a computer if you have one. If you have not come before\, that is alright because we will step throu gh each visualization. I'll bring the js library files for leaflet and the various plugins we will be using. Let's create some cool web map vi sualizations! please RSVP\n\nTags: open source\, osgeo\, spatial\, tempo ral\, web\, Visualizations\n\nImported from: http://calagator.org/events /1250467071 SUMMARY:OSGeo Spatio-Temporal Web Visualizations\, MapTimeStJohns LOCATION:Anna Bananas\, St Johns: 8716 N. Lombard\, Portland Oregon 97203 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190206T194854Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190221T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190221T180000 DTSTAMP;VALUE=DATE-TIME:20190206T194854Z LAST-MODIFIED;VALUE=DATE-TIME:20190206T194854Z UID:http://calagator.org/events/1250475002 DESCRIPTION:Temporal databases let you record history: either a history o f the database (what the table used to say)\, a history of the thing its elf (what it used to be)\, or both at once. The theory of temporal datab ases goes back to the 90s\, but standardization has only just begun with some modest recommendations in SQL:2011\, and database products (includ ing Postgres) are still missing major functionality. \;\n \;\nThis talk will cover how temporal tables are structured\, how they are queri ed and updated\, what SQL:2011 offers (and doesn't)\, what functionality Postgres has already\, and what remains to be built. \;\n \;\nPau l started programming on a Tandy 1000 at age 8 and hasn't been able to s top since. He helped build one of the Mac's first web servers in 1994 an d has founded software companies in politics and technical hiring. He wo rks as an independent consultant specializing in Rails\, Postgres\, and Chef.\n\nTags: postgres\, postgresql\, pdxpug\, temporal\n\nImported fro m: http://calagator.org/events/1250475002 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG: Temporal Databases: Theory and Postgres LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20200415T154356Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200423T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200423T183000 DTSTAMP;VALUE=DATE-TIME:20200415T154356Z LAST-MODIFIED;VALUE=DATE-TIME:20200415T154356Z UID:http://calagator.org/events/1250476979 DESCRIPTION:We are using Meetup.com to distribute the link to the online meeting [1]\, which will be set shortly before the meeting as we will be using Jitsi [2]. Meetup does require you to RSVP to get access to the link. Jitsi can be used directly with Firefox and Chrome (with extension )\, or phones/tablets with the Jitsi Meet app. \;\n \;\nSpeaker: P aul Jungwirth \;\n \;\nI'd like to present a couple patches I have in-progress for Postgres\, the first to add a new type called "\;mu ltiranges"\;\, and the second to add various SQL:2011 temporal datab ase features: temporal primary &\; foreign keys\, and temporal UPDATE and DELETE. I'll discuss what these features look like to users and als o highlight some of the implementation details behind them. \;\n \ ;\n[1] https://www.meetup.com/pdxpug/events/270062132/ \;\n[2] https: //jitsi.org \;\n\n\nTags: pdxpug\, postgres\, postgresql\, multirange s\, temporal\, datatypes\n\nImported from: http://calagator.org/events/1 250476979 URL:https://www.meetup.com/pdxpug/events/270062132/ SUMMARY:PDXPUG: Multiranges and SQL:2011 Temporal Features LOCATION:Online: placeholder for on-line events\, SEQUENCE:1 END:VEVENT END:VCALENDAR