20161025
11251800
1.0
FALSE
gisdb.gisadmin.agua_Hidrantes
002
Server=cscarcgisdb; Service=sde:postgresql:cscarcgisdb; Database=gisdb; User=gisadmin; Version=sde.DEFAULT
ArcSDE Connection
707660.888700
720457.606300
7080175.915600
7105690.534200
1
Projected
GCS_SIRGAS_2000
SIRGAS_2000_UTM_Zone_22S
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WKT>PROJCS["SIRGAS_2000_UTM_Zone_22S",GEOGCS["GCS_SIRGAS_2000",DATUM["D_SIRGAS_2000",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",10000000.0],PARAMETER["Central_Meridian",-51.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",31982]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>1900</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>31982</WKID><LatestWKID>31982</LatestWKID></ProjectedCoordinateSystem>
Linear Unit: Meter (1.000000)
CopyFeatures "C:\Users\augusto.soares\Desktop\Geodatabases\Dados CIA.gdb\Hidrantes" "\\aguasjve\caj\Arquivos\GMC\CMD\Cadastro Integrado\Cadastro_Integrado.gdb\Cadastro_Operacional_Agua\Hidrantes" # 0 0 0
CopyFeatures "N:\Arquivos\GFC\CCI\Cadastro Integrado\Cadastro_Integrado.gdb\Cadastro_Operacional_Agua\Hidrantes" "N:\Arquivos\GFC\CCI\Cadastro Integrado\Banco ArcGIS\Agua.gdb\Hidrantes" # 0 0 0
CalculateField "Hidrantes Operacionais" Micromedicao "Sim" VB #
CopyFeatures D:\arcgisserver\mapas\caj\Visualizador_CAJ.gdb\Hidrantes "Database Connections\PROD geo.sde\simgeo.geo.caj\simgeo.geo.Hidrantes" PG_GEOMETRY 0 0 0
CopyFeatures "Database Connections\PROD aguas.sde\simgeo.geo.caj\simgeo.geo.Hidrantes" "Database Connections\PROD aguas.sde\simgeo.aguas.aguas\simgeo.aguas.Hidrantes" PG_GEOMETRY 0 0 0
CopyFeatures "Database Connections\PROD aguas.sde\simgeo.aguas.aguas\simgeo.aguas.Hidrantes" M:\SAP\UNG\GEO\Temp\Michel\bkp_caj.gdb\Hidrantes # 0 0 0
CopyFeatures "Database Connections\PROD caj.sde\simgeo.caj.caj\simgeo.caj.Hidrantes" M:\SAP\UNG\GEO\Temp\Michel\aguas_caj.gdb\Hidrantes # 0 0 0
CopyFeatures M:\SAP\UNG\GEO\Temp\Michel\aguas_caj.gdb\agua_Hidrantes "Database Connections\PROD caj.sde\simgeo.caj.caj\simgeo.caj.agua_Hidrantes" PG_GEOMETRY 0 0 0
CalculateField simgeo.caj.agua_Hidrantes micromedicao "Não" VB #
CopyFeatures "Database Connections\Connection to Other.sde\simgeo.caj.caj\simgeo.caj.agua_Hidrantes" M:\TI\Desenvolvimento\Geral\Michel\MigracaoArcgis\caj.gdb\agua_Hidrantes # 0 0 0
ExportFeatures M:\TI\Desenvolvimento\Geral\Michel\MigracaoArcgis\caj.gdb\agua_Hidrantes "M:\TI\Desenvolvimento\Geral\Michel\ArcGIS\Connection Files\producao-gisadmin.sde\gisdb.gisadmin.caj\gisdb.gisadmin.agua_Hidrantes" # NOT_USE_ALIAS "hidrante_operacional "Hidrante_Operacional" true true false 5 Text 0 0,First,#,M:\TI\Desenvolvimento\Geral\Michel\MigracaoArcgis\caj.gdb\agua_Hidrantes,hidrante_operacional,0,5;micromedicao "Micromedicao" true true false 5 Text 0 0,First,#,M:\TI\Desenvolvimento\Geral\Michel\MigracaoArcgis\caj.gdb\agua_Hidrantes,micromedicao,0,5;usuario_ad "usuario_ad" true true false 50 Text 0 0,First,#,M:\TI\Desenvolvimento\Geral\Michel\MigracaoArcgis\caj.gdb\agua_Hidrantes,usuario_ad,0,50;dt_inc "dt_inc" true true false 8 Date 0 0,First,#,M:\TI\Desenvolvimento\Geral\Michel\MigracaoArcgis\caj.gdb\agua_Hidrantes,dt_inc,-1,-1;dt_upd "dt_upd" true true false 8 Date 0 0,First,#,M:\TI\Desenvolvimento\Geral\Michel\MigracaoArcgis\caj.gdb\agua_Hidrantes,dt_upd,-1,-1;tampa "Tampa" true true false 50 Text 0 0,First,#,M:\TI\Desenvolvimento\Geral\Michel\MigracaoArcgis\caj.gdb\agua_Hidrantes,tampa,0,50;globalid "globalid" false false true 38 GlobalID 0 0,First,#,M:\TI\Desenvolvimento\Geral\Michel\MigracaoArcgis\caj.gdb\agua_Hidrantes,globalid,-1,-1;matricula "Matrícula" true true false 20 Text 0 0,First,#,M:\TI\Desenvolvimento\Geral\Michel\MigracaoArcgis\caj.gdb\agua_Hidrantes,matricula,0,20" #
Rename "C:\Users\jose.coppetti\Downloads\10.1.2.26 Admin.sde\gisdb.gisadmin.caj\gisdb.gisadmin.agua_Hidrantes" "C:\Users\jose.coppetti\Downloads\10.1.2.26 Admin.sde\gisdb.gisadmin.caj\gisdb.gisadmin.agua_Hidrante" FeatureClass
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.4.0'><FeatureDataset>gisdb.gisadmin.caj</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686a694d6f592f594e624850753354416f62437a796a3739653971657a514b6a374f684d6146412f4d3664513d2a00;SERVER=10.1.2.26;INSTANCE=sde:postgresql:10.1.2.26;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=10.1.2.26;DATABASE=gisdb;USER=gisadmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.gisadmin.agua_Hidrante</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterField><field_name>hidrante_operacional</field_name><field_alias>Hidrante operacional</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>micromedicao</field_name><new_field_name>possui_micromedicao</new_field_name><field_alias>Possui micromedição?</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>tampa</field_name><new_field_name>tipo_tampa</new_field_name><field_alias>Tipo de tampa</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>matricula</field_name><new_field_name>matricula_sistema_comercial</new_field_name><field_alias>Matrícula sistema comercial</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AddField><field_name>status_utilizacao</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>20</field_length><field_alias>Estado de utilização</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CAJ - Utilização</field_domain></AddField></workflow><workflow><AddField><field_name>denominacao</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>100</field_length><field_alias>Denominação / Rua de instalação</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>data_implantacao</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>Data de implantação</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>data_operacao</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>Data de operação</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>diametro_rede</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>Diâmetro da rede</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CAJ - Diâmetro Redes</field_domain></AddField></workflow><workflow><AddField><field_name>pressao_rede</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>2</field_scale><field_alias>Pressão da rede</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>vazao_servico</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>2</field_scale><field_alias>Vazão de serviço</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>categoria</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>1</field_length><field_alias>Categoria</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>tipo_instalacao</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>20</field_length><field_alias>Tipo de instalação</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>codigo</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>20</field_length><field_alias>Código</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>observacoes</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>100</field_length><field_alias>Observações</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.4.0'><FeatureDataset>gisdb.gisadmin.caj</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6851492f2f50766e3271514e53327363333932454e36547430384c474a532f39494d544d774a2b52647a78593d2a00;SERVER=10.1.2.26;INSTANCE=sde:postgresql:10.1.2.26;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=10.1.2.26;DATABASE=gisdb;USER=gisadmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.gisadmin.agua_Hidrante</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><CreateDomain><domain_name>CAJ - Tipo Instalação Hidrante</domain_name><domain_description>Tipo de instalação do hidrante, conforme Norma NBR 12218.</domain_description><field_type>TEXT</field_type><domain_type>CODED</domain_type><split_policy>DEFAULT</split_policy><merge_policy>DEFAULT</merge_policy></CreateDomain><AddCodedValueToDomain><domain_name>CAJ - Tipo Instalação Hidrante</domain_name><code>Coluna</code><code_description>Coluna</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>CAJ - Tipo Instalação Hidrante</domain_name><code>Subterrâneo</code><code_description>Subterrâneo</code_description></AddCodedValueToDomain></workflow><workflow><AssignDomainToField><field_name>categoria</field_name><domain_name>CAJ - Categoria Hidrante</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>tipo_instalacao</field_name><domain_name>CAJ - Tipo Instalação Hidrante</domain_name></AssignDomainToField></workflow></operationSequence>"
CalculateField TERCEIROS\Hidrantes hidrante_operacional ""HDT" & [objectid]" VB #
CalculateField TERCEIROS\Hidrantes codigo ""HDT" & [objectid]" VB #
CalculateField TERCEIROS\Hidrantes codigo ""HDT" & ( [objectid]-1)" VB #
CalculateField CADASTRO\OPERACIONAL\SAA\Equipamentos\Peças\Secundárias\Hidrante codigo "
// Prefixo do código
var prefix = "HT";
// Número total de registros (ajuste conforme necessário)
var total = 81;
// Número sequencial baseado no ObjectID
var seq = $feature.OBJECTID;
// Formata o número com zeros à esquerda (4 dígitos)
var num = Text(seq, "0000");
// Junta o prefixo com o número formatado
return prefix + num;
" ARCADE # TEXT NO_ENFORCE_DOMAINS
CalculateField CADASTRO\OPERACIONAL\SAA\Equipamentos\Peças\Secundárias\Hidrante codigo "
// Prefixo do código
var prefix = "HT";
// Número total de registros (ajuste conforme necessário)
var total = 81;
// Número sequencial baseado no ObjectID
var seq = $feature.OBJECTID;
// Formata o número com zeros à esquerda (4 dígitos)
var num = Text(seq, "0000");
// Junta o prefixo com o número formatado
return prefix + num;
" ARCADE # TEXT NO_ENFORCE_DOMAINS
CalculateField CADASTRO\OPERACIONAL\SAA\Equipamentos\Peças\Secundárias\Hidrante codigo "
// Prefixo do código
var prefix = "HDT";
// Número total de registros (ajuste conforme necessário)
var total = 81;
// Número sequencial baseado no ObjectID
var seq = $feature.OBJECTID;
// Formata o número com zeros à esquerda (3 dígitos)
var num = Text(seq, "000");
// Junta o prefixo com o número formatado
return prefix + num;
" ARCADE # TEXT NO_ENFORCE_DOMAINS
CalculateField CADASTRO\OPERACIONAL\SAA\Equipamentos\Peças\Secundárias\Hidrante codigo "
// Prefixo do código
var prefix = "HDT";
// Número total de registros (ajuste conforme necessário)
var total = 81;
// Número sequencial baseado no ObjectID
var seq = $feature.OBJECTID;
// Formata o número com zeros à esquerda (4 dígitos)
var num = Text(seq, "000");
// Junta o prefixo com o número formatado
return prefix + num;
" ARCADE # TEXT NO_ENFORCE_DOMAINS
20230712
16411600
20230712
16411600
ISO 19139 Metadata Implementation Specification
Microsoft Windows 10 Version 10.0 (Build 19043) ; Esri ArcGIS 13.1.2.41833
hidrante_caj
002
1
-48.922581
-48.790281
-26.151294
-26.383430
Enterprise Geodatabase Feature Class
dataset
EPSG
6.11(8.1.2)
Simple
FALSE
0
TRUE
FALSE
0
gisdb.gisadmin.agua_Hidrantes
Feature Class
0
OBJECTID
objectid
OID
4
10
0
Internal feature number.
ESRI
Sequential unique whole numbers that are automatically generated.
SHAPE
shape
Geometry
8
0
0
Feature geometry.
ESRI
Coordinates defining the features.
Hidrante_Operacional
Hidrante_Operacional
String
5
0
0
Micromedicao
Micromedicao
String
5
0
0
usuario_ad
usuario_ad
String
50
0
0
dt_inc
dt_inc
Date
8
0
0
dt_upd
dt_upd
Date
8
0
0
tampa
Tampa
String
50
0
0
globalid
globalid
GlobalID
38
0
0
matricula
Matrícula
String
20
0
0
20230712
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAqGa5jhVssC4UkJnk1NWPd6H9p1eK+80jZ1XJ5pNtbIqKi/idhw1iVjIFsn+Qn7
xwcD8KlttUa4uUiNrIgYE7j0FaAAFLgVq5Qt8JFmFFFFZjCiiigAooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigA
ooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACi
iigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigA
ooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACi
iigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKACiiigAooooAKKKKAP/2Q==