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-09-18' AND p.permit_issue_date <= '2018-10-17 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
84232
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-09-18' AND p.permit_issue_date <= '2018-10-17 23:59:59' AND pt.type_id = '14' 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-09-18' AND tap.permit_issue_date <= '2018-10-17 23:59:59' AND tap.permit_type_id = '14' 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-09-18' AND p.permit_issue_date <= '2018-10-17 23:59:59' AND pt.type_id = '10' 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-09-18' AND tap.permit_issue_date <= '2018-10-17 23:59:59' AND tap.permit_type_id = '15' AND ( 1 )  
0
City of Midlothian's
Growth Profile Report
09/18/18 to 10/17/18
  Permit Applications Permits Issued Projects Completed CO's Issued Total SF Avg. SF Total Value Avg. Value
NEW SINGLE FAMILY DETACHED 30 30 0 47 84,232.00 2,807.73 $5,896,240.00 $196,541.33
RESIDENTIAL ADDITION/ALTERATION 4 4 2 0 0.00 0.00 $68,488.00 $17,122.00
NEW COMMERCIAL BUILDING 2 2 0 0 0.00 0.00 $980,000.00 $490,000.00
CERTIFICATE OF OCCUPANCY 1 1 1 2 0.00 0.00 $0.00 $0.00
Totals 37 37 3 49 84,232.00 2,339.78 $6,944,728.00 $192,909.11
Average 9 1 12 21,058.00 584.94 $1,736,182.00 $48,227.28
MYGOV.US
Growth Profile Report
Printed 10/17/18 at 10:39 AM