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
