CREATE TABLE table_17253 ("Station Number" CLOB, "District" CLOB, "Location" CLOB, "Type" CLOB, "Appliances" CLOB, "Registrations" CLOB)

what are all the type where location is st ives, cambridgeshire
SELECT "Type" FROM table_17253 WHERE "Location" = 'St Ives, Cambridgeshire'
SELECT "Type" FROM "table_17253" WHERE "Location" = 'St Ives, Cambridgeshire'