Permit Applications Opened By Type Year to Date
Query Details
CivicData.com's SQL Search API lets you execute SQL statements against datasets
The chart above was generated by querying the Building Permit dataset in CivicData.com. To see the raw JSON resonse for the SQL query below, click here.
SELECT substring("DATE OPENED" from 1 for 4) as Year,
substring("DATE OPENED" from 6 for 2) as Month,
"RECORD TYPE TYPE" as RecordType,
count(*) as Count
from "92c62bd0-64ea-48ed-b28b-6976fba03cde"
where "DATE OPENED" >= '2014-01-01'
and "DATE OPENED" <= '2014-12-31'
group by Year, Month, RecordType
order by Year, Month, RecordType
Permit Applications Opened By Year
Query Details
The chart above was generated by querying the Building Permit dataset in CivicData.com. To see the raw JSON resonse for the SQL query below, click here.
SELECT substring("DATE OPENED" from 1 for 4) as Year,
substring("DATE OPENED" from 6 for 2) as Month,
count(*) as Count
from "92c62bd0-64ea-48ed-b28b-6976fba03cde"
group by Year, Month
order by Year, Month
Permits Applications Opened by Type
Query Details
The chart above was generated by querying the Building Permit dataset in CivicData.com. To see the raw JSON resonse for the SQL query below, click here.
SELECT "RECORD TYPE SUBTYPE" as RecordType,
count(*) as Count
from "92c62bd0-64ea-48ed-b28b-6976fba03cde"
group by RecordType
order by Count desc
Percentage of Applications Filed Online - Based on eligible permit types
Query Details
The chart above was generated by querying the Building Permit dataset in CivicData.com. To see the raw JSON resonse for the SQL query below, click here.
SELECT "CREATED ONLINE", count(*) as COUNT
FROM "92c62bd0-64ea-48ed-b28b-6976fba03cde"
WHERE "CREATED ONLINE" != ''
AND "PERMIT TYPE" IN
('Building/Trade Permits/Residential/Electrical',
'Building/Trade Permits/Residential/Mechanical',
'Building/Trade Permits/Residential/Plumbing',
'Residential Irrigation',
'Residential Electrical',
'Residential Mechanical',
'Residential Plumbing',
'Residential Solar Water Heater',
'LD - ROW Utility-Internet',
'Lien/Permit/Code Case Research Request')
GROUP BY "CREATED ONLINE" ORDER BY COUNT DESC
Online Versus Paper Applications By Year - Based on eligible permit types
Query Details
The chart above was generated by querying the Building Permit dataset in CivicData.com. To see the raw JSON resonse for the SQL query below, click here.
SELECT substring("DATE OPENED" from 1 for 4) as Year,
"CREATED ONLINE",
count(*) as Count
from "92c62bd0-64ea-48ed-b28b-6976fba03cde"
WHERE "CREATED ONLINE" != ''
AND "PERMIT TYPE" IN
('Building/Trade Permits/Residential/Electrical',
'Building/Trade Permits/Residential/Mechanical',
'Building/Trade Permits/Residential/Plumbing',
'Residential Irrigation',
'Residential Electrical',
'Residential Mechanical',
'Residential Plumbing',
'Residential Solar Water Heater',
'LD - ROW Utility-Internet',
'Lien/Permit/Code Case Research Request')
and substring("DATE OPENED" from 1 for 4) >= '2009'
group by Year, "CREATED ONLINE"
order by Year, "CREATED ONLINE"
Percentage of Applications Filed Online - Based on all permits
Query Details
The chart above was generated by querying the Building Permit dataset in CivicData.com. To see the raw JSON resonse for the SQL query below, click here.
SELECT "CREATED ONLINE", count(*) as COUNT
FROM "92c62bd0-64ea-48ed-b28b-6976fba03cde"
WHERE "CREATED ONLINE" != ''
and substring("DATE OPENED" from 1 for 4) >= '2009'
GROUP BY "CREATED ONLINE" ORDER BY COUNT DESC
Online Versus Paper Applications By Year - Based on all permits
Query Details
The chart above was generated by querying the Building Permit dataset in CivicData.com. To see the raw JSON resonse for the SQL query below, click here.
SELECT substring("DATE OPENED" from 1 for 4) as Year,
"CREATED ONLINE",
count(*) as Count
from "92c62bd0-64ea-48ed-b28b-6976fba03cde"
WHERE "CREATED ONLINE" != ''
and substring("DATE OPENED" from 1 for 4) >= '2009'
group by Year, "CREATED ONLINE"
order by Year, "CREATED ONLINE"