Changeset 42a00c9 in osmose-backend


Ignore:
Timestamp:
Oct 18, 2012 10:19:44 PM (6 years ago)
Author:
Fred <fred.rodrigo@…>
Branches:
master
Children:
f75cb73
Parents:
dc6451c
git-author:
Frédéric Rodrigo <frodrigo@…> (07/10/2012 17:35:00)
git-committer:
Fred <fred.rodrigo@…> (18/10/2012 22:19:44)
Message:

Ensure datatype in Analyser_Merge

File:
1 edited

Legend:

Unmodified
Added
Removed
  • Analyser_Merge.py

    rdc6451c r42a00c9  
    212212( 
    213213    SELECT 
    214         id AS osm_id, 
    215         type AS osm_type, 
    216         tags, 
    217         ST_X(geom::geometry) AS lon, 
    218         ST_Y(geom::geometry) AS lat 
     214        id::bigint AS osm_id, 
     215        type::varchar AS osm_type, 
     216        tags::hstore, 
     217        ST_X(geom::geometry)::float AS lon, 
     218        ST_Y(geom::geometry)::float AS lat 
    219219    FROM 
    220220        match 
    221221) UNION ( 
    222222    SELECT 
    223         NULL AS osm_id, 
    224         NULL AS osm_type, 
    225         tags, 
    226         ST_X(geom::geometry) AS lon, 
    227         ST_Y(geom::geometry) AS lat 
     223        NULL::bigint AS osm_id, 
     224        NULL::varchar AS osm_type, 
     225        tags::hstore, 
     226        ST_X(geom::geometry)::float AS lon, 
     227        ST_Y(geom::geometry)::float AS lat 
    228228    FROM 
    229229        missing_official 
    230230) UNION ( 
    231231    SELECT 
    232         id AS osm_id, 
    233         type AS osm_type, 
    234         tags, 
    235         ST_X(geom::geometry) AS lon, 
    236         ST_Y(geom::geometry) AS lat 
     232        id::bigint AS osm_id, 
     233        type::varchar AS osm_type, 
     234        tags::hstore, 
     235        ST_X(geom::geometry)::float AS lon, 
     236        ST_Y(geom::geometry)::float AS lat 
    237237    FROM 
    238238        missing_osm 
Note: See TracChangeset for help on using the changeset viewer.