20210811
12040500
1.0
FALSE
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.8.0'><WorkspaceConnectionString>DATABASE=U:\IEDE\1.1_Parceiros IEDE RS\SES\shp_coordenadorias_saude18</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>sesrs.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>endereco</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField sesrs endereco !endereço! "Python 3" # Text NO_ENFORCE_DOMAINS
DeleteField sesrs endereço
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.8.0'><WorkspaceConnectionString>DATABASE=U:\IEDE\1.1_Parceiros IEDE RS\SES\shp_coordenadorias_saude18</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>sesrs.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>municipio1</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Campo</field_name><field_type>LONG</field_type><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
DeleteField sesrs Campo
CalculateField sesrs municipio1 !municipio! "Python 3" # Text NO_ENFORCE_DOMAINS
DeleteField sesrs municipio
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.8.0'><WorkspaceConnectionString>DATABASE=U:\IEDE\1.1_Parceiros IEDE RS\SES\shp_coordenadorias_saude18</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>sesrs.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>municipio</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField sesrs municipio !muni! "Python 3" # Text NO_ENFORCE_DOMAINS
DeleteField sesrs muni
FeatureClassToFeatureClass sesrs C:\Users\maria-barbosa\Documents\ArcGIS\Projects\MyProject.gdb coordenadorias_de_saude # "cod "cod" true true false 16 Double 6 15,First,#,sesrs,cod,-1,-1;crs "CRS" true true false 254 Text 0 0,First,#,sesrs,crs,0,254;fone "fone" true true false 254 Text 0 0,First,#,sesrs,fone,0,254;e_mail "e_mail" true true false 254 Text 0 0,First,#,sesrs,e_mail,0,254;lon "lon" true true false 16 Double 6 15,First,#,sesrs,lon,-1,-1;lat "lat" true true false 16 Double 6 15,First,#,sesrs,lat,-1,-1;endereco "endereço" true true false 254 Text 0 0,First,#,sesrs,endereco,0,254;municipio1 "municipio1" true true false 254 Text 0 0,First,#,sesrs,municipio1,0,254;municipio "município" true true false 254 Text 0 0,First,#,sesrs,municipio,0,254" #
Rename C:\Users\maria-barbosa\Documents\ArcGIS\Projects\MyProject.gdb\coordenadorias_de_saude C:\Users\maria-barbosa\Documents\ArcGIS\Projects\MyProject.gdb\sedes_coordenadorias_de_saude FeatureClass
FeatureClassToFeatureClass sedes_coordenadorias_de_saude C:\Users\maria-barbosa\Documents\ArcGIS\Projects\gisdb.pgsql-geo.procergs.reders(4).sde\gisdb.gisadmin.ses coordenadorias_de_saude_sedes # "cod "cod" true true false 8 Double 0 0,First,#,sedes_coordenadorias_de_saude,cod,-1,-1;crs "CRS" true true false 254 Text 0 0,First,#,sedes_coordenadorias_de_saude,crs,0,254;fone "fone" true true false 254 Text 0 0,First,#,sedes_coordenadorias_de_saude,fone,0,254;e_mail "e_mail" true true false 254 Text 0 0,First,#,sedes_coordenadorias_de_saude,e_mail,0,254;lon "lon" true true false 8 Double 0 0,First,#,sedes_coordenadorias_de_saude,lon,-1,-1;lat "lat" true true false 8 Double 0 0,First,#,sedes_coordenadorias_de_saude,lat,-1,-1;endereco "endereço" true true false 254 Text 0 0,First,#,sedes_coordenadorias_de_saude,endereco,0,254;municipio1 "municipio1" true true false 254 Text 0 0,First,#,sedes_coordenadorias_de_saude,municipio1,0,254;municipio "município" true true false 254 Text 0 0,First,#,sedes_coordenadorias_de_saude,municipio,0,254" #
Rename C:\Users\maria-barbosa\Documents\ArcGIS\Projects\gisdb.pgsql-geo.procergs.reders(4).sde\gisdb.gisadmin.ses\gisdb.gisadmin.coordenadorias_de_saude_sedes C:\Users\maria-barbosa\Documents\ArcGIS\Projects\gisdb.pgsql-geo.procergs.reders(4).sde\gisdb.gisadmin.ses\gisdb.gisadmin.coordenadorias_regionais_de_saude_sedes 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.8.0'><FeatureDataset>gisdb.gisadmin.ses</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68535854415932764c62727873356b44686f456c2f30456759537937506164565a33616b7236436e4a73644d3d2a00;SERVER=gisdb.pgsql-geo.procergs.reders;INSTANCE=sde:postgresql:gisdb.pgsql-geo.procergs.reders;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gisdb.pgsql-geo.procergs.reders;DATABASE=gisdb;USER=gisadmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.gisadmin.coordenadorias_regionais_de_saude_sedes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>regiao_saude</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>30</field_length><field_alias>Região da Saúde</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.8.0'><FeatureDataset>gisdb.gisadmin.ses</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68535854415932764c62727873356b44686f456c2f30456759537937506164565a33616b7236436e4a73644d3d2a00;SERVER=gisdb.pgsql-geo.procergs.reders;INSTANCE=sde:postgresql:gisdb.pgsql-geo.procergs.reders;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gisdb.pgsql-geo.procergs.reders;DATABASE=gisdb;USER=gisadmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.gisadmin.coordenadorias_regionais_de_saude_sedes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>regiao_saude</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>30</field_length><field_alias>Região da Saúde</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
gisdb.gisadmin.coordenadorias_de_saude_sedes
002
Server=gisdb.pgsql-geo.procergs.reders; Service=sde:postgresql:gisdb.pgsql-geo.procergs.reders; Database=gisdb; User=gisadmin; Version=sde.DEFAULT
ArcSDE Connection
Geographic
GCS_SIRGAS_2000
Angular Unit: Degree (0.017453)
<GeographicCoordinateSystem xsi:type='typens:GeographicCoordinateSystem' 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.8.0'><WKT>GEOGCS["GCS_SIRGAS_2000",DATUM["D_SIRGAS_2000",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433],AUTHORITY["EPSG",4674]]</WKT><XOrigin>-400</XOrigin><YOrigin>-400</YOrigin><XYScale>999999999.99999988</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>8.98315284119521e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4674</WKID><LatestWKID>4674</LatestWKID></GeographicCoordinateSystem>
20210813
17472200
20210813
18000100
150000000
5000
NAP
Microsoft Windows 10 Version 10.0 (Build 18363) ; Esri ArcGIS 12.8.0.29751
coordenadorias_regionais_saude_sedes
Sedes das Coordenadorias Regionais de Saúde (CRS) criadas a partir das regiões de coordenadorias de saúde com o vínculo do shapefile de municípios.
Coordenadorias Regionais de Saúde (CRS) criadas a partir das regiões de coordenadorias de saúde com o vínculo do shapefile de municípios do IBGE do ano de 2018 e sedes das coordenadorias.
Secretaria Estadual da Saúde/DGTI - Divisão de Projetos
Coordenadorias
Saúde
sedes crs
crs
Classe de Feição do Geodatabase Enterprise
dataset
EPSG
6.11(9.2.0)
0
Simple
FALSE
0
TRUE
FALSE
gisdb.gisadmin.coordenadorias_de_saude_sedes
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.
cod
cod
Double
8
38
8
crs
CRS
String
254
0
0
fone
fone
String
254
0
0
e_mail
e_mail
String
254
0
0
lon
lon
Double
8
38
8
lat
lat
Double
8
38
8
endereco
endereço
String
254
0
0
municipio1
municipio1
String
254
0
0
municipio
município
String
254
0
0
20210813
Dado criado a partir das regiões de Coordenadorias de Saúde com o vínculos do shapefile de municípios do IBGE do ano de 2018 e a sede das coordenadorias.
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigBK5vxD400nw1PHBemRpZBu2RqCQPU810lea/ELSEi1e21lrAXqTR/ZGiJxt
cn5G/U104SnTqVVGpt+phiJzhC8NzvtO1C21WxjvLRw8MgypFW8Vj+GdIGiaBbWX8Srl/qetbNY1
VFTajtfQ1g5OKctxaKKKgoKKKKAKt7fWun25nu5o4Yh1ZzgU2xv7TUbcTWc8c0R/iQ5rj/iZphvt
JtbiSSRbO2nDXOwZIQ8Egd8Unwz0wWWnXtzBJI1jczk2wkGCUHG7Hv8A0rs+rU/qvtub3r7dP+HO
X20/beztod7RRRXGdQUUUUANIBUgjg1ymieEV0rxHf6k0rSRPxaxliRCG5fA7ZPpXWd6SrhVlBOM
Xo9yJU1JpvoOoooqCwooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKjkiS
VQJEVgDnDDPNSUUAIaBXN+NdeufD+gtdWcIkuHcRx5GQpPc1j+BfE2s6pqF5putW4S4gUPuC7SAe
xFdEcJOVF1lay+8wliIRqKm92d5RSFgqkk4A6k1UttUsL2V4ra7hmkT7yxuCRXOk2rpGzaWhdooo
oGQXNtFd20kE6B4pFKup6EGktLWKytIbWBQkUKBEUdgBip6KOZ2t0FZXuLRRRQMKKKD0oAj3KCAS
AT0GacPevEvEMPiJ/E2oXgv/AC3troJDAJiGZSfl2r3GK9ms/ONlB5+PO8tfMx/exz+tdWJwvsYR
lzJ3/A5qFf2kpRtaxZooorlOkKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACiiigDN1rS49Y0q4sZeBKmFb+63Y/geayPBuhXOk6e8uouZdRuG3TSMcnA4Az9K6g0Voq01TdN
bMzdKLmp9UZuvW097oN7bWrlZ5ImVCPWvK/AujLH4utZbG7kk8mJmvAVK7G6bfevZqoWOkWenXN1
PbRBJLqTzJSO5rfD4t0qU6fcyq0FUqRn2L9FY3ifXF8PaHNfmIyspConqx6Vz3gvxxc+IdRm0++s
xbzrF5yFQQCuQOh+orOGGqSpOql7qLlWhGapt6s7uiiisDYKKKKACiiigDCv/Ddne+ILTV5B+9tw
Rt7N6E/StvHNLxRxmqlOUklJ7bExiottdRaKKKkoKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKAM3W9Li1nSZ7KUDEi8H0bsa53wPot9bCfUtX+a/cfZkJ
XG2JDx+Z/kK7OitY15xpumtmZSpRc1N7oWiiisjUKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooASqWpalbaVYzXt2+yGIZZv0q5isbxRo/9u+HbzT1OHkTKH/aByP1FXSUXUipu
yvr6ETclFuO5V8O+NNK8SzSQWbOssYzskXBI9RXSV5t8PtKjm1KbWFsPsSRL9mWIEncw4Zq9JrbF
06dOq409jLDznKF57i0UUVzHQFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAnailqreX
1rp8PnXc8cMfTc5wKEm3ZCbS1ZZo61BaXlvfQLNbTJLE3RkORU9DTTswTvqhaKKKBhRRRQAUUUUA
FFN3ru27hu9M06gCjqd9Fpem3F/MCUgjMjAdTgVxfhj4kLrutCwnsjAJs+SwOc+xruLy0hvrKe1n
XdFMhR19QRiuI8IeHb2DV3fUYowmlj7NaMqbS4/vn14xXbhlQdGbqL3ltr+XzOWs6ntIqL0PQaKK
K4jqCiiigCKOKOIERoFBJYgDHJqWiigAooooAKKKKACiiigBvavPPEnxNTRNefTobHz1hIEzlsck
ZwK9Drz/AMU+HLmfXl+x20Tw6tthu5GTJj2c7ge2RkfgK7MCqLqNVldW72ObFOqoXpvU7fT72LUb
CC8hz5cyB1z6GrVQWlrHZ2kVtENscahVHsKnrklbmfLsdEb213FooopDCiiigAooooAKKKKAE7Vw
PxM0oX9rYzXFy0NjDMPPYLu2A8bsV31Vr6yg1Gyms7hA8MqFHX1BrbD1XRqKfYyrU/aQcTj/AIZa
ZJYaHcyea0ltPcM1sWGN0Y4DY7Zxmu5qG3t4rW2jghQJHGoRFHYDgVNSr1XVqOo+o6VP2cFFdBaK
KKyNAoopu4A4yM+lADqac7Tjr2zTqKAPC7WLXh4gt7w6luv5bxontfMO9cHklfSvc6w08N2cfiiT
XAo894gmMdD6/lW32rsxuJVdxstl/S+Ry4ai6fNd7sdRRRXGdQUUUUAFFFRSzxQKGlkVAeAWOKEr
gS0U0MGAKkEHoRTqACiiigBKQmlryjx62v3PiV7ezu2traC289cSbA2Ov1PSt8Lh/bz5Oa3qY16v
so81rnq45orC8JXF7c+F7GbUNxuXjBYt1I7E/hW4TWU4csnF9C4yvFS7jqKKKksKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigBucmvEtZfxFJ4j1C8XUjDLa3QSO280gsCeNq9xXtvTNYF74
Xs7zxNa6y6jzIFwVx949j+FduCxEaEpOS3Xa/wAvmc2JpSqRSi+ptW/mm1i87Hm7Bvx/exz+tT0U
VxPU6QooooAKKKKACiiigBK8t+JWm3N/r2npLfra6e8T7ZHzsWQDPOO5HT6GvUqytd0O01+wFpdr
lBIsgPcEH+oyPxrowlf2FVT/AK9THEU/aQcUZXw/hvYPCNst67PISxQt12Z4/SuqpkcaxIqIAFUY
AHYU+sqtT2lSU7bsunDkgo9haKKKgsb9KwfEvhi28RraiclTBMrkj+JM/Mv4it+iqhOUJKUXZomc
IzXLJaCKiogVQAoGAB2p1FFSUFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFF
FABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUU
AFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA
UUUUAFFFFABRRRQAUUUUAFFFFABRRTWdUUs7BVHUk0AOoqOKeOZN8UiuvqpzUlFrAFFFFABRRRQA
UUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABR
RRQAnauP+I9veXHhSQWkjIFkUy4/ud/wrsKhuII7m3khlUNHIpVge4NaUavs6kZ9mZ1Yc8HHuedf
DPS7nTb3UlS8W5sAECumdrPjJwPYHn8K9LrO0bSLXRNNjsbRcRISeepJOea0avFVvbVXMmhT9lBR
FooorA2CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig
AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigDnPFfiu18K2cc0yNLJIcRxqcZpfC
nim28U2MlxAjRvE22SNux7UUV6f1an9S9tb3rnF7af1nk6f8A6KiiivMO0KKKKACiiigAooooAKK
KKACiiigAooooA//2Q==