Hi
user
Admin Login:
Username:
Password:
Name:
OSM data in MySQL
--client
fosdem
--show
fosdem_2014
--room UA2114 7814 --force
Next: 5 Webmaker and MozEdu - Mozilla in the education and the code
show more...
Marks
Author(s):
Hartmut Holzgraefe
Location
UA2.114 (Baudoux)
Date
feb Sat 01
Days Raw Files
Start
Feb. 1, 2014, 6:05 p.m.
First Raw Start
Feb. 1, 2014, 5:42 p.m.
Duration
00:30:00
Offset
0:22:23
End
Feb. 1, 2014, 6:35 p.m.
Last Raw End
Feb. 1, 2014, 6:36 p.m.
Chapters
00:00
Total cuts_time
25 min.
https://fosdem.org/2014/schedule/event/osm_mysql/
raw-playlist
raw-mp4-playlist
encoded-files-playlist
public
mp4
svg
png
assets
release.pdf
OSM_data_in_MySQL.json
logs
Admin:
episode
episode list
cut list
raw files day
marks day
marks day
image_files
State:
---------
borked
edit
encode
push to queue
post
richard
review 1
email
review 2
make public
tweet
to-miror
conf
done
Locked:
clear this to unlock
Locked by:
user/process that locked.
Start:
initially scheduled time from master, adjusted to match reality
Duration:
length in hh:mm:ss
Name:
Video Title (shows in video search results)
Emails:
email(s) of the presenter(s)
Released:
has someone authorised pubication
Unknown
Yes
No
Normalise:
Channelcopy:
m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:
filename.png
Description:
markdown
<p>So far the main workhorse database for OpenStreeMap data was PostgreSQL/PostGIS. With the GIS improvements in latest MySQL and MariaDB releases, especially having true spatial relationship functions instead of just max bounding rectangle (MBR) based ones, have become viable alternatives though. This talk is going to present the most important improvements, a MySQL backend for the osm2pgsql importer tool, and some sample applications including performance comparisons.</p>
Comment:
production notes
low audio. talk seemed to be already in progress
2014-02-01/16_42_37.dv
Apply:
17:42:37 - 18:06:17 ( 00:23:40 )
S:
17:42:37 -
E:
18:06:17
D:
00:23:40
show more...
vlc ~/Videos/veyepar/fosdem/fosdem_2014/dv/UA2114/2014-02-01/16_42_37.dv :start-time=00.0 --audio-desync=0
Raw File
Cut List
Feb. 1, 2014, 5:42 p.m.
seconds: 0.0
Wall: 17:42:37
Duration
00:23:40
Feb. 1, 2014, 6:06 p.m.
seconds: 0.0
Wall: 17:42:37
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2014-02-01/17_06_18.dv
Apply:
18:06:18 - 18:06:41 ( 00:00:23 )
S:
18:06:18 -
E:
18:06:41
D:
00:00:23
show more...
vlc ~/Videos/veyepar/fosdem/fosdem_2014/dv/UA2114/2014-02-01/17_06_18.dv :start-time=00.0 --audio-desync=0
Raw File
Cut List
Feb. 1, 2014, 6:06 p.m.
seconds: 0.0
Wall: 18:06:18
Duration
00:00:23
Feb. 1, 2014, 6:06 p.m.
seconds: 0.0
Wall: 18:06:18
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2014-02-01/17_11_19.dv
Apply:
18:11:19 - 18:36:57 ( 00:25:38 )
S:
18:11:19 -
E:
18:36:59
D:
00:25:40
(
Start:
0:00) (
End:
25:38)
show more...
vlc ~/Videos/veyepar/fosdem/fosdem_2014/dv/UA2114/2014-02-01/17_11_19.dv :start-time=00.0 --audio-desync=0
Raw File
Cut List
Feb. 1, 2014, 6:11 p.m.
seconds: 0.0
Wall: 18:11:19
Duration
00:25:40
Feb. 1, 2014, 6:36 p.m.
seconds: 1538.0
Wall: 18:36:57
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
Rf filename:
root is .../show/dv/location/, example: 2013-03-13/13:13:30.dv
Sequence:
get this:
check and save to add this
2014-02-01/16_42_37.dv
2014-02-01/17_06_18.dv
2014-02-01/17_11_19.dv
Veyepar
Video Eyeball Processor and Review
