交通规划课程设计

1、深圳大学交通规划课程设计姓 名：胡克川学 号： 2011090100专业班级：交通1班系（院）:土木工程学院指导老师：吕慎设计时间：2015-2016学年第2学期交通规划课程设计任务书1.设计目的通过课程设计使学生对交通规划课程的基本概念、基本原理以及模型与方法得到全面的复习与巩固，并且能在系统总结和综合运用本课程专业知识的课 程设计教学环节中，掌握和熟悉交通规划预测的操作程序和具体方法， 从而为毕 业设计和将来走上工作岗位从事专业技术工作打下良好的基础。2.设计内容无约束重力模型进行交通分布预测交通网络的计算机建模非平衡分配法（包括全无全有交通分配、容量限制-增量加载分配、多路 径概率分配）

2、和平衡分配进行交通分配预测设计题目现有一规划区域，共划分为 5个交通区，经调查其现状 0D分布见表1,各 交通区间的出行时间见表2,通过对各交通区的交通生成进行预测，得到各交通 区未来交通产生、吸引量见表3,分析计算得到未来各交通区间的交通出行时间 见表4,试用无约束重力模型进行交通分布预测，收敛条件为；乞3% o表1交通区1234511000500300200100245015005001001503350200800300504150150300700505801005070500表2交通区12345151018203021241025203151081535420251510305352

