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 >= '2017-01-01' AND p.start_date <= '2017-11-17 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
992633
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2017-01-01' AND tap.start_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '4' AND ( 1 )  
1574493
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 >= '2017-01-01' AND p.start_date <= '2017-11-17 23:59:59' AND pt.type_id = '73' AND p.permit_type_code != '' AND ( 1 )  
46062
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2017-01-01' AND tap.start_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '73' AND ( 1 )  
56744
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 >= '2017-01-01' AND p.start_date <= '2017-11-17 23:59:59' AND pt.type_id = '14' AND p.permit_type_code != '' AND ( 1 )  
5660
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2017-01-01' AND tap.start_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '14' AND ( 1 )  
9488
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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 23:59:59' AND pt.type_id = '10' 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '10' 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 23:59:59' AND pt.type_id = '11' 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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_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 >= '2017-01-01' AND p.start_date <= '2017-11-17 23:59:59' AND pt.type_id = '75' 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '75' 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 23:59:59' AND pt.type_id = '34' 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '34' 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 23:59:59' AND pt.type_id = '2' AND p.permit_type_code != '' AND ( 1 )  
2080
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2017-01-01' AND tap.start_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '2' AND ( 1 )  
2080
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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '3' AND ( 1 )  
2978
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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 23:59:59' AND pt.type_id = '27' AND p.permit_type_code != '' AND ( 1 )  
2200
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2017-01-01' AND tap.start_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '27' AND ( 1 )  
5009
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 >= '2017-01-01' AND p.start_date <= '2017-11-17 23:59:59' AND pt.type_id = '71' 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '71' 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 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 >= '2017-01-01' AND tap.start_date <= '2017-11-17 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 >= '2017-01-01' AND p.start_date <= '2017-11-17 23:59:59' AND pt.type_id = '63' AND p.permit_type_code != '' AND ( 1 )  
1516
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2017-01-01' AND tap.start_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '63' AND ( 1 )  
2732
City of Midlothian's
ACTIVITY REPORT BY PROJECT TYPE
01/01/17 to 11/17/17
  Permit Applications Permits Issued CO's Issued Total SF Avg. SF Total Value Avg. Value Total Fees
NEW SINGLE FAMILY DETACHED 562 529 352 1,574,493.00 2,976.36 $87,218,046.00 $155,192.25 $3,528,351.28
NEW SINGLE FAMILY ATTACHED 44 44 79 56,744.00 1,289.64 $2,950,688.00 $67,061.09 $349,099.46
RESIDENTIAL ADDITION/ALTERATION 54 51 0 9,488.00 186.04 $1,242,502.00 $23,009.30 $6,133.36
COMMERCIAL ADDITION / ALTERATION 30 22 0 0.00 0.00 $15,962,134.00 $532,071.13 $67,060.92
NEW COMMERCIAL BUILDING 12 9 6 0.00 0.00 $40,941,683.00 $3,411,806.92 $401,818.41
NEW COMMERCIAL SHELL BUILDING 9 8 0 0.00 0.00 $7,542,775.00 $838,086.11 $203,014.16
ACCESSORY BUILDING 39 34 0 0.00 0.00 $0.00 $0.00 $3,756.78
GENERAL BUILDING PERMIT 18 16 0 0.00 0.00 $468,500.00 $26,027.78 $2,573.11
FLATWORK 30 29 0 0.00 0.00 $297,712.00 $9,923.73 $1,454.00
MOBILE HOME 3 3 0 0.00 0.00 $0.00 $0.00 $120.00
ELECTRICAL 35 32 0 2,080.00 65.00 $112,885.00 $3,225.29 $2,330.00
MECHANICAL 52 51 0 2,978.00 58.39 $154,856.00 $2,978.00 $2,040.00
PLUMBING 123 121 0 0.00 0.00 $110,647.00 $899.57 $4,680.00
FENCE 57 48 0 0.00 0.00 $501,837.00 $8,804.16 $1,449.63
IRRIGATION 450 447 0 0.00 0.00 $0.00 $0.00 $640.00
ABOVE GROUND POOL 2 2 0 0.00 0.00 $5,250.00 $2,625.00 $120.00
IN GROUND POOL 91 89 0 0.00 0.00 $3,489,843.00 $38,349.92 $13,650.00
DEMOLITION 3 2 0 5,009.00 2,504.50 $32,000.00 $10,666.67 $50.00
EXCAVATING AND GRADING 6 3 0 0.00 0.00 $0.00 $0.00 $142.00
ROOF 81 77 0 0.00 0.00 $0.00 $0.00 $3,200.00
PERMANENT SIGN 104 87 0 0.00 0.00 $0.00 $0.00 $4,400.00
CERTIFICATE OF OCCUPANCY 34 25 13 0.00 0.00 $0.00 $0.00 $1,240.00
TENANT FINISH OUT 12 10 5 0.00 0.00 $2,785,552.00 $232,129.33 $27,692.87
SALES / CONSTRUCTION TRAILER 9 9 0 2,732.00 303.56 $152,064.00 $16,896.00 $37,801.00
Totals 1,860 1,748 455 1,653,524.00 1,511.45 $163,968,974.00 $149,880.23 $4,662,816.98
Average 78 19 68,896.83 62.98 $6,832,040.58 $6,245.01 $194,284.04
MYGOV.US
ACTIVITY REPORT BY PROJECT TYPE
Printed 11/17/17 at 5:14 PM