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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
144723
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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '14' AND p.permit_type_code != '' 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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '75' AND p.permit_type_code != '' AND ( 1 )  
1664
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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '3' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2018-01-01' AND tap.start_date <= '2018-01-24 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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '1' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2018-01-01' AND tap.start_date <= '2018-01-24 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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '8' AND p.permit_type_code != '' 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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '45' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2018-01-01' AND tap.start_date <= '2018-01-24 23:59:59' AND tap.permit_type_id = '45' 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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '6' AND p.permit_type_code != '' 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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '27' AND p.permit_type_code != '' AND ( 1 )  
1312
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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '71' AND p.permit_type_code != '' 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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '9' AND p.permit_type_code != '' 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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '5' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2018-01-01' AND tap.start_date <= '2018-01-24 23:59:59' AND tap.permit_type_id = '5' 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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '15' AND p.permit_type_code != '' 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_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-24 23:59:59' AND pt.type_id = '12' AND p.permit_type_code != '' AND ( 1 )  
0
City of Midlothian's
ACTIVITY REPORT BY PROJECT TYPE
01/01/18 to 01/24/18
  Permit Applications Permits Issued CO's Issued Total SF Avg. SF Total Value Avg. Value Total Fees
NEW SINGLE FAMILY DETACHED 53 21 23 144,723.00 6,891.57 $10,014,200.00 $188,947.17 $225,683.89
RESIDENTIAL ADDITION/ALTERATION 2 1 0 0.00 0.00 $75,786.00 $37,893.00 $136.35
NEW COMMERCIAL BUILDING 0 0 2 0.00 0.00 $0.00 $0.00 $0.00
ACCESSORY STRUCTURE 5 4 0 1,664.00 416.00 $38,167.00 $7,633.40 $737.96
MECHANICAL 6 5 0 0.00 0.00 $0.00 $0.00 $245.00
PLUMBING 16 14 0 0.00 0.00 $15,127.00 $945.44 $520.00
FENCE 1 0 0 0.00 0.00 $10,000.00 $10,000.00 $25.00
IRRIGATION 56 55 0 0.00 0.00 $0.00 $0.00 $40.00
IN GROUND POOL 3 3 0 0.00 0.00 $119,350.00 $39,783.33 $450.00
DEMOLITION 2 1 0 1,312.00 1,312.00 $510,000.00 $255,000.00 $80.00
EXCAVATING AND GRADING 1 1 0 0.00 0.00 $0.00 $0.00 $0.00
ROOF 1 1 0 0.00 0.00 $0.00 $0.00 $40.00
PERMANENT SIGN 5 2 0 0.00 0.00 $0.00 $0.00 $150.00
CERTIFICATE OF OCCUPANCY 4 0 0 0.00 0.00 $0.00 $0.00 $80.00
TENANT FINISH OUT 2 0 0 0.00 0.00 $410,650.00 $205,325.00 $2,058.64
Totals 157 108 25 147,699.00 1,758.32 $11,193,280.00 $133,253.33 $230,246.84
Average 10 2 9,846.60 117.22 $746,218.67 $8,883.56 $15,349.79
MYGOV.US
ACTIVITY REPORT BY PROJECT TYPE
Printed 01/24/18 at 3:16 AM