CREATE
  TABLE "CRASH_INTERSECTION_ID"
  (
    "CRASH_NUMBER"     VARCHAR2(128 BYTE),
    "CRASH_INT_ID"     VARCHAR2(128 BYTE)
  );
INSERT INTO CRASH_INTERSECTION_ID
SELECT C.ACDYEAR_NUMBER AS CRASH_NUMBER, C.ACCIDENTINTERSECTIONID AS CRASH_INT_ID
FROM ACDL_CRASHES_LOC_02_09_OLD C;
