arcgis实习之基于空间位置的属性表连接

《arcgis实习之基于空间位置的属性表连接》由会员分享，可在线阅读，更多相关《arcgis实习之基于空间位置的属性表连接（26页珍藏版）》请在装配图网上搜索。

1、实习二基于空间位置的连接1点点八、八、1汇总连接2.距离连接2点线1汇总连接2距离连接3.点面1汇总连接2距离连接4线面1汇总连接2距离连接5.面面1汇总连接2距离连接6思考注意：SPATIONJOIN基于平面距离，所以必须PROJECT，在LAYERS中设置动态投影GCS_Norih_Americ3n_1983WKID!4269ALrtharitiiEPSGAngdarUnt:Deg-ee(0.017453252519PrimeMeridan:GreenAidi0.0)Daum:D_North_Ama-ican_183Spheroid;S_15flOSemimajorAiis:6379W.O

2、SemiminarAMs63567523M140S56InverseFlattertig:29S.2572221D1广IWD1983HWNUS*4$WIGD;5071AuZtr员&I动态投影癫,IFse上时Mg:D.O芒IFAteJtaTtftXJ:D.O.7tandacd_Parato=i：29,5SCandardparaldM45.,ILJUtudejOngn：曲”0M坤5t：Meterfim1.点点亠八、八、属性表：City4C1T1E5?IDI5Dwpc!#匚mrpepsCITTKUMHETATKfIPSET1TIIUWEfiT*TKCITTPDPlWhaft.kPodit03240X

3、I1:畛AS33Vai.zLr：|ten530314C3ZLT9PMlt立B!VonrarEaaaMscLZE01FflSlt仇刑alLnKton5WL&M11431.Puiit4T5MXimkV-irnsc詔ar:E&47&M17<iPadx.tCukHarbTTaEtihrtcnLTLTbp-ailtW3MIElDt阳忡Mkz-ta3K33M34344FaiixIfllU|KllK-湎皿二3MiXi；311SL1R&as.t7l1X&DflSeethAaJsata3fi92Mi&i3aE.Padr.tPeri:mT3iEE.ir.rtBnLTTLD=F-aiitP-TcirhHur冋I

