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-04-24 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
563562
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-04-24 23:59:59' AND tap.permit_type_id = '4' AND ( 1 )  
567146
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-04-24 23:59:59' AND pt.type_id = '73' AND p.permit_type_code != '' AND ( 1 )  
8712
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-04-24 23:59:59' AND pt.type_id = '14' AND p.permit_type_code != '' AND ( 1 )  
2195
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-04-24 23:59:59' AND tap.permit_type_id = '14' AND ( 1 )  
2931
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-04-24 23:59:59' AND pt.type_id = '13' 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-04-24 23:59:59' AND tap.permit_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_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-04-24 23:59:59' AND pt.type_id = '10' 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-04-24 23:59:59' AND pt.type_id = '75' AND p.permit_type_code != '' AND ( 1 )  
11503
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-04-24 23:59:59' AND tap.permit_type_id = '75' AND ( 1 )  
13883
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-04-24 23:59:59' AND pt.type_id = '55' 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-04-24 23:59:59' AND tap.permit_type_id = '55' 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-04-24 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_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-04-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-04-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-04-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-04-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-04-24 23:59:59' AND pt.type_id = '8' 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-04-24 23:59:59' AND tap.permit_type_id = '8' 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-04-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-04-24 23:59:59' AND tap.permit_type_id = '45' AND ( 1 )  
2989
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-04-24 23:59:59' AND pt.type_id = '6' 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-04-24 23:59:59' AND tap.permit_type_id = '6' 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-04-24 23:59:59' AND pt.type_id = '27' AND p.permit_type_code != '' AND ( 1 )  
6412
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-04-24 23:59:59' AND tap.permit_type_id = '27' AND ( 1 )  
6412
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-04-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-04-24 23:59:59' AND pt.type_id = '9' 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-04-24 23:59:59' AND tap.permit_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_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-04-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-04-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-04-24 23:59:59' AND pt.type_id = '15' 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-04-24 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_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-04-24 23:59:59' AND pt.type_id = '12' 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-04-24 23:59:59' AND tap.permit_type_id = '12' 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-04-24 23:59:59' AND pt.type_id = '63' AND p.permit_type_code != '' AND ( 1 )  
0
City of Midlothian's
ACTIVITY REPORT BY PROJECT TYPE
01/01/18 to 04/24/18
  Permit Applications Permits Issued CO's Issued Total SF Avg. SF Total Value Avg. Value Total Fees
NEW SINGLE FAMILY DETACHED 199 157 164 567,146.00 3,612.39 $38,687,382.00 $194,408.95 $1,262,807.29
NEW SINGLE FAMILY ATTACHED 6 6 15 8,712.00 1,452.00 $609,840.00 $101,640.00 $48,131.40
RESIDENTIAL ADDITION/ALTERATION 21 19 0 2,931.00 154.26 $460,602.00 $21,933.43 $3,647.74
COMMERCIAL ADDITION / ALTERATION 6 4 0 0.00 0.00 $190,250.00 $31,708.33 $1,482.05
NEW COMMERCIAL BUILDING 8 0 2 0.00 0.00 $64,196,780.00 $8,024,597.50 $161,944.75
ACCESSORY STRUCTURE 38 29 0 13,883.00 478.72 $316,704.00 $8,334.32 $5,413.69
GENERAL BUILDING PERMIT 32 32 0 0.00 0.00 $267,571.00 $8,361.59 $4,391.50
FLATWORK 3 3 0 0.00 0.00 $7,820.00 $2,606.67 $120.00
MECHANICAL 17 15 0 0.00 0.00 $0.00 $0.00 $560.00
PLUMBING 80 77 0 0.00 0.00 $118,146.00 $1,476.83 $2,770.00
FENCE 21 20 0 0.00 0.00 $125,145.00 $5,959.29 $500.00
IRRIGATION 239 234 0 2,989.00 12.77 $209,230.00 $875.44 $200.00
IN GROUND POOL 30 22 0 0.00 0.00 $1,190,305.00 $39,676.83 $3,900.00
DEMOLITION 4 3 0 6,412.00 2,137.33 $525,432.00 $131,358.00 $160.00
EXCAVATING AND GRADING 1 1 0 0.00 0.00 $0.00 $0.00 $0.00
ROOF 25 23 0 0.00 0.00 $0.00 $0.00 $960.00
PERMANENT SIGN 22 14 0 0.00 0.00 $0.00 $0.00 $750.00
CERTIFICATE OF OCCUPANCY 91 18 85 0.00 0.00 $0.00 $0.00 $280.00
TENANT FINISH OUT 11 8 0 0.00 0.00 $1,738,769.00 $158,069.91 $17,067.60
SALES / CONSTRUCTION TRAILER 1 1 0 0.00 0.00 $20,000.00 $20,000.00 $50.00
Totals 855 686 266 602,073.00 1,216.31 $108,663,976.00 $219,523.18 $1,515,136.02
Average 43 13 30,103.65 60.82 $5,433,198.80 $10,976.16 $75,756.80
MYGOV.US
ACTIVITY REPORT BY PROJECT TYPE
Printed 04/24/18 at 4:03 PM