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 >= '2018-03-25' AND p.permit_issue_date <= '2018-04-24 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
163614
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 >= '2018-03-25' AND p.permit_issue_date <= '2018-04-24 23:59:59' AND pt.type_id = '14' AND p.permit_type_code != '' AND ( 1 )  
660
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 >= '2018-03-25' AND p.permit_issue_date <= '2018-04-24 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 >= '2018-03-25' AND p.permit_issue_date <= '2018-04-24 23:59:59' AND pt.type_id = '27' AND p.permit_type_code != '' AND ( 1 )  
3300
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 >= '2018-03-25' AND p.permit_issue_date <= '2018-04-24 23:59:59' AND pt.type_id = '15' AND p.permit_type_code != '' AND ( 1 )  
0
City of Midlothian's
Growth Profile Report
03/25/18 to 04/24/18
  Permit Applications Permits Issued Projects Completed CO's Issued Total SF Avg. SF Total Value Avg. Value
NEW SINGLE FAMILY DETACHED 55 55 0 58 163,614.00 2,974.80 $10,920,070.00 $198,546.73
RESIDENTIAL ADDITION/ALTERATION 5 5 0 0 660.00 132.00 $114,120.00 $22,824.00
COMMERCIAL ADDITION / ALTERATION 2 2 0 0 0.00 0.00 $49,450.00 $24,725.00
DEMOLITION 1 1 0 0 3,300.00 3,300.00 $10,932.00 $10,932.00
CERTIFICATE OF OCCUPANCY 1 1 0 7 0.00 0.00 $0.00 $0.00
Totals 64 64 0 65 167,574.00 2,659.90 $11,094,572.00 $176,104.32
Average 13 0 13 33,514.80 531.98 $2,218,914.40 $35,220.86
MYGOV.US
Growth Profile Report
Printed 04/24/18 at 4:12 PM