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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.type_id = '33' 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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND tap.permit_issue_date <= '2020-07-31 23:59:59' AND tap.permit_type_id = '15' 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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.type_id = '17' 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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.type_id = '109' 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 >= '2020-07-01' AND tap.permit_issue_date <= '2020-07-31 23:59:59' AND tap.permit_type_id = '109' 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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND tap.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.type_id = '13' 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 >= '2020-07-01' AND tap.permit_issue_date <= '2020-07-31 23:59:59' AND tap.permit_type_id = '13' 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 >= '2020-07-01' AND tap.permit_issue_date <= '2020-07-31 23:59:59' AND tap.permit_type_id = '21' 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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.type_id = '1' 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 >= '2020-07-01' AND tap.permit_issue_date <= '2020-07-31 23:59:59' AND tap.permit_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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.type_id = '23' 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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.type_id = '6' AND ( 1 )  
25537
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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND tap.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND tap.permit_issue_date <= '2020-07-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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.type_id = '31' 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 >= '2020-07-01' AND p.permit_issue_date <= '2020-07-31 23:59:59' AND pt.type_id = '88' AND ( 1 )  
0
City of Hewitt's
Monthly Report
Month of July, 2020
  Permit Applications Permits Issued Total Inspections CO's Issued Total Value Avg. Value Total Fees Avg. Fee Total Value YTD
Amendment of Zoning 1 1 1 0 $0.00 $0.00 $300.00 $300.00 $0.00
Appeal to Board of Adjustment 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00
Carport Permit 0 0 1 0 $0.00 $0.00 $0.00 $0.00 $0.00
Commercial Accessory Building 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00
Commercial Occupancy Permit 3 3 4 1 $0.00 $0.00 $150.00 $50.00 $0.00
Commercial Remodeling Permit 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00
Deck Permit 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00
Demolition Permit 1 1 1 0 $0.00 $0.00 $100.00 $100.00 $0.00
Electric Solar Panel 6 6 17 0 $0.00 $0.00 $243.00 $40.50 $0.00
Electrical Permit 4 4 13 0 $0.00 $0.00 $129.00 $32.25 $0.00
Fence Permit 4 4 7 0 $0.00 $0.00 $140.00 $35.00 $0.00
Fire Protection Systems 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00
Flat Work Permit 6 6 17 0 $0.00 $0.00 $240.00 $40.00 $0.00
Gas Repair Permit 1 1 1 0 $0.00 $0.00 $24.00 $24.00 $0.00
Lawn Sprinkler Permit 6 6 6 0 $0.00 $0.00 $431.00 $71.83 $0.00
Mechanical Permit 2 2 6 0 $0.00 $0.00 $109.00 $54.50 $0.00
Mobile Home Move-In Permit 1 1 0 0 $0.00 $0.00 $35.00 $35.00 $0.00
Network Nodes & Node Support Poles 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00
New Commercial Building Permit 0 0 1 0 $0.00 $0.00 $0.00 $0.00 $0.00
New Residential Building Permit 8 8 48 2 $2,793,635.92 $349,204.49 $7,337.46 $917.18 $9,669,158.64
New Residential Electrical 4 4 22 0 $0.00 $0.00 $678.66 $169.67 $0.00
New Residential Mechanical 3 3 12 0 $0.00 $0.00 $674.50 $224.83 $0.00
New Residential Plumbing 8 8 32 0 $0.00 $0.00 $1,294.02 $161.75 $0.00
Patio Cover Permit 3 3 12 0 $0.00 $0.00 $108.50 $36.17 $0.00
Patio Enclosure Permit 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00
Plumbing Permit 6 6 6 0 $0.00 $0.00 $184.00 $30.67 $0.00
Residential Accessory Building 6 6 15 0 $0.00 $0.00 $347.84 $57.97 $0.00
Residential Exterior Additions 1 1 2 0 $0.00 $0.00 $320.00 $320.00 $0.00
Residential Remodeling Permit 1 1 5 0 $0.00 $0.00 $360.00 $360.00 $0.00
Roofing Permit 87 87 106 0 $0.00 $0.00 $3,115.00 $35.80 $0.00
Sign Permit 0 0 2 0 $0.00 $0.00 $0.00 $0.00 $0.00
Special Use Permit Application 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00
Swimming Pool 2 2 6 0 $0.00 $0.00 $300.00 $150.00 $0.00
Temporary Commercial Building 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00
Temporary Storage Containers 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00
Window Replacement Permit 1 1 1 0 $0.00 $0.00 $25.00 $25.00 $0.00
Totals 165 165 344 3 $2,793,635.92 $77,601.00 $16,645.98 $462.39 $9,669,158.64
Average 5 10 0 $77,601.00 $2,155.58 $462.39 $12.84 $268,587.74
MYGOV.US
Monthly Report
Printed 08/05/20 at 5:38 PM