Schema Unfallpunkte

CSV-Schema

Schemaname:

CODE

ACCIDENT
(alt) UNFALLPUNKT

Aufbau:

Spalte	Inhalt
Name	Name des Unfallpunkts.
ID	ID des Unfallpunkts.
Info	Info des Unfallpunkts.
Trassierungslinie	Name oder ID der Trassierungslinie, auf die sich der Unfallpunkt bezieht.
LKS	Definition des zu verwendenden Lagesystems. Für Auswahlmöglichkeiten siehe Wertetabellen.
Station	Angabe der Station des Unfallpunkts.
Stationsdelta	Stationsverschiebung der Station des Unfallpunkts.
T	Abstand des Unfallpunkts von der Achse.
X	Absolute X-Koordinate.
Y	Absolute Y-Koordinate.
HKS	Definition des zu verwendenden Höhensystem. Für Auswahlmöglichkeiten siehe Wertetabellen.
Z	Höhe bezogen auf das Höhensystem.
Typ	Typ des Unfallpunkts. Für Auswahlmöglichkeiten siehe Wertetabellen.
Kategorie	Kategorie des Unfallpunkts. Für Auswahlmöglichkeiten siehe Wertetabellen.
Merkmal 1	Merkmal des Unfallpunkts. Für Auswahlmöglichkeiten siehe Wertetabellen.
Merkmal 2	Merkmal des Unfallpunkts. Für Auswahlmöglichkeiten siehe Wertetabellen.
Transformation	Koordinatensystem der absoluten Position mit Transformationseinstellungen (siehe Handbuch).

Beispiel:

CODE

ACCIDENT
Name; ID; Info; Fahrbahn; LKS; Station; Stationsdelta; T; X; Y; HKS; Z; Typ; Kategorie; Merkmal 1; Merkmal 2; Transformation
37992016; e9792aaf-db48-4655-b15b-00639784c063; ; ; geographisch; 0; 0; 0; 8,859309; 53,027932; Höhe Gitter Z-Werte; ; F; 5; Baum; ; (Definition siehe BIM-maschinelle Attribuierung)

XML-Schema

CODE

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
	<xs:element name="XUNFALL_UNFALL">
		<xs:complexType>
			<xs:attribute name="AccidentID" type="xs:integer" use="required" />
			<xs:attribute name="Longitude" type="xs:float" use="required" />
			<xs:attribute name="Latitude" type="xs:float" use="required" />
			<xs:attribute name="Direction" type="xs:integer" use="required" />
			<xs:attribute name="Date" type="xs:integer" use="required" />
			<xs:attribute name="Time" type="xs:integer" use="required" />
			<xs:attribute name="Office" type="xs:integer" use="required" />
			<xs:attribute name="City" type="xs:string" use="required" />
			<xs:attribute name="ZIP" type="xs:integer" use="required" />
			<xs:attribute name="RoadType" type="xs:string" use="required" />
			<xs:attribute name="RoadID" type="xs:string" use="required" />
			<xs:attribute name="RoadName" type="xs:string" use="required" />
			<xs:attribute name="RoadName2" type="xs:string" use="required" />
			<xs:attribute name="Location" type="xs:string" use="required" />		
			<xs:attribute name="Involved" type="xs:integer" use="required" />
			<xs:attribute name="Fatalities" type="xs:integer" use="required" />
			<xs:attribute name="SeriousInjuries" type="xs:integer" use="required" />
			<xs:attribute name="LightInjuries" type="xs:integer" use="required" />
			<xs:attribute name="Damage" type="xs:integer" use="required" />
			<xs:attribute name="AccidentCost" type="xs:float" use="required" />
			<xs:attribute name="Urban" type="xs:integer" use="required" />
			<xs:attribute name="Intersection" type="xs:integer" use="required" />
			<xs:attribute name="TrafficLights" type="xs:integer" use="required" />
			<xs:attribute name="Driveway" type="xs:integer" use="required" />
			<xs:attribute name="Curve" type="xs:integer" use="required" />
			<xs:attribute name="Slope" type="xs:integer" use="required" />
			<xs:attribute name="Crosswalk" type="xs:integer" use="required" />
			<xs:attribute name="Roundabout" type="xs:integer" use="required" />
			<xs:attribute name="SpeedLimit" type="xs:integer" use="required" />
			<xs:attribute name="Runaway" type="xs:integer" use="required" />
			<xs:attribute name="Car" type="xs:integer" use="required" />
			<xs:attribute name="Pedestrian" type="xs:integer" use="required" />
			<xs:attribute name="Bicycle" type="xs:integer" use="required" />
			<xs:attribute name="Motorcycle" type="xs:integer" use="required" />
			<xs:attribute name="Truck" type="xs:integer" use="required" />
			<xs:attribute name="Bus" type="xs:integer" use="required" />
			<xs:attribute name="Tram" type="xs:integer" use="required" />
			<xs:attribute name="Train" type="xs:integer" use="required" />		
			<xs:attribute name="Hazard" type="xs:integer" use="required" />
			<xs:attribute name="Category" type="xs:integer" use="required" />
			<xs:attribute name="Type1" type="xs:integer" use="required" />
			<xs:attribute name="Type2" type="xs:integer" use="required" />
			<xs:attribute name="Type3" type="xs:integer" use="required" />
			<xs:attribute name="Type4" type="xs:integer" use="required" />
			<xs:attribute name="Type5" type="xs:integer" use="required" />
			<xs:attribute name="Type6" type="xs:integer" use="required" />
			<xs:attribute name="CollisionCode" type="xs:string" use="required" />
			<xs:attribute name="CollisionType" type="xs:string" use="required" />
			<xs:attribute name="AccidentType" type="xs:string" use="required" />			
			<xs:attribute name="Slippery" type="xs:integer" use="required" />
			<xs:attribute name="Darkness" type="xs:integer" use="required" />
			<xs:attribute name="Animal" type="xs:integer" use="required" />
			<xs:attribute name="ObstacleOnRoad" type="xs:integer" use="required" />
			<xs:attribute name="BadView" type="xs:integer" use="required" />
			<xs:attribute name="BadWeather" type="xs:integer" use="required" />
			<xs:attribute name="BadRoad" type="xs:integer" use="required" />
			<xs:attribute name="BadSigns" type="xs:integer" use="required" />
			<xs:attribute name="EnvironmentalReason" type="xs:integer" use="required" />
			<xs:attribute name="Tree" type="xs:integer" use="required" />
			<xs:attribute name="OBSTACLEOFFROAD" type="xs:integer" use="required" />
			<xs:attribute name="OVERTAKING" type="xs:integer" use="required" />
			<xs:attribute name="ALCOHOL" type="xs:integer" use="required" />
			<xs:attribute name="SPEEDING" type="xs:integer" use="required" />			
			<xs:attribute name="REDLIGHT" type="xs:integer" use="required" />
			<xs:attribute name="DISTANCE" type="xs:integer" use="required" />
			<xs:attribute name="PRIORITY" type="xs:integer" use="required" />			
			<xs:attribute name="TURNING" type="xs:integer" use="required" />
			<xs:attribute name="IndividualReason" type="xs:string" use="required" />
			<xs:attribute name="Age1" type="xs:integer" use="required" />
			<xs:attribute name="Vehicle1" type="xs:string" use="required" />			
			<xs:attribute name="LicenseAge1" type="xs:integer" use="required" />
			<xs:attribute name="Offence1" type="xs:integer" use="required" />
			<xs:attribute name="Age2" type="xs:integer" use="required" />
			<xs:attribute name="Vehicle2" type="xs:string" use="required" />
			<xs:attribute name="LicenseAge2" type="xs:integer" use="required" />
			<xs:attribute name="Offence2" type="xs:integer" use="required" />
			<xs:attribute name="Age3" type="xs:integer" use="required" />
			<xs:attribute name="Vehicle3" type="xs:string" use="required" />
			<xs:attribute name="LicenseAge3" type="xs:integer" use="required" />
			<xs:attribute name="Offence3" type="xs:integer" use="required" />
			<xs:attribute name="Sketch" type="xs:string" use="required" />			
			<xs:attribute name="Description" type="xs:string" use="required" />
			<xs:attribute name="Notes" type="xs:string" use="required" />
			<xs:attribute name="Image" type="xs:string" use="required" />
			<xs:attribute name="Attachment" type="xs:string" use="required" />			
		</xs:complexType>
	</xs:element>
	<xs:element name="XUNFALL">
		<xs:complexType>
			<xs:sequence>
				<xs:element ref="XUNFALL_UNFALL" maxOccurs="unbounded"/>
			</xs:sequence>
		</xs:complexType>
	</xs:element>
</xs:schema>

Unfallpunkte_XML_Schema_Umwandlung.xsd