rtree/insertZipcode.c

static RDM_RETCODE insertZipCode (RDM_DB db)
{
    RDM_RETCODE rc = sOKAY;
    POINTSOFINTEREST poi = {0};

    /* Set the zip, city, and state column values */
    poi.zip = 83686;
    strcpy (poi.city, "Nampa");
    strcpy (poi.state, "ID");

    /* Set the location values (xmin, ymin), (xmax, ymax) */
    poi.location[0] = -116.577610; /* Longitude is the 'x' value */
    poi.location[1] = 43.529812;   /* Latitude is the 'y' value */
    poi.location[2] = -116.577610; /* Longitude is the 'x' value */
    poi.location[3] = 43.529812;   /* Latitude is the 'y' value */

    /* Start an update transaction */
    rc = rdm_dbStartUpdate (db, RDM_LOCK_ALL, 0, NULL, 0, NULL);
    if (rc == sOKAY)
    {
        /* Insert the row */
        rc = rdm_dbInsertRow (
            db, TABLE_POINTSOFINTEREST, &poi, sizeof (POINTSOFINTEREST), NULL);

        if (rc == sOKAY)
        {
            /* Commit the successful transaction */
            rc = rdm_dbEnd (db);
        }
        else
        {
            /* Rollback the failed transaction */
            (void) rdm_dbEndRollback (db);
        }
    }

    return rc;
}