图论中间件技术学习：rasterNULL 博文链接：https://flyqantas.iteye.

文件名称: 图论中间件技术学习：raster

所属分类: 其它

开发工具:

文件大小: 627kb

下载次数: 0

上传时间: 2019-08-10

提供者: weixin_********

下载 (627kb)

不能下载？报告错误

详细说明：NULL 博文链接：https://flyqantas.iteye.com/blog/22164513D Geometry Polyhedral Surface CREATE TABLE test3d(gid sErIAl PRIMArY KeY, geom geometry)i 工 NSERT INT○test3d(gem) VALUES POLYHEDRALSURFACE( ((000,005,0155,0150,000)) ((000,0150,10150,1000,000))r ((000,1000,1005;005,000)) ((1000,10150,10155,1005,1000)) ((0150,0155,10155,10150 0 150))):: geometry 3D Geometry Triangular Irregular Network (TIN) INSERT INTo test3d(geom VALUES(TIN(((123,456,789,123))r ((101112,131415,161718,101112)) ((192021,222324,252627,192021)))":: geometry) 3D Geometry ST ASGML SEleCt gid, ST AsGMl(3, geom) As gml FRom test3di result 1 . 2 . /gml: trianglePatches> PostGis goes 3D Open Source Desktop viewing None yet, but Gvsig upcoming version will have at least 3D support to view simple 3D(not TINS/Polyhedral). With st 3DShortestLine and Geometry Dump tricks can get to display polyhedral Surfaces. Using PostGIS Affine Transform functions e.g ST Affine*, ST Rotate*, ST Translate-can move TINS/Polyhedral Surfaces and other 3D geometries Snapshots from nicklas avens postgis post http://www.postgis.org/pipermail/postgis-users/2011-january/028658.html With associated SQL http://www.postgis.org/pipermail/postqis-devel2011-january/011302.html PostGis 2.0/PostgreSQL 3D Use Case Resource Management Arrival3d(nEwventure):http://www.arrival3d.com Collaboration with Network Optics Engineer and VRML/X3D Expert Web-based PHP/JQuery/X3D X3D scenes autogenerated from database objects viewed with BS Contact X3d web-viewer PostgreSQL 9.0 resource reposito with LTree for managing resource node relationships / incorporating PostGIS for more analytics (right now ust 3D resource node points and a postgre SQl inventory model server to place the models centered at the nodes) Cataloging cable pathS, summaries of terminations etc, Closest point for determining optimal paths Integration with existing Telecom Provisioning and Alarm Systems PostGIs/ PostgreSQL 3D Use Case 48 dubno she f FILTER Object Files and Manuals rEsults Column test file: New column Circuit order: dataconni telvent test demo: new structur model adc ds 3 2-pt 4n tan Rounding Audit 9-1-2009: ground bar Lebert blower user manual: liebert blow Grounding Pro]osal: ground bar Download upload Project Files 1Results Ca Alarms AA 154: FMA 154LA02 Power MOP Download Upload Room Details E beilin- 600 w 7s foor 1 s roo LA02 Details Pos/RotyConnections E POSITION C ROTATION 005 D xnot. 0 2 DZ Tot. 0 View mode o tree sear -Huilding: 600 W7 oor +hroom: Battery Collocation Electrica LA2 isle: 0109 se;0110 Filtering Objects on the fly s 应直了重0 st Y FM Are y coeben LaEr 升ubno3 Cable Congestio 色 ② Lde rxd damthiiia 上wLa Postis.0 Raster For more information http://www.postgis.org/documentation/manual-svn/rtreferencehtm Key Features Georeferenced rasters in the database uses GisT index like Geometry New data type called raster'-one row= raster tile One table raster coverage Python Loader utilities built on GDaL -can load in any kind of raster and bulk load many raster files Intersections, Intersects with Geometry data Extrude raster regions as geometry Ability to create pyramid (overview tables on load Can export raster data to any raster formats supported by GDA( Ql pixels Analysis- do averaging of pixel ranges in areas, extrude individu In place edit on rasters and ability to create new rasters Single band mapalgebra, just completed this week Rendering tools already available and undergoing fine-tuning

(系统自动生成,下载前可以参看下载内容)