Changes between Initial Version and Version 1 of Ticket #4183, comment 1


Ignore:
Timestamp:
Sep 19, 2018, 9:50:56 AM (3 years ago)
Author:
Algunenano
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #4183, comment 1

    initial v1  
    33With clipping on you get the whole extent as the geometry output:
    44{{{
    5 SELECT St_AsText(ST_AsMVTGeom(
    6  ST_Simplify(ST_RemoveRepeatedPoints(the_geom, 19.109257221221924), 19.109257221221924, true),
     5 SELECT St_AsText(ST_AsMVTGeom(
     6 'SRID=3857;MULTIPOLYGON(((-8231365.02893734 4980355.83678553,-8231366.94866817 4980350.2976052,-8231368.82883367 4980344.52250402,-8231370.96255986 4980333.47364302,-8231372.09200747 4980327.69798564,-8231372.84505222 4980323.68014243,-8231374.2255656 4980316.77455645,-8231375.10554947 4980309.86865218,-8231380.6311111 4980275.9676398,-8231394.82332406 4980186.31880185,-8231394.8569833 4980133.57928934,-8231367.43081065 4979982.17443372,-8231372.85765532 4979985.17751813,-8231395.25669799 4980132.93828551,-8231396.69199339 4980227.59327083,-8231377.30092207 4980340.77515211,-8231368.35061694 4980357.62467295,-8231365.02893734 4980355.83678553)))'::geometry,
    77 'SRID=3857;POLYGON((-8238077.16046316 4980025.2668358,-8238077.16046316 4970241.3272153,-8228293.22084265 4970241.3272153,-8228293.22084265 4980025.2668358,-8238077.16046316 4980025.2668358))'::geometry,
    88 256,
    99 1,
    1010 true
    11  )) as the_geom_webmercator
    12  FROM (SELECT 7278 AS cartodb_id, 5 as numfloors, 'SRID=3857;MULTIPOLYGON(((-8231365.02893734 4980355.83678553,-8231366.94866817 4980350.2976052,-8231368.82883367 4980344.52250402,-8231370.96255986 4980333.47364302,-8231372.09200747 4980327.69798564,-8231372.84505222 4980323.68014243,-8231374.2255656 4980316.77455645,-8231375.10554947 4980309.86865218,-8231380.6311111 4980275.9676398,-8231394.82332406 4980186.31880185,-8231394.8569833 4980133.57928934,-8231367.43081065 4979982.17443372,-8231372.85765532 4979985.17751813,-8231395.25669799 4980132.93828551,-8231396.69199339 4980227.59327083,-8231377.30092207 4980340.77515211,-8231368.35061694 4980357.62467295,-8231365.02893734 4980355.83678553)))'::geometry as the_geom) AS cdbq
    13                     the_geom_webmercator                     
    14 -------------------------------------------------------------
    15  MULTIPOLYGON(((175 -1,257 -1,257 257,-1 257,-1 -1,175 -1)))
     11 )) as the_geom_webmercator;
    1612}}}
    1713
     
    1915{{{
    2016SELECT St_AsText(ST_AsMVTGeom(
    21  ST_Simplify(ST_RemoveRepeatedPoints(the_geom, 19.109257221221924), 19.109257221221924, true),
     17 'SRID=3857;MULTIPOLYGON(((-8231365.02893734 4980355.83678553,-8231366.94866817 4980350.2976052,-8231368.82883367 4980344.52250402,-8231370.96255986 4980333.47364302,-8231372.09200747 4980327.69798564,-8231372.84505222 4980323.68014243,-8231374.2255656 4980316.77455645,-8231375.10554947 4980309.86865218,-8231380.6311111 4980275.9676398,-8231394.82332406 4980186.31880185,-8231394.8569833 4980133.57928934,-8231367.43081065 4979982.17443372,-8231372.85765532 4979985.17751813,-8231395.25669799 4980132.93828551,-8231396.69199339 4980227.59327083,-8231377.30092207 4980340.77515211,-8231368.35061694 4980357.62467295,-8231365.02893734 4980355.83678553)))'::geometry,
    2218 'SRID=3857;POLYGON((-8238077.16046316 4980025.2668358,-8238077.16046316 4970241.3272153,-8228293.22084265 4970241.3272153,-8228293.22084265 4980025.2668358,-8238077.16046316 4980025.2668358))'::geometry,
    2319 256,
    2420 1,
    2521 false
    26  )) as the_geom_webmercator
    27  FROM (SELECT 7278 AS cartodb_id, 5 as numfloors, 'SRID=3857;MULTIPOLYGON(((-8231365.02893734 4980355.83678553,-8231366.94866817 4980350.2976052,-8231368.82883367 4980344.52250402,-8231370.96255986 4980333.47364302,-8231372.09200747 4980327.69798564,-8231372.84505222 4980323.68014243,-8231374.2255656 4980316.77455645,-8231375.10554947 4980309.86865218,-8231380.6311111 4980275.9676398,-8231394.82332406 4980186.31880185,-8231394.8569833 4980133.57928934,-8231367.43081065 4979982.17443372,-8231372.85765532 4979985.17751813,-8231395.25669799 4980132.93828551,-8231396.69199339 4980227.59327083,-8231377.30092207 4980340.77515211,-8231368.35061694 4980357.62467295,-8231365.02893734 4980355.83678553)))'::geometry as the_geom) AS cdbq
    28 ;
     22 )) as the_geom_webmercator;
    2923                                                                                     the_geom_webmercator                                 
    3024                                                   
     
    3327 MULTIPOLYGON(((175.090909090909 -4.45454545454545,175 -5,176 -9,175.090909090909 -4.45454545454545)),((175.090909090909 -4.45454545454545,
    3428176 1,175 -4,175.090909090909 -4.45454545454545)))
    35 (1 row)
    3629}}}