<< 2014年7月22日 | 首页 | 2014年7月24日 >>

HTML table Export

HTML 表格导出 jQuery 插件可以帮助用户导出 HTML 表格到 JSON、XML、PNG、CSV、TXT、SQL、MS-Word、MS-Excel、MS-PowerPoint 和 PDF 格式。您可以轻松地设置字体大小,分隔符,导出类型等。

Installation

 jquery Plugin

<script type="text/javascript" src="tableExport.js">
<script type="text/javascript" src="jquery.base64.js">

 PNG Export

<script type="text/javascript" src="html2canvas.js">

 PDF Export

<script type="text/javascript" src="jspdf/libs/sprintf.js">
<script type="text/javascript" src="jspdf/jspdf.js">
<script type="text/javascript" src="jspdf/libs/base64.js">

 Usage

onClick ="$('#tableID').tableExport({type:'pdf',escape:'false'});"

 Type

{type:'json',escape:'false'}
{type:'json',escape:'false',ignoreColumn:'[2,3]'}
{type:'json',escape:'true'}

{type:'xml',escape:'false'}
{type:'sql'}

{type:'csv',escape:'false'}
{type:'txt',escape:'false'}

{type:'excel',escape:'false'}
{type:'doc',escape:'false'}
{type:'powerpoint',escape:'false'}

{type:'png',escape:'false'}
{type:'pdf',pdfFontSize:'7',escape:'false'}

 Options

separator: ','
ignoreColumn: [2,3],
tableName:'yourTableName'
type:'csv'
pdfFontSize:14
pdfLeftMargin:20
escape:'true'
htmlContent:'false'
consoleLog:'false' 

 Sample TABLE Format

<table id="customers" class="table table-striped" >
	<thead>			
		<tr class='warning'>
			<th>Country</th>
			<th>Population</th>
			<th>Date</th>
			<th>%ge</th>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td>Chinna</td>
			<td>1,363,480,000</td>
			<td>March 24, 2014</td>
			<td>19.1</td>
		</tr>
		<tr>
			<td>India</td>
			<td>1,241,900,000</td>
			<td>March 24, 2014</td>
			<td>17.4</td>
		</tr>
		<tr>
			<td>United States</td>
			<td>317,746,000</td>
			<td>March 24, 2014</td>
			<td>4.44</td>
		</tr>
		<tr>
			<td>Indonesia</td>
			<td>249,866,000</td>
			<td>July 1, 2013</td>
			<td>3.49</td>
		</tr>
		<tr>
			<td>Brazil</td>
			<td>201,032,714</td>
			<td>July 1, 2013</td>
			<td>2.81</td>
		</tr>
	</tbody>
</table> 

阅读全文……

标签 : ,

交通标志识别项目 putsi/tsaraisa · GitHub

问:识别交通标志,怎么确定图片里有交通标志,具体在哪里?答:这个应该算目标识别和物体识别,CV的经典教程都有object recognition的内容可以参考。具体到交通标志识别,Github上有些开源代码 Matlab C++ Java的都有

Tsaraisa was run with "./tsaraisa.py -s -g -c lbpCascade.xml -M" on demo screenshot.

What does it do?

  • Detect traffic signs.
  • Recognize speed limits in signs.
  • (optional) Compare GPS-speed to speed limit.
  • (optional) Run user command when overspeeding.

How?

GPS-class

  • Uses threading to update GPS-info automatically.
  • Gets speed from GPS-daemon using python bindings.

Frame handling

  • Reads frame from webcam.
  • Converts frame to grayscale with cv2.cvtColor(frame, cv2.COLOR_BGR2GRAY).
  • (optional) Morphological Open/close.
  • (optional) Equalizes histograms with cv2.equalizeHist().
  • Downscale frame with multiplier n.

Traffic sign detection

  • Uses LBP- or HAAR-cascade to detect speed signs.
  • LBP-cascade was trained with 2000 positive and 1000 negative images.
    • Negative image is image of road without speed limit sign.
    • Positive image is image of road with speed limit sign.
  • LBP- and HAAR-detection allows great differences in lightning.
  • LBP- and HAAR-detection works great on low performance machines.

Recognizing speed limits

  • Uses Fast Approximate Nearest Neighbor Search Library feature matching.
  • Creates "keypoints" of detected sign and compares them to all known speed limits (files in data-folder).
  • Keypoint match distances need to be inside a threshold.
  • Match with biggest proper keypoint amount will be returned.
  • It is fast and pretty accurate with different lightning conditions.

Speed assist

  • When new speed limit is detected it is added as current speed limit.
  • After every frame script compares current speed to current speed limit.
  • Script runs specified command when overspeeding (e.g. "beep").

Requirements

Required software

  • OpenCV >=3.0.0
  • Python >=2.7.3
  • LibAV >=0.8.10
  • (optional) gpsd && python-gps
  • (optional) V4L2 1.0.1

Required hardware

  • Webcam or some other video-source.
  • (optional) GPS Module BU-353

阅读全文……

标签 : ,