tag:blogger.com,1999:blog-44964658104212825732024-02-19T00:18:09.724-08:00Mundo ArcGISMarcelo Edy Peinadohttp://www.blogger.com/profile/07079236268375106512noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-4496465810421282573.post-45407031705383935702011-06-14T18:50:00.000-07:002011-06-14T18:50:09.658-07:00Preparando seu banco de dados para utilizar a geometria do PostGIS<div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 15.0pt; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;"><br />
Para utilizar o tipo de geometria do PostGIS você deve instalar o PostGIS.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 15.0pt; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">Instale o PostGIS após você instalar o PostgreSQL.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 15.0pt; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">Para obter a versão do PostGIS suportada pelo ArcSDE você pode instalar o PostgreSQL StackBuilder durante a instalação do PostgreSQL no Windows. Ou então, consulte o web site </span><a href="http://www.postgis.org/download/" target="_blank"><span style="color: #0c618d; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">http://www.postgis.org/download/</span></a><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;"> ou o web site da PgFoundry em </span><a href="http://pgfoundry.org/" target="_blank"><span style="color: #0c618d; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">http://pgfoundry.org/</span></a><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;"> para fazer download dos arquivos de instalação. Certifique-se de fazer download dos arquivos de instalação compatíveis com seu sistema operacional.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 15.0pt; margin-right: 0cm; margin-top: 6.0pt;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoKC025j9CXV1mWx9XRavs95q8J3EQtBAk4EnoGvS8m6o7b0BuhnQeNa-k_ziOYD2x9C38Fm2WaRda286kBuxCpuuDQXnpqvteXnEW3RLb113R4Kq7rm7RCQiKUore64PY7oBSDxekNYMD/s1600/Lampada.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoKC025j9CXV1mWx9XRavs95q8J3EQtBAk4EnoGvS8m6o7b0BuhnQeNa-k_ziOYD2x9C38Fm2WaRda286kBuxCpuuDQXnpqvteXnEW3RLb113R4Kq7rm7RCQiKUore64PY7oBSDxekNYMD/s1600/Lampada.png" /></a></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.6pt;"><b><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">Dica:<o:p></o:p></span></b></div><div class="MsoNormal" style="background: white; line-height: 12.75pt; margin-bottom: 7.5pt; margin-left: 21.0pt; margin-right: 13.5pt; margin-top: 0cm;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">Consulte a página de requisitos de sistema do ArcGIS Server na página de suporte da ESRI para mais informações sobre as versões do PostGIS suportadas com o ArcSDE.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 15.0pt; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">Quando você instala o PostGIS, um banco de dados template do PostGIS é criado em seu cluster de banco de dados do PostgreSQL. Utilize o template do banco de dados do PostGIS para criar um banco de dados para armazenar o seu geodatabase.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.6pt;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwTsKK2JfJFREnQFa1y-BrbBS53QSp0yVWcm5IA13x2b9BdC25yVvnxAbSWw6xKiXWvpCIqjDPSzfVAzcFofZxj7tbMRwKSegyXy9J6OWgddbRW2p3HHd205t36nmckjesrYPGE9hn2sd2/s1600/nota.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwTsKK2JfJFREnQFa1y-BrbBS53QSp0yVWcm5IA13x2b9BdC25yVvnxAbSWw6xKiXWvpCIqjDPSzfVAzcFofZxj7tbMRwKSegyXy9J6OWgddbRW2p3HHd205t36nmckjesrYPGE9hn2sd2/s1600/nota.png" /></a></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.6pt;"><b><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">Nota:<o:p></o:p></span></b></div><div class="MsoNormal" style="background: white; line-height: 12.75pt; margin-bottom: 7.5pt; margin-left: 21.0pt; margin-right: 13.5pt; margin-top: 0cm;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">Se você criar seu geodatabase através do wizard de Post Installation do ArcSDE, seu banco de dados é criado utilizando um template diferente do template do PostGIS. Entretanto, se você deseja utilizar o tipo de geometria do PostGIS, você precisa sair do wizard de instalação antes de iniciar o setup do post-installation e criar manualmente um banco de dados utilizando o template do PostGIS, um usuário sde e um esquema sde no banco de dados. Em seguida, você pode completar o resto dos passos do post-installation utilizando o wizard: escolha a opção Custom na caixa de diálogo do wizard do Post Installation, clique em Next e então desmarque a opção Define SDE User Environment.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 14.4pt; margin-bottom: 2.4pt; mso-margin-top-alt: auto; mso-outline-level: 3;"><b><span style="color: #af7209; font-family: "Verdana","sans-serif"; font-size: 11.5pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">Concendendo privilégios para criar tabelas com as colunas de geometria do PostGIS<o:p></o:p></span></b></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 26.25pt; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">Quando um banco de dados é habilitado para utilizar o PostGIS, as tabelas geometry_columns e spatial_ref_sys são criadas no esquema public. Você deve conceder ao menos os privilégios de SELECT, INSERT, UPDATE e DELETE na tabela geometry_columns e de SELECT na tabela spatial_ref_sys para o usuário sde e para qualquer outro usuário que for criar dados no geodatabase.<o:p></o:p></span></div><div style="background: #EEEEEE; border: dashed #C2C4BA 1.0pt; margin-left: 30.0pt; margin-right: 0cm; mso-border-alt: dashed #C2C4BA .75pt; mso-element: para-border-div; padding: 8.0pt 8.0pt 19.0pt 8.0pt;"> <div class="MsoNormal" style="background: #EEEEEE; border: none; line-height: 14.4pt; margin-bottom: .0001pt; margin-bottom: 0cm; mso-border-alt: dashed #C2C4BA .75pt; mso-padding-alt: 8.0pt 8.0pt 19.0pt 8.0pt; padding: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span lang="EN-US" style="color: black; font-family: "Courier New"; font-size: 8.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">GRANT select, insert, update, delete <o:p></o:p></span></div><div class="MsoNormal" style="background: #EEEEEE; border: none; line-height: 14.4pt; margin-bottom: .0001pt; margin-bottom: 0cm; mso-border-alt: dashed #C2C4BA .75pt; mso-padding-alt: 8.0pt 8.0pt 19.0pt 8.0pt; padding: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span lang="EN-US" style="color: black; font-family: "Courier New"; font-size: 8.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">ON TABLE public.geometry_columns <o:p></o:p></span></div><div class="MsoNormal" style="background: #EEEEEE; border: none; line-height: 14.4pt; margin-bottom: .0001pt; margin-bottom: 0cm; mso-border-alt: dashed #C2C4BA .75pt; mso-padding-alt: 8.0pt 8.0pt 19.0pt 8.0pt; padding: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span lang="EN-US" style="color: black; font-family: "Courier New"; font-size: 8.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">TO <user_name>;<o:p></o:p></span></div><div class="MsoNormal" style="background: #EEEEEE; border: none; line-height: 14.4pt; margin-bottom: .0001pt; margin-bottom: 0cm; mso-border-alt: dashed #C2C4BA .75pt; mso-padding-alt: 8.0pt 8.0pt 19.0pt 8.0pt; padding: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><br />
</div><div class="MsoNormal" style="background: #EEEEEE; border: none; line-height: 14.4pt; margin-bottom: .0001pt; margin-bottom: 0cm; mso-border-alt: dashed #C2C4BA .75pt; mso-padding-alt: 8.0pt 8.0pt 19.0pt 8.0pt; padding: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span lang="EN-US" style="color: black; font-family: "Courier New"; font-size: 8.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">GRANT select<o:p></o:p></span></div><div class="MsoNormal" style="background: #EEEEEE; border: none; line-height: 14.4pt; margin-bottom: .0001pt; margin-bottom: 0cm; mso-border-alt: dashed #C2C4BA .75pt; mso-padding-alt: 8.0pt 8.0pt 19.0pt 8.0pt; padding: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span lang="EN-US" style="color: black; font-family: "Courier New"; font-size: 8.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">ON TABLE public.spatial_ref_sys<o:p></o:p></span></div><div class="MsoNormal" style="background: #EEEEEE; border: none; line-height: 14.4pt; margin-bottom: 3.6pt; mso-border-alt: dashed #C2C4BA .75pt; mso-padding-alt: 8.0pt 8.0pt 19.0pt 8.0pt; padding: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span lang="EN-US" style="color: black; font-family: "Courier New"; font-size: 8.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">TO <user_name>;<o:p></o:p></span></div></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><span class="apple-style-span"><i><span style="color: #222222; font-family: "Verdana","sans-serif"; font-size: 10.0pt; line-height: 115%;"><br />
</span></i></span></div><div class="MsoNormal"><span class="apple-style-span"><i><span style="color: #222222; font-family: "Verdana","sans-serif"; font-size: 10.0pt; line-height: 115%;">fonte: ArcGIS Resource Center</span></i></span><o:p></o:p></div>Marcelo Edy Peinadohttp://www.blogger.com/profile/07079236268375106512noreply@blogger.com0tag:blogger.com,1999:blog-4496465810421282573.post-90399356654136147022011-06-13T11:05:00.001-07:002011-06-13T11:09:00.968-07:00ArcGIS e o tipo de geometria do PostGIS<div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">PostGIS é um produto da Refractions Research que habilita espacialmente o banco de dados PostgreSQL. O PostGIS segue o Open Geospatial Consortium, Inc. e as especificações de Simple Features para linguagem de consultas estruturadas (SQL).<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">Quando você for utilizar o tipo de geometria de amazenamento do PostGIS com o ArcGIS, tenha as seguintes regras em mente:<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo1; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span style="color: black; font-family: Symbol; font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">Você deve utilizar um template do banco de dados PostGIS para criar um banco de dados no PostgreSQL e utilizar o geodatabase. Consulte o post “Preparando seu banco de dados para utilizar a geometria do PostGIS”.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo1; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span style="color: black; font-family: Symbol; font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">O usuário do sde e qualquer usuário que cria dados no geodatabase deve ter permissões concedidas em tabelas específicas no PostGIS. Consulte o post “Concedendo privilégios aos usuários que criam tabelas com colunas de geometria no PostGIS”.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo1; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span style="color: black; font-family: Symbol; font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">As classes de feições que você criar podem somente utilizar as referências espaciais listadas na tabela public.spatial_ref_sys do PostGIS. Se você especificar uma referência espacial que não esteja nesta tabela o processo de criação da classe de feição irá apresentar erro.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo1; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span style="color: black; font-family: Symbol; font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">Você deve especificar uma chave de configuração que contenha o parâmetro GEOMETRY_STORAGE definido para PG_GEOMETRY para criar uma classe de feição que utiliza o tipo de geometria do PostGIS.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">Os posts seguintes contém mais informações sobre como utilizar o tipo de geometria do PostGIS com aplicações ArcGIS.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><br />
</div><div class="MsoNormal"><span class="apple-style-span"><i><span style="color: #222222; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 115%;">fonte: ArcGIS Resource Center</span></i></span><o:p></o:p></div>Marcelo Edy Peinadohttp://www.blogger.com/profile/07079236268375106512noreply@blogger.com0tag:blogger.com,1999:blog-4496465810421282573.post-22653198908078578422011-06-13T05:17:00.000-07:002011-06-13T05:18:31.598-07:00O que é o tipo de geometria do PostGIS?<div class="MsoNormal" style="line-height: 14.4pt; margin-bottom: 2.4pt; mso-margin-top-alt: auto; mso-outline-level: 1;"><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 14px; line-height: 17px;">O PostGIS é um produto da Refractions Research que permite suportar tipos de dados espaciais do PostGIS no banco de dados PostgreSQL. O PostGIS segue os padrões do Open Geospatial Consortium, Inc. (OGC) e das especificações de Simple Features para a linguagem de consulta estruturada (SQL). Ele utiliza um binário bem conhecido (WKB) e um texto bem conhecido (WKT) para representação da geometria. Essencialmente, o PostGIS adiciona um tipo espacial para o PostgreSQL.</span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">Classes de feições do tipo PostGIS possuem uma tabela de negócios contendo uma coluna espacial referente ao tipo da geometria.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">Uma vez que a coluna da geometria é adicionada à tabela, ela deve ser registrada com o ArcSDE através do comando sdelayer –o register se você deseja utilizar o dado com uma aplicação cliente do ArcSDE. Consulte o guia do ArcSDE (ArcSDE Administration Command Reference) para mais detalhes a respeito do uso deste comando. As tabelas do PostGIS também podem ser lidas diretamente no ArcGIS a partir da versão 10 se você utilizar a opção <b style="mso-bidi-font-weight: normal;">Query Layers</b> (No ArcMap, <i style="mso-bidi-font-style: normal;">File > Add Data > Add Query Layer...) </i>ou em versões anteriores através da extensão ArcGIS Data Interoperability.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.6pt;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5v3VAzrF_BDk8I_U-DN72z7YNIxwO4ZN0G7r6XCpPY05U-72YhN5DlD_NN3EltG4UxYKa8F26XukDPd9M-_jd9LCKKRz8yfUz6jcWifALIj-29D-zIYAP1HxnSCWh3MRA77w_qFYivMqr/s1600/Lampada.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5v3VAzrF_BDk8I_U-DN72z7YNIxwO4ZN0G7r6XCpPY05U-72YhN5DlD_NN3EltG4UxYKa8F26XukDPd9M-_jd9LCKKRz8yfUz6jcWifALIj-29D-zIYAP1HxnSCWh3MRA77w_qFYivMqr/s1600/Lampada.png" /></a></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.6pt;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;"></span></b><b><span lang="EN-US" style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">Dica:<o:p></o:p></span></b></div><div class="MsoNormal" style="background: white; line-height: 12.75pt; margin-bottom: 7.5pt; margin-left: 13.5pt; margin-right: 13.5pt; margin-top: 0cm;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 12.75pt; margin-bottom: 7.5pt; margin-left: 13.5pt; margin-right: 13.5pt; margin-top: 0cm;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">Consulte a documentação do PostGIS a partir do Refractions Research's para mais informações sobre as sintaxes SQLs usadas para riar colunas espaciais através do PostGIS, validar a geometria e acessar as tabelas e colunas espaciais dos tipos de geometrias.<o:p></o:p></span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><span class="apple-style-span"><i><span style="color: #222222; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 115%;">fonte: ArcGIS Resource Center</span></i></span><o:p></o:p></div>Marcelo Edy Peinadohttp://www.blogger.com/profile/07079236268375106512noreply@blogger.com0tag:blogger.com,1999:blog-4496465810421282573.post-28944552745717758722011-06-10T07:00:00.000-07:002011-06-13T05:19:16.072-07:00Quais são os tipos de armazenamento do ST_Geometry?<div class="MsoNormal" style="line-height: 14.4pt; margin-bottom: 2.4pt; mso-margin-top-alt: auto; mso-outline-level: 1;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 17px;">O tipo de dados ST_Geometry são um tipo de dados definidos pelo usuário (user-defined data type - UDT) que permite a você definir colunas que armazenam dados espaciais.</span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-size: 10pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">O ST_Geometry por si só é uma superclasse abstrata e não-instanciada. Entretanto, suas subclasses podem ser instanciadas. Um tipo de dados instanciado é um que pode ser definido como uma coluna de uma tabela e ter valores de seus tipos inseridos dentro dele.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-size: 10pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">Embora você possa definir uma coluna com o tipo ST_Geometry, você não pode inserir valores dentro da coluna ST_Geometry devido ao fato dela não ser instanciada. Ao invés disso, você insere valores na subclasse.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-size: 10pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">O seguinte gráfico demostra a hierarquia do tipo de dados do ST_Geometry e suas subclasses. Veja que o ST_Curve, ST_Surface, ST_MultiCurve e o ST_MultiSurface são definidos para serem tipos não-instanciados. Nenhum construtor foi definido para esses tipos.<o:p></o:p></span></span></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: 11.25pt; width: 562px;"><tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;"> <td style="padding: 1.5pt 3.75pt 0cm 3.75pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><br />
<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7gIerzCp7QHLjNX_ggdFQE2aldcNutdFEdd9ubNzioU_DptT_rvgEXzJx4OpTQDOLaH39NtYyTtPpsOXIuCHoiL2WKmDOxtFz6AwhPaFkVWLbbhLhzncelOAZdgWeC0y-NlG0ScAOWoNR/s1600/superclasse_ST_Geometry_PostGIS.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7gIerzCp7QHLjNX_ggdFQE2aldcNutdFEdd9ubNzioU_DptT_rvgEXzJx4OpTQDOLaH39NtYyTtPpsOXIuCHoiL2WKmDOxtFz6AwhPaFkVWLbbhLhzncelOAZdgWeC0y-NlG0ScAOWoNR/s1600/superclasse_ST_Geometry_PostGIS.png" /></a></div><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-style-span" style="font-size: 12px;"><br />
</span></span></div></td> </tr>
<tr style="mso-yfti-irow: 1; mso-yfti-lastrow: yes;"> <td style="padding: 1.5pt 3.75pt 0cm 3.75pt;" valign="top"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: 3.6pt; text-align: center;"><i><span lang="EN-US" style="font-size: 7pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">A superclasse ST_Geometry e suas subclasses<o:p></o:p></span></span></i></div></td> </tr>
</tbody></table><div class="MsoNormal" style="line-height: 14.4pt; margin-bottom: 2.4pt; mso-margin-top-alt: auto; mso-outline-level: 2;"><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style="color: #103e4e; font-size: 13.5pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">Subclasses<o:p></o:p></span></span></b></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="color: black; font-size: 10pt;">As subclasses dos ST_Geometry's estão divididas dentro de duas categorias: a subclasse de geometria base e a subclasse de coleções homogêneas. </span><span lang="EN-US" style="color: black; font-size: 10pt;">As geometrias base incluem o ST_Point, ST_LineString e ST_Polygon, enquanto as coleções homogêneas incluem o ST_MultiPoint, ST_MultiLineString e o ST_MultiPolygon. </span><span style="color: black; font-size: 10pt;">Como o próprio nome indica, as coleções homogêneas são coleções de geometrias base. Além de compartilhar as propriedades das geometrias base, as coleções homogêneas possuem suas próprias propriedades.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-size: 10pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">Cada subclasse armazena os tipos de geometria implícita ao seu nome; por exemplo, ST_MultiPoint armazena multipontos. Cada subclasse possui funções particulares que podem retornar informações sobre a subclasse. Um resumo das subclasses, suas descrições e exemplos de funções que podem ser utilizadas para obter informações sobre elas estão listadas na tabela abaixo:<o:p></o:p></span></span><br />
<span style="color: black; font-size: 10pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br />
</span></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 15.0pt; margin-right: 0cm; margin-top: 6.0pt;"><br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-bottom-style: none; border-collapse: collapse; border-color: initial; border-left-style: none; border-right-style: none; border-top-style: none; border-width: initial; margin-left: 11.25pt; width: 499px;"><tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;"> <td style="background: #C2C4BA; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; padding: 1.5pt 0cm 1.5pt 3.0pt; width: 69.75pt;" width="93"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 7.5pt; margin-right: 0cm; margin-top: 0cm;"><b><span style="color: black; font-size: 7pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">Subtipo<o:p></o:p></span></span></b></div></td> <td style="background: #C2C4BA; border-left: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; padding: 1.5pt 0cm 1.5pt 3.0pt; width: 148.8pt;" width="198"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 7.5pt; margin-right: 0cm; margin-top: 0cm;"><b><span style="color: black; font-size: 7pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">Descrição<o:p></o:p></span></span></b></div></td> <td style="background: #C2C4BA; border-left: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; padding: 1.5pt 0cm 1.5pt 3.0pt; width: 155.95pt;" width="208"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 7.5pt; margin-right: 0cm; margin-top: 0cm;"><b><span style="color: black; font-size: 7pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">Funções usadas com o subtipo<o:p></o:p></span></span></b></div></td> </tr>
<tr style="mso-yfti-irow: 1;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 69.75pt;" valign="top" width="93"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 7.5pt; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-size: 7pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">ST_Point<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 148.8pt;" valign="top" width="198"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l9 level1 lfo1; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Uma geometria de zero-dimensão que ocupa uma posição única nas coordenadas do espaço <o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l9 level1 lfo1; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Possui um único valor de coordenadas x,y, é sempre único e possui contorno NULO.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l9 level1 lfo1; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Usado para definir feições como poços de petróleo, marcações e elevações.<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 155.95pt;" valign="top" width="208"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo2; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_X—Retorna o valor de coordenada x de um ponto como um número de precisão double.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo2; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_Y—Retorna o valor de coordenada y de um ponto como um número de precisão double.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo2; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_Z—Retorna o valor de coordenada z de um ponto como um número de precisão double.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo2; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_M—Retorna o valor de coordenada m de um ponto como um número de precisão double.<o:p></o:p></span></span></div></td> </tr>
<tr style="mso-yfti-irow: 2;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 69.75pt;" valign="top" width="93"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 7.5pt; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-size: 7pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">ST_LineString<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 148.8pt;" valign="top" width="198"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l5 level1 lfo3; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Um objeto de uma-dimensão armazenado como uma sequência de pontos definindo um caminho linear interpolado.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l5 level1 lfo3; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_LineStrings possui um comprimento (length).<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l5 level1 lfo3; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">O ST_LineString é único se ele não intersecta com seu próprio interior.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l5 level1 lfo3; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Os endpoints (o contorno) de um ST_LineString fechado ocupam o mesmo ponto no espaço. <o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l5 level1 lfo3; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Um ST_LineString é um anel se estiver fechado e for único.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l5 level1 lfo3; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Os endpoints normalmente formam o contorno de um ST_LineString a menos que o ST_LineString esteja fechado, neste caso o contorno será Nulo. <o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l5 level1 lfo3; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">O interior de uma ST_LineString é o caminho que se encontra conectado entre os endpoints, a menos que ele esteja fechado, neste caso o interior será contínuo.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l5 level1 lfo3; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_LineStrings são na maioria das vezes usados pra definir feições lineares como rodovias, rios e linhas de transmissão de energia.<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 155.95pt;" valign="top" width="208"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo2; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_StartPoint—Retorna o primeiro ponto de uma linestring.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo2; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_EndPoint—Retorna o último ponto de uma linestring.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo2; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_PointN —Pega uma linestring e um índice e retorna o número de pontos e retorna estes pontos. <o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo2; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_Length—Retorna o comprimento das linestrings como um número de precisão double.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo2; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_NumPoints—Retorna o número de pontos numa sequência de linestrings como um inteiro. <o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo2; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_IsRing—Retorna 1 (TRUE) se uma linestring é um anel (ring) ou 0 (FALSE) se ela não for.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l0 level1 lfo2; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_IsClosed—Retorna 1 (TRUE) se uma linestring está fechada ou 0 (FALSE) se ela não está.<o:p></o:p></span></span></div></td> </tr>
<tr style="mso-yfti-irow: 3;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 69.75pt;" valign="top" width="93"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 7.5pt; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-size: 7pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">ST_Polygon<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 148.8pt;" valign="top" width="198"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l8 level1 lfo4; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Uma superfície bi-dimensional armazenada como uma sequência de pontos definindo seu limite exterior.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l8 level1 lfo4; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">O ST_Polygon possui área e é sempre único.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l8 level1 lfo4; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Os contornos exteriores e interiores definem os limites de um ST_Polygon e o espaço fechado entre os contornos define o interior do ST_Polygon.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l8 level1 lfo4; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">O contorno de um ST_Polygon pode intersectar um ponto tangente mas nunca cruzá-lo.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l8 level1 lfo4; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Define parcelas de terreno, contornos d’água e outras feições com extensão espacial.<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 155.95pt;" valign="top" width="208"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l4 level1 lfo5; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_Area—Retorna a área de um polígono como um número de precisão double.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l4 level1 lfo5; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_ExteriorRing—Retorna o polígono do contorno exterior como uma linestring<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l4 level1 lfo5; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_NumInteriorRing—Retorna o número de contornos interiores que um polígono contém<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l4 level1 lfo5; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_InteriorRingN— Pega um polígono e um índice e retorna o número de contornos como uma linestring. <o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l4 level1 lfo5; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_Centroid—Retorna um ponto que está no centro do envelope de um polígono.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l4 level1 lfo5; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_PointOnSurface—Retorna um ponto que está na superfície de um polígono.<o:p></o:p></span></span></div></td> </tr>
<tr style="mso-yfti-irow: 4;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 69.75pt;" valign="top" width="93"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 7.5pt; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-size: 7pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">ST_MultiPoint<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 148.8pt;" valign="top" width="198"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l6 level1 lfo6; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Uma coleção de ST_Points<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l6 level1 lfo6; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Têm uma dimensão 0.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l6 level1 lfo6; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Um ST_MultiPoint é único se nenhum de seus elementos ocupar a mesma coordenada no espaço.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l6 level1 lfo6; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">O limite de um ST_MultiPoint é Nulo.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l6 level1 lfo6; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Define coisas como padrões de frequência aéreas e incidentes de um surto de doença<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 155.95pt;" valign="top" width="208"></td> </tr>
<tr style="mso-yfti-irow: 5;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 69.75pt;" valign="top" width="93"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 7.5pt; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-size: 7pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">ST_MultiLineString<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 148.8pt;" valign="top" width="198"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l3 level1 lfo7; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Uma coleção de ST_LineStrings<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l3 level1 lfo7; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_MultiLineStrings possuem comprimento (length).<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l3 level1 lfo7; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_MultiLineStrings são únicas se elas somente interseccionam os endpoints dos elementos de uma ST_LineString.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l3 level1 lfo7; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_MultiLineStrings não são únicas se o interior dos elementos de ST_LineString se intersectam.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l3 level1 lfo7; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">O contorno de um ST_MultiLineString são os endpoints não interseccionados dos elementos de ST_LineString.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l3 level1 lfo7; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Um ST_MultiLineString está fechado se todos os seus elementos de ST_LineString estiverem fechados.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l3 level1 lfo7; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">O contorno de um ST_MultiLineString é Nulo se todos os endpoints de todos os seus elementos estão interseccionados.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l3 level1 lfo7; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Utilizado para definir entidades como redes de drenagens e de rodovias.<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 155.95pt;" valign="top" width="208"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l7 level1 lfo8; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_Length—Retorna o comprimento acumulado de todos os elementos ST_LineString de uma multilinestring como um número de precisão double.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l7 level1 lfo8; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_IsClosed—Retorna 1 (TRUE) se uma multilinestring está fechada e 0 (FALSE) se estiver aberta.<o:p></o:p></span></span></div></td> </tr>
<tr style="mso-yfti-irow: 6; mso-yfti-lastrow: yes;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 69.75pt;" valign="top" width="93"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 7.5pt; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-size: 7pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">ST_MultiPolygon<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 148.8pt;" valign="top" width="198"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l1 level1 lfo9; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Uma coleção de polígonos<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l1 level1 lfo9; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_MultiPolygons possuem área.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l1 level1 lfo9; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">O contorno de um ST_MultiPolygon será o comprimento acumulado de seus elementos exteriores e contornos interiores.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l1 level1 lfo9; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">O interior de um ST_MultiPolygon é definido conforme a soma dos interiores de seus elementos ST_Polygons<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l1 level1 lfo9; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">O contorno dos elementos de um ST_MultiPolygon podem somente interseccionar um ponto tangente.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l1 level1 lfo9; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">Define feições como uma porção de floresta ou terras não contíguas como a cadeia de ilhas do Pacífico.<o:p></o:p></span></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 155.95pt;" valign="top" width="208"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l2 level1 lfo10; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_Area—Retorna a somatória da área (ST_Area) dos elementos de polígono de um multipolígono como um número de precisão double.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l2 level1 lfo10; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_Centroid—Retorna um ponto que é o centro do envelope de um multipolígono.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.75pt; margin-left: 22.5pt; mso-list: l2 level1 lfo10; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 10pt;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="font-size: 7pt;">ST_PointOnSurface—Retorna um ponto que está na superfície de um dos elementos de polígono de um multipolígono.<o:p></o:p></span></span></div></td> </tr>
</tbody></table><br />
<div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.6pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><i><span lang="EN-US" style="color: black; font-size: 7.5pt;">Subtipos do ST_Geometry</span></i><span lang="EN-US" style="color: black; font-size: 10pt;"><o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.6pt;"><i><span lang="EN-US" style="color: black; font-size: 7.5pt;"><br />
</span></i></div></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-size: 10pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">Note que cada subclasse herda as propriedades da superclasse do ST_Geometry mas também possui suas próprias propriedades. Funções que operam em tipos de dados no ST_Geometry aceitam quaisquer das subclasses de tipos de dados. Entretanto, algumas funções foram definidas com base no nível da subclasse e somente aceitam determinadas subclasses. Por exemplo, a função ST_GeometryN somente aceita valores dos subtipos ST_MultiLinestring, ST_MultiPoint ou ST_MultiPolygon como entrada.<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-size: 10pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;">Para explorar a subclasse de um ST_Geometry, você pode usar a função ST_GeometryType. A função ST_GeometryType pega um ST_Geometry e retorna uma subclasse instanciada na forma de um caractere string. Para saber como vários elementos de geometrias base estão contidos numa coleção homogênea, você pode utilizar a função ST_NumGeometries, na qual pega uma coleção homogênea e retorna o número de elementos de geometria base que ela contém.<o:p></o:p></span></span><br />
<span style="color: black; font-size: 10pt;"><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"><br />
</span></span></div><div class="MsoNormal"><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 13px; line-height: 16px;"><i>fonte: ArcGIS Resource Center</i></span></div>Marcelo Edy Peinadohttp://www.blogger.com/profile/07079236268375106512noreply@blogger.com0tag:blogger.com,1999:blog-4496465810421282573.post-39379685737906210712011-06-01T18:20:00.000-07:002011-06-01T18:20:00.171-07:00Quais são os tipos de dados definidos pelo usuário (user-defined)?<div class="MsoNormal" style="line-height: 14.4pt; margin-bottom: 2.4pt; mso-margin-top-alt: auto; mso-outline-level: 1;"><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 14px; line-height: 17px;">Tipos de dados definidos pelo usuário (User-Defined data Types ou UDTs) são objetos para armazenamento de dados que um programador define para atender as necessidades de uma aplicação. Devido à sua definição ser feita pelo programador, os UDTs são lidos por um sistema de gerenciamento de banco de dados (DBMS) e, então armazenados no banco de dados através de um tipo de dados nativo ao DBMS.</span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">O ArcSDE geodatabase utiliza vários UDTs diferentes. Alguns foram definidos pela ESRI e outros foram definidos por companhias ou organizações fora da ESRI. Todos os UDTs utilizados pelo ArcSDE geodatabase armazenam dados espaciais, tanto para vetor ou raster.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">Os UDTs suportados são:<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span lang="EN-US" style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">- ST_Geometry<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span lang="EN-US" style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">- ST_Raster<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span lang="EN-US" style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">- PostGIS Geometry<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">- SDO_Geometry (Oracle)<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">- SDO_GeoRaster (Oracle)<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">- Microsoft SQL Server Geometry<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;">- Microsoft SQL Server Geography<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;"><br />
</span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT-BR;"><i>fonte: ArcGIS Resource Center</i></span></div>Marcelo Edy Peinadohttp://www.blogger.com/profile/07079236268375106512noreply@blogger.com0tag:blogger.com,1999:blog-4496465810421282573.post-56464487196119136612011-06-01T18:17:00.000-07:002011-06-14T18:52:50.696-07:00Comparativo sobre tipos de dados do ArcGIS, ArcSDE e PostgreSQL<div class="MsoNormal" style="margin-bottom: 2.4pt;"><span class="Apple-style-span" style="line-height: 17px;"><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 14px;">Quando você cria uma tabela ou adiciona uma coluna a uma tabela num banco de dados, as colunas não criadas conforme o tipo de dados específico. Tipos de dados são classificações que identificam possíveis valores para operações que podem ser feitas sobre os dados, assim como a maneira como o dado em cada coluna é armazenado no banco de dados.</span></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">Quando você importa dados de um tipo dentro de uma coluna de outro tipo de dados, você precisa entender qual tipo de dado equivalente é equivalente entre o ArcSDE e seu sistema de gerenciamento de banco de dados (DBMS) pois pode haver impacto no conteúdo do dado. Além disso, ao criar novos datasets no ArcGIS, é importante conhecer os tipos de dados equivalentes entre o ArcGIS e o seu DBMS.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">Quando você criar uma classe de feição ou tabela no ArcGIS, existem 11 possíveis tipos de dados que você pode atribuir a uma coluna. Isto significa que alguns tipos de dados podem somente ser criados fora do ArcGIS.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><br />
</div><table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-bottom-style: none; border-collapse: collapse; border-color: initial; border-left-style: none; border-right-style: none; border-top-style: none; border-width: initial; margin-left: 11.25pt; width: 537px;"><tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;"> <td style="background: #C2C4BA; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; padding: 1.5pt 0cm 1.5pt 3.0pt; width: 98.1pt;" width="131"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"><b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8pt;">ArcSDE<o:p></o:p></span></b></div><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"><b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8pt;">(tipos de dados)<o:p></o:p></span></b></div></td> <td style="background: #C2C4BA; border-left: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; padding: 1.5pt 0cm 1.5pt 3.0pt; width: 3.0cm;" width="113"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"><b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8pt;">PostgreSQL<o:p></o:p></span></b></div><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"><b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8pt;">(tipos de dados)<o:p></o:p></span></b></div></td> <td style="background: #C2C4BA; border-left: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; padding: 1.5pt 0cm 1.5pt 3.0pt; width: 92.1pt;" width="123"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"><b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8pt;">ArcGIS<o:p></o:p></span></b></div><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"><b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8pt;">(tipos de dados)<o:p></o:p></span></b></div></td> <td style="background: #C2C4BA; border-left: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; padding: 1.5pt 0cm 1.5pt 3.0pt; width: 127.6pt;" width="170"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"><b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8pt;">Notas<o:p></o:p></span></b></div></td> </tr>
<tr style="mso-yfti-irow: 1;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_STRING_TYPE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">VARCHAR<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">TEXT<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"></td> </tr>
<tr style="mso-yfti-irow: 2;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span lang="EN-US" style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_INT16_TYPE (SE_SMALLINT_TYPE)<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SMALLINT<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SHORT INTEGER<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"></td> </tr>
<tr style="mso-yfti-irow: 3;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span lang="EN-US" style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_INT32_TYPE (SE_INTEGER_TYPE)<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">INTEGER<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">LONG INTEGER<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"></td> </tr>
<tr style="mso-yfti-irow: 4;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_INT64_TYPE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">BIGINT<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">N/A<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">O parâmetro de configuração do servidor INT64TYPES deve ser TRUE para criar colunas com este tipo de dado.<o:p></o:p></span></div></td> </tr>
<tr style="mso-yfti-irow: 5;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span lang="EN-US" style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_FLOAT32_TYPE (SE_FLOAT_TYPE)<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">REAL<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">N/A<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"></td> </tr>
<tr style="mso-yfti-irow: 6;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span lang="EN-US" style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_FLOAT64_TYPE (SE_DOUBLE_TYPE)<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">NUMERIC(n,m)<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">N/A<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"></td> </tr>
<tr style="mso-yfti-irow: 7;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_DATE_TYPE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">TIMESTAMP WITHOUT ZONE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">DATE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"></td> </tr>
<tr style="mso-yfti-irow: 8;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_UUID_TYPE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">VARCHAR(38)<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">GUID<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"></td> </tr>
<tr style="mso-yfti-irow: 9;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_BLOB_TYPE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">BYTEA<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">BLOB<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"></td> </tr>
<tr style="mso-yfti-irow: 10;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_SHAPE_TYPE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">ST_GEOMETRY ou GEOMETRY *<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">GEOMETRY<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">O tipo de dado do PostgreSQL depende da chave de configuração (configuration keyword) usada ao criar uma camada: ST_GEOMETRY ou PG_GEOMETRY (geometria do PostGIS).<o:p></o:p></span></div></td> </tr>
<tr style="mso-yfti-irow: 11;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_XML_TYPE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SDE_XML or XML<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">N/A<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">Colunas XML não são expostas no ArcGIS Desktop.<o:p></o:p></span></div></td> </tr>
<tr style="mso-yfti-irow: 12;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_RASTER_TYPE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">BYTEA ou ST_RASTER<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">RASTER<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">Tipos de dados raster do PostgreSQL dependem do armazenamento específico na tabela DBTUNE.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">Você deve configurar separadamente o ST_Raster no banco de dados. Consulte as instruções no post </span><span style="font-family: Verdana, sans-serif; font-size: 8pt;"><a href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/006z/006z000000p8000000.htm"><span style="color: #0c618d;">Instalando o_tipo_ST_Raster no PostgreSQL</span></a></span><span style="font-family: Verdana, sans-serif; font-size: 8pt;">.<o:p></o:p></span></div></td> </tr>
<tr style="mso-yfti-irow: 13;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">SE_STRING_TYPE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">INTEGER<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">OBJECTID<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"></td> </tr>
<tr style="mso-yfti-irow: 14;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">NUMERIC(38,8)<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">FLOAT<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"></td> </tr>
<tr style="mso-yfti-irow: 15; mso-yfti-lastrow: yes;"> <td style="border-top: none; border: solid #C2C4BA 1.0pt; mso-border-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 98.1pt;" valign="top" width="131"></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 3.0cm;" valign="top" width="113"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">NUMERIC(38,8)<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 92.1pt;" valign="top" width="123"><div class="MsoNormal" style="line-height: normal; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="font-family: Verdana, sans-serif; font-size: 8pt;">DOUBLE<o:p></o:p></span></div></td> <td style="border-bottom: solid #C2C4BA 1.0pt; border-left: none; border-right: solid #C2C4BA 1.0pt; border-top: none; mso-border-alt: solid #C2C4BA .75pt; mso-border-left-alt: solid #C2C4BA .75pt; mso-border-top-alt: solid #C2C4BA .75pt; padding: 1.5pt 3.75pt 0cm 3.75pt; width: 127.6pt;" valign="top" width="170"></td> </tr>
</tbody></table><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 3.6pt;"><i><span style="color: black; font-family: Verdana, sans-serif; font-size: 7.5pt;">Comparativo entre os tipos de dados no PostgreSQL</span></i><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;"><o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;">*ST_Geometry e geometry são superclasses. Ao criar uma classe de feição no ArcGIS Desktop, tal classe de feição de pontos quando criada como ST_Geometry utiliza um subtipo ST_Point e quando criada com a geometria do PostGIS, utiliza um subtipo Point para seu armazenamento. Para todos os outros tipos de classes de feição criadas no ArcGIS Desktop, uma superclasse é utilizada. Se você criar uma coluna espacial utilizando SQL, o subtipo de dados atual criado depende de qual tipo de subtipo você especificou.<o:p></o:p></span></div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><br />
</div><div class="MsoNormal" style="line-height: 12.75pt; margin-bottom: 6.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 6.0pt;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 10pt;"><o:p><i>fonte: ArcGIS Resource Center</i></o:p></span></div>Marcelo Edy Peinadohttp://www.blogger.com/profile/07079236268375106512noreply@blogger.com0tag:blogger.com,1999:blog-4496465810421282573.post-18019984660978371712011-05-31T20:35:00.000-07:002011-06-03T04:52:26.670-07:00Como: Salvar um shapefile corrompido<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 10.5pt; margin-left: 0cm; margin-right: 0cm; margin-top: 7.5pt; mso-outline-level: 2; vertical-align: top;"><i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Software:</span></i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"> <b>ArcGIS - ArcEditor</b> 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1 e 10.0 <b>ArcGIS - ArcInfo</b> 8.3, 9.0, 9.1, 9.2, 9.3</span><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 14px;">, 9.3.1 e 10.0 </span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><b>ArcGIS - ArcView</b> 8.3, 9.0, 9.1, 9.2, 9.3</span><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 14px;">, 9.3.1 e 10.0</span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 1.5pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.5pt; mso-outline-level: 4; vertical-align: top;"><i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Platformas:</span></i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"> N/A<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 1.5pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.5pt; mso-outline-level: 4; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 1.5pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.5pt; mso-outline-level: 4; vertical-align: top;"><b><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Resumo<o:p></o:p></span></b></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 1.5pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.5pt; mso-outline-level: 4; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">As instruções fornecidas descrevem várias formas de salvar um shapefile corrompido. Dentre as causas comuns que podem corromper um shapefile, estão:<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 1.5pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.5pt; mso-outline-level: 4; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 1.5pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.5pt; mso-outline-level: 4; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"> - Um “crash” no computador durante uma operação de salvamento. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 1.5pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.5pt; mso-outline-level: 4; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">– Adicionar uma geometria ilegal, como uma “gravata borboleta” (bowties). <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 1.5pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.5pt; mso-outline-level: 4; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">– Modificar os atributos em outro software, como o Microsoft Excel.<b><o:p></o:p></b></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><br style="mso-special-character: line-break;" /> <br style="mso-special-character: line-break;" /> </span><span lang="EN-US" style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Está fora do âmbito deste documento enumerar todas as causas e situações onde os arquivos shapefile são corrompidos.<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><br />
Se um dos passos abaixo corrigir o shapefile, não é necessário passar para o próximo passo. Se os passos neste documento não recuperarem o shapefile, retorne o backup.<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 1.5pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.5pt; mso-outline-level: 4; vertical-align: top;"><b><span lang="EN-US" style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Procedimento<o:p></o:p></span></b></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 12.0pt; vertical-align: top;"><span lang="EN-US" style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Selecione uma opção abaixo. </span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Faça um novo back-up do dado antes de experimentar cada uma destas opções.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Utilize a ferramenta Check Geometry no caminho <i>ArcToolBox > Data Management Tools > Features</i>. Problemas com dados são reportados durante a execução da ferramenta, ou numa tabela de saída. Veja a tabela de saída após a execução do comando. Uma tabela vazia indica que a ferramenta não encontrou nenhuma geometria inválida (bad geometry). Se uma geometria inválida for reportada, utilize a ferramenta Repair Geometry conforme descrito abaixo.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Symbol; font-size: 10pt;">-<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span lang="EN-US" style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Execute o comando Repair Geometry no <i>ArcToolBox > Data Management Tools > Features</i>. </span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Após rodar a ferramenta Repair Geometry , execute novamente o Check Geometry para ter certeza de que todas as feições corrompidas foram removidas. Repita o Check Geometry/Repair Geometry quantas vezes forem necessárias.<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Exporte o dado para um geodatabase, então copie-o de volta para um novo shapefile.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span lang="EN-US" style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Se o dado estiver num drive na rede, copie-o para um drive local. Se o dado estiver num drive local, copie-o para a raiz do drive principal, por exemplo, C:\.</span><span lang="EN-US" style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Verifique se há algum nome ilegal nos campos da tabela de atributos. O nome dos campos podem ter somente dez caracteres. O nome dos campos deve iniciar com uma letra. O nome dos campos não pode conter espaços ou caracteres especiais, exceto o caracter underscore (_).<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">O nome dos arquivos não pode conter caracteres especiais, exceto para o character underscore (_). Geralmente falando, espaços no nome dos shapefiles funcionam no ArcGIS 9.X, entretanto para finalidades de teste, renomeie o shapefile para que ele não tenha espaços.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Remova todos os arquivos de indices (espacial, atributo e geocodificação), projeção e metadados no Windows Explorer. Isto é, remova todos os arquivos, exceto o the .shp, .dbf e .shx. Verifique se uma cópia destes arquivos foi feita antes de removê-los.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Tente abrir o shapefile em outro computador.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Symbol; font-size: 10pt;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Abra o shapefile em outro software, preferencialmente o ArcView 3.X. Se você puder abrí-lo no ArcView 3.X, tente salvá-lo em um novo shapefile clicando em Theme > Convert To Shapefile.<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Copie o dado para uma nova feature class usando o simple data loader ou copiando e colando as feições numa sessão de edição no ArcMap. Se seu shapefile não contém muitas feições, você pode tentar copiar e colar as feições uma por vez, ou grupos de feições para determinar quais feições podem estar corrompidas. Após cada operação de copiar e colar, salve as edições e veja se o problema desapareceu.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Se o dado ainda não tiver sido reparado e as ferramentas Check Geometry/Repair Geometry nas opções 1 ou 2 acima reportarem os IDS dos registros errados, remova-os manualmente numa sessão de edição.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Faça um cálculo num campo usando o ArcGIS e o ArcView 3.X usando o field calculator. O field calculator pode parar num registro corrompido. Examine a tabela de atributos do shapefile corrompido para determinar isto. Por exemplo, você pode ter um shapefile com 1.000 registros. Se o field calculator parar no 750º registro, então tanto o 750º ou o 751º podem estar corrompidos. Para apagar o registro corrompido, inicie uma sessão de edição no ArcMap. Copie e cole todos os registros exceto os suspeitos de erro para um novo shapefile. Como alternativa, tente apagar manualmente o(s) registro(s) com suspeita de geometria inválida. <o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Exporte o shapefile para um geodatabase. Veja so o exporte para num registro em particular. Examine a tabela de atributos da feature class exportada para determinar isto. Por exemplo, você pode ter um shapefile com 1.000 registros. Se a operação de export parar no registro parar no 750º registro, então tanto o 750º ou o 751º registros podem estar corrompidos. Para apagar o registro corrompido, inicie uma sessão de edição no ArcMap. Copie e cole todos os registros exceto os suspeitos de erro para um novo shapefile. Como alternativa, tente apagar manualmente o(s) registro(s) com suspeita de geometria inválida. <o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Apague todos os campos do shapefile exceto o FID, Shape e um atributo (shapefiles devem ter ao menos um campo). Se o problema persistir, adicione um novo campo string (texto) e remova os demais atributos. Se o problema desaparecer, isto poderia indicar um problema com um dos campos. Recupere o backup e use um processo de eliminação para determinar o campo corrompido.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Execute o aplicativo Shapefile Repairer encontrado na seção de Informações Relacionadas na parte inferior desta página. Note que este aplicativo não é suportado pela equipe de suporte técnico da ESRI.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Execute o aplicativo Shapefile Repair (não deve ser confundido com o Shapefile Repairer) encontrado na seção de Informações Relacionadas na parte inferior desta página. Note que este aplicativo não é suportado pela equipe de suporte técnico da ESRI.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Execute o aplicativo FunkFinder encontrado na seção de nformações Relacionadas na parte inferior desta página. Este aplicativo irá escrever os ID’s das feições suspeitas numa tabela dbf. Você pode tentar removê-los a partir de uma sessão de edição no ArcMap ou copiando e colando todas as feições exceto os registros suspeitos de erro para um novo shapefile Note que este aplicativo não é suportado pela equipe de suporte técnico da ESRI.<o:p></o:p></span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;"><br />
</span></div><div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; margin-left: 36pt; text-indent: -18pt; vertical-align: top;"><span style="color: black;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"><span class="Apple-style-span" style="font-family: Symbol;"><span class="Apple-style-span" style="font-size: 14px; line-height: 20px;">-</span></span><span class="Apple-style-span" style="font-family: Symbol; font-size: x-small;"><span class="Apple-style-span" style="line-height: 15.6pt;"> </span></span></span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 15.6pt;">Faça download e execute o aplicativo CleanShapefile a partir da seção de Informações Relacionadas na parte inferior desta página (apenas para o ArcGIS 8.3.).<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 1.5pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.5pt; mso-outline-level: 4; vertical-align: top;"><b><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Informações Relacionadas<o:p></o:p></span></b></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Symbol; font-size: 10pt;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><a href="http://arcscripts.esri.com/details.asp?dbid=10806" target="_new"><span style="color: #08684f;">Shapefile Repairer Utility</span></a> <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Symbol; font-size: 10pt;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><a href="http://arcscripts.esri.com/details.asp?dbid=13733" target="_new"><span style="color: #08684f;">Shapefile Repair Tool</span></a> <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Symbol; font-size: 10pt;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><a href="http://arcscripts.esri.com/details.asp?dbid=13497" target="_new"><span style="color: #08684f;">FunkFinder Utility</span></a> <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Symbol; font-size: 10pt;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><a href="http://edndoc.esri.com/arcobjects/8.3/default.asp?url=/arcobjects/8.3/Samples/Utilities/CleanShapefile/CleanShapefiles.htm" target="_new"><span style="color: #08684f;">CleanShapefile Utility (for ArcGIS 8.3)</span></a><o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; line-height: 18.0pt; mso-margin-bottom-alt: auto; vertical-align: top;"><i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Criado em:</span></i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"> 28/2/2008<br />
<i>Modificado em:</i> 31/05/2011<o:p></o:p></span><br />
<span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><i>fonte: http://www.support.esri.com</i></span></div>Marcelo Edy Peinadohttp://www.blogger.com/profile/07079236268375106512noreply@blogger.com0tag:blogger.com,1999:blog-4496465810421282573.post-29467873115538760052011-05-31T20:05:00.000-07:002011-06-03T04:52:39.833-07:00Como: Determinar o tamanho de um índice espacial (spatial index)<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 14.0pt; mso-outline-level: 2; vertical-align: top;"><span class="Apple-style-span" style="line-height: 24px;"><i style="mso-bidi-font-style: normal;"><span lang="EN-US" style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 150%;">Software</span></i></span><span class="Apple-style-span" style="line-height: 24px;"><span lang="EN-US" style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 150%;">: <b>ArcGIS - ArcEditor</b> 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1 e 10.0 <b>ArcGIS - ArcInfo</b> 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2</span></span><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 13px; line-height: 19px;">, 9.3, 9.3.1 e 10.0 </span><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 13px; line-height: 19px;"><b>ArcSDE</b> 8.0.1, 8.0.2, 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2</span><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 13px; line-height: 19px;">, 9.3, 9.3.1 e 10.0</span></div><div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; mso-outline-level: 4; vertical-align: top;"><i style="mso-bidi-font-style: normal;"><span lang="EN-US" style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 150%;">Plataformas</span></i><span lang="EN-US" style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; line-height: 150%;">: <b>Windows</b> NT 4.0, 2000, XP, Vista, Windows 2003 Server, Windows 2008 Server, Windows 7<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.0pt; mso-outline-level: 4; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.0pt; mso-outline-level: 4; vertical-align: top;"><b><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Resumo<o:p></o:p></span></b></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">O índice espacial de uma classe de feição do ArcSDE geodatabase faz consultas com velozes filtros espaciais. Determinar um valor ótimo do índice espacial é um processo interativo e depende da geometria das feições individuais que podem variar de dataset a dataset. Este post demonstra um bom ponto de partida de como determinar um índice espacial para uma classe de feição onde a geometria das feições estão com tamanho relativamente uniformes. Este documento usa uma linha de comando do SDE e SQL*Plus. O mesmo processo pode ser usado com o SQL Server Query Analyzer.<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 2.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 2.0pt; mso-outline-level: 4; vertical-align: top;"><b><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Procedimento<o:p></o:p></span></b></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-bottom: 12.0pt; margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">1.<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Use o comando sdelayer para obter o layer ID e as estatísticas de índices espaciais das camadas (layer's). <o:p></o:p></span></div><div class="MsoNormal" style="background: whitesmoke; line-height: 15.6pt; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt; vertical-align: top;"><span lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 10pt;">sdelayer -o si_stats -l <layer_name>,shape -i <instance> -u <username> -p <password><o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">O Layer ID estará na Terceira linha que diz: Layer 1 Spatial Index Statistics:<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">2.<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Inicie o SQLPlus e log como proprietário (OWNER) da camada (layer). <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-bottom: 12.0pt; margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">3.<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Calcule o tamanho médio do envelope das feições e multiplique por 3. <o:p></o:p></span></div><div class="MsoNormal" style="background: whitesmoke; line-height: 15.6pt; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt; vertical-align: top;"><span lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 10pt;">select avg((((emaxx - eminx)+(emaxy-eminy))/2)*3) average_edge from<F_table>;<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"> Onde <F_table> é o F<layerID>.<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; line-height: 18.0pt; mso-margin-bottom-alt: auto; vertical-align: top;"><i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Criado em:</span></i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"> 19/11/2007</span><br />
<span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"></span><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 13px;"><i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><i>Modificado em:</i> 31/05/2011</span></i></span><br />
<div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><i>fonte: http://www.support.esri.com</i></span></i></span></div><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><o:p></o:p></span></div>Marcelo Edy Peinadohttp://www.blogger.com/profile/07079236268375106512noreply@blogger.com0tag:blogger.com,1999:blog-4496465810421282573.post-23354011286644855832011-05-31T19:49:00.000-07:002011-06-03T04:53:06.267-07:00Como: Instalar o ArcSDE numa máquina remota ao servidor RDBMS do Oracle<div class="MsoNormal" style="background: white; margin-bottom: 9.5pt; mso-outline-level: 2; text-align: justify; vertical-align: top;"><i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Software:</span></i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"> </span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">ArcSDE</span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"> 8.2, 8.3, 9.0, 9.1, 9.2, 9.2, 9.3, 9.3.1 e 10.0</span></div><div class="MsoNormal" style="background: white; margin-bottom: 1.35pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.35pt; mso-outline-level: 4; text-align: justify; vertical-align: top;"><i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Plataforma:</span></i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"> N/A<o:p></o:p></span></div><div class="MsoNormal" style="background: white; margin-bottom: 1.35pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.35pt; mso-outline-level: 4; text-align: justify; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; mso-margin-bottom-alt: auto; mso-outline-level: 4; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><b>Resumo</b><o:p></o:p></span></div><div class="MsoNormal" style="background: white; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Às vezes é necessário instalar o ArcSDE numa máquina diferente da máquina onde a instância do Oracle está instalada. Embora este procedimento seja possível, é geralmente recomendado que o ArcSDE esteja no mesmo servidor do RDBMS Oracle. As instruções fornecidas abaixo, descrevem como instalar o ArcSDE em uma máquina e manter o RDMS Oracle em outra. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; text-align: justify; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; margin-bottom: 1.35pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.35pt; mso-outline-level: 4; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><b>Procedimento</b><o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">1.<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Certifique-se de que o Oracle esteja instalado e rodando no servidor. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">2.<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Instale o </span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><b>Oracle Net Software</b></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"> no Servidor onde o ArcSDE está instalado. Certifique-se que o SQL irá operar o servidor de dados Oracle a partir desta máquina remota. <o:p></o:p></span><br />
<span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Como o ArcSDE está em uma maquina diferente do Oracle, o ArcSDE é na verdade um cliente do Oracle, e irá usar um software de comunicação Oracle Net.<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">3.<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Realize a pré-instalação dos requisitos, como descrito no guia de instalação do ArcSDE. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">O ArcSDE Installation Guide pode ser encontrado no CD de instalação como um documento HTML.<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">4.<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Instale o ArcSDE, seguindo o guia de instalação. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">5.<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Realize o post installation do ArcSDE, conforme o guia de instalação. <o:p></o:p></span><br />
<span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Quando estiver no Wizard do Post Installation, use o Oracle Net Service Name criado com o Oracle Client em todos os locais onde o Wizard solicitar o Net Service Name.<o:p></o:p></span><br />
<span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Se a criação do repositório de tabelas do post installation for através do comando </span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><b>sdesetup </b></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">pode ser necessário uma senha -p da seguinte forma: </span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><b>password@Oracle_net_service_name</b><o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">6.<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">No Windows:<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 18.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Será necessário um passo adicional. Você deve criar um serviço no Windows. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 18.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 18.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Use o comando </span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><b>sdeservice -o create</b></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"> para criar um serviço do windows pois o Install Wizard não foi desenvolvido para criar um serviço para o ArcSDE que esteja em uma máquina remota ao servidor de dados RDBMS. No prompt de comando, insira: </span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><b>sdeservice -h</b></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"> para obter informações sobre a sintaxe do comando ou consulte o guia ArcSDE Developer. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 18.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">No setup do ArcSDE 8.x não use a opção –d do sdeservice para não criar uma dependência. Não é possível que um serviço do windows tenha uma dependência de um serviço que esteja num servidor remoto. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">No setup do ArcSDE 9.0, a opção –d para o comando sdeservice é necessária e você deve inserir o nome da instância do Oracle (SID). Entretanto, como não é possível para um serviço do windows ter uma dependência de um serviço que está num servidor remoto, você irá precisar adicionar na sintaxe do sdeservice o parâmetro –n para recusar a dependência. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><b>Exemplo:</b></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"> sdeservice -o create -p sdepasswd -d ORACLE9I,ORCL -n -i esri_sde <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">7.<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Para o Oracle conectar uma instância remota, o Oracle tem que definir uma variável de ambiente para identificar a instância remota do Oracle através de um net service name.<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 35.4pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Se o servidor ArcSDE estiver no Windows, configure a variável LOCAL para o Oracle net service name no arquivo SDEHOME\etc\dbinit.sde;<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 35.4pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 35.4pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><i>set LOCAL=netservicename. </i><o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">O arquivo dbinit.sde deverá ter a configuração LOCAL adicionada após o serviço do ArcSDE ter sido criado com o comando sdeservice. Se o serviço do ArcSDE for criado após o arquivo dbinit.sde ter sido atualizado, ele irá sobrepor a configuração com o ORACLE_SID. O arquivo SDEHOME/etc/dbinit.sde não deve conter a seguinte linha - <i>set ORACLE_SID=SID</i>. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Se o servidor ArcSDE está no UNIX, configure o TWO_TASK para o Oracle net service name. A variável ORACLE_HOME também deve estar configurada. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">TWO_TASK e LOCAL são variáveis de ambiente do Oracle. Consulte a documentação do Oracle para mais informações.<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">A variável TNS_ADMIN deve estar configurada se o local default do arquivo tnsnames.ora não for usado. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Se você receber erros de conexão do Oracle, verifique se a variável TNS_ADMIN foi configurada, e para onde ela está apontando. Configure a variável TNS_ADMIN para ver se ela resolve o problema. Verifique o arquivo tnsnames.ora para correção. Verifique se a variável ORACLE_HOME foi configurada. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 13px;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 13px;">Quando o servidor do ArcSDE estiver iniciado, o processo giomgr irá ler as configurações da variável no arquivo $SDEHOME/etc/dbinit.sde. Essas variáveis configuradas sobrepõem as variáveis definidas nos arquivos .cshrc ou .profile. O papel do arquivo dbinit.sde é mais detalhado no livro Managing ArcSDE Services.</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify; vertical-align: top;"><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: 13px;"><br />
</span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">8.<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Inicie o ArcSDE, conforme o guia de instalação. <o:p></o:p></span></div><div class="MsoNormal" style="background: white; text-align: justify; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; margin-bottom: 1.35pt; margin-left: 0cm; margin-right: 0cm; margin-top: 1.35pt; mso-outline-level: 4; text-align: justify; vertical-align: top;"><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;">Informações Relacionadas<o:p></o:p></span></div><div class="MsoNormal" style="background: white; line-height: 15.6pt; margin-left: 36.0pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt; vertical-align: top;"><span style="color: black; font-family: Symbol; font-size: 10pt; font-weight: normal;"><span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"><a href="http://help.arcgis.com/en/geodatabase/10.0/sdk/arcsde/welcome.htm" target="_new"><span style="color: #0a8161;">ArcSDE Developer Help</span></a><o:p></o:p></span></div><div class="MsoNormal" style="background: white; text-align: justify; vertical-align: top;"><br />
</div><div class="MsoNormal" style="background: white; line-height: 18.0pt; text-align: justify; vertical-align: top;"><i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;">Criado em:</span></i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"> 24/3/2007</span><br />
<span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt; font-weight: normal;"></span><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: x-small;"><i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><i>Modificado em:</i> 31/05/2011</span></i></span><br />
<span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: x-small;"><i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"></span></i></span><span class="Apple-style-span" style="font-family: Verdana, sans-serif; font-size: x-small;"><i><span style="color: black; font-family: Verdana, sans-serif; font-size: 9.5pt;"><i>fonte: http://www.support.esri.com</i></span></i></span></div>Marcelo Edy Peinadohttp://www.blogger.com/profile/07079236268375106512noreply@blogger.com0