PAVEsense - Export Formats: Difference between revisions

From ASAsense Documentation (staging)
Nieuwe pagina aangemaakt met 'Roads AI data kan geëxporteerd worden in CSV en ESRI Shapefile formaat via het portaal. Hieronder vindt u een lijst met de betekenis van alle velden. We refereren geregeld naar de SCCR indicatoren. Dat zijn de relatieve indicatoren macro1, macro2, mega1, mega2 en waviness. Voor informatie betreffende de interpretatie van de indicatoren en convergentiecriteria, zie Roads AI#:~:text%3Dstukken%20weg%20afgebeeld.-%2CKwaliteitsindicatoren%2Cbrontekst%20bewerke...'
 
English source text for translation
Line 1: Line 1:
Roads AI data kan geëxporteerd worden in CSV en ESRI Shapefile formaat via het portaal. Hieronder vindt u een lijst met de betekenis van alle velden.
<languages/>
<translate>
PAVEsense data (formerly ''Roads AI'') can be exported from the portal in CSV and ESRI Shapefile format. Below is a list with the meaning of all fields.


We refereren geregeld naar de SCCR indicatoren. Dat zijn de relatieve indicatoren macro1, macro2, mega1, mega2 en waviness.
We regularly refer to the SCCR indicators. These are the relative indicators macro1, macro2, mega1, mega2 and waviness.
 
