20231011
13341600
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/3.1.0'><WorkspaceConnectionString>DATABASE=U:\IEDE\1.1_Parceiros IEDE RS\SES\GEOPROTEÇÃO\IGP_locais pericias_psiquicas\pontos_municipios_pericias psiquicas</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>pontos_municipios_pericias_psiquicas_shp.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>N_atendi</field_name><field_type>TEXT</field_type><field_length>254</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>DATABASE=U:\IEDE\1.1_Parceiros IEDE RS\SES\GEOPROTEÇÃO\IGP_locais pericias_psiquicas\pontos_municipios_pericias psiquicas</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>pontos_municipios_pericias_psiquicas_shp.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Endereco</field_name><field_type>TEXT</field_type><field_length>254</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>DATABASE=U:\IEDE\1.1_Parceiros IEDE RS\SES\GEOPROTEÇÃO\IGP_locais pericias_psiquicas\pontos_municipios_pericias psiquicas</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>pontos_municipios_pericias_psiquicas_shp.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Name</field_name><field_name>descriptio</field_name><field_name>timestamp</field_name><field_name>begin</field_name><field_name>end</field_name><field_name>altitudeMo</field_name><field_name>tessellate</field_name><field_name>extrude</field_name><field_name>visibility</field_name><field_name>drawOrder</field_name><field_name>icon</field_name><field_name>Endereço</field_name><field_name>N_atendi</field_name></DeleteField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>DATABASE=U:\IEDE\1.1_Parceiros IEDE RS\SES\GEOPROTEÇÃO\IGP_locais pericias_psiquicas\pontos_municipios_pericias psiquicas</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>pontos_municipios_pericias_psiquicas_shp.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>N_atendi</field_name><field_type>TEXT</field_type><field_length>254</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>DATABASE=U:\IEDE\1.1_Parceiros IEDE RS\SES\GEOPROTEÇÃO\IGP_locais pericias_psiquicas\pontos_municipios_pericias psiquicas</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>pontos_municipios_pericias_psiquicas_shp.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Nº_atendi</field_name></DeleteField></workflow></operationSequence>
SpatialJoin Pericias_psiquicas Municipios C:\Users\isabel-rekowsky\Documents\ArcGIS\Default.gdb\Pericias_psiquicas_SpatialJo JOIN_ONE_TO_ONE KEEP_ALL "Cidade "Cidade" true true false 254 Text 0 0 ,First,#,Pericias_psiquicas,Cidade,-1,-1;Nome "Nome" true true false 254 Text 0 0 ,First,#,Pericias_psiquicas,Nome,-1,-1;Telefone "Telefone" true true false 254 Text 0 0 ,First,#,Pericias_psiquicas,Telefone,-1,-1;Perito "Perito" true true false 254 Text 0 0 ,First,#,Pericias_psiquicas,Perito,-1,-1;Dia_da_Sem "Dia_da_Sem" true true false 254 Text 0 0 ,First,#,Pericias_psiquicas,Dia_da_Sem,-1,-1;Turno "Turno" true true false 254 Text 0 0 ,First,#,Pericias_psiquicas,Turno,-1,-1;Endereco "Endereco" true true false 254 Text 0 0 ,First,#,Pericias_psiquicas,Endereco,-1,-1;N_atendi "N_atendi" true true false 254 Text 0 0 ,First,#,Pericias_psiquicas,N_atendi,-1,-1;codigo "codigo" true true false 4 Long 0 0 ,First,#,Municipios,codigo,-1,-1;nome_1 "nome" true true false 254 Text 0 0 ,First,#,Municipios,nome,-1,-1;corede "corede" true true false 254 Text 0 0 ,First,#,Municipios,corede,-1,-1;regiao_func "regiao_func" true true false 4 Long 0 0 ,First,#,Municipios,regiao_func,-1,-1;areaf_km2 "areaf_km²" true true false 8 Double 0 0 ,First,#,Municipios,areaf_km2,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,Municipios,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,Municipios,Shape_Area,-1,-1;cos_ses "Cod_SES" true true false 4 Long 0 0 ,First,#,Municipios,cos_ses,-1,-1;crs "CRS" true true false 4 Long 0 0 ,First,#,Municipios,crs,-1,-1" INTERSECT # #
CalculateField Pericias_psiquicas_SpatialJo Cidade [nome_1] VB #
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/3.1.0'><WorkspaceConnectionString>DATABASE=U:\IEDE\1.1_Parceiros IEDE RS\Projeto_IEDE_RS\iede.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Pericias_psiquicas</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Dia_da_Sem</field_name><new_field_name>Dia_da_Semana</new_field_name><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>Turno</field_name><new_field_name>Turno_atendimento</new_field_name><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>cos_ses</field_name><new_field_name>cod_ses</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>DATABASE=U:\IEDE\1.1_Parceiros IEDE RS\Projeto_IEDE_RS\iede.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Pericias_psiquicas</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>codigo</field_name><new_field_name>cod_ibge</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
CopyFeatures Pericias_psiquicas "U:\IEDE\1.1_Parceiros IEDE RS\SES\GEOPROTEÇÃO\IEDE_Geoprotecao\IEDE_Geoprotecao.gdb\Pericias_psiquicas" # # # #
CopyFeatures Pericias_psiquicas "C:\Users\maria-barbosa\AppData\Roaming\Esri\ArcGISPro\Favorites\gisdb.pgsql-geo.procergs.reders (1).sde\gisdb.gisadmin.geoprotecao\gisdb.gisadmin.Pericias_psiquicas" # # # #
gisdb.gisadmin.Pericias_psiquicas
002
-55.536963
-50.278126
-32.028932
-27.646561
1
0.001
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/3.1.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>
20231017
12081200
20231017
12081200
150000000
5000
ItemDescription
North American Profile of ISO19115 2003
Microsoft Windows 10 Version 10.0 (Build 22621) ; Esri ArcGIS 13.1.3.41833
Perícias Psíquicas
1
-55.536963
-50.278126
-27.646561
-32.028932
0.000000
0.000000
Dados relacionados às Perícias Psíquicas realizadas pelo IGP-RS.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Dados relacionados às Perícias Psíquicas realizadas pelo IGP-RS. Dados fornecidos por e-mail, com autorização da Direção-Geral do órgão</SPAN><SPAN>, a partr da tabela fornecida com os dados, foi utilizado no google earth, gerando pontos dos dados para serem georreferenciados no software QGIS. </SPAN></P></DIV></DIV></DIV>
Violência sexual
violência
rede de proteção
atendimento violência sexual
abuso sexual
estupro de vulnerável
crainça
adolescente
abuso de menor
Posto Médico-Legal
Perícia Psíquica
Classe de Feição do Geodatabase Enterprise
0.001
dataset
EPSG
6.11(9.2.0)
0
Simple
FALSE
0
TRUE
TRUE
gisdb.gisadmin.Pericias_psiquicas
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.
Cidade
Cidade
String
254
0
0
Nome
Nome
String
254
0
0
Telefone
Telefone
String
254
0
0
Perito
Perito
String
254
0
0
Dia_da_Semana
Dia da Semana
String
254
0
0
Turno_atendimento
Turno atendimento
String
254
0
0
Endereco
Endereço
String
254
0
0
N_atendi
Nº de atendimentos
String
254
0
0
cod_ibge
Cód_IBGE
Integer
4
10
0
corede
COREDE
String
254
0
0
regiao_func
Região Funcional
Integer
4
10
0
cod_ses
Cod_SES
Integer
4
10
0
crs
CRS
Integer
4
10
0
20231017
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKyn161j15dIIbz2AwcjuCenXGFPPStWm4tbjcWtwooopCCiiigAo
oooAKKKKACqOs376ZpNxeom/yV3HgnC55bA5OBk4HpV6kZVdCjKGVhggjgimmk7sasnqUdGv31PS
Le9ePYZl3AYIyM8HB5GRg4PrV+kVVRQqgBQMADtS0SabugbTegUUUUhBRRRQAUUUUAFFFFABRRRQ
AUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAVG020fVI9SaFTdxxGFZO4UkEj9Kt0UU229xtt7
hRRRSEFFFFABRRRQAUUUUAFFBOBmsvSNdttZMwtwR5WM8g9fX0PHSmotptdBqLaualFFFIQUUUUA
FFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABVSx0y004zm0hWPz5TLJj+Jj1NW6Kd3aw7vYKKKKQgooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKge8tkultmmUTNyEJ5ppXCxPWN4mv73TdLFzZRNIwcBgq7jg8cD64r
ZoIBGCM04tJptXKi0ndkVq0r2sTTqFlKAuB2NYviW71S0aw/s6NnWWXy32AHDH7pP+z1z+Fb9FOM
lGV7BGVpXsA6c9aKKKgkKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
qeq2sl7pdxbxPskdCFJ6Z7Z9qaV2NasuUVmeH7C403RoLe6dGnGS+wYUE9lHYVp0SSTaQSVnZBRR
RSEFFFFABRTJVdoXWNtjlSFbGcHsaxfC66t9inbVlMchmISMyFyFHGcn1IJx71SjeLdylG6bN2se
40CO48R2+rGaQeUmGhB+V2H3WPuMn862KKIycdhRk47BRRRUiCkZgoyxAHqTS1x/xDufI0i2XeI2
eYhHePzFLbSAhXByWzgehq6cOeaj3Lpw55KJ2FFQ2sXk2cMQLEJGq5Y5PA7+9TVDICiiigAooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAK5/xB4fl1jUNMnjmVI4JczKygkoCGyvo2VAyOxNdBRVQm4O6KjJxd0FFFFSSFFFFAHP+H9K1
Gwv9RlvZkeN5NsAXqyjnc3P3ucfgK6CiiqnNzd2VKTk7sKKKKkkKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiq9+Lk6fciyKi68pvJLdA+OM/jWf4ZuL+70WO51COWKWVmZI5sGREzwGwAM
/h0IquX3eYrl93mNiiiipJCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKwNF0a9sNb
1G6uJ0eCU4gCjBIJyS/qR0HtW/VTSTsncqSSdk7hRRRUkhRRRQAUUUUAFFFFABRRRQAUUUUAFFFF
ABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUA
FFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU
UVSn1W1t7+OzkZhK+Oi8DOcZPvg00m9hpN7F2iiikIKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigArNutDsrvWbTVJUJuLVW
VOeDn1+nOPrWlRTUnHYabWwUVieKbfUp9JX+y8tOsqkxiVo96ng/MpBGMhv+A1rW0ckVrFHLIZJE
QKzn+Igcmm4+6ncbj7t7ktFFFSSFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAF
FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUU
UUAFFFFAH//Z