20200519
10453500
1.0
FALSE
dbs_geo.SDE.vw_rod_snv
002
Server=svdf01045; Service=sde:sqlserver:svdf01045; Database=dbs_geo; User=sde; Version=sde.DEFAULT
ArcSDE Connection
-73.705074
-32.400220
-33.693081
4.483634
1
-
Relationship
-
Relationship
-
Relationship
-
Relationship
-
Relationship
-
Relationship
-
dbs_geo.SDE.tba_snv_coberturasinalizacao
Relationship
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/10.7'><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>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>8.9831528411952133e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4674</WKID><LatestWKID>4674</LatestWKID></GeographicCoordinateSystem>
FeatureClassToFeatureClass F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\RODOVIARIO fc_rod_snv # "id_trecho_ "id_trecho_" true true false 4 Long 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,id_trecho_,-1,-1;vl_br "vl_br" true true false 3 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,vl_br,-1,-1;sg_uf "sg_uf" true true false 2 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,sg_uf,-1,-1;nm_tipo_tr "nm_tipo_tr" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,nm_tipo_tr,-1,-1;sg_tipo_tr "sg_tipo_tr" true true false 1 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,sg_tipo_tr,-1,-1;desc_coinc "desc_coinc" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,desc_coinc,-1,-1;vl_codigo "vl_codigo" true true false 20 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,vl_codigo,-1,-1;ds_local_i "ds_local_i" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,ds_local_i,-1,-1;ds_local_f "ds_local_f" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,ds_local_f,-1,-1;vl_km_inic "vl_km_inic" true true false 8 Double 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,vl_km_inic,-1,-1;vl_km_fina "vl_km_fina" true true false 8 Double 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,vl_km_fina,-1,-1;vl_extensa "vl_extensa" true true false 8 Double 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,vl_extensa,-1,-1;ds_sup_fed "ds_sup_fed" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,ds_sup_fed,-1,-1;ds_obra "ds_obra" true true false 3 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,ds_obra,-1,-1;ul "ul" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,ul,-1,-1;ds_coinc "ds_coinc" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,ds_coinc,-1,-1;ds_tipo_ad "ds_tipo_ad" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,ds_tipo_ad,-1,-1;ds_ato_leg "ds_ato_leg" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,ds_ato_leg,-1,-1;est_coinc "est_coinc" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,est_coinc,-1,-1;sup_est_co "sup_est_co" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,sup_est_co,-1,-1;ds_jurisdi "ds_jurisdi" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,ds_jurisdi,-1,-1;ds_superfi "ds_superfi" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,ds_superfi,-1,-1;ds_legenda "ds_legenda" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,ds_legenda,-1,-1;sg_legenda "sg_legenda" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,sg_legenda,-1,-1;leg_multim "leg_multim" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,leg_multim,-1,-1;versao_snv "versao_snv" true true false 15 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,versao_snv,-1,-1;id_versao "id_versao" true true false 4 Long 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,id_versao,-1,-1;marcador "marcador" true true false 254 Text 0 0 ,First,#,F:\MORENO\ONTL\PORTAL_RODOVIARIO_2020\MODELO_RELACIONAL.gdb\SNV_202001A,marcador,-1,-1" #
CalculateField "SNV 2020" COD_LRS ""BR-" & [vl_br]&"/"& [sg_uf]" VB #
CalculateField "SNV 2020" COD_LRS ""BR-" & [vl_br] & "/" & [sg_uf]" VB #
SimplifyLine "Database Connections\producao@sde.sde\dbs_geo.SDE.RODOVIARIO\dbs_geo.SDE.fc_rod_snv" "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" POINT_REMOVE "100 Meters" RESOLVE_ERRORS KEEP_COLLAPSED_POINTS CHECK #
JoinField "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" vl_codigo dbs_geo.SDE.tb_rod_cobertura_manutencao vl_codigo_snv intervencao;pnmr;projetos_crema;status;contrato;divisao_de_contrato;divisao_final_do_contrato;acesso;disponibilidade_empenho;mpv_082_2002;edital
JoinField "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" vl_codigo "Database Connections\producao@sde.sde\dbs_geo.SDE.tb_rod_cobertura_sinalizacao" vl_codigo_snv intervencao;contrato
JoinField "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" vl_codigo "Database Connections\producao@sde.sde\dbs_geo.SDE.tb_rod_modelagem_pnct" vl_codigo_snv classificação;VMDa_C;VMDa_D;NS_C;NC_D
JoinField "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" codigo_SNV \dbs_geo.sde.tb_rod_resumo_acidente_snv vl_codigo_snv prf_total_acidentes;prf_total_mortos;prf_total_feridos_leves;prf_total_feridos_graves;prf_total_ilesos
JoinField "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" codigo_SNV "Database Connections\producao@sde.sde\dbs_geo.sde.tb_rod_resumo_acidente_snv" vl_codigo_snv prf_total_acidentes;prf_total_mortos;prf_total_feridos_leves;prf_total_feridos_graves;prf_total_ilesos
JoinField "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" codigo_SNV "Database Connections\producao@sde.sde\dbs_geo.sde.tb_rod_resumo_acidente_snv" vl_codigo_snv prf_total_acidentes;prf_total_mortos;prf_total_feridos_leves;prf_total_feridos_graves;prf_total_ilesos
JoinField "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" codigo_SNV "Database Connections\producao@sde.sde\dbs_geo.sde.tb_rod_resumo_acidente_snv" vl_codigo_snv prf_total_acidentes;prf_total_mortos;prf_total_feridos_leves;prf_total_feridos_graves;prf_total_ilesos
JoinField "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" codigo_SNV "Database Connections\producao@sde.sde\dbs_geo.sde.tb_rod_resumo_OAE_snv" vl_codigo_snv dnit_total_oae
JoinField "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" codigo_SNV "Database Connections\producao@sde.sde\dbs_geo.sde.tb_rod_resumo_OAE_snv" vl_codigo_snv dnit_total_oae
JoinField "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" codigo_SNV dbs_geo.sde.tb_rod_resumo_iri_ics_snv_pivotada vl_codigo_snv C___Bom;C___Regular;C___Ruim;D___Bom;D___Regular;D___Ruim
JoinField "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv" codigo_SNV "Database Connections\producao@sde.sde\dbs_geo.SDE.tb_rod_resumo_iri_ics_snv_pivotada" vl_codigo_snv C___Bom;C___Regular;C___Ruim;D___Bom;D___Regular;D___Ruim
CalculateField dbs_geo.SDE.vw_rod_snv prf_acidentes_p_km "[prf_total_acidentes]/ [vl_extensa]" VB #
SimplifyLine dbs_geo.SDE.vw_rod_snv "Database Connections\producao@sde.sde\dbs_geo.SDE.VIEWS\dbs_geo.SDE.vw_rod_snv_200m" POINT_REMOVE "200 Meters" RESOLVE_ERRORS KEEP_COLLAPSED_POINTS CHECK #
20210929
13491600
20210929
13491600
150000000
5000
Version 6.2 (Build 9200) ; Esri ArcGIS 10.7.1.11595
Acidentes por Km rodoviário
1
-73.705074
-32.400220
4.483634
-33.693081
View com dados do SNV otimizados para publicação na web através da redução de vértices (100m). Esta view agrega diversas informações como acidentes, nível de serviço, contratos de manutenção e sinalização.
dnit, prf, epl
dnit
epl
ontl
snv
vmda
nivel de servico
SDE Feature Class
dataset
EPSG
7.8.3(9.2.0)
7178
Simple
FALSE
7178
TRUE
FALSE
dbs_geo.SDE.vw_rod_snv
Feature Class
7178
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
vl_br
br
String
3
0
0
sg_uf
uf
String
2
0
0
nm_tipo_tr
Tipo trecho
String
254
0
0
codigo_SNV
Código SNV
String
20
0
0
kmi
KM Inicial
Double
8
38
8
kmf
KM Final
Double
8
38
8
desc_coinc
Desconsiderar coincidente
String
254
0
0
vl_extensa
Extensão
Double
8
38
8
ds_sup_fed
ds_sup_fed
String
254
0
0
ds_coinc
Coincidência
String
254
0
0
ds_tipo_ad
Tipo administração
String
254
0
0
ds_ato_leg
ds_ato_leg
String
254
0
0
ds_jurisdi
Jurisdição
String
254
0
0
ds_superfi
Superfície
String
254
0
0
ds_legenda
ds_legenda
String
254
0
0
versao_snv
versao_snv
String
15
0
0
COD_LRS
COD_LRS
String
15
0
0
manutencao_intervencao
manutencao_intervencao
String
255
0
0
manutencao_pnmr
manutencao_pnmr
String
255
0
0
manutencao_projetos_crema
manutencao_projetos_crema
String
255
0
0
manutencao_status
manutencao_status
String
255
0
0
manutencao_contrato
manutencao_contrato
String
255
0
0
manutencao_divisao_de_contrato
manutencao_divisao_de_contrato
String
255
0
0
manut_divisao_final_do_contrato
manut_divisao_final_do_contrato
String
255
0
0
manutencao_acesso
manutencao_acesso
String
255
0
0
manut_disponibilidade_empenho
manut_disponibilidade_empenho
String
255
0
0
manutencao_mpv_082_2002
manutencao_mpv_082_2002
String
255
0
0
manutencao_edital
manutencao_edital
String
255
0
0
sinalizacao_intervencao
sinalizacao_intervencao
String
254
0
0
sinalizacao_contrato
sinalizacao_contrato
String
254
0
0
pnct_classificação
pnct_classificação
String
255
0
0
pnct_VMDa_C
VMDa Crescente
Double
8
38
8
pnct_VMDa_D
VMDa Descrescente
Double
8
38
8
pnct_NS_C
Nível de Serviço Crescente
String
255
0
0
pnct_NC_D
Nível de Serviço Decrescente
String
255
0
0
prf_total_acidentes
prf_total_acidentes
Integer
4
10
0
prf_total_mortos
prf_total_mortos
Integer
4
10
0
prf_total_feridos_leves
prf_total_feridos_leves
Integer
4
10
0
prf_total_feridos_graves
prf_total_feridos_graves
Integer
4
10
0
prf_total_ilesos
prf_total_ilesos
Integer
4
10
0
dnit_contagem_oae
Qtde de OAE
Integer
4
10
0
ics_c_bom_extensao
Cresc - Bom - Km
Double
8
38
8
ics_c_regular_extensao
Cresc - Regular - Km
Double
8
38
8
ics_c_ruim_extensao
Cresc - Ruim - Km
Double
8
38
8
ics_d_bom_extensao
Decresc - Bom - Km
Double
8
38
8
ics_d_regular_extensao
Decresc - Regular - Km
Double
8
38
8
ics_d_ruim_extensao
Decresc - Ruim - Km
Double
8
38
8
prf_acidentes_p_km
prf_acidentes_p_km
Double
8
38
8
minfra_concessionaria
minfra_concessionaria
String
50
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20210929
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk
GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY
QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ
hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW
kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG
YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF
ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh
WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB
GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY
FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA
hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG
BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ
YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=