parenthesis enclosed NYC open data lat/lon to the_geom

command.sql

--replace table_1 with your table name
--replace both instances of column_name with your column, often it is called 'shape'
UPDATE 
    table_1 
SET 
    the_geom = ST_SetSRID(
                ST_MakePoint( 
                 (string_to_array(
                  replace(
                   replace(column_name,'(',''),
                   ')',''
                  ),
                  ','
                 ))[2]::float, 
                 (string_to_array(replace(replace(column_name,'(',''),')',''),','))[1]::float),4326)