3、5353512表3交通区产牛量吸引量150004000240004500330003500425002500520002000表4交通区1234515101215202104820203101071030415201082053020303010如下图所示的交通网络，其中节点 1、3、7、9为出行生成点，其余节点为交 叉口，4个生成点之间出行分布如表1所示。网络中各路段的零流量的出行时间 和通行能力如表2,交通阻抗函数为tj =toi/(1-Vi/CJ。请用平衡分配法确定各路段的交通量川皿VVIWI T T忸区X幻刘图交通网络图表1 OD表137910202050330040107403002

4、093040300表2各路段零流量的出行时间和通行能力表InVVVDIXXto333243233542C180100501005050100806050501004.设计成果采用手工的方式计算，提交成果包括设计计算书和计算结果， 要求计算书提供 每一关键步骤的计算。采用计算机编程的方式计算，要求提供计算机的原代码、输入数据文件、输出 成果文件、程序流程图和必要说明（包括变量说明等）。采用软件计算必须有输入和输出文件和详细的计算界面。课程设计成果设计一无约束重力模型进行交通分布预测使用软件：SPSS Excel。设计步骤：根据无约束重力模型q厂心D/j应先求出代标定参数a、B 1、B 2和丫，再

5、根据模型计算一遍分布交通量，最 后通过数次平均系数法迭代得到最终分布交通量。一、使用Excel处理数据并进行运算根据重力模型，两边取对数得In(qij)=ln a + B iln(Oi)+ B 2ln(Dj)- 丫 ln(cj)转换式子为y=ao+aiiXii+ai2Xi2+a2X2参数定义：y=l n(qij), ao=ln a, ai= B i, ai2= B 2, a2=- 丫，xii=l n(O i), xi2=l n( Dj),X2=l n(Cij)。为方便计算机处理数据，将现状 OD分布和现状、将来行驶时间t的矩阵型表 格转化为目录型表格。根据参数定义和OD表数据，计算出各OD点对

6、的对应样本数据如下：样本数据1jOiDjcijyillxl2k21110002100203056.9A7S7.&1977-6157910721.60941250021003450106.21467.64977.038413042. 30261330021001950185. 70337.64977. 5755846522. S9041420021001S70一常丘曲S37.6J97T. 222566G19Z 9967S10021008S0304. 60527.64976.74523634$3- 401221颂27Q02030126.10921 90107.-615791072Z 4B49221

7、5002700245047.31337. W107- 803343304L38632350027001950106.21467.90107. 5755G46522. 302624100270013702a4.60S27.90107. 2223660193.21W251.5027008S0205. 01067.90106,7462363492. 9957335017002D30155. 35797. 43347.6157910722. 70813220017002460W6, 29837.W47.S038433042. 302653SOO1700195086.63467.4JB47a575846

8、522. 07943430017001370La5. TOSS7. 4847. 2225660192. 7081355017008&0353.91207.4SS46. 7452363493.5553411.5013502030205. 01067. 20797. 6157910722. 99S742150135024S0255.01067.20797.80334330412109斗3300135019S0155.7O3S7. 20797.5755646522. 70814470013501370106.55117. 2OT9h 2226&0192. 302645501350850303. 91

9、207. 2079& 7452363493. 40125180SOO2030354. 38206.6S467.SI57910723.55a3521.00SOO24502a4.60526.63467.S0384S3043.21895350SOO19S03d3. 91206.6846T.眺 BB46S21. 5553S4708001370药4.24SS丘曲骼7.2225660193一 5553555008QQE5Q126.2146.6B4&6. 7452363492.4849二、使用SPSS软件进行回归得到参数值将计算得到的y、X11、X12、X2数据复制到SPSS软件中进行线性回归分析护土未嗣J

10、.固甩劣5 - IEM SPSS Statistics数届滴指器交件日會辑观图呵数据側转换分析 宜梢世1圈形回实用程序辿）窗口&耦肋X1116917 6526217 6535.707.6545307.554617J5566 117.9017.317.90Q6 217 9094.617.90105.017.90115 867 4斗125.307 441366S7.44145.707 44153917 44165017 21175017 21185.707 21196.557 21203917.21214.386.6fl224.61&es23391ALAS244 256.6B356216 68nf

11、报告 昨光计 裹 比載均tt（M） -股糕性ISM（G*广义域性損型飆合模星送）相吴卜回归迟】拠娄性棋型*祸盏网堆做日*隆维匿罐3非奏数检验迪）卜0（1），生存函（S）*拿盍响直妙*皤缺矢值分析世势重归因（D*集阳由样）*质量畦制（3）*riROC曲线图世）.辰叢量J变畳!变爲国自动拔性建掾凶idW-込曲线佶计. 囤部分最小罕方E3 二兀 L四islic . I 多项 Logistic 日有序-.S Fnobit.田非线性邑匚吕枳重估计 园两齢則二乘迭最佳 rafetCATREG）.7&07.587.226.753 223.563.5C2 43因娈呈|卫）: k块啲1上 Tkd j自娶虽（!）

12、.4 A I 1Zxiz少x2方法画：透入取消塹怦辿.绘制CQ.保存坯项Bol rrirl -iWbR-椁耐1n-1IHJIt itllf4an3MCK ff.IklTT99-n：.-： nJ.sli-IK*：tM*EtvmEll !f134T SBr719IJi Mi2MlFW1m2-4MOHW31-HJ-IOi!4111 lUWtg BRGRES5IC*IJMSV-KUSHMSEJ5TAH5HC5 coot own r jCHjTERM-RtJcOSlPCUTLWl .iHOonaN jQCPWWEf .iWlHOO-BiTO ?：n k3J J.系数a模型非标准化系数标准系数tSig.B

13、标准误差试用版1（常量）x11x12x29.967-.019-.012-1.5512.496.187.200.142-.008-.005-.9543.993-.102-.061-10.909.001.920.952.000a.因变量：y由SPSS软件得出ao=9.967, aii=-0.019, ai2=-0.012, a2=-1.551根据参数定义算得参数值为a =21311.455, B i=-0.019, B 2=-0.012, 丫 =1.551标定的无约束重力模型为/ 厂厂 /-v 0.019 0.0121.551q厂 21311.455QDj -q三、使用Excel求解已标定重力模型

14、的交通量由重力模型和样本数据，使用Excel计算分布交通量得到下表交腿：1j2J3J4j5QIU/0il1385.7935471.968o356.610?253.3569163.09492630.7294aOOO1.9000941247G. 69161945.145S665.6473161.3909162.31803405.183640001.17167968?浅4718371473.766&826.051487.31052339.048830001.282572667142512900163.393T477,1516677. 3350164.01735.640125001.44039075&

15、15S7.64M161016288.0641邮 7448914.166420002.187785449D267125163217,19092413.15781657.22991063,9381lim 7693Vm450035002500200016500V/D1.4963050871.39S7357581.4503817421.508541477L 879808694四、使用Excel进行平均系数法迭代第一次迭代：取重力模型分布交通量中的 V/D和U/0数据，根据平均系数法得到各点对应的 系数ijFOFD平均系数111.9006135941.4963050871.698459341121.90

16、06135941.3987357581.649674676131.9006135941.4503817421.675497668141.9006135941.5085414771.704577535151.9006135941.8798086941.890211144211.1746796871.4963050871.335492387221.1746796871.3987357581.286707722231.1746796871.4503817421.312530714241.1746796871.5085414771.341610582251.1746796871.8798086941.

17、52724419311.2825726671.4963050871.389438877321.2825726671.3987357581.340654213331.2825726671.4503817421.366477204341.2825726671.5085414771.395557072351.2825726671.8798086941.581190681411.4403907581.4963050871.468347923421.4403907581.3987357581.419563258431.4403907581.4503817421.44538625441.440390758

18、1.5085414771.474466118451.4403907581.8798086941.660099726512.1877854491.4963050871.842045268522.1877854491.3987357581.793260603532.1877854491.4503817421.819083595542.1877854491.5085414771.848163463552.1877854491.8798086942.033797071将各0D点对的交通量乘以平均系数得到第一次迭代的交通分布量表格，整理为矩阵型表格如下:L次送代廿算交道区jLj2j3i产JO0fil23

19、53.7138778.42M5&L 5087431.8665308.28384469,8023oMC1.11861771712628.59172502.8341873.6826216.6237247.郦24469,5313m0.89434842613659.75716311 函1128.7805&65.7965138.05433227. 546030000.929J987J9i4373.3862230.5232689.6683998.7076273.03632665.3265俪flL974534818i5161.454329J. 12391W. 5187162.7568989.94021767

20、. 79392&001.131353&0234176.90314441.07293449. Ib872476.65111957. 214116500. 0000V4000J50Q350025t200016500系瓠D0.9576472961.01326S6551. 014740191. 009835361.021S60616未达到收敛标准 =3%，继续进行迭代。第二次迭代：ijFOFD平均系数11L1186177176 957647296L 038132506121.1186177171.0132686551. 06594318613L118617717L 014740191. 0666789

21、5314L1186177171. 009835361. 064226538151.118617717L 0218606161.070239166210. 894948426Q. 9576472960. 926297861220. 894948426L 0132686550. 954108541230.8949484261. 014740190. 9548443082 40. 8949484261. 009835360. 952391893250. 894948426L 0218606160. 958404521310.9294987490.9576472960. 943573023320. 9

22、29498749L 0132686550. 971383702330. 9294987491.014740190. 972119469340. 9294987491. 009835360. 969667054350. 929498749L 0218606160.975679682410. 9745348180.9576472960. 966091057420,974534818L 0132686550. 993901736430+9745348181. 014740190. 994637504440. 9745348181.009835360. 992185089450. 9745348181

23、.0218606160. 998197717511.1313536020.9576472961. 04450044902L 1313536021.0132686551.072311128o31. 131353602L 014740191. 073046896541.1313536021. 009835361. 070594481551.1313536021. 0218606161. 076607109*jlj2j3j4j50U辎U/Qil2443.4668829.7616637.3500459. m329. &3744700,11955M01.06J802733i2582.26322387.9

24、7548312308206.2154237.58774248.27254m0.94155918213622. o290616.98151097.3095645. &010134. m311 j. 1180am0.962427479i4360.7250229.12236S5.9700MO. 9028272. oU22639.2643SjOfl0.984o37131io1.68,639131&. 3923171.1710174.狮106a. 77671895.22572&001.03307D4177.62324379.23313426.03132476.56942040.543016M. 0000

25、V40450035002500测16500删/D0.95 幽2245L 027577181021590211L 0094608960.980131246未达到收敛标准& =3% ,继续进行迭代。第三次迭代:ijFOFD平均系数111.0638027330.9574822451.010642489121.0638027331.027577181.045689957131.0638027331.0215902111.042696472141.0638027331.0094608961.036631815151.0638027330.9801312461.02196699210.9415591820

26、.9574822450.949520714220.9415591821.027577180.984568181230.9415591821.0215902110.981574696240.9415591821.0094608960.975510039250.9415591820.9801312460.960845214310.9624274790.9574822450.959954862320.9624274791.027577180.995002329330.9624274791.0215902110.992008845340.9624274791.0094608960.9859441873

27、50.9624274790.9801312460.971279362410.9845371310.9574822450.971009688420.9845371311.027577181.006057156430.9845371311.0215902111.003063671440.9845371311.0094608960.996999013450.9845371310.9801312460.982334189511.0552833070.9574822451.006382776521.0552833071.027577181.041430244531.0552833071.02159021

28、11.038436759541.0552833071.0094608961.032372102551.0552833070.9801312461.017707277第三次送代计算交駆Jlj2j3J4jo0Ujgftivoil246914皿肌碑664.562647& 439933118514815.332350001,03S349936l2顽.87092351.1246813.8599201.1652228.28504152.3056m0.963320227i3597.5997613.89S110815407636.5265130.82&43067.383530000.973029082it35

29、0.2675230.51&2688.0715987.9291267.729525245078350&0.9W29205i5169.7155328.459117L 7M3179.8S7210B4.648T1940.460820001,03030 历D4139.92514391,66523437.785024S1.94792O4S. 676316500.0000V46fl0J50025W2M016o00系亂ID0. 966201057L 02466S273L 0180974161.0072733440,976239889未达到收敛标准 =3% ,继续进行迭代。第四次迭代：ijFOFD平均系数111

30、.0383499360.9662010571.002275497121.0383499361.0246682731.031509104131.0383499361.0180974161.028223676141.0383499361.0072733441.02281164151.0383499360.9762398891.007294913210.9633202270.9662010570.964760642220.9633202271.0246682730.99399425230.9633202271.0180974160.990708821240.9633202271.0072733440

31、.985296785250.9633202270.9762398890.969780058310.9780290820.9662010570.972115069320.9780290821.0246682731.001348677330.9780290821.0180974160.998063249340.9780290821.0072733440.992651213350.9780290820.9762398890.977134485410.990292050.9662010570.978246554420.990292051.0246682731.007480161430.99029205

32、1.0180974161.004194733440.990292051.0072733440.998782697450.990292050.9762398890.98326597511.0306830150.9662010570.998442036521.0306830151.0246682731.027675644531.0306830151.0180974161.024390215541.0306830151.0072733441.018978179551.0306830150.9762398891.003461452瓢恥側算交駆J1卫J3J30E170112475.0M7895.012&

33、組 3189487, X339.64494380.37571.0245112881253133812331 004331L2517198. M75221.38634101.23/8WOO0.97531529713观 9357614.7260108&. 4325631, m127.83703041.7800册Q. 98626462614MJ.6M0232.2344飙 95T8986,7265263,24932515.816025M0,993113373i5169.4511337.5191192,0857183.3012IM 10321960.79052JJL QI 哪 67944101.5136

34、4416,52713454.04662487.39222040.520616500.0000V4500350025M200016500V/D0.9752497261.0189001291.0133042181,0050686960.980142043达到收敛标准 =3%。综上，满足要求的交通分布量如下表所示:交通区1234512475.0907895.0129683.3189487.3083339.64492533.38812337.0043811.2517198.2075221.38633580.9357614.72601086.4325631.8488127.83704342.648023

35、2.2344690.9578986.7265263.24935169.4511337.5494182.0857183.30121088.4032设计二平衡分配法进行交通分配预测使用软件：Tran sCAD。设计步骤：使用TransCAD的交通分配功能直接进行设计。软件使用步骤如下:打开软件，点击菜单栏file new创建Geographic file文件，选择建立类型为line geographic 的文件New Geographic FileChoose a Type of FileC gointGeogiaphicFil+New File Line Geographic FileC Aia

36、a Geographic Filep Layer SellingsName New LayerOptions厂 Add ihs leisr toUis urrsntinnBip windShowihe Isyer in a n?w map winderEndpoint Layer SettingsName (New End point LayerCreate a Table for endpoint dala在属性窗口添加出行时间和通行能力，点击 0K储存图层点击菜单栏ToolMap Editing Toolbox弹出Map Editing小窗口，根据题目线路序号的顺序，绘制路网：E8 Map

37、l - Ne-w layer口 I 回 3*,J _ *ll_11h, !Check line Layer Conn亡ttiStyNode Layer New Endpoint LayerLine Layer New LayerNode Selecticn All.Threshold |o.Ql| Feet.检查路网连通性：点击菜单栏Tools Map Editing Check Line Connectivity，选择提示即可。Threshold 精度为 0.01 进行校准，点击 OK 得到 No Connectivity Problems FoundOKCancel切换图层为 New En

38、dpoint Layer，点击菜单 Selection Settings,弹出窗口点击Add Set增加设置，并改名为OD点击Style进行样式设置如下Style (OD)TypeC Color Bitmap Font CharacterIcons:Font |Cahper CartographicTW Symbol Fcnts OnlySize 画3Color |T-Style二 BoldllabeOK | CancelApply-LRS Layer Settings- Posiliori |点击菜单栏 ToolSelection,得至U New Endpoint Layer Selecti

39、on工具窗口hfew Encfcoint Lay&r Selection|ODSample:Records: 0Z + E点击Tools工具窗口中的select by Pointing,用shift+左键选择1、3、7、9节点SB Map! - New L白密Tools X4 M-i塞|te Mrrr宅刿T V 口O e ws what Label TtCancelApplyRemove Manual.点击ffllNew Dataview输入数据ilDjLanglhUirlHNlluaEEAJl12-1 .BQ03BQ2flq3inn3507n.?D02inoB14 73DHng14.9403fiOi1QIl .凸Ol5EOin?l BD114nn1221JG101Q0iUSMew 5艸选择菜单栏planningtraffic assignment进行交通流的分配，按图中进行设置, 点击okTraffic AssignmentNewLayerLine LayerNetwork File惶口蟻瑁纬躺杓芒第二题収ETJ4ETCanc