Open


Government / Transparency / Open Data

Initiatives / Accomplishments in Place

An Open Government is one that is transparent, participatory, and collaborative. Sharing data and information, hearing and implementing ideas, and engaging in ongoing conversation with employees and the public not only increase our own accountability but also build trust with our citizens. Listening and building upon ideas shared by others enables us to become more innovative, effective, and efficient in the work we do. The City of Roseville is committed to fostering an environment that values openness. Currently Roseville showcases this in many ways. The best showcase of this is the City’s Open Data Portal (https://data.roseville.ca.us/).

The open data portal has greatly improved our internal efficiency when answering the scores of weekly inquiries from the public, media and special interest groups in addition to being more transparent.

Current List of Partial Datasets by Department (as of May 2016):

Police Department
  • Crime Data 
    Fire Department
  • Fire Occupancy Inspections
    Environmental Utilities
  • Water Consumption
    City Clerk
  • Annual Population Growth Rate
  • Finance
  • FY14 Adopted Budget
  • FY12 and FY13 Actual Budget
  • Operating Revenues for FY16 by Major Service Area
  • Operating and Capital Revenues for FY14 Adopted by Resource Category
  • Stale Dated Checks
  • Development Services
  • Planning Permits
  • Building Permits
  • Engineering Permits

    Information Technology (GIS)

  • City Boundary Map  

  • Roseville's open data budget app

    Much effort has been put into the creation of Roseville’s Open Data portal to ensure a more transparent, effective and accountable government. As the City matures, so will the Open Data portal. The City will continue to expand on datasets and uphold its commitment to providing citizens with data that is viewable, downloadable, searchable and indexable.

    Additionally, our portal is now CA SB 272 compliant: https://data.roseville.ca.us/City-Government/Catalog-of-Enterprise-Systems/rvhx-gmk2 


    Initiatives / Accomplishments in the Last Year

    In support of our Open Data Initiative, the City approved a Budget Application, an extension of the existing Open Data portal. The app is an interactive tool that will display the City’s budget data in a way that is easily interpreted by citizens. The goal is to provide updated budget information on a regular basis. This endeavor is the first for the City, to provide budget information to citizens with this level of frequency, and in an automated fashion. The app will significantly improve City services by providing citizens with current information that is useful and of interest.

    All budget data will be housed in the app rather than the City’s main Open Data portal. However, citizens will be able to access the budget app through the Open Data portal, so there will be one point of entry. In addition to the budget application, the City is also implementing ArcGIS data to the site. The site will be a map centric platform that will allow the general public to search for GIS data by topic or location. The data will be downloadable in multiple formats and users will have the option of viewing, filtering, and visualizing the data on an online interactive map.

    In addition to datasets, the GIS Open Data portal will help the City tell its story by providing access to Story Maps such as: the Historic Walking Tour, Aerial Swipe, Fitness Program, and the Safe Routes to School map.

    http://roseville.maps.arcgis.com/apps/MapTour/index.html?appid=538e911fca7844c8881a6a600a7ce767&webmap=05331f27dbcb4f9b98901bb1c1ea4364
     
    http://roseville.maps.arcgis.com/apps/StorytellingSwipe/index.html?appid=f87a996d17ac4849ac5ac80a5bc2d259
     
    http://roseville.maps.arcgis.com/apps/MapSeries/index.html?appid=629ca770fa304ec7846cfd6c5451227d
     
    http://roseville.maps.arcgis.com/apps/MapSeries/index.html?appid=53519621cac44463bfb8e69ceb4df399  

    Additionally, we also looked at other methods to improve transparency. City Council approved a new Requests for Proposal policy implemented on March 3, 2016. The policy provides a formal, uniform process for how RFP’s are issued, evaluated, and selected. As part of the policy development, staff surveyed neighboring agencies and solicited feedback through a vendor workshop and presentations to City staff. Included in the new policy are language clarifications and modifications to the RFP process pertaining to scope changes, score sheets, interview round criteria and ranking sheets, notices of intent to award, public information requests and a protest policy. 
      

    Current bids are available for citizens to view here: http://www.roseville.ca.us/business/bids_rfps_rfqs_and_rfis.asp
      

    Status of City Initiatives (next 12 - 18 months)

    I-3. Select the status for each city item/ area below:
    No Plans to Use/ Deploy
    No Plans, but Considering/ Under Discussion
    Definite Plans to Procure/ Deploy/ Upgrade in next 12-18 mos.
    In Use Now
    I-3.1 Big Data Infrastructure    X    
    I-3.2 Open Data Sets/
    Platform
           X
    I-3.3 Open Checkbook      X  
    I-3.4 Budget Dashboards published online      X  
    I-3.5 Participatory Budgeting    X    
    I-3.6 Department Performance Reports published online        X
    I-3.7 Council/ elected body
    Public Meetings Videoed,
    Archived, Searchable online
           X
    I-3.8 Other (describe below)        

    The City of Roseville is has several initiatives relating to Open Data and Open Budget. First, we are currently working with our Open Data Vendor on implementing their Budget App in our Open Data Portal. The app is an interactive tool that will display the City’s budget data in a way that is easily understood and interpreted by citizens. The IT department has partnered with Finance to start collecting data. The initial set up and launch is expected to be completed in 2016, with the goal of providing updated budget information on a regular basis. This endeavor is the first for the City, to provide budget information to citizens with this level of frequency, and in an automated fashion. The app will significantly improve City services by providing citizens with current information that is useful and of interest.

    The City continues to plan additional datasets to add to our Open Data Portal. New dataset Goals for FY16/17:
     
    Police Department
  • Police Beats
  • Traffic Accidents
    Finance
  • Business Licenses
    Fire Department
  • CUPA
    Finance
  • Operating Expenses
  • Operating Revenues                
  •  
    Development Services
  • Parcel Maps
  • Parcel Characteristics / Tax Rate Area
    Information Technology
  • ArcGIS Data
  • Enterprise Systems Catalog (SB272 mandate)
    Electric / EU
  • Utility Rates
  • Utility Consumption
    Human Resources
  • Salary Schedules                
  •  
    Parks, Recreation & Libraries
  • Park Locations / City Recreation Facilities
    Public Works
  • Transit Data
    Central Services
  • RFPs
  • City Contracts
  • Purchase Orders

  • We are also currently upgrading our Open Data Portal with the “new experience”, which is much more engaging and visually appealing to the community. This upgrade will provide the community more custom views, easier access to data, and greater capability to share data. The new experience is an exciting opportunity to enhance the City’s Open Data Portal.

    The City is currently evaluating RFPs for a new ERP system. Part of our overall plan is to implement a system that gives us the ability to provide expanded finance and budget information (Open Checkbook). Our current system makes the availability of data challenging and costly.

    Each year it more and more legislature is introduced that is requiring local governments to provide more data and become more transparent. The City of Roseville will continue to make effort possible to comply with these mandates.