You are using an UNSUPPORTED version of browser, please try to update your browser.

Title: Universal ETL Maintenance
Procurement
Information Technology and Telecommunications (DOITT)
Public Safety
Liro Gis Inc.
3 Aerial Way , Syosset, NY, 11791
Services (other than human services)
Sole Source
7/15/2024
Award
$1,156,111.00

PIN#85824S0002001

LiRo GIS, Inc. is currently the sole provider and maintainer of the Universal Extract Transform and Load (ETL) software code. As such, LiRo GIS, Inc. is the only vendor that can provide the required Universal ETL services and support to the agency. This application has been a key component of the successful processing of millions of e911 calls since it went into production and is part of the city’s Life Safety Operations. The design engineer and software developers that built the Universal ETL over a decade ago are the same employees who have maintained and enhanced the software over its lifetime.
Description

LiRo PSETL is used as a vital prerequisite of 9-1-1 call-taking and emergency dispatching, supporting the application that prepares map and address data for City Computer-Aided Dispatch (CAD) systems. Specifically, LiRo maintains and enhances the Extract, Transform, and Load (ETL) application that takes GIS data from the City’s CSCL database and prepares it for the CAD environments at NYPD and FDNY (EMS). LiRo built the Public Safety ETL application based on their extensive knowledge of NYC Street Centerline (CSCL), which they were also largely responsible for building over a decade ago. NYC CSCL is a multi-agency GIS that includes address point data, dispatch area shapes, and road-bed representation of NYC streets containing address ranges as well as other key information such as traffic directions, road types, and segment types. The Centerline Maintenance Group (CMG), comprised of NYC DCP GIS and DoITT GIS teams, enhance the GIS data as new requirements are identified by City agencies. The Public Safety ETL (PSETL) must be modified to reflect these changes, and Public Safety agencies also require enhancements of the PSETL itself as their requirements change.


Disclaimer: Pursuant to Section 103 (2) of the New York State General Municipal Law, New York City Charter Section 1066 and the City of New York Procurement Policy Board Rules, The City Record is the official paper of the City of New York. It is published each weekday except legal holidays. The print edition of The City Record is the official publication for the following notices: public hearings, meetings, court notices, property dispositions, procurements (solicitations and awards), agency public hearings, agency rules, and special materials which include changes in personnel. This electronic version of The City Record is offered solely for the convenience of readers.