129 3/20/15 3/25/15 While near real time data is Does all the data needs to be always preferable, SPD assumes managed at near real time and that the DAP may be updated on a updated in active datawarehouse or nightly batch basis; if in the there are specific / key topics needs future the DAP is used for to be at near real time? Kindly brief crime analysis, then real the high-level vision time updates from CAD and IAPro will be required. 130 3/20/15 3/25/15 Some of the address data has been Is Addressing cleansing required to cleansed and geocoded; some has clean the data or there is an already not. For consistency we would solution to manage? prefer to incorporate SPD’s address cleansing utilities. 131 3/20/15 3/25/15 Vendors are free to offer Does the solution need to include whatever products and only COTS (Commercial Off the architecture they believe will best Shelf) or can also include Open meet the City’s functional and source products? technical requirements. 132 3/20/15 3/25/15 Is there a need to embed the Yes; please see Technical interactive reports / dashboards in a Requirement sets UI1 and UI2. customer portal? 133 3/20/15 3/25/15 Are the users internal to SPD or Please see response to question includes external users. If external 47. users required, what would be the estimated count?
129 3/20/15 3/25/15 Does all the data needs to be managed at near real time and updated in active datawarehouse or there are specific / key topics needs to be at near real time? Kindly brief the high-level vision While near real time data is always preferable, SPD assumes that the DAP may be updated on a nightly batch basis; if in the future the DAP is used for crime analysis, then real time updates from CAD and IAPro will be required. 130 3/20/15 3/25/15 Is Addressing cleansing required to clean the data or there is an already solution to manage? Some of the address data has been cleansed and geocoded; some has not. For consistency we would prefer to incorporate SPD’s address cleansing utilities. 131 3/20/15 3/25/15 Does the solution need to include only COTS (Commercial Off the Shelf) or can also include Open source products? Vendors are free to offer whatever products and architecture they believe will best meet the City’s functional and technical requirements. 132 3/20/15 3/25/15 Is there a need to embed the interactive reports / dashboards in a customer portal? Yes; please see Technical Requirement sets UI1 and UI2. 133 3/20/15 3/25/15 Are the users internal to SPD or includes external users. If external users required, what would be the estimated count? Please see response to question 47.
RFPSPD3289A032515.docx