Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
St_Intersect
select iso_3166_2,gn_name,region,geonunit from Provinces where ST_Intersects(geometry, ST_GeomFromText('MULTILINESTRING ((12.052012566021233 43.765163478639863,12.037852409771233 43.756699936973199,12.031423373312919 43.738552150514863,12.033213737896233 43.716864324994027,12.040049675396233 43.702256577598199,12.060557487896233 43.647284246869027,12.066416862896233 43.613836981244027,12.046641472271233 43.593329168744027,12.046641472271233 43.586533921348199,12.082041862896233 43.579942124473199,12.112315300396233 43.569769598431527,12.138926628521233 43.554225978639863,12.163340691021233 43.531317449994027,12.167491081646233 43.522324936973199,12.168955925396233 43.513495184369027,12.171885612896233 43.506699936973199,12.186940951437919 43.502020574994027,12.211192253521233 43.489691473431527,12.222097201437919 43.478583074994027,12.232920769146233 43.463812567181527,12.240000847271233 43.448309637494027,12.239024284771233 43.435085353639863,12.232188347271233 43.442490952598199,12.246348503521233 43.380926824994027,12.252696159771233 43.366807358848199,12.261403842062919 43.361924546348199,12.298594597271233 43.348496811973199,12.314219597271233 43.346380926556527,12.309825066021233 43.324815171348199,12.323985222271233 43.310899155723199,12.362559441021233 43.291693426556527,12.409434441021233 43.214951890098199,12.425303581646233 43.197088934369027,12.438487175396233 43.174099025514863,12.458018425396233 43.164007879681527,12.455739779562919 43.153265692181527,12.444590691021233 43.137477931764863,12.444590691021233 43.116970119264863,12.447683138937919 43.113145249473199,12.461843295187919 43.106634832806527,12.465017123312919 43.102972723431527,12.459890170187919 43.094183660931527,12.434255404562919 43.070908921348199,12.424001498312919 43.058946030723199,12.429372592062919 43.051865952598199,12.429372592062919 43.044053452598199,12.424978060812919 43.036729233848199,12.417165560812919 43.031032619264863,12.421071810812919 43.028753973431527,12.423757357687919 43.026800848431527,12.426524284771233 43.025254624473199,12.430918816021233 43.024196681764863,12.417002800396233 43.009548244264863,12.413503451437919 43.001247463014863,12.417165560812919 42.990057684369027,12.408864779562919 42.988226629681527,12.404226107687919 42.985419012494027,12.396739128521233 42.976385809369027,12.399424675396233 42.972520249473199,12.403575066021233 42.969549871869027,12.399424675396233 42.964178778119027,12.394053581646233 42.954209702598199,12.389903191021233 42.949082749473199,12.395518425396233 42.940375067181527,12.395030144146233 42.930487371869027,12.390391472271233 42.921210028119027,12.383067253521233 42.914333400514863,12.383067253521233 42.908148504681527,12.390391472271233 42.895941473431527,12.386729362896233 42.884629624473199,12.377940300396233 42.874823309369027,12.368825717062919 42.867132879681527,12.390065951437919 42.856716213014863,12.397959831646233 42.849798895306527,12.403575066021233 42.839219468223199,12.387136263937919 42.833766994264863,12.378591342062919 42.832302150514863,12.368825717062919 42.832383530723199,12.368825717062919 42.826198634889863,12.376882357687919 42.817694403119027,12.388194206646233 42.812201239056527,12.398610873312919 42.804958400514863,12.403575066021233 42.790838934369027,12.388356967062919 42.788845119264863,12.370290560812919 42.781195379681527,12.321706576437919 42.748602606244027,12.308360222271233 42.743475653119027,12.273203972271233 42.736192124473199,12.232188347271233 42.702012436973199,12.197438998312919 42.702012436973199,12.202565951437919 42.683946030723199,12.210378451437919 42.666286525514863,12.221364779562919 42.652777410931527,12.235606316021233 42.647406317181527,12.240489128521233 42.638983465619027,12.245127800396233 42.619696356244027,12.247325066021233 42.598700262494027,12.245290560812919 42.585394598431527,12.258962435812919 42.565497137494027,12.262217644146233 42.564154364056527,12.267100456646233 42.565537827598199,12.271413607687919 42.565985418744027,12.273203972271233 42.561794338014863,12.272471550396233 42.548203843223199,12.275401237896233 42.535915431764863,12.277272982687919 42.518866278119027,12.280039909771233 42.510280666139863,12.283620638937919 42.506130275514863,12.295095248312919 42.496852931764863,12.300466342062919 42.489813543744027,12.318858269146233 42.497870184369027,12.342702670187919 42.491766668744027,12.393321159771233 42.462347723431527,12.417165560812919 42.441351629681527,12.417735222271233 42.438991603639863,12.416514519146233 42.430609442181527,12.417165560812919 42.428290106244027,12.420176628521233 42.428005275514863,12.428151888937919 42.429022528119027,12.430918816021233 42.428290106244027,12.435476107687919 42.425848699994027,12.446706576437919 42.423407293744027,12.451426628521233 42.420843817181527,12.451426628521233 42.414658921348199,12.445241732687919 42.410996811973199,12.440603060812919 42.406602280723199,12.430918816021233 42.392930405723199,12.438487175396233 42.388942775514863,12.446706576437919 42.387762762494027,12.455495638937919 42.389227606244027,12.465017123312919 42.392930405723199,12.465017123312919 42.386745509889863,12.453379753521233 42.372137762494027,12.454600456646233 42.352850653119027,12.466237826437919 42.335231838014863,12.486094597271233 42.325262762494027,12.472422722271233 42.318426824994027,12.490977409771233 42.298285223431527,12.546885612896233 42.293524481244027,12.560557487896233 42.270615952598199,12.569509310812919 42.278265692181527,12.572276237896233 42.282578843223199,12.574229362896233 42.291123765098199,12.581716342062919 42.291123765098199,12.581065300396233 42.278916733848199,12.584646029562919 42.272243556764863,12.591726107687919 42.271551824994027,12.602224154562919 42.277533270306527,12.611745638937919 42.265163478639863,12.622325066021233 42.254339910931527,12.629812045187919 42.241400457806527,12.629405144146233 42.222235418744027,12.611094597271233 42.237738348431527,12.605723503521233 42.226141668744027,12.607920769146233 42.205837306764863,12.612071159771233 42.194932358848199,12.606130404562919 42.191758530723199,12.612966342062919 42.184759832806527,12.629405144146233 42.174505926556527,12.635264519146233 42.163356838014863,12.637868685812919 42.156317449994027,12.637950066021233 42.149725653119027,12.636241081646233 42.139715887494027,12.629405144146233 42.120672918744027,12.618825717062919 42.109808660931527,12.581553581646233 42.081366278119027,12.573252800396233 42.079779364056527,12.566335482687919 42.080145574994027,12.560557487896233 42.078884181764863,12.542979362896233 42.069037176556527,12.542002800396233 42.063910223431527,12.553721550396233 42.057806707806527,12.553721550396233 42.051581121869027,12.530690951437919 42.050156968223199,12.515391472271233 42.038641668744027,12.509206576437919 42.021551824994027,12.512705925396233 42.003200588014863,12.505137566021233 41.997422593223199,12.499685092062919 41.989935614056535,12.492930534771233 41.975205796348199,12.494313998312919 41.958929754681535,12.492198112896233 41.944199936973199,12.481700066021233 41.934759832806535,12.458181185812919 41.934271551556535,12.458181185812919 41.928045965619035,12.466726107687919 41.924505926556535,12.471202019146233 41.918402410931535,12.470957878521233 41.910345770306535,12.465017123312919 41.900742905723199,12.474864128521233 41.891546942181535,12.473806185812919 41.879828192181535,12.468272331646233 41.865545965619035,12.465017123312919 41.848944403119035,12.459483269146233 41.836127020306535,12.446055534771233 41.833604233848199,12.430349154562919 41.834418035931535,12.417165560812919 41.831854559369035,12.415293816021233 41.826727606244035,12.416270378521233 41.818915106244035,12.415944857687919 41.810817775514863,12.410329623312919 41.804510809369035,12.403819206646233 41.803168035931535,12.363454623312919 41.806504624473199,12.350515170187919 41.809190171348199,12.339366081646233 41.807725327598199,12.328542513937919 41.797064520306535,12.311696810812919 41.804307358848199,12.297373894146233 41.799017645306535,12.273203972271233 41.777207749473199,12.279307487896233 41.761338608848199,12.267832878521233 41.752224025514863,12.232188347271233 41.742499090619035))')) = true order by region
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment