title: Set SRID in View From XY Data
body: <p>Trying to create a view that joins two tables, converts XY coord data into a sinlge spatial point, and sets the SRID value. I've got it all working except for the SRID command. I can't use pre assigned coordinates to do a transform as I'm generating multiple results. Any help would be appreciated!</p>
  
  <pre><code>CREATE  VIEW V_Station_Locations AS
        SELECT S.station_id, S.station_name, 
             ST_MakePoint(V.x_coord, V.y_coord)
             ST_SetSRID(ST_Point(x_coord, y_coord),28350)
   FROM  STATION S
   INNER JOIN SUBURB_VERTEX V ON (S.vertex_id=V.vertex_id)
  </code></pre>