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.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2017-12-23' AND p.permit_issue_date <= '2018-01-22 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
140285
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.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2017-12-23' AND p.permit_issue_date <= '2018-01-22 23:59:59' AND pt.type_id = '14' AND p.permit_type_code != '' AND ( 1 )  
1164
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.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2017-12-23' AND p.permit_issue_date <= '2018-01-22 23:59:59' AND pt.type_id = '13' 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.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2017-12-23' AND p.permit_issue_date <= '2018-01-22 23:59:59' AND pt.type_id = '27' AND p.permit_type_code != '' AND ( 1 )  
1312
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2017-12-23' AND tap.permit_issue_date <= '2018-01-22 23:59:59' AND tap.permit_type_id = '15' AND ( 1 )  
0
City of Midlothian's
Growth Profile Report
12/23/17 to 01/22/18
  Permit Applications Permits Issued Projects Completed CO's Issued Total SF Avg. SF Total Value Avg. Value
NEW SINGLE FAMILY DETACHED 50 50 0 24 140,285.00 2,805.70 $9,847,250.00 $196,945.00
RESIDENTIAL ADDITION/ALTERATION 4 4 0 0 1,164.00 291.00 $80,664.00 $20,166.00
COMMERCIAL ADDITION / ALTERATION 3 3 0 0 0.00 0.00 $482,000.00 $160,666.67
NEW COMMERCIAL BUILDING 0 0 0 2 0.00 0.00 $0.00 $0.00
DEMOLITION 1 1 0 0 1,312.00 1,312.00 $10,000.00 $10,000.00
CERTIFICATE OF OCCUPANCY 1 1 1 0 0.00 0.00 $0.00 $0.00
Totals 59 59 1 26 142,761.00 2,504.58 $10,419,914.00 $182,805.51
Average 10 0 4 23,793.50 417.43 $1,736,652.33 $30,467.58
MYGOV.US
Growth Profile Report
Printed 01/22/18 at 3:50 PM