Surveys & Statistics - Step 1

Create custom reports using data from annual local government surveys.

CivicInfo BC thanks and acknowledges our partners who help to make this service possible, including the UBCM, LGMA BC, BCRPA, MISA BC, and the Ministry of Community, Sport and Cultural Development.

Step 1
Select your surveys 		Step 2
Customize your information		 Step 3
Create your report
Select the survey year(s) you want to view.
<% While Not rs.EOF %> <% if yearcount = 4 then %> <% End IF %>     " <% if InStr(1, getyears, rs("year")) then %> checked <%End IF%> > <%=rs("year")%>
<% yearcount = yearcount + 1 RS.MoveNext Wend %> 		  
<% 'get all the categories to order the survyes and stats in a nice select list Dim getSQL, RS Dim innerSQL, innerRS if Session("survey-access") = "true" then getSQL = "SELECT distinct Category FROM ubcm_survey_admin WHERE isLive='YES'"&sqlyears&" order by category asc;" else getSQL = "SELECT distinct Category FROM ubcm_survey_admin WHERE ispublic='YES' AND isLive='YES'"&sqlyears&" order by category asc;" End IF Set RS = mycivConn.execute(getSQL) %>
Select the surveys you wish to view. (Limit: 5).
Surveys

Selected Surveys