After importing shapefile into postgis
I got geom data as MultiPoligon
Like: 0106000020AD1000000100000001030000000100000013000000C036FFFFF506254140DEFFDF4510284180ADBD3F5707254100A320E0051028413B503BA26F07254165D13CC4F70F284116080C5A89072541BD431F44EC0F2841C036FF1FA407254180909D7FE30F2841E0132426090725410026E1AA270F284160AB92984D06254140B378E9BD0F28414F4FEA235C06254145EBF842CE0F284140FB1F206906254140DEFFDFDF0F2841E0E89CBFA2062541C019DF9F351028410B66D362A906254188E8BCA83D102841C631D04CB1062541EEF9A6704410284146DEDC41BA062541338773C4491028412FF663FEC30625415A76F07B4D1028411AEBEE38CE062541C2A2127B4F102841556050A4D80625410975C9B24F1028419F7BEAF1E2062541B68D70214E1028413E1200D4EC0625410029DCD24A102841C036FFFFF506254140DEFFDF45102841
I want to get point and plogygon so that insert into fusiontable through script. Please suggest.
When I run the query like
SELECT the_geom FROM (SELECT (ST_Dump(geom)).geom As the_geom FROM parcels LIMIT 1) AS a;
and got out in polygon following result:
689018.999994002282619,788514.937498994288035 689067.624494001269341,788482.937748998403549 689079.816858775331639,788475.883276504115202 689092.675873043714091,788470.133051029988565 689106.062494002282619,788465.749248996376991 689028.574494000524282,788371.833748996374197 688934.797993998974562,788446.955998994410038 688942.070147016900592,788455.130805351422168 688948.562743999180384,788463.937498994171619 688977.374244000762701,788506.81224899739027 688980.693019093363546,788510.829566256143153 688984.650025897426531,788514.220023928093724 688989.128638216061518,788516.883693909621798 688993.996856396901421,788518.742068956838921 688999.111197802470997,788519.740376554662362 689004.320925722480752,788519.849193246336654 689009.472492087516002,788519.065311840502545 689014.414063043775968,788517.411835938692093 689018.999994002282619,788514.937498994288035
While testing on fusiontable it show no result. Please advise me or provide me help so that I can implement it successfully.
Apart from this I also need help for get point.
أكثر...
I got geom data as MultiPoligon
Like: 0106000020AD1000000100000001030000000100000013000000C036FFFFF506254140DEFFDF4510284180ADBD3F5707254100A320E0051028413B503BA26F07254165D13CC4F70F284116080C5A89072541BD431F44EC0F2841C036FF1FA407254180909D7FE30F2841E0132426090725410026E1AA270F284160AB92984D06254140B378E9BD0F28414F4FEA235C06254145EBF842CE0F284140FB1F206906254140DEFFDFDF0F2841E0E89CBFA2062541C019DF9F351028410B66D362A906254188E8BCA83D102841C631D04CB1062541EEF9A6704410284146DEDC41BA062541338773C4491028412FF663FEC30625415A76F07B4D1028411AEBEE38CE062541C2A2127B4F102841556050A4D80625410975C9B24F1028419F7BEAF1E2062541B68D70214E1028413E1200D4EC0625410029DCD24A102841C036FFFFF506254140DEFFDF45102841
I want to get point and plogygon so that insert into fusiontable through script. Please suggest.
When I run the query like
SELECT the_geom FROM (SELECT (ST_Dump(geom)).geom As the_geom FROM parcels LIMIT 1) AS a;
and got out in polygon following result:
689018.999994002282619,788514.937498994288035 689067.624494001269341,788482.937748998403549 689079.816858775331639,788475.883276504115202 689092.675873043714091,788470.133051029988565 689106.062494002282619,788465.749248996376991 689028.574494000524282,788371.833748996374197 688934.797993998974562,788446.955998994410038 688942.070147016900592,788455.130805351422168 688948.562743999180384,788463.937498994171619 688977.374244000762701,788506.81224899739027 688980.693019093363546,788510.829566256143153 688984.650025897426531,788514.220023928093724 688989.128638216061518,788516.883693909621798 688993.996856396901421,788518.742068956838921 688999.111197802470997,788519.740376554662362 689004.320925722480752,788519.849193246336654 689009.472492087516002,788519.065311840502545 689014.414063043775968,788517.411835938692093 689018.999994002282619,788514.937498994288035
While testing on fusiontable it show no result. Please advise me or provide me help so that I can implement it successfully.
Apart from this I also need help for get point.
أكثر...