Created
October 11, 2012 14:29
-
-
Save andrewxhill/3872764 to your computer and use it in GitHub Desktop.
Longer single line text
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH line AS (SELECT ST_GeometryFromText('LINESTRING( -112.445 42.87133,-112.445 42.87124,-112.444 42.87086,-112.444 42.87086,-112.445 42.87055,-112.445 42.8705000,-112.446 42.8702000,-112.446 42.86988,-112.447 42.8695500,-112.447 42.8695500,-112.447 42.8703200,-112.448 42.8710600,-112.449 42.87183,-112.449 42.87203,-112.449 42.8722000,-112.450 42.8723100,-112.450 42.87268,-112.450 42.87279,-112.450 42.87279,-112.450 42.87326,-112.450 42.87404,-112.450 42.8744600,-112.450 42.87505,-112.450 42.87518,-112.450 42.8767600,-112.450 42.8768,-112.450 42.8769000,-112.450 42.8769000,-112.450 42.8768700,-112.450 42.8768700,-112.450 42.87686,-112.451 42.8768300,-112.451 42.87682,-112.451 42.8768,-112.453 42.87664,-112.453 42.8766500,-112.455 42.8766700,-112.456 42.87666,-112.456 42.8766300,-112.456 42.8766100,-112.456 42.8765200,-112.457 42.87615,-112.457 42.87615,-112.457 42.8760900,-112.457 42.87608,-112.457 42.8761100,-112.458 42.87635,-112.459 42.8773000,-112.460 42.87865,-112.461 42.8792200,-112.461 42.87926,-112.462 42.87991,-112.463 42.8802800,-112.463 42.8805000,-112.464 42.88127,-112.465 42.8820200,-112.465 42.88208,-112.465 42.8824900,-112.466 42.8831200,-112.466 42.8834100,-112.466 42.88349,-112.468 42.8848700,-112.470 42.88595,-112.470 42.88624,-112.472 42.88776,-112.474 42.88917,-112.474 42.88926,-112.474 42.8892800,-112.474 42.8897700,-112.475 42.89029,-112.475 42.89068,-112.476 42.89077,-112.477 42.89155,-112.477 42.8916900,-112.477 42.8920700,-112.478 42.8925400,-112.478 42.89273,-112.479 42.8933700,-112.480 42.8939,-112.480 42.89412,-112.484 42.8956,-112.484 42.89574,-112.485 42.8959300,-112.485 42.89618,-112.486 42.89658,-112.487 42.8968700,-112.488 42.8972000,-112.489 42.8975400,-112.490 42.89802,-112.493 42.8994200,-112.495 42.90023,-112.495 42.9002700,-112.496 42.9003400,-112.496 42.9004900,-112.497 42.90095,-112.498 42.9011800,-112.500 42.90214,-112.500 42.9021500,-112.501 42.90252,-112.501 42.9026000,-112.502 42.90306,-112.503 42.9033100,-112.503 42.90337,-112.503 42.90352,-112.503 42.9035800,-112.504 42.90375,-112.505 42.9041600,-112.507 42.9051500,-112.508 42.90552,-112.509 42.9058000,-112.510 42.9063600,-112.511 42.9068300,-112.513 42.9073600,-112.513 42.90755,-112.514 42.9078,-112.514 42.9079000,-112.514 42.90796,-112.515 42.9081500,-112.515 42.9083700,-112.516 42.90852,-112.517 42.90885,-112.518 42.90901,-112.519 42.9093300,-112.520 42.90959,-112.521 42.90975,-112.521 42.9097800,-112.522 42.90991,-112.523 42.9103200,-112.525 42.9107000,-112.525 42.9108,-112.526 42.9108600,-112.526 42.9109000,-112.526 42.9109500,-112.527 42.9109700,-112.527 42.91111,-112.527 42.91125,-112.528 42.9113900,-112.528 42.9117100,-112.528 42.91181,-112.528 42.91199,-112.528 42.91237,-112.529 42.9124400,-112.529 42.91266,-112.529 42.9129,-112.529 42.9132500,-112.529 42.9132500,-112.530 42.91317,-112.530 42.9130500,-112.531 42.9129200,-112.532 42.91284,-112.532 42.91279,-112.533 42.91273,-112.534 42.9126700,-112.535 42.9125600,-112.535 42.91255,-112.538 42.9123600,-112.539 42.9122000,-112.540 42.9121300,-112.544 42.9115500,-112.546 42.9110100,-112.549 42.91033,-112.555 42.9084,-112.567 42.9048800,-112.572 42.9034000,-112.576 42.902,-112.580 42.901,-112.581 42.9007600,-112.583 42.90003,-112.584 42.8998900,-112.584 42.8998700,-112.584 42.8998700,-112.584 42.8998700,-112.584 42.8998600,-112.584 42.8998000,-112.584 42.8996900,-112.585 42.8995100,-112.585 42.8994600,-112.585 42.89934,-112.586 42.8990800,-112.587 42.89873,-112.588 42.89815,-112.589 42.8979600,-112.590 42.8976000,-112.591 42.8973300,-112.592 42.8971100,-112.592 42.8969300,-112.594 42.89658,-112.598 42.89551,-112.602 42.8947400,-112.606 42.89368,-112.608 42.89329,-112.613 42.89204,-112.615 42.89173,-112.616 42.8915200,-112.619 42.89068,-112.621 42.89023,-112.623 42.8898600,-112.624 42.8896600,-112.625 42.88951,-112.626 42.88942,-112.627 42.88936,-112.628 42.8892800,-112.629 42.88927,-112.630 42.88918,-112.631 42.8891400,-112.632 42.8891000,-112.633 42.88904,-112.633 42.8890100,-112.633 42.88895,-112.633 42.88893,-112.634 42.88884,-112.634 42.8887800,-112.634 42.88871,-112.635 42.88855,-112.636 42.88823,-112.638 42.8877,-112.638 42.8874800,-112.639 42.8873700,-112.640 42.8868100,-112.642 42.88635,-112.643 42.8861000,-112.644 42.88573,-112.647 42.88454,-112.648 42.88448,-112.650 42.8836600,-112.654 42.8825800,-112.660 42.88076,-112.663 42.87984,-112.664 42.8794900,-112.666 42.87906,-112.667 42.87866,-112.668 42.87827,-112.669 42.8780200,-112.671 42.87749,-112.677 42.8759100,-112.678 42.87541,-112.679 42.87519,-112.680 42.8749900,-112.681 42.87489,-112.682 42.87476,-112.682 42.87467,-112.684 42.87456,-112.685 42.8744800,-112.686 42.8744300,-112.687 42.8743500,-112.688 42.8743400,-112.689 42.8742,-112.690 42.87413,-112.691 42.874,-112.692 42.8738100,-112.693 42.87366,-112.694 42.8733800,-112.695 42.8732300,-112.695 42.8731100,-112.695 42.8731100,-112.696 42.87292,-112.696 42.8728200,-112.697 42.87259,-112.697 42.8722900,-112.699 42.87185,-112.699 42.8716100,-112.700 42.8713500,-112.700 42.8708800,-112.701 42.8704500,-112.704 42.8686,-112.705 42.8681900,-112.706 42.8674500,-112.708 42.8663800,-112.709 42.86569,-112.710 42.8651900,-112.712 42.86455,-112.713 42.8639800,-112.717 42.86285,-112.718 42.86243,-112.719 42.86243,-112.919 42.85843, -113.445 42.87133,-113.445 42.87124,-113.444 42.87086,-113.444 42.87086,-113.445 42.87055,-113.445 42.8705000,-113.446 42.8702000,-113.446 42.86988,-113.447 42.8695500,-113.447 42.8695500,-113.447 42.8703200,-113.448 42.8710600,-113.449 42.87183,-113.449 42.87203,-113.449 42.8722000,-113.450 42.8723100,-113.450 42.87268,-113.450 42.87279,-113.450 42.87279,-113.450 42.87326,-113.450 42.87404,-113.450 42.8744600,-113.450 42.87505,-113.450 42.87518,-113.450 42.8767600,-113.450 42.8768,-113.450 42.8769000,-113.450 42.8769000,-113.450 42.8768700,-113.450 42.8768700,-113.450 42.87686,-113.451 42.8768300,-113.451 42.87682,-113.451 42.8768,-113.453 42.87664,-113.453 42.8766500,-113.455 42.8766700,-113.456 42.87666,-113.456 42.8766300,-113.456 42.8766100,-113.456 42.8765200,-113.457 42.87615,-113.457 42.87615,-113.457 42.8760900,-113.457 42.87608,-113.457 42.8761100,-113.458 42.87635,-113.459 42.8773000,-113.460 42.87865,-113.461 42.8792200,-113.461 42.87926,-113.462 42.87991,-113.463 42.8802800,-113.463 42.8805000,-113.464 42.88127,-113.465 42.8820200,-113.465 42.88208,-113.465 42.8824900,-113.682 42.87476,-113.682 42.87467,-113.684 42.87456,-113.685 42.8744800,-113.686 42.8744300,-113.687 42.8743500,-113.688 42.8743400,-113.689 42.8742,-113.690 42.87413,-113.691 42.874,-113.692 42.8738100,-113.693 42.87366,-113.694 42.8733800,-113.695 42.8732300,-113.695 42.8731100,-113.695 42.8731100,-113.696 42.87292,-113.696 42.8728200,-113.697 42.87259,-113.697 42.8722900,-113.699 42.87185,-113.699 42.8716100,-113.700 42.8713500,-113.700 42.8708800,-113.701 42.8704500,-113.704 42.8686,-113.705 42.8681900,-113.706 42.8674500,-113.708 42.8663800,-113.709 42.86569,-113.710 42.8651900,-113.712 42.86455,-113.713 42.8639800,-113.717 42.86285,-113.718 42.86243,-113.719 42.86243,-113.919 42.85843)',4326) as geom), buff AS (SELECT ST_Union(ST_Buffer(geom::geography,50)::geometry) as geom from line) SELECT ST_AsText(ST_Transform(ST_Centroid(usa_admin.the_geom_webmercator),4326)) FROM usa_admin,buff WHERE ST_Intersects(the_geom,geom) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment