Permits Issued - Construction Cost by Neighborhood by Month

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 "Neighborhood" as Neighborhood, 
      substring("Issued" from 6 for 2) as Month, 
      SUM(cast("Construction Cost" as double precision)) as TotalConstructionCost 
    FROM "e741edf8-04ad-450d-bc62-6684a7a427dd" 
    WHERE
      "Issued" >= '2014-01-01' 
      and "Issued" <= '2014-12-31' 
      and "Neighborhood" != '' 
    GROUP BY 
      Neighborhood, Month 
    ORDER BY
      Neighborhood, Month, TotalConstructionCost desc

Permits Issued by Year and Month

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("Issued" from 1 for 4) as Year, 
      substring("Issued" from 6 for 2) as Month, 
      count(*) as Count 
    FROM "e741edf8-04ad-450d-bc62-6684a7a427dd" 
    GROUP BY 
      Year, Month 
    ORDER BY 
      Year, Month

Permits Issued 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 "Type" as RecordType, 
      count(*) as Count 
    FROM "e741edf8-04ad-450d-bc62-6684a7a427dd" 
    GROUP BY 
      RecordType 
    ORDER BY Count desc

Permits Issued - Percentage of Applications Filed Online

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 "Applied Online", 
      count(*) as COUNT 
    FROM "e741edf8-04ad-450d-bc62-6684a7a427dd" 
    WHERE 
      "Applied Online" != '' 
      and substring("Issued" from 1 for 4) >= '2011' 
    GROUP BY 
      "Applied Online" 
    ORDER BY 
      COUNT DESC

Permits Issued - Online Vs. Paper Applications 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("Issued" from 1 for 4) as Year, 
      "Applied Online", 
      count(*) as Count 
    FROM "e741edf8-04ad-450d-bc62-6684a7a427dd" 
    WHERE 
      "Applied Online" != '' 
      and "Issued" >= '2011-06-01' 
    GROUP BY 
      Year, "Applied Online" 
    ORDER BY 
      Year, "Applied Online"