[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: [postgis-users] Converting data from SDE 9.3 sql server database to
From: Toni Hefer <THefer () landadvisors ! com>
Date: 2008-12-30 20:49:59
Message-ID: 9AEDE8F6C1867249BCDE7CFDD83B3FA52DE35E3F03 () shelley3 ! webville ! net
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi - we have created a postgres database and are in the process of copying =
the + 50 Gb of vector data in about 53 different feature classes into the P=
ostgres database. I am finding some very strange behavior when I use the PG=
_Geometry keyword, some of which I have saved out in screenshots. I have be=
en using the following procedure to load the data:
=B7 Because I was getting errors, ArcCatalog was crashing and there=
were many polygons missing, I have been copying the data into a file based=
geodatabase, using the geometry fix tool in ArcCatalog and then loading th=
e data from the file based geodatabase.
=B7 If there was still data missing, I created a feature class and =
loaded the data without using pg_geometry and the data seemed fine
=B7 I then tried loading the data from the default geometry feature=
class into a new feature class using pg_geometry and there seemed to be th=
e same data missing as if I loaded directly from the fbgb
=B7 I am experiencing strange behavior if I bring the pg_geometry d=
ata into ArcMap:
o Takes a long time to load
o If I get into an edit session, I can select a couple of polygons but if=
I try to select a lot it gives me the following error: "Unable to create l=
ogfile system tables. User perhaps lacks permissions or resources to create=
tables[ERROR: schema "thefer" does not exist :: SQL state: 3F000]" which i=
s inconsistent with me being able to edit other data as usual
o While the same number of records are in the feature class as was in the=
fgdb, only some of the features are visible (as you can see from first att=
achment)
o When I try to use the select tool in ArcMap to select the entire datase=
t, the following error occurs "There was an error executing the query. Oper=
ation Failed[name of database.sde.name of dataset]
o When I select a portion of the data that cannot be seen when zoomed to=
the extents of the dataset, those features can be seen as selected (these =
features can be seen when you zoom in to them)
=B7 The third picture is the extent of the data as it should appear=
.
Is there any information you can give me that would cause this inconsistent=
and unstable behavior?
I really will appreciate any help you can give me in this regard.
Toni
Toni Hefer
GIS Manager
Land Advisors Organization
4900 North Scottsdale Road, Suite 3000
Scottsdale, Arizona 85251
480.483.8100 | 800.888.0998
480.483.0000 Fax
www.landadvisors.com<http://www.landadvisors.com/>
=FC Please consider the environment before printing this e-mail.
[Attachment #5 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:x="urn:schemas-microsoft-com:office:excel" \
xmlns:p="urn:schemas-microsoft-com:office:powerpoint" \
xmlns:a="urn:schemas-microsoft-com:office:access" \
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" \
xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" \
xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" \
xmlns:b="urn:schemas-microsoft-com:office:publisher" \
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" \
xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" \
xmlns:odc="urn:schemas-microsoft-com:office:odc" \
xmlns:oa="urn:schemas-microsoft-com:office:activation" \
xmlns:html="http://www.w3.org/TR/REC-html40" \
xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" \
xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" \
xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" \
xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" \
xmlns:ds="http://www.w3.org/2000/09/xmldsig#" \
xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" \
xmlns:udc="http://schemas.microsoft.com/data/udc" \
xmlns:xsd="http://www.w3.org/2001/XMLSchema" \
xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" \
xmlns:ec="http://www.w3.org/2001/04/xmlenc#" \
xmlns:sp="http://schemas.microsoft.com/sharepoint/" \
xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" \
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" \
xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" \
xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" \
xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" \
xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" \
xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" \
xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" \
xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" \
xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" \
xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" \
xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" \
xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" \
xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" \
xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" \
xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" \
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
@font-face
{font-family:"Arial Narrow";
panose-1:2 11 6 6 2 2 2 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1290893973;
mso-list-type:hybrid;
mso-list-template-ids:-587987218 67698689 67698691 67698693 67698689 67698691 \
67698693 67698689 67698691 67698693;} @list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>Hi – we have created a postgres database and are in
the process of copying the <u>+</u> 50 Gb of vector data in about 53 different
feature classes into the Postgres database. I am finding some very strange behavior
when I use the PG_Geometry keyword, some of which I have saved out in
screenshots. I have been using the following procedure to load the \
data:<o:p></o:p></p>
<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if \
!supportLists]><span style='font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]>Because I was getting errors, ArcCatalog was
crashing and there were many polygons missing, I have been copying the data
into a file based geodatabase, using the geometry fix tool in ArcCatalog and
then loading the data from the file based geodatabase.<o:p></o:p></p>
<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if \
!supportLists]><span style='font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]>If there was still data missing, I created a
feature class and loaded the data without using pg_geometry and the data seemed
fine<o:p></o:p></p>
<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if \
!supportLists]><span style='font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]>I then tried loading the data from the default
geometry feature class into a new feature class using pg_geometry and there
seemed to be the same data missing as if I loaded directly from the \
fbgb<o:p></o:p></p>
<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if \
!supportLists]><span style='font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]>I am experiencing strange behavior if I bring
the pg_geometry data into ArcMap:<o:p></o:p></p>
<p class=MsoListParagraph style='margin-left:1.0in;text-indent:-.25in;
mso-list:l0 level2 lfo1'><![if !supportLists]><span style='font-family:"Courier \
New"'><span style='mso-list:Ignore'>o<span style='font:7.0pt "Times New \
Roman"'> </span></span></span><![endif]>Takes a long time to \
load<o:p></o:p></p>
<p class=MsoListParagraph style='margin-left:1.0in;text-indent:-.25in;
mso-list:l0 level2 lfo1'><![if !supportLists]><span style='font-family:"Courier \
New"'><span style='mso-list:Ignore'>o<span style='font:7.0pt "Times New \
Roman"'> </span></span></span><![endif]>If I get into an edit session, I \
can select a couple of polygons but if I try to select a lot it gives me the \
following
error: "Unable to create logfile system tables. User perhaps lacks
permissions or resources to create tables[ERROR: schema "thefer" does
not exist :: SQL state: 3F000]” which is inconsistent with me being able
to edit other data as usual<o:p></o:p></p>
<p class=MsoListParagraph style='margin-left:1.0in;text-indent:-.25in;
mso-list:l0 level2 lfo1'><![if !supportLists]><span style='font-family:"Courier \
New"'><span style='mso-list:Ignore'>o<span style='font:7.0pt "Times New \
Roman"'> </span></span></span><![endif]>While the same number of records \
are in the feature class as was in the fgdb, only some of the features are visible \
(as you can see from first attachment)<o:p></o:p></p>
<p class=MsoListParagraph style='margin-left:1.0in;text-indent:-.25in;
mso-list:l0 level2 lfo1'><![if !supportLists]><span style='font-family:"Courier \
New"'><span style='mso-list:Ignore'>o<span style='font:7.0pt "Times New \
Roman"'> </span></span></span><![endif]>When I try to use the select tool \
in ArcMap to select the entire dataset, the following error occurs “There was \
an error executing the query. Operation Failed[name of database.sde.name of \
dataset]<o:p></o:p></p>
<p class=MsoListParagraph style='margin-left:1.0in;text-indent:-.25in;
mso-list:l0 level2 lfo1'><![if !supportLists]><span style='font-family:"Courier \
New"'><span style='mso-list:Ignore'>o<span style='font:7.0pt "Times New \
Roman"'> </span></span></span><![endif]>When I select a portion of the \
data that cannot be seen when zoomed to the extents of the dataset, those features \
can be seen as selected (these features can be seen when you zoom in to \
them)<o:p></o:p></p>
<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if \
!supportLists]><span style='font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]>The third picture is the extent of the data as
it should appear.<o:p></o:p></p>
<p class=MsoNormal>Is there any information you can give me that would cause
this inconsistent and unstable behavior?<o:p></o:p></p>
<p class=MsoNormal>I really will appreciate any help you can give me in this
regard.<o:p></o:p></p>
<p class=MsoNormal>Toni<o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif";
color:#333333'><br>
<br>
</span><o:p></o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr>
<td width=638 valign=top style='width:6.65in;border:solid white 1.0pt;
background:white;padding:0in 5.4pt 0in 5.4pt'>
<p class=MsoNormal><b><span style='font-size:12.0pt;color:#000099'>Toni \
Hefer</span></b><b><span \
style='font-size:12.0pt;color:#000099'><o:p></o:p></span></b></p> <p \
class=MsoNormal><b><span style='font-size:10.0pt;color:#595959'>GIS \
Manager<o:p></o:p></span></b></p> <p class=MsoNormal><b><span \
style='font-size:10.0pt;color:#595959'>Land Advisors \
Organization<o:p></o:p></span></b></p> <p class=MsoNormal><span \
style='font-size:10.0pt;color:#595959'>4900 North Scottsdale Road, Suite 3000<br>
Scottsdale, Arizona 85251<br>
480.483.8100 </span><span style='font-size:10.0pt;font-family:"Times New \
Roman","serif"; color:#595959'>|</span><span style='font-size:10.0pt;color:#595959'>
800.888.0998<br>
480.483.0000 Fax</span><span \
style='font-size:10.0pt;color:black'><o:p></o:p></span></p> </td>
</tr>
<tr style='height:22.0pt'>
<td width=638 style='width:6.65in;border:solid white 1.0pt;border-top:none;
background:white;padding:0in 5.4pt 0in 5.4pt;height:22.0pt'>
<p class=MsoNormal><u><span style='font-size:10.0pt;color:#000099'><o:p><span
style='text-decoration:none'> </span></o:p></span></u></p>
<p class=MsoNormal><u><span style='font-size:10.0pt;color:#000099'><a
href="http://www.landadvisors.com/"><span style='color:#000099;text-decoration:
none'>www.landadvisors.com</span></a><o:p></o:p></span></u></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:13.5pt;font-family:Webdings;color:green'>ü</span><span
style='font-size:10.0pt;font-family:"Arial Narrow","sans-serif";color:green'>
Please consider the environment before printing this e-mail.</span><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:navy'> </span><span
style='font-size:10.0pt;font-family:"Times New \
Roman","serif"'><o:p></o:p></span></p> </td>
</tr>
</table>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>
["2.jpg" (image/jpeg)]
["1.jpg" (image/jpeg)]
["3.jpg" (image/jpeg)]
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic