SHARE
TWEET

Untitled

a guest Nov 15th, 2019 96 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select * ,st_area(geom) from ST_dump(ST_GeomFromGeoJSON('{"type":"MultiPolygon","coordinates":[[[[26989.4997181935 ,3656.55484408608] ,[26985.1384667244,3660.59680565028] ,[26985.3975575702 ,3660.88430810321] ,[26989.5451317466,3665.44472257475]  ,[26994.8013215505,3671.43047649521]  ,[27000.9424147095 ,3678.37939461626]  ,[27004.9314354664,3682.68521336282],[27006.0940630988,3683.84889753323],[27006.8847044156,3684.37110829105],[27007.6864830472,3684.75998857335],[27008.3478997365,3684.95998428666],[27008.7555191044,3685.03037549022],[27008.7711971391,3684.74881067589],[27010.1222821198,3684.70337049968],[27010.1144431025,3685.00839904861],[27011.1334899337,3684.92236562669],[27011.8861881188,3684.71806759105],[27013.5167895152,3683.67400751935],[27015.8619426019,3681.63409373778],[27020.5568276256,3677.42357651909],[27025.8330995493,3672.63006246698],[27033.3180455839,3665.95809830809],[27036.8209010995,3662.79383017626],[27037.3997840896,3662.32924937221],[27038.091927693,3661.9023377001],[27038.834410053,3661.42520079013],[27040.1054366464,3660.94806388017],[27041.1876976692,3660.6090457637],[27041.8420856164,3660.44581475839],[27042.5298696204,3660.31141297609],[27043.7462614089,3660.17536271645],[27045.0307481067,3660.2195557483],[27046.6607171705,3660.44052253555],[27047.8694161091,3660.73526947023],[27049.0123842359,3661.16112774497],[27050.2437200449,3661.75331941872],[27051.1118554657,3662.27480159021],[27051.9818529311,3662.95858347913],[27052.796837463,3663.5507743388],[27053.4169364617,3664.25786936053],[27054.711311697,3665.73934821403],[27057.4728637239,3668.83704798165],[27061.1041208816,3672.87540473925],[27062.2406036277,3674.13102103126],[27063.2084188107,3675.10937401725],[27063.9068571419,3675.62156203281],[27065.0452972591,3676.16714697823],[27065.5741814905,3676.34602752843],[27066.4078436648,3676.48018753403],[27067.4387141618,3676.44441191243],[27068.364754087,3676.27493378854],[27069.2163440018,3676.06922091162],[27070.1396448785,3675.65779597181],[27070.9374515719,3675.06749129583],[27072.0686659391,3674.05233208471],[27080.0927596935,3666.87397033951],[27088.9438522987,3658.84404508865],[27091.6006894929,3656.44810870487],[27084.2651245431,3648.36374608139],[27075.0415766511,3638.24168595791],[27067.6854587777,3630.12608509641],[27063.1620977049,3625.09241318659],[27062.2223772929,3624.09831244146],[27061.3517190121,3623.55984357997],[27060.2737909292,3623.06279320738],[27058.919489209,3622.80045710722],[27051.297965899,3622.35845085172],[27035.5334084393,3621.39160136287],[27032.8524131698,3621.19829132661],[27031.7053812516,3621.1844946655],[27030.321961725,3621.37509209531],[27028.895591038,3621.72626498478],[27027.9508512275,3622.16985192106],[27026.8393948699,3622.89068099777],[27025.4315493029,3624.05509619668],[27022.2781226711,3626.97476203946],[27015.121856115,3633.40883829994],[27011.2279871108,3636.98699228375],[27003.0104822067,3644.38504680778],[26996.9977493815,3649.8191567127],[26989.4997181935,3656.55484408608]],[[26997.6338123668,3657.43026185824],[27001.5387159873,3661.75913581659],[27002.2357699094,3662.53187155207],[27003.3914493549,3661.48937946428],[27000.816049302,3658.63435836645],[27000.1552590239,3657.8805259029],[26998.8265103682,3656.3646835763],[27005.0964844342,3650.61744778216],[27006.4510865568,3652.13553704037],[27007.6368266137,3653.46438424445],[27009.0505292828,3652.29707345882],[27009.8542230295,3651.61136324159],[27007.3153139199,3648.5794899447],[27018.0832095056,3638.87613283193],[27020.7961084771,3641.78731384934],[27021.6825634756,3641.03503579404],[27021.396589356,3640.72230740062],[27022.7348002273,3639.43919508796],[27022.9819118173,3639.70942517261],[27023.7262445509,3639.03583488575],[27023.0845296113,3638.32062345939],[27021.1460900018,3636.16017171918],[27028.9084900504,3629.17605385152],[27030.8562593077,3631.34662007297],[27031.5818680281,3632.15522806005],[27032.6989557038,3631.15280343419],[27031.9590480953,3630.32826097047],[27030.0070200009,3628.15294876191],[27030.6264522683,3627.70739357188],[27031.3573181193,3627.43510905283],[27032.249287239,3627.21232433142],[27036.6048723734,3627.52186553666],[27052.2205041867,3628.54018170255],[27054.0539452941,3630.54520143682],[27049.8270283154,3634.3500418752],[27048.7935044467,3635.28036376918],[27050.2257512897,3636.85902676647],[27049.2638203737,3637.73174153836],[27049.2638125077,3637.73174863391],[27050.3630197701,3638.95030103764],[27051.8891032386,3637.573682333],[27051.2607359217,3636.87709077054],[27052.66496491,3635.61039210641],[27053.2933322268,3636.30698366888],[27054.6717303644,3635.06358597942],[27057.534816872,3632.50571226116],[27063.1425897157,3638.78921815965],[27063.3284550105,3639.0042522838],[27063.4458754969,3639.30725165185],[27063.4849868159,3639.56138941217],[27063.4458754969,3639.80574229467],[27063.3754693541,3640.00366409358],[27064.6516636173,3641.37198642341],[27064.2151801434,3641.78790202536],[27063.7903618261,3642.18633790558],[27063.7197676445,3642.25001808617],[27064.4177423651,3643.02377459475],[27064.4178524348,3643.02389661511],[27068.0946602459,3639.62249229205],[27071.7418163811,3643.57795798414],[27080.8509279882,3653.69347609576],[27078.3447849816,3655.87909109245],[27077.5943281556,3656.53356679035],[27077.6500047531,3656.59542661355],[27076.7307471173,3657.38257022961],[27077.9147329359,3658.69510592196],[27078.285999495,3658.36020124586],[27078.6572660541,3658.02529656977],[27078.9443702043,3657.76488542844],[27079.2532227146,3657.4925680648],[27080.490709463,3658.87867537405],[27080.1921049725,3659.14908703785],[27079.9047867108,3659.40826532092],[27079.5335201517,3659.74316999702],[27079.1622535926,3660.07807467312],[27078.4285295865,3660.73993767847],[27079.4306369648,3661.85084769191],[27079.4268297626,3661.85428201634],[27079.5227330881,3661.96059793312],[27080.5826138905,3660.99505089969],[27084.3603351987,3657.55356239082],[27085.9800840596,3659.33388753529],[27074.9612126856,3669.17834686426],[27074.0231008623,3668.17358147994],[27073.2908498415,3667.38930346515],[27072.6749966127,3667.94483996859],[27073.1459963072,3668.4669779033],[27071.8788219956,3669.68254098629],[27072.1445097392,3669.99958806767],[27067.3459316262,3674.36808307134],[27062.9462255123,3669.35118520495],[27063.2360403206,3669.09107068656],[27062.3500905911,3668.09570799968],[27061.3264455225,3668.95162442129],[27060.2832895672,3667.70404764573],[27061.3739561061,3666.79209150998],[27060.5900337679,3665.85454876007],[27058.6269343477,3667.59547930603],[27053.6626349215,3662.05965453948],[27054.9640140303,3660.88068138554],[27056.723972363,3662.69745080955],[27057.5758941818,3661.87892506535],[27058.8708331498,3660.71081254622],[27056.199897966,3657.74988370249],[27055.0923345133,3658.74897228253],[27054.8110970506,3659.00266532066],[27054.5006635937,3659.28269489454],[27052.7087485707,3657.29622479633],[27052.4241846585,3657.52660437199],[27052.2383770501,3657.61943066431],[27051.933101091,3657.65920695479],[27051.6410929836,3657.61943066431],[27051.2959846267,3657.36747230388],[27050.539428655,3656.50552412521],[27050.2572911376,3656.11464304129],[27049.4434126422,3655.21239864135],[27051.8188471631,3653.06961440932],[27051.0461977311,3652.12162591258],[27048.0121348271,3655.02050680745],[27043.831999201,3650.36585825481],[27044.1887413405,3650.05513645924],[27043.1271273748,3648.83628910816],[27041.2347642786,3650.54331397808],[27041.6903773562,3651.06114100307],[27042.0068156165,3651.48723610662],[27042.0893647278,3651.78962560146],[27042.1306392835,3652.0920150963],[27041.9655410607,3652.44938286868],[27041.2363860869,3653.05416185836],[27040.8924314562,3653.27408393702],[27040.5622638539,3653.30157307573],[27040.1185839712,3653.15386299244],[27036.4513258389,3649.0884366027],[27035.2639054547,3650.15956091862],[27036.1214276094,3651.10102752337],[27042.9598395695,3658.60886444067],[27042.2383988644,3658.71182630028],[27041.3366292612,3658.86626908966],[27040.357540098,3659.09794752651],[27039.5974813171,3659.30387124567],[27038.6055472648,3659.74147340169],[27037.4460874993,3660.34640283233],[27036.4283802603,3660.95131801019],[27035.3770594478,3661.78967896578],[27034.1476617633,3662.92607915806],[27031.5607928404,3665.24748141711],[27029.1420751935,3662.47965455034],[27031.0674323258,3660.68909593197],[27030.9641578026,3660.57358474409],[27030.1602972633,3659.67447736568],[27030.0452660669,3659.77824239542],[27029.011409293,3658.63213583294],[27026.1602389824,3661.20406224511],[27027.1346013271,3662.28421484049],[27027.7094900988,3662.92152148728],[27025.8495468897,3664.59930167702],[27026.0099400233,3664.81764774417],[27026.1121601668,3665.03652048207],[27026.1413782834,3665.37212116152],[27026.0829420501,3665.62017812705],[27025.9766933129,3665.93351448724],[27024.5657144573,3667.20630193605],[27024.7839982132,3667.4482855951],[27023.8992144998,3668.24641350526],[27022.8037656614,3667.03202759198],[27021.8488055276,3667.85901263714],[27024.9278255437,3671.25492965182],[27016.4144165225,3678.95291071161],[27013.7667846013,3676.15210298335],[27012.9166447798,3676.89030987097],[27012.8059160641,3676.73760315519],[27010.8762971806,3678.47823497699],[27011.1011147892,3678.71393204716],[27011.2637613438,3678.91972838566],[27011.3721827657,3679.15801841081],[27011.3830277922,3679.52629215139],[27011.2994711537,3679.86439436558],[27009.758114316,3681.25479056422],[27009.6278890951,3681.11042629247],[27008.8017362955,3681.85566560625],[27004.9464825744,3677.58183222696],[27004.3532585337,3678.11695584721],[27000.0229472982,3673.31648614017],[26999.5440649462,3673.74846670787],[26999.0651825942,3674.18044727556],[26996.9745788907,3671.86285872299],[26997.9323435946,3670.9988975876],[26996.3166035559,3669.20773046623],[26996.5500660629,3668.99713329995],[26996.2151613868,3668.62586674082],[26995.8802567107,3668.25460018169],[26995.5453520346,3667.88333362256],[26995.2104473585,3667.51206706344],[26994.9099659259,3667.17896121118],[26994.6068627534,3666.84294896664],[26994.31386603,3666.51814046709],[26995.4425574583,3665.46050378095],[26996.2615654337,3664.73057566756],[26993.3129668189,3661.40409934401],[26997.6338123668,3657.43026185824]],[[27043.3928124234,3653.23877064083],[27046.6779762284,3656.9726916007],[27044.9664364552,3658.53559105747],[27041.6074562418,3654.82041246266],[27043.3928124234,3653.23877064083]]]]}') :: geometry);
  2. select *,ST_Area(geom) from ST_dump(ST_GeomFromGeoJSON('{"type":"MultiPolygon","coordinates":[[[[26989.49971819346,3656.554844086084],[26985.1384667244,3660.596805650281],[26985.39755757016,3660.884308103206],[26989.54513174659,3665.444722574753],[26994.80132155049,3671.430476495206],[27000.94241470951,3678.379394616257],[27004.93143546637,3682.685213362823],[27006.0940630988,3683.848897533226],[27006.8847044156,3684.371108291055],[27007.68648304723,3684.759988573347],[27008.34789973646,3684.959984286655],[27008.75551910439,3685.030375490223],[27008.77119713908,3684.748810675893],[27010.12228211979,3684.703370499683],[27010.11444310247,3685.008399048613],[27011.13348993365,3684.922365626694],[27011.8861881188,3684.718067591047],[27013.51678951518,3683.674007519349],[27015.86194260189,3681.634093737779],[27020.55682762564,3677.423576519093],[27025.83309954926,3672.630062466978],[27033.31804558387,3665.958098308092],[27036.82090109951,3662.793830176259],[27037.39978408956,3662.329249372207],[27038.09192769297,3661.902337700096],[27038.83441005295,3661.425200790134],[27040.10543664641,3660.948063880172],[27041.18769766917,3660.609045763699],[27041.8420856164,3660.44581475839],[27042.52986962043,3660.311412976091],[27043.74626140893,3660.175362716454],[27045.03074810669,3660.219555748302],[27046.66071717054,3660.440522535554],[27047.86941610908,3660.735269470226],[27049.01238423595,3661.161127744966],[27050.24372004488,3661.753319418723],[27051.11185546566,3662.274801590215],[27051.98185293106,3662.958583479132],[27052.79683746296,3663.550774338797],[27053.41693646174,3664.257869360528],[27054.71131169701,3665.739348214029],[27057.4728637239,3668.837047981647],[27061.10412088162,3672.875404739254],[27062.24060362773,3674.131021031263],[27063.20841881066,3675.109374017247],[27063.90685714185,3675.621562032811],[27065.04529725914,3676.167146978226],[27065.57418149049,3676.346027528427],[27066.40784366484,3676.480187534031],[27067.43871416178,3676.444411912434],[27068.36475408703,3676.274933788543],[27069.21634400185,3676.069220911621],[27070.13964487848,3675.657795971809],[27070.9374515719,3675.067491295831],[27072.06866593912,3674.05233208471],[27080.09275969354,3666.87397033951],[27088.94385229869,3658.844045088653],[27091.60068949289,3656.448108704875],[27084.26512454313,3648.363746081388],[27075.04157665107,3638.241685957906],[27067.68545877768,3630.126085096414],[27063.16209770492,3625.092413186587],[27062.2223772929,3624.098312441459],[27061.35171901205,3623.559843579972],[27060.27379092921,3623.06279320738],[27058.91948920899,3622.800457107219],[27051.29796589902,3622.358450851719],[27035.53340843934,3621.391601362873],[27032.85241316978,3621.198291326607],[27031.70538125155,3621.1844946655],[27030.32196172499,3621.375092095313],[27028.89559103802,3621.72626498478],[27027.95085122754,3622.169851921059],[27026.83939486989,3622.890680997774],[27025.43154930286,3624.055096196676],[27022.27812267115,3626.974762039459],[27015.12185611503,3633.408838299943],[27011.22798711082,3636.98699228375],[27003.01048220668,3644.385046807784],[26996.99774938149,3649.819156712703],[26989.49971819346,3656.554844086084]]],[[[26997.63381236684,3657.43026185824],[26993.31296681889,3661.40409934401],[26996.26156543372,3664.730575667555],[26995.44255745833,3665.460503780954],[26994.31386603,3666.51814046709],[26994.60686275341,3666.84294896664],[26994.90996592593,3667.17896121118],[26995.21044735851,3667.512067063435],[26995.5453520346,3667.883333622564],[26995.8802567107,3668.254600181693],[26996.2151613868,3668.625866740824],[26996.5500660629,3668.997133299952],[26996.3166035559,3669.207730466234],[26997.93234359461,3670.998897587605],[26996.97457889066,3671.86285872299],[26999.06518259421,3674.180447275557],[26999.54406494619,3673.748466707865],[27000.02294729819,3673.316486140168],[27004.35325853367,3678.116955847214],[27004.94648257441,3677.581832226962],[27008.8017362955,3681.855665606254],[27009.62788909508,3681.110426292469],[27009.75811431598,3681.254790564219],[27011.29947115371,3679.864394365583],[27011.38302779218,3679.526292151389],[27011.37218276572,3679.158018410813],[27011.26376134376,3678.919728385661],[27011.10111478924,3678.713932047158],[27010.87629718057,3678.478234976992],[27012.80591606415,3676.737603155192],[27012.91664477976,3676.890309870966],[27013.76678460129,3676.152102983349],[27016.41441652246,3678.952910711608],[27024.92782554371,3671.254929651823],[27021.84880552764,3667.859012637137],[27022.80376566136,3667.032027591983],[27023.89921449978,3668.246413505258],[27024.78399821317,3667.448285595097],[27024.5657144573,3667.206301936053],[27025.97669331292,3665.933514487238],[27026.0829420501,3665.620178127046],[27026.14137828341,3665.372121161516],[27026.11216016676,3665.036520482066],[27026.00994002327,3664.817647744172],[27025.84954688965,3664.599301677024],[27027.70949009879,3662.921521487283],[27027.13460132714,3662.284214840491],[27026.16023898237,3661.204062245113],[27029.011409293,3658.632135832942],[27030.04526606691,3659.778242395424],[27030.16029726326,3659.674477365675],[27030.96415780265,3660.573584744091],[27031.06743232583,3660.689095931968],[27029.14207519349,3662.479654550344],[27031.56079284041,3665.247481417111],[27034.14766176327,3662.926079158057],[27035.37705944784,3661.789678965778],[27036.42838026033,3660.95131801019],[27037.44608749929,3660.346402832332],[27038.60554726477,3659.741473401689],[27039.59748131709,3659.303871245672],[27040.35754009799,3659.097947526515],[27041.33662926119,3658.866269089656],[27042.23839886437,3658.711826300276],[27042.95983956949,3658.608864440666],[27036.12142760937,3651.101027523373],[27035.26390545473,3650.159560918619],[27036.45132583893,3649.0884366027],[27040.11858397123,3653.153862992436],[27040.56226385394,3653.301573075729],[27040.89243145622,3653.274083937021],[27041.23638608688,3653.054161858364],[27041.96554106075,3652.44938286868],[27042.13063928348,3652.092015096303],[27042.08936472781,3651.789625601461],[27042.00681561648,3651.487236106619],[27041.69037735622,3651.061141003066],[27041.23476427859,3650.543313978078],[27043.12712737483,3648.836289108159],[27044.18874134051,3650.055136459243],[27043.83199920101,3650.365858254807],[27048.01213482706,3655.020506807453],[27051.04619773115,3652.121625912577],[27051.81884716306,3653.069614409317],[27049.44341264224,3655.212398641352],[27050.2572911376,3656.11464304129],[27050.53942865497,3656.505524125208],[27051.29598462672,3657.367472303882],[27051.64109298363,3657.619430664312],[27051.93310109104,3657.659206954787],[27052.23837705006,3657.619430664312],[27052.42418465848,3657.526604371986],[27052.70874857072,3657.296224796328],[27054.50066359366,3659.28269489454],[27054.81109705061,3659.002665320662],[27055.09233451328,3658.74897228253],[27056.19989796596,3657.749883702486],[27058.87083314979,3660.71081254622],[27057.57589418177,3661.878925065349],[27056.72397236296,3662.697450809555],[27054.96401403032,3660.880681385544],[27053.66263492152,3662.059654539476],[27058.6269343477,3667.595479306033],[27060.59003376789,3665.854548760075],[27061.37395610606,3666.792091509981],[27060.28328956719,3667.704047645731],[27061.32644552251,3668.951624421286],[27062.35009059108,3668.095707999679],[27063.23604032057,3669.091070686563],[27062.94622551228,3669.351185204952],[27067.34593162625,3674.368083071338],[27072.14450973915,3669.999588067668],[27071.87882199563,3669.682540986288],[27073.14599630717,3668.466977903295],[27072.67499661274,3667.94483996859],[27073.2908498415,3667.389303465153],[27074.02310086235,3668.173581479943],[27074.96121268559,3669.178346864264],[27085.98008405961,3659.333887535289],[27084.36033519867,3657.553562390818],[27080.58261389048,3660.995050899695],[27079.52273308809,3661.96059793312],[27079.42682976258,3661.854282016343],[27079.43063696476,3661.850847691911],[27078.42852958645,3660.739937678471],[27079.16225359257,3660.078074673116],[27079.53352015169,3659.743169997018],[27079.90478671082,3659.408265320922],[27080.19210497247,3659.149087037853],[27080.49070946299,3658.878675374053],[27079.25322271461,3657.492568064796],[27078.94437020432,3657.764885428445],[27078.65726605412,3658.025296569765],[27078.28599949499,3658.360201245862],[27077.91473293586,3658.695105921959],[27076.73074711729,3657.382570229612],[27077.65000475306,3656.595426613549],[27077.59432815557,3656.533566790351],[27078.34478498157,3655.879091092455],[27080.85092798815,3653.693476095763],[27071.74181638114,3643.577957984143],[27068.0946602459,3639.622492292048],[27064.41785243477,3643.023896615105],[27064.41774236509,3643.023774594745],[27063.71976764447,3642.250018086168],[27063.7903618261,3642.18633790558],[27064.21518014345,3641.787902025356],[27064.65166361732,3641.371986423411],[27063.37546935407,3640.003664093583],[27063.44587549692,3639.805742294669],[27063.48498681592,3639.561389412174],[27063.44587549692,3639.307251651854],[27063.32845501046,3639.004252283803],[27063.14258971569,3638.789218159651],[27057.53481687201,3632.50571226116],[27054.67173036441,3635.063585979418],[27053.29333222684,3636.306983668879],[27052.66496490998,3635.610392106411],[27051.2607359217,3636.877090770536],[27051.88910323857,3637.573682333004],[27050.36301977011,3638.950301037635],[27049.26381250772,3637.73174863391],[27049.26382037366,3637.731741538358],[27050.22575128966,3636.859026766467],[27048.79350444671,3635.280363769179],[27049.82702831535,3634.350041875197],[27054.05394529415,3630.545201436817],[27052.22050418667,3628.540181702552],[27036.60487237343,3627.521865536659],[27032.24928723896,3627.212324331424],[27031.35731811929,3627.435109052832],[27030.62645226831,3627.707393571876],[27030.00702000092,3628.152948761908],[27031.95904809525,3630.328260970471],[27032.69895570382,3631.15280343419],[27031.58186802812,3632.155228060053],[27030.85625930774,3631.346620072971],[27028.90849005044,3629.176053851518],[27021.14609000183,3636.160171719178],[27023.08452961127,3638.320623459395],[27023.72624455087,3639.035834885751],[27022.98191181734,3639.70942517261],[27022.73480022733,3639.439195087958],[27021.39658935601,3640.722307400615],[27021.68256347558,3641.035035794037],[27020.79610847708,3641.787313849341],[27018.08320950557,3638.876132831934],[27007.31531391994,3648.579489944702],[27009.85422302948,3651.61136324159],[27009.05052928284,3652.297073458816],[27007.63682661366,3653.464384244446],[27006.45108655683,3652.135537040371],[27005.09648443418,3650.617447782158],[26998.82651036818,3656.364683576303],[27000.15525902386,3657.880525902899],[27000.81604930197,3658.634358366452],[27003.39144935487,3661.489379464285],[27002.23576990941,3662.531871552073],[27001.53871598727,3661.759135816588],[26997.63381236684,3657.43026185824]]],[[[27043.39281242344,3653.238770640829],[27041.60745624182,3654.820412462662],[27044.96643645523,3658.535591057468],[27046.67797622844,3656.972691600702],[27043.39281242344,3653.238770640829]]]]}
  3.        ') :: geometry);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top