For information on the interpretation of the indicators and the convergence criteria, see the [[PaveSense/en#Kwaliteitsindicatoren|PAVEsense user manual]].


Voor informatie betreffende de interpretatie van de indicatoren en convergentiecriteria, zie [[Roads AI#:~:text%3Dstukken%20weg%20afgebeeld.-%2CKwaliteitsindicatoren%2Cbrontekst%20bewerken%2C-Aan%20de%20basis|Roads AI]]
{| class="wikitable"
{| class="wikitable"
|+
! CSV field name
!Veldnaam CSV
! Meaning
!Betekenis
|-
|-
|recipe_id
| recipe_id
|De versie van de software die gebruikt is voor de export. Alle data binnen dezelfde recipe_id zijn vergelijkbaar. SCCR indicatoren zijn niet vergelijkbaar wanneer het recipe_id verschilt.
| The version of the software used for the export. All data within the same recipe_id are comparable. SCCR indicators are not comparable when the recipe_id differs.
|-
|-
|gen_date
| gen_date
|De datum waarop de export plaatsvond
| The date on which the export took place
|-
|-
|month
| month
|De maand waarop de data betrekking heeft
| The month the data relates to
|-
|-
|segment_id
| segment_id
|Het interne ID van het betreffende wegsegment
| The internal ID of the road segment concerned
|-
|-
|road_name
| road_name
|De naam van de weg, indien deze bestaat en gekend is door het systeem
| The name of the road, if it exists and is known to the system
|-
|-
|sccr_first
| sccr_first
|De datum van de oudste meting gebruikt voor het bepalen van de SCCR indicatoren
| The date of the oldest measurement used to determine the SCCR indicators
|-
|-
|sccr_last
| sccr_last
|De datum van de recentste meting gebruikt voor het bepalen van de SCCR indicatoren
| The date of the most recent measurement used to determine the SCCR indicators
|-
|-
|sccr_conv
| sccr_conv
|Zijn de SCCR waarden geconvergeerd?
| Have the SCCR values converged?
|-
|-
|v_85_kmh
| v_85_kmh
|De referentiesnelheid (85e percentiel van de opgemeten snelheden)
| The reference speed (85th percentile of the measured speeds)
|-
|-
|macro1
| macro1
|Macro1 indicator
| Macro1 indicator
|-
|-
|macro2
| macro2
|Macro2 indicator
| Macro2 indicator
|-
|-
|mega1
| mega1
|Mega1 indicator
| Mega1 indicator
|-
|-
|mega2
| mega2
|Mega2 indicator
| Mega2 indicator
|-
|-
|waviness
| waviness
|Waviness indicator
| Waviness indicator
|-
|-
|macro1_ns
| macro1_ns
|Macro1 indicator - non scaled
| Macro1 indicator – non-scaled
|-
|-
|macro2_ns
| macro2_ns
|Macro2 indicator - non scaled
| Macro2 indicator – non-scaled
|-
|-
|mega1_ns
| mega1_ns
|Mega1 indicator - non scaled
| Mega1 indicator – non-scaled
|-
|-
|mega2_ns
| mega2_ns
|Mega2 indicator - non scaled
| Mega2 indicator – non-scaled
|-
|-
|wavi_ns
| wavi_ns
|Waviness indicator - non scaled
| Waviness indicator – non-scaled
|-
|-
|iri_first
| iri_first
|De datum van de oudste meting gebruikt voor het bepalen van de IRI indicator
| The date of the oldest measurement used to determine the IRI indicator
|-
|-
|iri_last
| iri_last
|De datum van de recentste meting gebruikt voor het bepalen van de IRI indicator
| The date of the most recent measurement used to determine the IRI indicator
|-
|-
|iri_conv
| iri_conv
|Zijn de IRI metingen geconvergeerd?
| Have the IRI measurements converged?
|-
|-
|iri_min
| iri_min
|De minimaal opgemeten IRI
| The minimum measured IRI
|-
|-
|iri_50perc
| iri_50perc
|Het 50e percentiel van de IRI metingen
| The 50th percentile of the IRI measurements
|-
|-
|iri_85perc
| iri_85perc
|Het 85e percentiel van de IRI metingen
| The 85th percentile of the IRI measurements
|-
|-
|iri_max
| iri_max
|De grootste opgemeten IRI waarde
| The largest measured IRI value
|-
|-
|iri_avg
| iri_avg
|De gemiddelde IRI waarde
| The average IRI value
|-
|-
|iri_sterr
| iri_sterr
|De standaardafwijking op de opgemeten IRI waarden
| The standard deviation of the measured IRI values
|-
|-
|iri_rq
| iri_rq
|De driving quality (van Poor naar Very Good)
| The driving quality (from Poor to Very Good)
|-
|-
|iri_rq_int
| iri_rq_int
|De driving quality (van 1 tot 5, met 1 Poor en 5 Very Good)
| The driving quality (from 1 to 5, with 1 Poor and 5 Very Good)
|-
|-
|surf_conv
| surf_conv
|Zijn de bepalingen van het oppervlak geconvergeerd?  
| Have the surface determinations converged?
|-
|-
|surf_best
| surf_best
|Meest waarschijnlijk ingeschatte oppervlaktetype
| Most likely estimated surface type
|-
|-
|surf_src
| surf_src
|De bron die werd gebruikt voor de bepaling van het type oppervlakte '''(TODO: betekenis bronnen documenteren)'''
| The source used to determine the surface type '''(TODO: document the meaning of the sources)'''
|-
|-
|geometry
| geometry
|De geomtrie van het wegsegment, in [[wikipedia:Well-known_text_representation_of_geometry|WKT]]
| The geometry of the road segment, in [[wikipedia:Well-known_text_representation_of_geometry|WKT]]
|-
|-
|authority
| authority
|De wegbeheerder verantwoordelijk voor dit wegsegment
| The road authority responsible for this road segment
|}
|}
</translate>

Revision as of 10:23, 14 October 2026

PAVEsense data (formerly Roads AI) can be exported from the portal in CSV and ESRI Shapefile format. Below is a list with the meaning of all fields.

We regularly refer to the SCCR indicators. These are the relative indicators macro1, macro2, mega1, mega2 and waviness.

For information on the interpretation of the indicators and the convergence criteria, see the PAVEsense user manual.

CSV field name Meaning
recipe_id The version of the software used for the export. All data within the same recipe_id are comparable. SCCR indicators are not comparable when the recipe_id differs.
gen_date The date on which the export took place
month The month the data relates to
segment_id The internal ID of the road segment concerned
road_name The name of the road, if it exists and is known to the system
sccr_first The date of the oldest measurement used to determine the SCCR indicators
sccr_last The date of the most recent measurement used to determine the SCCR indicators
sccr_conv Have the SCCR values converged?
v_85_kmh The reference speed (85th percentile of the measured speeds)
macro1 Macro1 indicator
macro2 Macro2 indicator
mega1 Mega1 indicator
mega2 Mega2 indicator
waviness Waviness indicator
macro1_ns Macro1 indicator – non-scaled
macro2_ns Macro2 indicator – non-scaled
mega1_ns Mega1 indicator – non-scaled
mega2_ns Mega2 indicator – non-scaled
wavi_ns Waviness indicator – non-scaled
iri_first The date of the oldest measurement used to determine the IRI indicator
iri_last The date of the most recent measurement used to determine the IRI indicator
iri_conv Have the IRI measurements converged?
iri_min The minimum measured IRI
iri_50perc The 50th percentile of the IRI measurements
iri_85perc The 85th percentile of the IRI measurements
iri_max The largest measured IRI value
iri_avg The average IRI value
iri_sterr The standard deviation of the measured IRI values
iri_rq The driving quality (from Poor to Very Good)
iri_rq_int The driving quality (from 1 to 5, with 1 Poor and 5 Very Good)
surf_conv Have the surface determinations converged?
surf_best Most likely estimated surface type
surf_src The source used to determine the surface type (TODO: document the meaning of the sources)
geometry The geometry of the road segment, in WKT
authority The road authority responsible for this road segment