求arcsde 9.3 for sql server 下载拜托各位了 3Q_百度知道安装sde 9.3 for oracle 10g ,
[问题点数：40分，结帖人wildwave]
安装sde 9.3 for oracle 10g ,
[问题点数：40分，结帖人wildwave]
不显示删除回复
显示所有回复
显示星级回复
显示得分回复
只显示楼主
2011年8月 总版技术专家分月排行榜第三
2012年10月 荣获微软MVP称号2011年10月 荣获微软MVP称号
本帖子已过去太久远了，不再提供回复功能。Using ArcSDE 9.3 with PostgreSQL, Part 2 | geoMusings
geospatial technologies and practices
In my , I discussed some approaches to configuring
databases and accessing the data in them with
9.3. For this post, I will describe some of my ongoing experiences with getting data into ArcSDE 9.3.
There are two main ways that I am investigating of loading/making available your spatial data in ArcSDE 9.3 for PostgreSQL. The first is the traditional method of importing a feature class via ArcCatalog. (You can also create data in this manner but I haven’t played with that yet.) The second is to register an existing
table as a layer using the “ -o register” command-line tool. I will discuss this latter option first.
My first experience in trying to register an existing layer met with abject failure. I was greeted with an error message stating that I had to be the owner of the table in order to register it. I was already aware of this fact via the online documentation and I was, indeed, the owner of the table.
I hacked at this numerous time, parsing through PostgreSQL and ArcSDE log files to no avail. I did find some cryptic messages referring to tables in a “postgres” schema (which I didn’t have), but generally found nothing helpful.
Next I turned to ArcCatalog and decided to import a shapefile and see how well that worked. I set up an ArcSDE connection as depicted below.
I was able to connect just fine but my first attempt to import a shapefile failed with a message saying it could not create a feature class named “arcsde_test1.postgres.fema_regions”. At that point, I realized that ArcCatalog was assuming that I was importing the data into the schema of the user that I was connected as. The “postgres” user is the equivalent to SQL Server’s “sa”. PostgreSQL doesn’t create a schema for it automatically and I don’t typically create one for it in my databases. In this case, because I was testing, I did (not sure if that’s a good practice or not). I did so using the following SQL in pgAdmin III:
CREATE SCHEMA AUTHORIZATION
This creates a schema for the user that will own the objects in the schema. Once this was in place, I was able to import my shapefile with no issues. I did make sure to use the PG_GEOMETRY configuration keyword to ensure that the PostGIS data type was used.
This got me wondering about my earlier registration problem. I went back and used shape2pgsql to import a shapefile into the newly created postgres schema and then attempted to use the sdelayer utility to register it with ArcSDE. This time it registered! What I learned is that, in addition to being the owner of the table, the table must be in the schema for the user that you are using to register the table. In my case, it wasn’t enough that the “postgres” user already owned the table. The table also had to be in the postgres user schema in my database.
At this point I had one layer which had been loaded via ArcCatalog and using PostGIS geometries and I had another copy of the same data set loaded via shp2pgsql and registered via “sdelayer -o register”. It was time to check the behavior of each. Because I was using PostGIS geometry, I wanted to test both layers in ArcMap and in .
First, the layer registered with the sdelayer command-line tool. This layer did not initially draw in ArcMap after it was registered. With a little investigation in ArcCatalog, I realized the X and Y offsets, the scaling factor and XY cluster tolerance were not set. I will not go into an ArcSDE tuning discussion here but suffice it to say I was able to rectify this problem. I have used the “sdelayer -o register” approach in the past with Oracle Spatial and did not have to take this step so I am chalking it up to a “beta-ism”. I will submit this as feedback to ESRI. The next two images show this data set. The top image shows it in ArcMap and the bottom shows it in uDig. Both applications are reading the same PostGIS data set. Bear in mind that additional tuning was required in ArcSDE and this tuning will need to be maintained separately but, as of this point, both applications are reading the same data set.
With this having been accomplished, it was now time to see what I could do with the data. Since I believe in jumping in with both feet, I went straight to editing. My test was pretty simple: with both ArcMap and uDig pointed at the layer, I did the following:
1. Add a new feature using ArcMap and save it (the big triangle in the Northwest).
2. Refresh the display in uDig to show the new feature.
3. Modify the feature in uDig and commit the change.
4. Refresh the display in ArcMap to show the update.
As can be seen from the series of screen captures, this test worked flawlessly. I have also been able to render the data in both desktops and perform analysis on it. It is important to remember that this test only addresses PostGIS layers that have been registered with ArcSDE via the “sdelayer -o register” command line tool. In my next post I will dig a little deeper with the layer I loaded via ArcCatalog.
Rate this:Share this:Like this:Like Loading...
About Bill Dollins
I've been designing and implementing geospatial systems since the early '90s, using both commercial and open-source technologies. I am available for consulting and can be contacted via the e-mail address on the 'About' page.
This entry was posted in , , , , , . Bookmark the .
feeds…&&
Eid as a holiday in the country
Middle class incomes had their fastest growth on record last year
github is the new ftp
using 's powerful extensibility!
Disclaimer
The information in this weblog is provided "AS IS" with no warranties, and confers no rights.
This weblog does not represent the thoughts, intentions, plans or strategies of my employer. It is solely my opinion and probably incorrect.
Follow &geoMusings&
Get every new post delivered to your Inbox.
Join 29 other followers
Send to Email Address
Your Email Address
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.
%d bloggers like this:君，已阅读到文档的结尾了呢~~
ArcSDE 9.3 for SQL Server 安装指南 - ArcGIS SDE 9
扫扫二维码，随身浏览文档
手机或平板扫扫即可继续访问
ArcSDE 9.3 for SQL Server 安装指南 - ArcGIS SDE 9
举报该文档为侵权文档。
举报该文档含有违规或不良信息。
反馈该文档无法正常浏览。
举报该文档为重复文档。
推荐理由：
将文档分享至：
分享完整地址
文档地址：
粘贴到BBS或博客
flash地址：
支持嵌入FLASH地址的网站使用
html代码：
&embed src='/DocinViewer-4.swf' width='100%' height='600' type=application/x-shockwave-flash ALLOWFULLSCREEN='true' ALLOWSCRIPTACCESS='always'&&/embed&
450px*300px480px*400px650px*490px
支持嵌入HTML代码的网站使用
您的内容已经提交成功
您所提交的内容需要审核后才能发布，请您等待！
3秒自动关闭窗口：转载时请以超链接形式标明文章原始出处和作者信息及本声明
开始安装很顺利，只是最后一步时候报了个错误：
Can not start arcsde，check for&&zombie processes
忽略掉，把services中的esri_sde服务启动，在ArcCatalog中使用sde连接数据库也能连接诶，随便找个 shp文件也可以导入，只是 每一步操作都得输入机器名和数据库名重新连接。
然后我做了一些操作：
（在ArcSDE安装帮助文档里又这个要求：
sqlplus sys/***** as sysdbaGRANT EXECUTE ON dbms_pipe TOGRANT EXECUTE ON dbms_lock TO
也参考了这个日志：
使用命令：sdemon -o start -i esri_sde -p sde& 启动服务
3sNews.Net&&最具影响力的中国地理空间信息门户网站j X&h{E
其实这些没多大用，我已经在services.msc里启动了服务了。
做了这些操作后，
运行 Post Installation 还是会出现这个error：
Can not start arcsde，check for&&zombie processes
后来我重新启动下机器，重新通过sde连接数据库，保存连接，这下好了，难道是我一开始忘记保存连接了？
可以认为 这个error没甚么~
此外，为了使局域网机器可以连接，需要添加Tcp5151到防火墙的入站规则里。
以前不知道怎么整，今天仔细看了下在 控制面板 高级设置 新建入站规则 即可
引用地址：