Skip to content

Instantly share code, notes, and snippets.

@talaj
talaj / dummy.png
Last active October 12, 2016 15:32
comp-op
dummy.png
<Map background-image="../../data/images/pattern.png" srs="+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over">
<Parameters>
<Parameter name="sizes">1000,1000</Parameter>
<Parameter name="bbox">-20037508.3427892476320267,-8283343.6938826972618699,20037508.3427892439067364,18365151.3630704730749130</Parameter>
</Parameters>
<Style name="world">
<Rule>
<PolygonSymbolizer fill="green"/>
</Rule>
</Style>
@talaj
talaj / tv-rip
Last active November 28, 2015 06:03
mencoder
mplayer tv:// -tv driver=v4l2:width=720:height=576:device=/dev/video1:input=0:fps=25:alsa:amode=1:forcechan=2:audiorate=48000:adevice=hw.2,0:forceaudio:immediatemode=0
mencoder tv:// -tv driver=v4l2:width=720:height=576:device=/dev/video1:input=0:fps=25:alsa:amode=1:forcechan=2:audiorate=48000:adevice=hw.2,0:forceaudio:immediatemode=0 -ovc lavc -lavcopts vcodec=mpeg4 -oac mp3lame -o o.avi
mencoder tv:// -tv driver=v4l2:width=720:height=576:device=/dev/video1:input=0:fps=25:alsa:amode=1:forcechan=2:audiorate=48000:adevice=hw.2,0:forceaudio:immediatemode=0 -ovc lavc -lavcopts vcodec=mpeg4:mbd=2:trell:v4mv:last_pred=2:dia=-1:vmax_b_frames=2:vb_strategy=1:cmp=3:subcmp=3:precmp=0:vqcomp=0.6:turbo -oac mp3lame -o x.avi
mencoder tv:// -tv driver=v4l2:width=720:height=576:device=/dev/video1:input=0:fps=25:alsa:amode=1:forcechan=2:audiorate=48000:adevice=hw.2,0:forceaudio:immediatemode=0 -ovc lavc -lavcopts vcodec=mpeg4:mbd=2:trell:v4mv:last_pred=2:dia=-1:vmax_b_frames=2:vb_strategy=1:cmp=3:subcmp=3:precmp=0:vqcomp
@talaj
talaj / fix_kappa.sql
Created February 9, 2015 09:23
fix kappa
update panorama p1 set kappa=(180.0 / pi()) * st_azimuth(p1.the_geom, (select p2.the_geom from panorama p2 where p2.timestamp > p1.timestamp order by timestamp limit 1)) where filepath like '/topgis/Vltava20112012%';
@talaj
talaj / pocet_nasnapovanych.sql
Created January 16, 2015 11:49
Kontrola křižovatek
select count(*) from import.pm_junction_pt j
where (select 1 from import.pm_road_ln r
where routing is not null and
r.geometrie && j.geometrie and
(j.geometrie && ST_StartPoint(r.geometrie) or
j.geometrie && ST_EndPoint(r.geometrie)) limit 1) is not null;
@talaj
talaj / multiline.png
Last active August 29, 2015 14:09
Line height
multiline.png
@talaj
talaj / mapnik-2.3-text-top-800-800-1.0-agg.png
Last active August 29, 2015 14:06
mapnik test vertical-alignment=top
mapnik-2.3-text-top-800-800-1.0-agg.png
@talaj
talaj / fix_filemask
Last active August 29, 2015 14:06
fix filemask
update panorama set filemask = regexp_replace(filemask, '^00_', 'zz_') where source='topgis';
@talaj
talaj / diff
Last active August 29, 2015 14:05
profiling: text rendering with line placement on corners in 3.x
This file has been truncated, but you can view the full file.
CPU: Intel Ivy Bridge microarchitecture, speed 2101 MHz (estimated)
Counted CPU_CLK_UNHALTED events (Clock cycles when not halted) with a unit mask of 0x00 (No unit mask) count 100000
samples % diff % image name symbol name
1470396 22.5499 -5.9453 libfreetype.so.6.11.1 /usr/lib/x86_64-linux-gnu/libfreetype.so.6.11.1
1111698 17.0489 -0.4756 ld-2.19.so do_lookup_x
908036 13.9256 +1.5524 libz.so.1.2.8 /lib/x86_64-linux-gnu/libz.so.1.2.8
650209 9.9716 -0.0209 no-vmlinux /no-vmlinux
550562 8.4434 +18.0841 libmapnik.so.3.0.0 mapnik::hextree<mapnik::rgba, mapnik::RGBAPolicy>::quantize(unsigned int) const
431761 6.6215 +0.2471 libmapnik.so.3.0.0 void mapnik::save_as_png8_hex<std::ostream, mapnik::ImageData<unsigned int> >(std::ostream&, mapnik::ImageData<unsigned int> const&, mapnik::png_options const&)
169181 2.5945 +4.8197 libmapnik.so.3.0.0 void mapnik::save_as_png8<std::ostream, mapnik::ImageDa