Laserfiche WebLink
<br />/' <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br /> <br />~ <br /> <br />2.1.3 Data Model Review and Acceptance <br /> <br />Intergraph will prepare the data model for review with the City. Intergraph will meet <br />with the City for an Interwise review session. Intergraph will revise the Data Model <br />based on the discussion and provide a final Data Model to the City. The Data Model will <br />include a finalized Entity-Relationship Diagram for the Data Model. <br /> <br />The City shall approve the Data Model. <br /> <br />Deliverable: Data Model as a pdf file <br /> <br />Exit Criteria: City and Intergraph signoff of the Data Model <br /> <br />2.1.4 Migration of Data into Oracle Repository <br /> <br />This task is the migration of City's street centerline data into the Oracle repository. <br /> <br />· Build the data model in Oracle according to the agreed-upon Data Model <br />document <br /> <br />· Migrate new centerline network into Oracle Repository <br /> <br />. Migrate Street Master table into Oracle Repository <br /> <br />. Populate new data sets <br /> <br />Using GeoMedia Transportation Manager, futergraph will populate new data sets, <br />adding an intersection markers table for street centerline <br /> <br />futergraph will populate the street alias table, to map each street name inside of <br />MicroPaver PMS to a respective street name inside of the master street table and <br />provide the table to the City. This will be an Access database - attributes only <br /> <br />City shall have 10 business days to QAJQC the street alias table (attributes only) <br /> <br />. QNQC street centerline network to validate the data for route consistency. <br /> <br />Deliverable: Street Centerline datasets <br /> <br />Exit Criteria: City and Intergraph completion of dataset QNQC <br /> <br />2.1.5 Develop Workflows <br /> <br />The activities in this task are for developing workflows and confirming that they are <br />appropriate and correct for maintaining the new data model. The City and Consultant <br />both have tasks in this phase, as follows: <br /> <br /> <br />City of Santa Ana <br />Oracle Locator Geo.spatial Street Centerline Data Model with LRS <br /> <br />Page9of39 <br /> <br />~(JJ <br />