[postgis-users] newbie WITHIN query

Mark Fenbers Mark.Fenbers at noaa.gov
Thu Dec 1 07:58:20 PST 2005


So your district 22 is in meters (?) but you are comparing it against a 
point in degrees (lat,lon).  You must first convert your lat,lon into 
meters, then make the comparison.

something like...
 Transform(SetSRID(MakePoint(-122.916725, 47.046528),4269),2285)

Mark

Alec Brecher wrote:

> Thank you.  Below is the additional information.
>
> SELECT extent([geom Column name]) FROM [table name];
> yields: BOX(176647.859375 24943.796875,777579 41385.40625)
>
> SELECT extent([geom Column name]) FROM [table name];
> yields: 2285
> This confirms that SRID is loaded correctly?
>
> the_geom of district 22:
> MULTIPOLYGON(((323652.895920867 185706.654440942,323190.647744872 
> 185873.734724393,323019.030341988 186214.545389586,323057.181184904 
> 186230.768850555,323101.847559915 186248.579767998,323130.08873194 
> 186256.532636772,323168.20847365 186251.071349145,323198.516865134 
> 186231.04936065,323219.65189927 186196.729127847,323240.534312933 
> 186156.410975865,323261.809930451 186129.426761797,323299.668697473 
> 186115.077070273,323345.11959102 186107.843995604,323392.2345707 
> 186108.013467272,323432.055370486 186111.178331862,323455.716270975 
> 186113.484556079,323465.637522887 186114.4158664,323474.629932971 
> 186114.818470794,323483.331259745 186115.674502701,323474.298718495 
> 186147.524511985,323450.575143413 186207.72115557,323427.49535643 
> 186240.652037203,323412.354871069 186269.234416061,323362.754002677 
> 186404.260620821,323360.030734867 186412.570516145,323336.084156469 
> 186485.786100296,323333.777906026 186492.749182901,323300.630237341 
> 186594.595078515,323309.881306134 186601.217673799,323307.820673192 
> 186696.587181209,322942.933035817 186727.811746116,322913.912044643 
> 186726.889210084,322904.786976536 186732.274431326,322872.207163518 
> 186770.603953442,322842.521598923 186865.677729111,322831.013588262 
> 186870.243767014,322831.437047883 186884.577664456,322841.442047546 
> 186906.413379622,322848.534790016 186912.098117807,322863.913745663 
> 186922.653879188,322881.249212225 186919.583975015,323314.98148626 
> 186900.895404651,323319.861546618 187035.54084971,322589.4413463 
> 187048.986362992,322583.273923456 187064.293741934,322582.91679212 
> 187065.082796183,322549.641485503 187115.779402133,322529.302440374 
> 187158.753323518,322527.688776376 187183.93515315,322517.483326677 
> 187258.1936601,322511.078606842 187293.748879897,322501.208461328 
> 187361.324757119,322492.251676163 187400.625578153,322486.712434299 
> 187442.271932857,322493.173653382 187470.328724328,322315.640550962 
> 187464.687792181,322232.673574984 187489.389389661,322175.294233055 
> 187509.66326897,321923.948767784 187598.641450469,321709.837696344 
> 187670.3972414,321705.468134077 187671.861725016,321525.333329157 
> 187755.06999832,321423.336794089 187817.605985345,321344.678550132 
> 187851.311325087,321311.70376439 187865.639539093,321263.340824742 
> 187886.988228642,321230.366420679 187901.31689109,321188.643307785 
> 187913.126292004,320806.585372453 188021.510571333,320674.211393001 
> 188047.377298693,320612.87286834 188067.228802194,320425.022450783 
> 188110.442309528,320371.21075401 188160.543596138,320276.988791268 
> 188248.334847661,320158.03354545 188340.873237659,320083.354950795 
> 188387.59950262,320009.01108834 188445.438137543,319902.595682657 
> 188448.63377752,319818.649689658 188440.034538407,319681.75375847 
> 188444.150195495,319587.53137126 188346.891490954,319553.009963332 
> 188342.480845905,319508.873564447 188344.699078383,319351.55867454 
> 188342.875260245,319344.81701378 188343.85689486,319267.456316793 
> 188354.418269213,319155.624337463 188369.801612312,319100.287621373 
> 188371.470985787,318964.231703046 188365.679495226,318963.029655983 
> 188257.83721866,318962.812530311 188238.047504181,319036.929210055 
> 188235.921266588,319034.827631166 188214.186565605,319015.900156994 
> 188214.757870233,319012.835888055 188161.133543626,319127.84605461 
> 188157.662985078,319128.59017949 188182.330242304,319332.689463576 
> 188186.297302497,319330.901558375 188126.962488991,319325.84922108 
> 187959.291691362,319318.402970707 187712.174631155,319312.629313402 
> 187679.651506048,319250.72378497 187710.989129758,319209.142732374 
> 187717.358559529,319178.077045997 187726.747611658,318909.782449724 
> 187822.370412186,318899.22299327 187606.265197155,318899.379596653 
> 187477.918573532,318840.339224805 187034.842933824,318677.654981735 
> 186939.666353874,318616.158762895 186919.283080008,318522.904912653 
> 186855.375436099,318491.298929568 186733.88444649,318479.155730097 
> 186687.208126111,318473.72999116 186666.352758675,318471.232417568 
> 186656.752670929,318457.528712352 186591.217120183,318450.965865685 
> 186462.40668664,318446.82425289 186380.900462454,318443.11048175 
> 186308.500908402,318437.539756978 186199.901606459,318440.969351657 
> 186157.313797094,318436.139064901 186093.289180253,318430.340477337 
> 186017.393926854,318428.319900537 185990.87480783,318385.114292342 
> 185845.935715411,318236.971073313 185742.10008384,318226.085658793 
> 185734.533715402,318107.844024261 185643.029614345,317703.828519768 
> 185330.324833836,317821.061915959 185180.182336559,318019.194709016 
> 184926.271288453,318110.870439699 184808.94016115,318177.841379934 
> 184717.827346059,318224.692594656 184653.571510182,318273.597772355 
> 184581.691296731,318324.424637452 184495.295494876,318349.48488019 
> 184455.500504657,318432.228530361 184324.321101402,318456.345133969 
> 184286.000958459,318516.243386191 184194.77275116,318666.2567831 
> 183966.474664512,318523.743999615 183843.665962853,318450.338041865 
> 183780.49284164,318383.870310882 183725.229186206,318359.735421184 
> 183705.16275261,318281.462767715 183652.37062582,318207.098767378 
> 183613.029167756,318198.563847172 183610.284979952,318123.813266514 
> 183585.858915126,318062.923097141 183571.578821576,318003.633982417 
> 183569.929179312,317967.72906213 183573.576235618,317947.652588948 
> 183574.407753326,316754.912190405 183620.723656994,316348.687105183 
> 183633.143193698,316363.579485284 184234.138605998,316368.641679742 
> 184436.840211122,316288.603010433 184441.069989558,315953.170796404 
> 184451.350665558,315494.215270809 184465.447626246,315333.3453014 
> 184470.397114864,315326.886921121 184470.818341759,315183.786551111 
> 184479.228668856,315166.68001686 184489.876316624,315174.176967288 
> 184619.545579009,315131.575800373 184670.015647249,315125.96994823 
> 184675.86041126,315077.499425023 184726.066906094,315036.788323927 
> 184761.242844612,315001.673034414 184790.240843851,314998.160013847 
> 184792.351067312,314933.183610115 184830.611628058,314941.805310237 
> 184870.717133042,315030.885633136 185285.809091812,315055.893394643 
> 185380.906440853,315074.929017153 185432.924871595,315103.896411906 
> 185505.879525509,315132.083685762 185560.952533655,315128.383703426 
> 185673.061384241,315121.62429451 185799.50026933,314899.063759984 
> 185802.138059283,314899.213721965 185866.194135623,314899.330831924 
> 185951.382378631,314891.443754021 186075.632247493,314889.126109054 
> 186111.515517005,314644.226916393 186119.968559367,314686.53188006 
> 186173.713600149,314765.202279764 186278.71876643,314794.969055768 
> 186318.393607266,314685.996856154 186318.9792058,314686.530495501 
> 186395.368648238,314687.391628864 186509.450491694,314618.666268075 
> 186509.461282972,314562.348423228 186509.534082227,314539.194163858 
> 186499.128352645,314505.366862552 186510.295239478,314440.347779537 
> 186502.185820477,314406.968127291 186503.218671806,314273.069397835 
> 186507.363708129,314082.636067524 186502.142294827,313973.80838841 
> 186504.849572658,313948.941293117 186505.50972366,313899.805792563 
> 186496.690985953,313909.133163702 186552.010204,313913.611591944 
> 186696.342524993,313883.887946807 186719.508351083,313880.42261953 
> 186853.076743384,313874.888565097 186919.978940601,313778.786208799 
> 186922.962363596,313745.636989396 186923.991812932,313654.400635103 
> 186926.826105901,313660.884416024 187137.938034537,313666.753723941 
> 187326.825642798,314207.297973125 187332.297160008,314227.293102676 
> 187732.060379889,314299.968301822 187729.809224226,314407.916869728 
> 187726.46708331,314470.557474743 187724.528591174,314470.213686009 
> 187713.417494626,314846.43853976 187701.788525502,314852.610694437 
> 187854.855163499,314863.009712602 188112.780411281,314756.588403321 
> 188116.067388704,314687.110522891 188118.214334526,314650.167152399 
> 188119.356255019,314593.307822266 188121.114223515,314597.471149668 
> 188221.303587807,314651.88678083 188219.28751963,314653.356883178 
> 188266.843121853,314690.209595081 188265.259125373,314690.339629995 
> 188271.928149688,314691.506979026 188329.391465275,314696.084685915 
> 188551.35121123,314579.952236324 188555.275373933,314313.881155127 
> 188559.839897957,313766.229733356 188569.374897928,313784.177129822 
> 189147.151494152,313790.734839463 189358.262401645,313608.336242016 
> 189363.931002289,312933.420761869 189378.72614727,312935.18819083 
> 189635.252721061,312833.529606403 189636.757762871,312833.567294297 
> 189608.729429259,312776.333154499 189644.327321252,312732.570413893 
> 189580.297616739,312546.660632347 189597.563984872,312550.355560925 
> 189647.608225484,312446.72849988 189685.8836942,311845.229194248 
> 189908.376985745,311227.426206181 190312.289258155,310298.828032412 
> 190919.621665546,310310.904800003 190991.199233785,310330.103858162 
> 191028.295415058,310332.985905075 191049.669810771,310461.700323236 
> 191142.025922391,310575.794677783 191383.104026168,310733.00631755 
> 191544.967673637,310682.634381023 191635.535457365,310707.108758211 
> 191712.171931795,310724.831230018 191767.667382074,310862.276727351 
> 191785.571609946,311072.057411912 192168.226021411,311315.24337537 
> 192405.248379822,311354.222806235 192616.897334394,311369.254649117 
> 192698.282496368,311406.943705933 192902.854359912,311234.071926604 
> 192893.83999778,311173.607227086 192900.416699396,311130.502111093 
> 192915.010735385,311096.05471306 192934.114595321,311070.034908247 
> 192952.841664614,310818.752187563 193186.216600244,310772.034472946 
> 193225.952177493,310785.678508866 193253.548973657,310838.401012242 
> 193305.270168781,310873.335196364 193347.432237122,310870.697471628 
> 193374.653492426,310881.331200391 193417.694065223,310885.421884021 
> 193472.619444417,310867.252975614 193520.79575678,310820.792526393 
> 193667.295432952,310807.043351302 193708.547906843,310776.930100028 
> 193746.758236551,310554.79573209 193984.564090068,310424.431129506 
> 194044.74430296,310023.416651156 194698.08858601,310012.214689107 
> 194716.350688771,310012.859689503 194736.68388828,309907.535677936 
> 194785.293314253,309751.61543462 194848.969568426,309584.565478705 
> 194952.154162163,309436.358641152 195114.693018103,309342.670358214 
> 195311.202460205,309274.282058271 195574.086470579,309287.680888583 
> 195882.637085385,309355.001649431 196180.684288502,309422.055062099 
> 196439.479060753,309490.145459825 196590.132718592,309583.387743125 
> 196748.106420466,309702.119727766 196864.341152403,309863.097039465 
> 196963.998783624,309983.598860086 197023.792599989,310063.337033274 
> 197092.000155316,310083.719963561 196972.901107371,310431.51113023 
> 197204.344334861,310916.017196671 197526.916376679,311330.865628217 
> 197817.576048395,311981.412436023 198273.472325636,312231.507776641 
> 198448.804599173,312570.667619719 198686.644611127,313021.801043214 
> 199028.110669244,313315.527747515 199267.522160639,313551.16086686 
> 199466.381667918,313571.948662765 199487.644743899,313694.806558842 
> 199613.836948943,313810.944596471 199734.123444018,313905.443085263 
> 199866.874508881,313980.343879251 200002.015730346,314014.079722365 
> 200080.824301013,314036.33727457 200125.066133744,314058.672071983 
> 200210.902582436,314062.998777039 200274.386988776,314062.780926686 
> 200343.12882904,314053.542993606 200417.267193373,314019.31628225 
> 200547.348317707,313942.936283483 200735.574840472,313854.796691953 
> 200958.091204682,313815.601723938 201074.648191485,313786.699415579 
> 201151.067588267,313770.381425977 201221.97920396,313764.351302465 
> 201289.233960265,313752.716085759 201361.779461608,313753.397911887 
> 201420.261195072,313760.557243454 201540.492159521,313795.50900916 
> 201992.635724998,313867.429133464 202069.254218521,313912.437793305 
> 202212.999303819,314008.452329188 202432.34699991,314118.974112803 
> 202635.118040047,314259.638869718 202875.104225072,314266.543094196 
> 202887.235529268,314366.156737957 203061.876677436,314468.308302037 
> 203218.200165862,314571.943899885 203349.120548666,314638.131264696 
> 203430.152044141,314693.774609328 203506.505923116,315105.088041347 
> 203962.24427448,316089.693894834 204965.692247098,316376.993048183 
> 205258.607878511,317243.3251117 206302.797128081,317317.037415293 
> 206391.523671781,317291.230330628 206311.56513584,317286.372910875 
> 206296.587393841,317257.59045318 206188.803193764,317232.374833333 
> 206083.579416363,317223.032786673 205929.377581091,317210.774894402 
> 205793.950275733,317214.904235768 205740.437460294,317232.021593813 
> 205694.869221446,317338.395992866 205538.910450929,317409.986637881 
> 205456.087738319,317515.057583101 205371.465395257,317601.920386722 
> 205334.002334029,317733.265894673 205277.38885044,317836.58577041 
> 205247.101882734,317929.137197859 205246.840769786,318072.414362399 
> 205275.511971693,318170.4386017 205300.557720826,318351.472663481 
> 205390.927330679,318523.846051 205498.582007655,318570.748586101 
> 205519.180250789,318627.80363556 205529.34971694,318667.24378625 
> 205534.048038132,318715.726902521 205529.241050304,318988.677625739 
> 205443.783268443,319190.521858044 205382.509939525,319346.098201881 
> 205359.121808827,319418.910491832 205353.474259569,319470.33376147 
> 205370.606322526,319510.158543394 205385.530887465,319549.102422717 
> 205411.493136859,319589.516889282 205445.97523769,319605.793314832 
> 205464.947691293,319659.103168556 205527.068733573,319688.984222182 
> 205561.980452489,319831.931686713 205728.839151283,319845.105187999 
> 205733.002192359,319913.796782164 205754.400075499,320142.412747775 
> 205851.842386069,320287.473970755 205940.793691924,320415.459133896 
> 206039.71510384,320507.766475573 206145.493787666,320593.77826598 
> 206236.225597394,320694.538593346 206315.505369918,320778.747928288 
> 206381.714125299,320886.596575103 206426.862337633,321000.382716288 
> 206477.840536861,321062.197040097 206495.453307925,321128.689317888 
> 206547.73861784,321177.119894316 206581.99120275,321313.105447043 
> 206678.022566476,321492.640485565 206838.153539831,321597.671027235 
> 206946.905026444,321664.664271075 207016.30901508,321805.178440978 
> 207150.364512996,321970.895130291 207351.62780772,322139.327077289 
> 207568.051828047,322296.310070796 207787.490099206,322408.051481995 
> 207964.900839833,322490.492517557 208131.283329757,322512.1563749 
> 208176.462479459,322538.590081009 208231.621071091,322590.983985775 
> 208318.374012511,322646.884485238 208408.359917632,322752.523517741 
> 208536.687493661,322912.447762452 208703.446962903,322945.1173208 
> 208733.842854307,322988.770797889 208763.913515801,323063.429100505 
> 208821.983468139,323138.643239935 208863.021224502,323226.149888872 
> 208927.497263715,323290.703382125 208974.746940292,323383.362854219 
> 209016.161531702,323501.722145631 209067.829057795,323556.759822317 
> 209090.783061899,323607.153414265 209113.096127649,323680.722127136 
> 209137.172490257,323748.811982903 209170.865034741,323810.990210541 
> 209199.50533685,323867.36515706 209226.760271818,323899.048485891 
> 209239.395137741,323929.443974549 209252.068119884,323943.194426241 
> 209286.474658477,324112.890427549 209431.623003231,324118.570048115 
> 209421.112379539,324661.726932257 209071.489693043,325170.169399532 
> 208567.227981067,325429.906027809 208114.76028934,325486.923254882 
> 208041.915197708,325585.826847533 207915.464280634,325818.528083228 
> 207618.286966277,325905.129676549 207522.006857948,325938.331980972 
> 207485.116381155,326042.416127977 207403.121243264,326116.447633622 
> 207322.892035554,326180.316479859 207245.183725894,326185.736220381 
> 207238.57548258,326248.927038312 207140.090007099,326294.514075794 
> 207035.99991531,326335.483647544 206932.155630118,326379.894268445 
> 206790.064180346,326403.715066776 206680.601724661,326418.698681969 
> 206611.545494688,326428.049620904 206573.126421066,326436.188186857 
> 206534.742573436,326458.86071749 206479.69905174,326496.469380407 
> 206419.21730993,326770.362158302 205966.739401172,327131.480726374 
> 205486.173288227,327220.522738979 205362.262146343,327272.319794057 
> 205272.459648967,327308.048376025 205188.348940441,327363.141447327 
> 205089.109995284,327428.771946996 204994.794649862,327505.540831925 
> 204928.852516873,327649.488718196 204822.048981138,327944.713968534 
> 204622.699985603,328083.32785495 204530.407728185,328145.540725986 
> 204480.240550722,328186.667046909 204419.669572008,328219.511055779 
> 204356.000372299,328166.281685749 204351.857777383,328223.383355682 
> 204123.671200594,328279.694072634 203907.408214127,328311.861887563 
> 203817.401128202,328353.570696835 203737.24099844,328461.186090898 
> 203595.022994947,328507.223613961 203528.085742548,328634.78293089 
> 203406.31893504,328819.514105453 203229.757694335,329034.333340284 
> 203048.783542608,329247.579794343 202923.914561334,329247.862144808 
> 202933.804588859,329278.756976843 202918.131128963,330231.60237875 
> 202433.586647602,331684.839380045 201694.990017444,331864.844663806 
> 201572.153940679,331975.452076733 201513.217624859,332078.724911002 
> 201484.96151484,332320.269237275 201306.697078905,332537.880089527 
> 201146.128203832,332666.928213343 201051.212364722,332798.734178006 
> 200954.331773445,332802.528121763 200951.556662252,332979.940300759 
> 200821.265708371,332883.47172469 198818.148767038,332948.889529493 
> 198588.117399894,332996.269874099 198544.312600653,333054.294815667 
> 198503.658833135,333125.988922821 198457.508844147,333172.690183966 
> 198427.403391183,333222.995604991 198403.981754218,333239.402262016 
> 198398.631357088,333276.956175653 198386.352912444,333303.962202522 
> 198374.368453195,333307.86490426 198372.70281478,333329.258933209 
> 198350.08731983,333340.114452473 198322.649631055,333346.642598448 
> 198308.900158687,333349.588829389 198289.245040524,333351.252835095 
> 198267.178988204,333339.510478453 198219.129257545,333318.416820607 
> 198168.003622148,333262.614685631 198078.698604715,333245.312641288 
> 198041.035308694,333221.911480553 197991.642444643,333207.815055881 
> 197943.658557992,333199.797380929 197903.957330489,333193.585687449 
> 197847.301769987,333184.500995963 197772.042895803,333192.601822922 
> 197730.224383361,333214.69726772 197648.202575495,333218.333018458 
> 197612.402687061,333176.539444465 197486.342331526,333158.236263845 
> 197453.711667104,333146.3004078 197439.698167159,333110.947896513 
> 197419.442386396,333057.218699902 197404.814924872,332916.09480249 
> 197372.27492507,332854.529013759 197368.099361829,332799.778139769 
> 197357.728713072,332762.432578358 197347.761997635,332715.347729661 
> 197323.610255842,332674.131549572 197300.18453024,332615.080543014 
> 197261.020938596,332543.142141298 197214.656043726,332428.980250022 
> 197155.127487156,332414.757603582 197143.626040049,332409.841472834 
> 197133.532261557,332407.06672654 197115.81620649,332411.080782309 
> 197093.684101325,332419.675105844 197069.644419395,332445.035280744 
> 197023.115775251,332487.090495121 196951.54254496,332500.885092811 
> 196907.00594954,332518.103123412 196859.926995467,332532.092217974 
> 196819.611060186,332535.466706061 196774.587576553,332531.904535607 
> 196731.426282294,332515.45145539 196680.952052333,332493.609986811 
> 196562.790158007,332476.865759879 196504.650654798,332449.012110415 
> 196462.169126647,332402.826021951 196386.281615628,332390.292238713 
> 196351.045080715,332374.044276684 196310.685654469,332367.372814559 
> 196278.621369152,332366.280838252 196239.617042427,332365.356858398 
> 196206.613384834,332370.127607792 196170.78124977,332375.19209761 
> 196142.725635264,332383.669652202 196114.463276065,332449.143881895 
> 196010.762076801,332472.564409209 195976.187614671,332492.227542482 
> 195934.934530671,332525.573687576 195883.067470577,332541.108228077 
> 195857.165858422,332559.680107776 195817.611705854,332562.156172649 
> 195800.193666444,332561.537843985 195778.080110828,332566.35995978 
> 195744.026148352,332578.618860437 195685.186807583,332594.795941993 
> 195641.473772379,332619.522591637 195593.740671921,332643.930041815 
> 195564.477497597,332111.167817761 195283.014518849,331983.830866016 
> 195215.744672255,331919.956275961 195192.40348595,331867.009263851 
> 195173.983060295,331825.225138005 195166.148235895,331800.527401443 
> 195166.06336596,331770.313057864 195164.354193523,331741.334364732 
> 195166.057981483,331706.611286021 195166.143964648,331655.732829685 
> 195172.689622159,331444.010996952 195187.986550831,331384.940933246 
> 195189.649391201,331117.303639421 195197.190768982,330602.045126224 
> 195181.160178345,329993.76430872 195087.185505706,329986.130617527 
> 195085.956460869,329752.964416154 195049.986204896,329747.855661712 
> 194747.302731462,329750.5650061 194722.314369002,329744.563413191 
> 194511.183447675,329161.637708436 194352.623816593,329001.636711559 
> 194309.146164288,328875.027654474 194274.727674398,328859.033306372 
> 193781.405186074,328321.173862715 193793.126168494,327953.434743641 
> 193802.898437959,327405.622647004 193817.434202827,327407.689155697 
> 193883.879611069,327194.098067449 193827.981116132,326979.532629794 
> 193767.447345966,326780.396921819 193717.596200167,326581.011992128 
> 193656.637530793,326578.116774299 193556.629965679,326591.376044076 
> 193489.518557401,326407.493139908 193439.237977965,326366.942718618 
> 193351.443030847,326362.433725646 193195.876012259,326365.520011871 
> 193040.08892411,326394.291122198 192983.648847753,326382.900544984 
> 192976.194055719,326374.051049876 192961.992888024,326365.721149771 
> 192923.754765833,326347.296406713 192673.61581121,326341.499141581 
> 192473.601471365,326362.354962016 192406.269593296,326561.78312918 
> 192467.220758647,326598.37486149 192378.748809909,326609.386727088 
> 192352.072830762,326645.625860448 192264.501141599,326652.660721869 
> 192247.50457365,326663.960880434 192220.264317497,326690.390378021 
> 192156.220096745,326696.786826879 192140.799028349,326701.169448933 
> 192029.460192104,326696.99151624 191885.005378748,326694.420481583 
> 191796.110138239,326693.134964495 191751.662526332,326701.086648221 
> 191737.419844746,326609.663519425 191717.933371795,326538.896350841 
> 191702.854843278,326546.542181399 191678.05566136,326610.413949939 
> 191520.51040631,326610.32558449 191506.945106714,326779.177136045 
> 190685.323006956,326781.917765952 190674.901119841,326820.423606119 
> 190528.434876723,326891.464548295 190204.981584619,326906.471819898 
> 190137.376518672,326945.784085872 189960.638743677,327058.368552731 
> 189911.347912409,327117.105524155 189867.282060924,327208.314605539 
> 189783.467996903,327340.944842723 189650.975092197,327342.602308471 
> 189645.144381818,327403.689446845 189426.301533646,327339.91205462 
> 189203.15864252,327247.560019917 188933.575205219,327205.155973326 
> 188729.168582806,327221.678107423 188668.972254918,327287.475939533 
> 188594.900675122,327371.654051087 188498.614561131,327408.242020581 
> 188458.859921329,327386.357677199 188361.95831282,327379.639548294 
> 188128.609731136,327462.936354418 188115.091147547,327492.703042687 
> 188091.992576632,326586.934811727 187550.946075858,326364.375375417 
> 187393.017009493,326346.041049236 187379.98021275,326330.308784156 
> 187370.093222022,326287.528795136 187343.196020374,326148.260678153 
> 187255.705511017,325330.704333088 186742.202123231,323790.423537507 
> 185771.230287212,323671.046559131 185700.115414994,323652.895920867 
> 185706.654440942)))
>
> Robert Burgholzer wrote:
>
>> I would try to verify the following:
>>
>> - the geometrys have been loaded, and have the coords you think they
>> should:
>>    SELECT extent([geom Column name]) FROM [table name];
>>
>> - the geometry has been set to the correct SRID
>>    SELECT getsrid(the_geom) FROM [table name] limit 1;
>>
>>
>> -----Original Message-----
>> From: postgis-users-bounces at postgis.refractions.net
>> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Alec
>> Brecher
>> Sent: Thursday, December 01, 2005 9:35 AM
>> To: PostGIS Users Discussion
>> Subject: [postgis-users] newbie WITHIN query
>>
>> I have searched the docs and am still a bit confused....
>>
>> I have successfully (I think) loaded a set of Washington State 
>> polygons into a table with SRID 2285 (NAD83 ftUS Washington North).
>>
>> When I try to test WITHIN with a point which I know is within one of the
>>
>> polygons:
>> SELECT district,
>>    WITHIN( pointFromText('POINT(-122.916725 47.046528)',2156), the_geom)
>> FROM dist
>>
>> all districts return false. I have tested this point in MapInfo with the
>>
>> same projections and find the point within district 22.
>>
>> Any help would be greatly appreciated.  -Alec
>
>



More information about the postgis-users mailing list