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-06-23' AND p.permit_issue_date <= '2018-07-22 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
80043
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-06-23' AND p.permit_issue_date <= '2018-07-22 23:59:59' AND pt.type_id = '14' 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-06-23' AND p.permit_issue_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.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2018-06-23' AND p.permit_issue_date <= '2018-07-22 23:59:59' AND pt.type_id = '27' AND p.permit_type_code != '' AND ( 1 )  
2830
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-06-23' AND p.permit_issue_date <= '2018-07-22 23:59:59' AND pt.type_id = '15' AND p.permit_type_code != '' AND ( 1 )  
0
City of Midlothian's
Growth Profile Report
06/23/18 to 07/22/18
  Permit Applications Permits Issued Projects Completed CO's Issued Total SF Avg. SF Total Value Avg. Value
NEW SINGLE FAMILY DETACHED 29 29 0 64 80,043.00 2,760.10 $5,603,010.00 $193,207.24
RESIDENTIAL ADDITION/ALTERATION 3 3 0 0 0.00 0.00 $19,000.00 $6,333.33
NEW COMMERCIAL BUILDING 1 1 0 0 0.00 0.00 $350,000.00 $350,000.00
DEMOLITION 2 2 0 0 2,830.00 1,415.00 $12,000.00 $6,000.00
CERTIFICATE OF OCCUPANCY 2 2 0 0 0.00 0.00 $0.00 $0.00
Totals 37 37 0 64 82,873.00 2,367.80 $5,984,010.00 $170,971.71
Average 7 0 13 16,574.60 473.56 $1,196,802.00 $34,194.34
MYGOV.US
Growth Profile Report
Printed 07/22/18 at 7:24 AM