4、LaTfllLri2t(in5S499H:lF7li14Faiit4995SXazTAYilla.jai-LrttanE34a93E1D3SS1JPodtt7T34ZT-ixeLiiIKV*ni33Vai.zLn|ten337943：LZ33uPMlt22EHIQJastirrtcn3K2MC11P-351TT&ndFwk:岳fiflrntik：TiaSB32W4=42534Roas.tS274SPj:thFl-iLiLFL-fl3t:ssknrv53Eminftcn百皱卓1BE7CI!PadttE&17.*tLaJEi-FdTAri-xtJaEkirrtcn34+：Z24-37+14P-ai

5、itaktStrenfHHithLrrwi-J33JailLrirtcin533T-Ml+ZMjj；PiTiSTd%R-1Mjarrharok;rSlag1riBTfln(flouibf31如SeledBifl:OTIK：CentroidI5DwpC!#ITJ.TZMAHHHTXTXPIPS|snranxcicwSTMTKABBraPL-flIU丄HEFHH1LISVHETRkPoditTai.zLnEtEr:r=LficKR；4L3r4TZ4ZN3333137IPMltW-snrajiEMlnMT793M；33937H+J3ZKTtlLUFflSlt血5ta23:=-MEl2252ESTEW

6、SW79L2DMK.Puiitarhh.】E话讯：KD3lA2：lSMMSW42iPadx.tSasKhail:atjT3iZksaC1EynID:应枷=4B=b沏讯E.Padr.tfraan1：3CXXr：|VT3-tZ?3E7?3+KIETI-SaSSCEE=FfliltKLni4tDtsTVCmMN43T3C993H9?Li54L3Z-3951-&FaiitGrsE.-3n4LPteifuOK23423211357DJ314Ji2435M7Br1JPodtt3-3x-卫：.KMLLG5Q3Z3=N4se3?MLocr-assuPMlt9SCwUZTT9733I43L3S3科已换11P-3

7、51TKflridC-nUfi&XIi：W血Ma丸If427liDMUE34Roas.t11石0卡J(EWTEQBEi花irn删斑l4&：=5E!Padtty-reYoriiUidMLX37W-3439exiru333ESSSSZE-s0r”i亠iri-fb-s0、E1Rgir1.汇总连接1.CITY4_CENTROI2.CITY4_CENTROID_SUMdty_centroid-E-unitenrt厂口idFIDSTATE.flPS:Cpunt.JSmiPQP199缶uni=ElLdLCIf.nnMALESs.=FSiULLB4Z30-I|7=r9O65741111I23B13-57634

8、0325f；这些属性是由count对：-4E-fiE3；4StE937149aDl437473452EM5e胡sac&CM143355431201仙辭37l4375O3&94=k：4S1431B3S22&9l应的记录的数值属性的：13Z792E313STSSDa3CK37S14Wir.，L4313244533EM与甜邛J49S334Hi绎OX63751Z23B34249B35B5&D统计信息、2&12Z21263E7S74617S35FQ73站弧i：r2L1959533777WS3E：291DE451273143I5l33L1109255L037433Ti&E543544M57&EK&3C41

9、17号捋!聋1333S2532B5&D55E-3G47E23381d5S5B8JJTOfil227GOT226SB1巧d27251:-275E55S-D3E1321275492237J2E5hLi.4STId1=-1=.33?gMK-7&3二H：l323LCDl-a-12：31!2ST43001302SE97133127EaMaE2719L2?75：a&saaK1134iBO2L431W30*5ijw?jicri口TPhFM,nr丁匸口匚T1U】*ZiZ-iioerHR(51outof3149Selected这个命令只能得到在源数据中距目标数据最近的的点的数目，却不能得到具体是哪写点（源数据）

10、，至于统计，只是将count对应的源数据点的数值属性统计后，添加到新数据表中2距离连接1CITY_CENTROID_DISTPUHUS：UkUQIDiEtfiru.-WWifiMn中更纟些上1teiziroiiLMPR的0dtyctntroid4Hjisuzh:3.13S3LL313779aiwh.Ejwb*0卜卜i亘j目(i)autDf314?SBlected)fITIESL丄却：J55433Liaass54g332.=5EE3L1O33K54-4333aesie2B：fl54船33LPDE2Z?-5E3E3S44SLE91E2.tL?313E331EUll2H5E3P554购36测jf3B

11、354453S36旺:E3.-S1363543B3L54433336%162.?2(|46将centroid的属性添加到city5.4(3Lies?/l關曲盖3的%：g2715aL12Z=2T255丿2把即弭盂5V355M+3SWBf-755CO4355CO43415+7；2245L1=C1?GR5G22215L24皿百2215LLIS2Z5勢腊35距离连接和near命令作用非常相似，均为寻找距目标数据点最近的源数据点，并将其属性添加到目标数据的复制图层属性表中,且计算距离，添加了distance字段3根据以上推断，centroid-citycount_总和为3249，且最大值大于1记录数为5

12、1（同目标图层）FieldoTCount:Minimum:4MaMimum:Sum:Mean:61.74541StandardDeviation:!FIDEhapeCount.!CfIEE?D)STATHXLffisursjDfciit二:匪詬避MH531kiitI3D2Pciiti逆s253士J3兄i：hDebts:EPciit4SKthOEkDtE4efciit5了=訴&PciztMiscxin.S5IdilwLEJiit12fl七二：sD9Pcizt719JiJZ!l=Dta；Tfciit二13旳宓愛4111Pcizt2211YetIsipihirr33RciitIT二Im.19Jhii

13、tflSCaEsnbisEtti25llPciit9l4KekEik；31J:foiit1=価Teri36:-:oizEnT*1Hin1110*H裁(0outnf51Selerteiillrtnxl|FIT!Statistics;Centroid_city_dist记录数为51Fid-2为最近点的fidFID2CITFIPSCITTNAMESTATEF4223800Gi3tFs.11e207521240ElienstinsL町7200BzLEinaTDk和13?11674ElkRiv&i19fi02795Eangzcn2144M75MarslifieIM严-2314MJ0Pistie4fi25

14、205300Een4175弗盟*MwuilI:PlSHEH-ntML蜩401BOLaconia詰402079AubLizn3拒El12150CssieT託42727060Si&enfielri25437E2SL：Kin.Fq1121545asooofforc&Ete-i2=627O1S55心二已吕19-D-itonrs7Tdl4simrtr-cIlddt-*i1.卜I|curtafS7Q-2.点线RoadROADSrid盃!+T.EMC-THTTfP-HTDtLIEDRTDE4UUT1T?MJTHPelTldn.*-140.3j,1tx.i*n.*-口LVidd.NP盘JnEarxht.*AS

15、1!T口二7ldj=.1EB.or31-i.ltiE=.rldd.W34Zjx-bx(OR.-IC.UTl-5-X.9FalyISn.*-B.-G43ICult-Lun.*-Dvd-d.K*7nCX-dEXHt043-FelrIdm5.419SuitiLbhDi-v-idwd.W94l：TLbrath934FaljrISn.*-B.2OEICult-Lun.*-Dvd-d.K3=7ncx-dExst32EPlrlarLv22.1M3ultiLanDxidd.超494Intvx-atHtv49-Poljrln.*-IB.1S43jIti-Li*n.*-D-idd.K=7nc3Cx3EPelrla

16、rtB.273ultLhhmdN3EIntvra13EQ.Pelyld-R-d13G.Q27M-uItx-Lrr口wKIl*n.Erxt!*PD甘Pltlan74.1MMuItLhh4Dxv-iddN3Elntr1SEIOPolyldnd1SD.173M-uItx-Lrr口二讥日“WKI3TLErX*：Ht*WZ111Pltlan230.9543ultz-Lmrz4DxiddN29XrLtvr1h-Lv13Polyldn33S.-3-ult=.-S-arr*口-viddwKI3tlefx-atVOFolrIdn4173.匪孟3J1T1-L&n4DividedNJncarsiaT:ariaTC1

17、3LtHolyIdn.aE.3293uItx.-Ekha口dw斗39Int-axsBtaIMAj-fc33RhIIt1nadTqaVai1t1ronaHiVirlcrlN3STnraretstcNotes数据1汇总连接1ROAD_NODESJainDtsWhatdoyouwanttojointothislayer?JoindatafromanotherlayerbasedonspatiallocationE:ancgis_shbaEX2dart3fenxiVROAD_NODE|shpdboutioi门inqdata3.Theresult(?ftinejoinwillbesavedintomne

18、wlayer.Specifyoutputshapefilearfeatur亡dassfbrthisn亡剧layer:Joinletsyouappendadditionaldatatnthislayersattributetablefarewamplejsymbalinetinelayersfeaturesusingthisdata.inteUMinimum二|StandardMaximumVarianceOAverage|3Suminklii-!1.ChoasethelayertojointothislayerTorlodspatialdatafromdisk:2.Youarejoining:

19、SelectajoinfeaturedassaboveYouwillbegivendifferentoptionsbasedongeorrietrytypesoftiiesourcefeaturetla召呂andth亡joinfieBtur亡匚hss.Eachlinewillbegivenasummayoftlipointsthatane:礼匚ountfidpwillalsobeaddedshowinghawmanypointsareinteraectedclosesttoit,andadistancefieldshowinghowclosethatpointisjntheunitsofthe

20、tangeftlaryer).POINTSTOine从源数据到目标数据的选择，有两种模式,相交和最近CtatisticEroadntintresiFID?clr：L!PclFlLITPclFlLIPclr?LI二PcIfIli:fOlflLI264PdrlLi311斑Pclrlj34S351?clr-jJtt1ia2552d:Closested时，同一个点位于两条线交点时，距离均为零，即被使用了两次然而：当反过来连接时Node_roadJoinDataJoinletsyouappendadditioraldatatothislayersattributetablesoyoucan,forexa

21、mpleTsymbolizethelayersfeaturesusingtiiisdata.Whatdoyouwanttojointothislayer?Joindatafromanotherlayerbasedonspatiallocation1.Choosethelayertojointothislayerorloadspatialdatafromdisk:ROADS2Youarejoining:LinetoPointsJ)推测：结果为count结果有零值不同与cloestSelectajoinfeaturedassaEBUL.YuujullBl=giwendifferentoptions

22、basedongeomeirytypesofthesourcefeaturedassandthejoinfeaturedass.linesintersoEachpointwillbegivenasummarv叮inenumericattributesofthelinesthati出and口countfieIdshowinghowmanyHowdayouwanttheattributestobesummarized?UAverageMinimumZlStandardD.eviatiQnSumMaumumVarianceEachpointwillbegivenalltheattributesoft

23、helinethatis匚losesttort,andadistancefieldshowinghowclosethatlineis0ntheunitsafthetargetIsyerJ.IS)3.TheresultofthejoinMilbesavedintosnewlaer.Specifyoutputshapefileorfeatureclassforthisnewlayer:E:ancgis_3hbdEX2dafeiJoin_C)LitpLrt.shpAbciutioinin口dataCancel使用pointtoline有两种方式，interest与closested，前者计算和线和点

24、相交，而后者计算点距那条线最近，这是，就会出现多可能问题，点距两条线距离相等，在统计时，被多计算使用linetopoint是，只计算相交的2距离连接Node_road_distncid?_ra3d_c(5lJIuuJtmiKrrWU!这些点在线上或位于_.t_ii阮tnnb-DEL2L.E：WulEi-Li/:*EXvidd0s97.QT-SMulti-L-uieDL：4e;3线的交点Gll9.S3Mjlti-LimDividedaaa0DE3:EE.3KWulEi-Li/:*Sv諾20tr乳月號Multi-L-tneDLvi.jeflND0g3.67EMult-LivDividedDaoD3

25、1LZD.4ZZKultl-LiDLuudi-dX33:nc*ri.Ea-：3Z住0:H55PavfclUidivcdti33i；.SiHwr旳D000左SS.296血IuLhqDlVLdH94aa0D33LJL.SdSKulti-LiBDLuisii-dXT4:nELEi*:i-54QgJt?477175.631y闪luberrtiaTe13打32E31Z.3Q33Cult-La-BLvLdi-dXL3:nE*r&ca-：1200Qi79.WWult：-LEncWvided3DZnteTstatEW.Gt43D百04$6.362Wulti-LuiflOLv：dd*?ahUTrCfllfil7

26、0rS3973Sa6Cf花乳孟fnt*匕“403M-l23HX1iH巨oF165elprlEdJ：7E37d3H可以看出位于道路上的点，距离为零，可以看出，和near结果相同上图的圈点）最近线只是83号吗？为什么一个点只对应一条线Locatiom-1CH.E63B1441.111O5BDecimslD咚gr吐sFieldYbluaSTATEJJfllSTATEFIPS5UE-PE&I0MSTATE_ABBKrOT199D0HALES0FEMALES0flHITEnBUCK0HiEtafLca0RTEJIUm25LENGTH288.306FID3aOADS_FIB3-aHDUTEIniatefa

27、ta25TYPEIflulii-LarieDiv:ded70LUDKL；L”.-.ft-aT.+这个也和near命令相同3点面State数据:rm*STIhrE?U.I1ISTilTlFEFSPlFlinQ14192-1ih-ltL-lantMvilanKInt4r=to.ta1PlFlinQ皿.*&ih-ltL-lantMvilanKInt4r=to.taPlFlinQ9.42ih-ltL-lantMvilanK94Int4r=to.taPlFlinQ9-J2-9MultL-laniMvilanK94Int4r=to.ta4F-d-IfIinaa.=ohMulti-Lan*K33Int*r*

28、ts.tQ335F-d-IfIina22.iHMulti-Lan*K19*4Int*r*ts.tQ34EF-d-IfIinaLB.L34Multi-Lan*K33Int*r*ts.tQ337F-d-IfIinc*B.797Wulti-Lan*K33Int*r*ts.tQ331|言日0口就of679Sdedffd)Few-roadRIOShaae慕LENGTHTYPETODRTEW1ROUTECFolyline9-6.IDF2P4F=1FFF3FLcuri;Mnnum:3Mamum.7Sle:4LIMrcn:&TableLJ-倉k哥色区胡fewroadtCounFIDPalrlinePolyli

29、nePolylineiEfOADSPIDLine2line计算和线相交的线（包括重合的），所以count综合远大于源数据个数，且两种连接count总和相等2距离连接Iinuiiiiiiidxiiuuiii|_|vdridriteaEactilinEwillbegivenmilth已sttibutesefth已linejintfielayerbeingjoinedthatitispartof(j.e.asubEtringaf).Forexamplejifihelinerepresentsapartianofaraadandth亡lay亡beingjoin亡dcontainsafieBturerepresentingHieentirercadjtiieattributesoftJieentirereadwillbejoinedtoHieportion.1.ROAD_FEW_SUB这个指令会将few中属于road的线属性添加到road中3FEW_ROAD_SUBrvcroi3d_sublLENCTHT/PETOLLRERTEMUM1RourizFID2RC31DSLBHCTM