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-12-22' AND p.permit_issue_date <= '2019-01-21 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
36855
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-12-22' AND p.permit_issue_date <= '2019-01-21 23:59:59' AND pt.type_id = '14' AND p.permit_type_code != '' AND ( 1 )  
2121
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-12-22' AND p.permit_issue_date <= '2019-01-21 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.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2018-12-22' AND tap.permit_issue_date <= '2019-01-21 23:59:59' AND tap.permit_type_id = '27' AND ( 1 )  
1200
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2018-12-22' AND tap.permit_issue_date <= '2019-01-21 23:59:59' AND tap.permit_type_id = '15' AND ( 1 )  
0
City of Midlothian's
Growth Profile Report
12/22/18 to 01/21/19
  Permit Applications Permits Issued Projects Completed CO's Issued Total SF Avg. SF Total Value Avg. Value
NEW SINGLE FAMILY DETACHED 13 13 0 11 36,855.00 2,835.00 $2,579,850.00 $198,450.00
RESIDENTIAL ADDITION/ALTERATION 2 2 0 0 2,121.00 1,060.50 $135,292.00 $67,646.00
COMMERCIAL ADDITION / ALTERATION 3 3 0 0 0.00 0.00 $47,200.00 $15,733.33
DEMOLITION 1 1 1 0 1,200.00 1,200.00 $1,500.00 $1,500.00
CERTIFICATE OF OCCUPANCY 1 1 1 2 0.00 0.00 $0.00 $0.00
Totals 20 20 2 13 40,176.00 2,114.53 $2,763,842.00 $145,465.37
Average 4 0 3 8,035.20 422.91 $552,768.40 $29,093.07
MYGOV.US
Growth Profile Report
Printed 01/21/19 at 7:44 PM