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-10-19 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
738737
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-10-19 23:59:59' AND tap.permit_type_id = '4' AND ( 1 )  
1077561
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-10-19 23:59:59' AND pt.type_id = '73' AND p.permit_type_code != '' AND ( 1 )  
8312
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-10-19 23:59:59' AND tap.permit_type_id = '73' AND ( 1 )  
14120
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-10-19 23:59:59' AND pt.type_id = '14' AND p.permit_type_code != '' AND ( 1 )  
3956
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-10-19 23:59:59' AND tap.permit_type_id = '14' AND ( 1 )  
6887
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-10-19 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-10-19 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-10-19 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-10-19 23:59:59' AND pt.type_id = '75' AND p.permit_type_code != '' AND ( 1 )  
28681
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-10-19 23:59:59' AND tap.permit_type_id = '75' AND ( 1 )  
43428
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-10-19 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-10-19 23:59:59' AND tap.permit_type_id = '55' 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-10-19 23:59:59' AND pt.type_id = '16' 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-10-19 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-10-19 23:59:59' AND pt.type_id = '34' 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-10-19 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-10-19 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-10-19 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-10-19 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-10-19 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-10-19 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-10-19 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-10-19 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-10-19 23:59:59' AND pt.type_id = '32' 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-10-19 23:59:59' AND tap.permit_type_id = '32' 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-10-19 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-10-19 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-10-19 23:59:59' AND pt.type_id = '27' AND p.permit_type_code != '' AND ( 1 )  
10443
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-10-19 23:59:59' AND tap.permit_type_id = '27' AND ( 1 )  
11755
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-10-19 23:59:59' AND pt.type_id = '71' AND p.permit_type_code != '' AND ( 1 )  
447975
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-10-19 23:59:59' AND tap.permit_type_id = '71' AND ( 1 )  
449475
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-10-19 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-10-19 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-10-19 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-10-19 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-10-19 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-10-19 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-10-19 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-10-19 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-10-19 23:59:59' AND pt.type_id = '63' AND p.permit_type_code != '' AND ( 1 )  
256
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-10-19 23:59:59' AND tap.permit_type_id = '63' AND ( 1 )  
256
City of Midlothian's
ACTIVITY REPORT BY PROJECT TYPE
01/01/18 to 10/19/18
  Permit Applications Permits Issued CO's Issued Total SF Avg. SF Total Value Avg. Value Total Fees
NEW SINGLE FAMILY DETACHED 379 348 460 1,077,561.00 3,096.44 $74,180,472.00 $195,726.84 $2,633,335.17
NEW SINGLE FAMILY ATTACHED 10 10 31 14,120.00 1,412.00 $988,400.00 $98,840.00 $79,223.92
RESIDENTIAL ADDITION/ALTERATION 50 46 0 6,887.00 149.72 $1,016,368.00 $20,327.36 $8,087.39
COMMERCIAL ADDITION / ALTERATION 21 17 0 0.00 0.00 $32,837,817.00 $1,563,705.57 $171,129.94
NEW COMMERCIAL BUILDING 18 11 4 0.00 0.00 $431,395,836.00 $23,966,435.33 $1,689,452.18
ACCESSORY STRUCTURE 108 96 0 43,428.00 452.38 $1,078,537.00 $9,986.45 $14,625.60
GENERAL BUILDING PERMIT 58 56 0 0.00 0.00 $862,777.00 $14,875.47 $8,896.45
FLATWORK 25 23 0 0.00 0.00 $152,720.00 $6,108.80 $1,176.71
MOBILE HOME 1 1 0 0.00 0.00 $0.00 $0.00 $40.00
MECHANICAL 69 61 0 0.00 0.00 $0.00 $0.00 $2,160.00
PLUMBING 174 167 0 0.00 0.00 $212,554.44 $1,221.58 $6,250.00
FENCE 75 72 0 0.00 0.00 $560,378.00 $7,471.71 $1,675.00
IRRIGATION 515 510 0 2,989.00 5.86 $209,230.00 $406.27 $640.00
ABOVE GROUND POOL 5 5 0 0.00 0.00 $9,600.00 $1,920.00 $300.00
IN GROUND POOL 90 80 0 0.00 0.00 $4,041,074.00 $44,900.82 $13,655.93
DEMOLITION 8 7 0 11,755.00 1,679.29 $656,845.00 $82,105.63 $320.00
EXCAVATING AND GRADING 14 11 0 449,475.00 40,861.36 $0.00 $0.00 $0.00
ROOF 172 166 0 0.00 0.00 $0.00 $0.00 $6,520.00
PERMANENT SIGN 85 74 0 0.00 0.00 $0.00 $0.00 $3,750.00
CERTIFICATE OF OCCUPANCY 105 32 90 0.00 0.00 $0.00 $0.00 $840.00
TENANT FINISH OUT 18 18 3 0.00 0.00 $2,452,269.00 $136,237.17 $32,658.27
SALES / CONSTRUCTION TRAILER 12 11 0 256.00 23.27 $40,920.00 $3,410.00 $10,918.96
Totals 2,012 1,822 588 1,606,471.00 1,176.04 $550,695,797.44 $403,144.80 $4,685,655.52
Average 91 27 73,021.41 53.46 $25,031,627.16 $18,324.76 $212,984.34
MYGOV.US
ACTIVITY REPORT BY PROJECT TYPE
Printed 10/19/18 at 11:17 AM