SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '15' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2019-12-01' AND tap.permit_issue_date <= '2019-12-31 23:59:59' AND tap.permit_type_id = '16' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '2' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2019-12-01' AND tap.permit_issue_date <= '2019-12-31 23:59:59' AND tap.permit_type_id = '2' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '14' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2019-12-01' AND tap.permit_issue_date <= '2019-12-31 23:59:59' AND tap.permit_type_id = '14' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '13' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '4' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2019-12-01' AND tap.permit_issue_date <= '2019-12-31 23:59:59' AND tap.permit_type_id = '4' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '1' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '105' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '9' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '6' AND ( 1 )  
9626
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '69' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '70' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '68' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '26' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '3' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2019-12-01' AND tap.permit_issue_date <= '2019-12-31 23:59:59' AND tap.permit_type_id = '3' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '27' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2019-12-01' AND tap.permit_issue_date <= '2019-12-31 23:59:59' AND tap.permit_type_id = '27' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '95' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '39' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '11' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2019-12-01' AND tap.permit_issue_date <= '2019-12-31 23:59:59' AND tap.permit_type_id = '11' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '28' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2019-12-01' AND tap.permit_issue_date <= '2019-12-31 23:59:59' AND tap.permit_type_id = '85' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_hewitt_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2019-12-01' AND p.permit_issue_date <= '2019-12-31 23:59:59' AND pt.type_id = '88' AND ( 1 )  
0
City of Hewitt's
Monthly Report
Month of December, 2019
  Permit Applications Permits Issued Total Inspections CO's Issued Total Value Avg. Value Total Fees Avg. Fee Total Value YTD
Carport Permit 0 0 1 0 $0.00 $0.00 $0.00 $0.00 $0.00
Commercial Occupancy Permit 2 2 2 0 $0.00 $0.00 $100.00 $50.00 $0.00
Commercial Remodeling Permit 1 1 3 1 $0.00 $0.00 $225.00 $225.00 $0.00
Deck Permit 0 0 1 0 $0.00 $0.00 $0.00 $0.00 $0.00
Demolition Permit 0 0 2 0 $0.00 $0.00 $0.00 $0.00 $0.00
Electric Solar Panel 0 0 9 0 $0.00 $0.00 $0.00 $0.00 $0.00
Electrical Permit 4 4 11 0 $0.00 $0.00 $349.00 $87.25 $0.00
Fence Permit 2 2 9 0 $0.00 $0.00 $70.00 $35.00 $0.00
Fire Protection Systems 0 0 1 0 $0.00 $0.00 $0.00 $0.00 $0.00
Flat Work Permit 2 2 9 0 $0.00 $0.00 $80.00 $40.00 $0.00
Garage Enclosure Permit 0 0 1 0 $0.00 $0.00 $0.00 $0.00 $0.00
Lawn Sprinkler Permit 5 5 3 0 $0.00 $0.00 $417.00 $83.40 $0.00
Mechanical Permit 3 3 3 0 $0.00 $0.00 $259.00 $86.33 $0.00
Network Nodes & Node Support Poles 4 4 1 0 $0.00 $0.00 $6,000.00 $1,500.00 $0.00
New Commercial Building Permit 2 2 3 0 $0.00 $0.00 $8,989.36 $4,494.68 $0.00
New Platting 0 0 1 0 $0.00 $0.00 $0.00 $0.00 $0.00
New Residential Building Permit 4 4 48 1 $1,155,518.88 $288,879.72 $3,894.12 $973.53 $0.00
New Residential Electrical 3 3 30 0 $0.00 $0.00 $467.82 $155.94 $0.00
New Residential Mechanical 1 1 6 0 $0.00 $0.00 $167.58 $167.58 $0.00
New Residential Plumbing 4 4 21 0 $0.00 $0.00 $729.54 $182.39 $0.00
Patio Cover Permit 1 1 2 0 $0.00 $0.00 $35.00 $35.00 $0.00
Plumbing Permit 8 8 18 0 $0.00 $0.00 $236.00 $29.50 $0.00
Residential Accessory Building 3 3 9 0 $0.00 $0.00 $55.36 $18.45 $0.00
Residential Exterior Additions 1 1 0 0 $0.00 $0.00 $320.00 $320.00 $0.00
Residential Remodeling Permit 1 1 7 1 $0.00 $0.00 $125.00 $125.00 $0.00
Roofing Permit 5 5 22 0 $0.00 $0.00 $175.00 $35.00 $0.00
Sign Permit 3 3 4 0 $0.00 $0.00 $308.00 $102.67 $0.00
Spa/Hot Tub 0 0 1 0 $0.00 $0.00 $0.00 $0.00 $0.00
Swimming Pool 0 0 2 0 $0.00 $0.00 $0.00 $0.00 $0.00
Temporary Storage Containers 2 2 4 0 $0.00 $0.00 $25.00 $12.50 $0.00
Window Replacement Permit 3 3 2 0 $0.00 $0.00 $100.00 $33.33 $0.00
Totals 64 64 236 3 $1,155,518.88 $288,879.72 $23,127.78 $5,781.95 $0.00
Average 2 8 0 $37,274.80 $9,318.70 $746.06 $186.52 $0.00
MYGOV.US
Monthly Report
Printed 01/22/20 at 3:02 PM