[postgis-users] newbie WITHIN query
Alec Brecher
alec at eresearchresources.com
Thu Dec 1 07:04:53 PST 2005
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
--
Alec Brecher
AtomD / E Research Resources
office: 802 253-8908
http://www.atomd.com
More information about the postgis-users
mailing list