System.Data.SqlClient.SqlException (0x80131904): Column name or number of supplied values does not match table definition. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Modules.dtlRadarSummary.View.loadGrids() ClientConnectionId:8fd09cf9-0ac9-450f-9e39-4c32b81e2eaf Error Number:213,State:7,Class:16 Radar Speed Data Summary

What am I seeing?

This is actual radar speed data, collected from random school zone signs around New Zealand.

Vehicle speed statistics for a calendar month are shown in two tables: Site Statistics  and Top-20 Speeds. They summarise the radar speed information collected from the sites listed.

As a logged-in customer, you would see information pertaining to your speed data collection sites.

What is it telling me?

  • The compliance rate is the percentage of vehicles respecting the posted speed limit. You can see at a glance which sites had the best/worst compliance rate for the selected month.

  • The 95th Percentile kph tells you the speed 95% of drivers were travelling at or below.

  • How many vehicles were counted during the month?

Top-20 Speeds

This table lists the top twenty speeds for the month:
  • ranked by speed in excess of the posted limit 
  • across all sites 
  • with time and location displayed 

What Else?

The Radar Speed Data page allows you to select a specific site, and view much more detailed information about it.

Exporting Data

You can download an export of the information in one of both of the tables:

  • Export to Excel downloads an Excel spreadsheet with two (unformatted) sheets: one for each table

  • Statistics to File downloads a standard file containing the contents of the Site Statistics table. Specify whether you want csv (comma-separated-value) format, or txt (tab-delimited); either format will load into most spreadsheet programs.

  • Top 20 to File downloads a standard file containing the contents of the Top 20 - Speeds above Posted Limit table
     
Site Statistics
Top 20 - Speeds above Posted Limit