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-07-22 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
773815
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-07-22 23:59:59' AND tap.permit_type_id = '4' AND ( 1 )  
821711
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-07-22 23:59:59' AND pt.type_id = '73' AND p.permit_type_code != '' 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-07-22 23:59:59' AND pt.type_id = '14' AND p.permit_type_code != '' AND ( 1 )  
4116
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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 23:59:59' AND pt.type_id = '75' AND p.permit_type_code != '' AND ( 1 )  
21984
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-07-22 23:59:59' AND tap.permit_type_id = '75' AND ( 1 )  
31263
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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 23:59:59' AND pt.type_id = '27' AND p.permit_type_code != '' AND ( 1 )  
9230
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-07-22 23:59:59' AND tap.permit_type_id = '27' AND ( 1 )  
10542
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-07-22 23:59:59' AND pt.type_id = '71' AND p.permit_type_code != '' AND ( 1 )  
77975
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-07-22 23:59:59' AND tap.permit_type_id = '71' AND ( 1 )  
77975
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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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-07-22 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 07/22/18
  Permit Applications Permits Issued CO's Issued Total SF Avg. SF Total Value Avg. Value Total Fees
NEW SINGLE FAMILY DETACHED 288 272 328 821,711.00 3,021.00 $56,270,972.00 $195,385.32 $2,056,373.66
NEW SINGLE FAMILY ATTACHED 10 10 25 14,120.00 1,412.00 $988,400.00 $98,840.00 $79,223.92
RESIDENTIAL ADDITION/ALTERATION 34 32 0 6,887.00 215.22 $818,186.00 $24,064.29 $5,753.19
COMMERCIAL ADDITION / ALTERATION 12 11 0 0.00 0.00 $12,984,825.00 $1,082,068.75 $50,750.45
NEW COMMERCIAL BUILDING 13 5 3 0.00 0.00 $78,155,557.00 $6,011,965.92 $864,302.67
ACCESSORY STRUCTURE 74 69 0 31,263.00 453.09 $702,734.00 $9,496.41 $10,354.94
GENERAL BUILDING PERMIT 47 46 0 0.00 0.00 $574,334.00 $12,219.87 $5,551.20
FLATWORK 16 15 0 0.00 0.00 $116,820.00 $7,301.25 $856.71
MOBILE HOME 1 1 0 0.00 0.00 $0.00 $0.00 $40.00
MECHANICAL 44 40 0 0.00 0.00 $0.00 $0.00 $1,440.00
PLUMBING 129 124 0 0.00 0.00 $173,694.44 $1,346.47 $4,530.00
FENCE 47 43 0 0.00 0.00 $319,927.00 $6,806.96 $1,075.00
IRRIGATION 383 374 0 2,989.00 7.99 $209,230.00 $546.29 $440.00
ABOVE GROUND POOL 5 5 0 0.00 0.00 $9,600.00 $1,920.00 $300.00
IN GROUND POOL 66 59 0 0.00 0.00 $2,975,709.00 $45,086.50 $10,655.93
DEMOLITION 7 7 0 10,542.00 1,506.00 $542,432.00 $77,490.29 $280.00
EXCAVATING AND GRADING 9 6 0 77,975.00 12,995.83 $0.00 $0.00 $0.00
ROOF 112 101 0 0.00 0.00 $0.00 $0.00 $4,000.00
PERMANENT SIGN 46 42 0 0.00 0.00 $0.00 $0.00 $2,050.00
CERTIFICATE OF OCCUPANCY 99 24 86 0.00 0.00 $0.00 $0.00 $600.00
TENANT FINISH OUT 14 13 1 0.00 0.00 $2,006,769.00 $143,340.64 $25,850.28
SALES / CONSTRUCTION TRAILER 4 4 0 0.00 0.00 $23,000.00 $5,750.00 $200.00
Totals 1,460 1,303 443 965,487.00 1,019.52 $156,872,189.44 $165,651.73 $3,124,627.95
Average 66 20 43,885.77 46.34 $7,130,554.07 $7,529.62 $142,028.54
MYGOV.US
ACTIVITY REPORT BY PROJECT TYPE
Printed 07/22/18 at 7:35 AM