20230601
14512600
1.0
FALSE
gis.linnavalitsus.teeregister
002
0.000
Server=gis.server.linnavalitsus; Service=sde:postgresql:gis.server.linnavalitsus; Database=gis; User=linnavalitsus; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_Estonia_1997
Linear Unit: Meter (1.000000)
Estonia_1997_Estonia_National_Grid
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' 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>PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0],AUTHORITY["EPSG",3301]]</WKT><XOrigin>-34999000</XOrigin><YOrigin>-25103900</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>-97203.953408000001</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>3301</WKID><LatestWKID>3301</LatestWKID></ProjectedCoordinateSystem>
Intersect "HaapsaluLinn_teed_08022021 #;SHP_KATASTRIYKSUS_184 #" "C:\Users\peep.aedviir\Desktop\Teeregistri lepingud\HaapsaluLinn\teed_loik\teed_3.shp" "All attributes" # "Same as input"
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=C:\Users\peep.aedviir\Desktop\Teeregistri lepingud\HaapsaluLinn\teed_loik</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>teed_3.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>OMANIK</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>
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=C:\Users\peep.aedviir\Desktop\Teeregistri lepingud\HaapsaluLinn\teed_loik</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>teed_3.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>KONTAKTID</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>
CopyFeatures teed_3 "C:\Users\peep.aedviir\Documents\ArcGIS\Projects\Teede lepingud\Teede lepingud.gdb\teed_3" # # # #
Rename "C:\Users\peep.aedviir\Documents\ArcGIS\Projects\Teede lepingud\Teede lepingud.gdb\teed_3" "C:\Users\peep.aedviir\Documents\ArcGIS\Projects\Teede lepingud\Teede lepingud.gdb\Teed_lepingud" FeatureClass
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=C:\Users\peep.aedviir\Documents\ArcGIS\Projects\Teede lepingud\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Alguskm</field_name><field_name>L6ppkm</field_name><field_name>FID_SHP_KA</field_name><field_name>HKOOD</field_name><field_name>MK_NIMI</field_name><field_name>OV_NIMI</field_name><field_name>REGISTR</field_name><field_name>MUUDET</field_name><field_name>SIHT1</field_name><field_name>SIHT2</field_name><field_name>SIHT3</field_name><field_name>SO_PRTS1</field_name><field_name>SO_PRTS2</field_name><field_name>SO_PRTS3</field_name><field_name>PINDALA</field_name><field_name>RUUMPIND</field_name><field_name>REG_YHIK</field_name><field_name>HARITAV</field_name><field_name>ROHUMAA</field_name><field_name>METS</field_name><field_name>OUEMAA</field_name><field_name>MUUMAA</field_name><field_name>MOOTVIIS</field_name><field_name>MOOTJA</field_name><field_name>MOODUST</field_name><field_name>OMVIIS</field_name><field_name>MAKS_HIND</field_name><field_name>MARKETEKST</field_name><field_name>EKSPORT</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/2.8.0'><WorkspaceConnectionString>DATABASE=C:\Users\peep.aedviir\Documents\ArcGIS\Projects\Teede lepingud\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>KONTROLL</field_name><field_type>SHORT</field_type><field_alias>KONTROLLITUD</field_alias><field_is_nullable>True</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/2.8.0'><WorkspaceConnectionString>DATABASE=C:\Users\peep.aedviir\Documents\ArcGIS\Projects\Teede lepingud\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><CreateDomain><domain_name>JAH/EI</domain_name><domain_description>JAH/EI</domain_description><field_type>SHORT</field_type><domain_type>CODED</domain_type><split_policy>DEFAULT</split_policy><merge_policy>DEFAULT</merge_policy></CreateDomain><AddCodedValueToDomain><domain_name>JAH/EI</domain_name><coded_values><coded_value><code>0</code><code_description>EI</code_description></coded_value><coded_value><code>1</code><code_description>JAH</code_description></coded_value></coded_values></AddCodedValueToDomain></workflow><workflow><AssignDomainToField><field_name>KONTROLL</field_name><domain_name>JAH/EI</domain_name></AssignDomainToField></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/2.8.0'><WorkspaceConnectionString>DATABASE=C:\Users\peep.aedviir\Documents\ArcGIS\Projects\Teede lepingud\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>KONTROLL</field_name><default_value>1</default_value></AssignDefaultToField></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/2.8.0'><WorkspaceConnectionString>DATABASE=C:\Users\peep.aedviir\Documents\ArcGIS\Projects\Teede lepingud\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>KONTROLL</field_name><clear_value>True</clear_value></AssignDefaultToField></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/2.8.0'><WorkspaceConnectionString>DATABASE=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>K_OMANIK</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>KIN OMANIK</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
AddRelate Teed_lepingud TUNNUS Maakasutusregister_ Kinnistu_tunnus "Omanik maakasutusregistrist" "One to many"
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=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>Lep_Tyyp</field_name><field_type>LONG</field_type><field_alias>Lepingu tüüp</field_alias><field_is_nullable>True</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/2.8.0'><WorkspaceConnectionString>DATABASE=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>Lep_Tyyp</field_name></RemoveDomainFromField></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/2.8.0'><WorkspaceConnectionString>DATABASE=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Lep_Tyyp</field_name></DeleteField></workflow><workflow><AddField><field_name>Field</field_name><field_type>LONG</field_type><field_alias>Field</field_alias><field_is_nullable>True</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/2.8.0'><WorkspaceConnectionString>DATABASE=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>LepTyyp</field_name><field_type>SHORT</field_type><field_alias>Lepingu tüüp</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>lepingu tüüp</field_domain></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/2.8.0'><WorkspaceConnectionString>DATABASE=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>YP_avalik</field_name><field_type>SHORT</field_type><field_alias>YP_avalik</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Teed_lepingud TUNNUS !TUNNUS!.strip() "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Teed_lepingud TUNNUS !TUNNUS!.strip() "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Teed_lepingud TUNNUS !TUNNUS!.strip() "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Teed_lepingud L_AADRESS !L_AADRESS!.strip() "Python 3" # Text NO_ENFORCE_DOMAINS
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=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Field</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/2.8.0'><WorkspaceConnectionString>DATABASE=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>YP_avalik</field_name><domain_name>YP_avalik</domain_name></AssignDomainToField></workflow></operationSequence>
CalculateField Teed_lepingud YP_avalik 1 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateGeometryAttributes Teed_lepingud "Pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
CalculateGeometryAttributes Teeregister_KOV "Pikkus LENGTH_GEODESIC" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
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.9.0'><WorkspaceConnectionString>DATABASE=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Field</field_name><field_type>LONG</field_type><field_alias>Field</field_alias><field_is_nullable>True</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.0.0'><WorkspaceConnectionString>DATABASE=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>TALV_SEISUNDITASE</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Talv_seisunditase</field_domain></AddField></workflow><workflow><AddField><field_name>TALV_HOOLDAJA</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>hooldaja_talv</field_domain></AddField></workflow><workflow><AddField><field_name>TALV_LEPINGU_NR</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>TALV_LEPINGU_ALGUS</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>TALV_LEPINGU_LÕPP</field_name><field_type>DATE</field_type><field_is_nullable>True</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.0.0'><WorkspaceConnectionString>DATABASE=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>TALV_HOOLDUS_PRK</field_name><field_type>SHORT</field_type><field_is_nullable>True</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.0.0'><WorkspaceConnectionString>DATABASE=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>TALV_HOOLDUS_PRK</field_name><domain_name>Talihooldus piirkond</domain_name></AssignDomainToField></workflow></operationSequence>"
EnableAttachments Teed_lepingud
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.0.0'><WorkspaceConnectionString>DATABASE=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>Kasutusv</field_name><domain_name>Kasutusv</domain_name></AssignDomainToField></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=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>YP_avalik</field_name></DeleteField></workflow></operationSequence>
CalculateGeometryAttributes Teed_lepingud "Pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
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=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Loik</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</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=M:\REGISTRID\Teeregister\töö failid\Teede lepingud.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Teed_lepingud</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>algus_m</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>lopp_m</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Teed_lepingud algus_m "var result = 0;
var a = 0;
var b = $feature.Loik;
for(a; a < b; a++) {
result += a;
}
return result" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Teed_lepingud algus_m "var result = 0;
var a = 0;
var b = $feature.Loik;
var c = $feature.TeeNr;
var d = $feature.Pikkus;
for(a; a < b; a++) {
result = a;
}
return result" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Teed_lepingud algus_m "var result = 0;
var a = 0;
var b = $feature.Loik;
var c = $feature.TeeNr;
var d = $feature.Pikkus;
for(a; a < b; a++) {
result = a;
}
return result" Arcade # Text NO_ENFORCE_DOMAINS
CalculateGeometryAttributes "Avalik tee" "Pikkus LENGTH" # # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
CalculateGeometryAttributes "Avalik tee" "Pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
CalculateGeometryAttributes "Avalik tee" "Pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
CalculateGeometryAttributes "Avalik tee" "Pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
CalculateGeometryAttributes "Avalik tee" "Pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
CalculateGeometryAttributes "Avalik tee" "Pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
CalculateGeometryAttributes "Avalik tee" "Pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
ExportFeatures "Avalik tee" "M:\REGISTRID\Teeregister\töö failid\gis.server.linnavalitsus.sde\gis.linnavalitsus.Avalike_teede_nimekiri\gis.linnavalitsus.teeregister" # NOT_USE_ALIAS "FID_Haapsa "FID_Haapsa" true true false 4 Long 0 0,First,#,Avalik tee,FID_Haapsa,-1,-1;TeeNr "TeeNr" true true false 4 Long 0 0,First,#,Avalik tee,TeeNr,-1,-1;TeeNimi "TeeNimi" true true false 254 Text 0 0,First,#,Avalik tee,TeeNimi,0,254;TUNNUS "TUNNUS" true true false 25 Text 0 0,First,#,Avalik tee,TUNNUS,0,25;KINNISTU "KINNISTU" true true false 50 Text 0 0,First,#,Avalik tee,KINNISTU,0,50;L_AADRESS "L_AADRESS" true true false 240 Text 0 0,First,#,Avalik tee,L_AADRESS,0,240;KONTROLL "KONTROLLITUD" true true false 2 Short 0 0,First,#,Avalik tee,KONTROLL,-1,-1;avkasKp "avkasKp" true true false 8 Date 0 0,First,#,Avalik tee,avkasKp,-1,-1;avKasLep "avKasLep" true true false 254 Text 0 0,First,#,Avalik tee,avKasLep,0,254;OMANIK "OMANIK" true true false 254 Text 0 0,First,#,Avalik tee,OMANIK,0,254;K_OMANIK "KIN OMANIK" true true false 255 Text 0 0,First,#,Avalik tee,K_OMANIK,0,255;KONTAKTID "KONTAKTID" true true false 254 Text 0 0,First,#,Avalik tee,KONTAKTID,0,254;Jaotus "Jaotus" true true false 254 Text 0 0,First,#,Avalik tee,Jaotus,0,254;S6idutee "S6idutee" true true false 4 Long 0 0,First,#,Avalik tee,S6idutee,-1,-1;Pikkus "Pikkus" true true false 4 Long 0 0,First,#,Avalik tee,Pikkus,-1,-1;Kasutusv "Kasutusv" true true false 254 Text 0 0,First,#,Avalik tee,Kasutusv,0,254;TeeLiik "TeeLiik" true true false 254 Text 0 0,First,#,Avalik tee,TeeLiik,0,254;KOV "KOV" true true false 254 Text 0 0,First,#,Avalik tee,KOV,0,254;Maakond "Maakond" true true false 254 Text 0 0,First,#,Avalik tee,Maakond,0,254;oigaktKp "oigaktKp" true true false 8 Date 0 0,First,#,Avalik tee,oigaktKp,-1,-1;oigakNr "oigakNr" true true false 254 Text 0 0,First,#,Avalik tee,oigakNr,0,254;halKp "halKp" true true false 8 Date 0 0,First,#,Avalik tee,halKp,-1,-1;halNr "halNr" true true false 4 Long 0 0,First,#,Avalik tee,halNr,-1,-1;omLiik "omLiik" true true false 254 Text 0 0,First,#,Avalik tee,omLiik,0,254;TervLiik "TervLiik" true true false 254 Text 0 0,First,#,Avalik tee,TervLiik,0,254;AY_NIMI "AY_NIMI" true true false 100 Text 0 0,First,#,Avalik tee,AY_NIMI,0,100;OMVORM "OMVORM" true true false 50 Text 0 0,First,#,Avalik tee,OMVORM,0,50;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Avalik tee,Shape_Length,-1,-1;LepTyyp "Lepingu tüüp" true true false 2 Short 0 0,First,#,Avalik tee,LepTyyp,-1,-1;Field "Field" true true false 4 Long 0 0,First,#,Avalik tee,Field,-1,-1;TALV_SEISUNDITASE "TALV_SEISUNDITASE" true true false 2 Short 0 0,First,#,Avalik tee,TALV_SEISUNDITASE,-1,-1;TALV_HOOLDAJA "TALV_HOOLDAJA" true true false 255 Text 0 0,First,#,Avalik tee,TALV_HOOLDAJA,0,255;TALV_LEPINGU_NR "TALV_LEPINGU_NR" true true false 255 Text 0 0,First,#,Avalik tee,TALV_LEPINGU_NR,0,255;TALV_LEPINGU_ALGUS "TALV_LEPINGU_ALGUS" true true false 8 Date 0 0,First,#,Avalik tee,TALV_LEPINGU_ALGUS,-1,-1;TALV_LEPINGU_LÕPP "TALV_LEPINGU_LÕPP" true true false 8 Date 0 0,First,#,Avalik tee,TALV_LEPINGU_LÕPP,-1,-1;TALV_HOOLDUS_PRK "TALV_HOOLDUS_PRK" true true false 2 Short 0 0,First,#,Avalik tee,TALV_HOOLDUS_PRK,-1,-1;Loik "Loik" true true false 8 Double 0 0,First,#,Avalik tee,Loik,-1,-1;algus_m "algus_m" true true false 8 Double 0 0,First,#,Avalik tee,algus_m,-1,-1;lopp_m "lopp_m" true true false 8 Double 0 0,First,#,Avalik tee,lopp_m,-1,-1" #
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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6863394c74486d434c6d4849775448454476613445394d744d336c6931666d6d6c4a706e7971774a2f476c553d2a00;ENCRYPTED_PASSWORD=00022e68455068317571305537416b4d7470642b484f6a4763487378334869625168753566554b6873505056636c343d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>tunnus</field_name><field_name>kinnistu</field_name><field_name>l_aadress</field_name></DeleteField></workflow></operationSequence>
CalculateField "Avalik tee" talv_seisunditase null Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" talv_hooldaja null Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" talv_lepingu_nr null Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" talv_lepingu_algus null Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" talv_lepingu_lõpp null Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" talv_hooldus_prk null Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" kov "Haapsalu linn" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" maakond "Lääne maakond" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" omvorm "Munitsipaalomand" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" omliik "Omavalitsusomand" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" omliik "Omavalitsusomand" Arcade # Text NO_ENFORCE_DOMAINS
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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6863394c74486d434c6d4849775448454476613445394d744d336c6931666d6d6c4a706e7971774a2f476c553d2a00;ENCRYPTED_PASSWORD=00022e68455068317571305537416b4d7470642b484f6a4763487378334869625168753566554b6873505056636c343d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>niitmine</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>JAH/EI</field_domain></AddField></workflow><workflow><AddField><field_name>piirkond</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField "Avalik tee" piirkond "Hajaasustus" Arcade # Text NO_ENFORCE_DOMAINS
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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684d4b4d39474e4f79736b736e345942435a6543524f7a5945724c3232416667556b7631586e5370374244493d2a00;ENCRYPTED_PASSWORD=00022e6872554a555777674470614644334e61714b326343593476596a6f4b6b713054494f63644d2f714e4c7945593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>kontaktid</field_name></DeleteField></workflow></operationSequence>
AddFields "Avalik tee" "gis.linnavalitsus.teeregister.pikkus DOUBLE # # # #" #
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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684d4b4d39474e4f79736b736e345942435a6543524f7a5945724c3232416667556b7631586e5370374244493d2a00;ENCRYPTED_PASSWORD=00022e68694c4d644d6d4530746d55644974424c64506e624c624a356e64656e6b433469506554522f4162555668593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>gis_linnavalitsus_teeregister_p</field_name></DeleteField></workflow></operationSequence>
CalculateGeometryAttributes "Avalik tee" "pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
CalculateField "Avalik tee" teeliik "maantee" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" teeliik "tänav" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" teeliik "tänav" Arcade # Text NO_ENFORCE_DOMAINS
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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684d4b4d39474e4f79736b736e345942435a6543524f7a5945724c3232416667556b7631586e5370374244493d2a00;ENCRYPTED_PASSWORD=00022e68694c4d644d6d4530746d55644974424c64506e624c624a356e64656e6b433469506554522f4162555668593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AlterField><field_name>algus_m</field_name><new_field_name>Alguskm</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>lopp_m</field_name><new_field_name>L6ppkm</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684d4b4d39474e4f79736b736e345942435a6543524f7a5945724c3232416667556b7631586e5370374244493d2a00;ENCRYPTED_PASSWORD=00022e68694c4d644d6d4530746d55644974424c64506e624c624a356e64656e6b433469506554522f4162555668593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>field</field_name></DeleteField></workflow></operationSequence>
CalculateField "Avalik tee" halkp "26.05.2023" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" halnr "109" Arcade # Text NO_ENFORCE_DOMAINS
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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684d4b4d39474e4f79736b736e345942435a6543524f7a5945724c3232416667556b7631586e5370374244493d2a00;ENCRYPTED_PASSWORD=00022e68694c4d644d6d4530746d55644974424c64506e624c624a356e64656e6b433469506554522f4162555668593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>halkp</field_name><field_name>halnr</field_name></DeleteField></workflow></operationSequence>
CalculateField "Avalik tee" oigaktkp "26.05.2023" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" oigaknr "109" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" oigaktkp $feature.avkaskp Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" oigaknr $feature.avkaslep Arcade # Text NO_ENFORCE_DOMAINS
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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684d4b4d39474e4f79736b736e345942435a6543524f7a5945724c3232416667556b7631586e5370374244493d2a00;ENCRYPTED_PASSWORD=00022e68694c4d644d6d4530746d55644974424c64506e624c624a356e64656e6b433469506554522f4162555668593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>omvorm</field_name></DeleteField></workflow></operationSequence>
CalculateField "Avalik tee" omliik "Eraomand" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" tervliik "Muu tee" Arcade # Text NO_ENFORCE_DOMAINS
CalculateGeometryAttributes "Avalik tee" "pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
CalculateGeometryAttributes "Avalik tee" "pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
CalculateField "Avalik tee" talv_hooldaja "if(Distinct($feature.teenr) > -1) {
return "1";
} else {
return "2"; }
" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" talv_hooldaja "if(Distinct($feature.teenr) > $feature.teenr) {
return "1";
} else {
return "2"; }
" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Avalik tee" alguskm null Arcade # Text NO_ENFORCE_DOMAINS
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/3.0.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68484e65414b7956346a7446334e4b414331347838755a5371434f4f494c376f586f3955616a5147595759343d2a00;ENCRYPTED_PASSWORD=00022e686e784d707659306d797a372b67422f4479634a5a6a792f573233437639635634676251326d74682f6463303d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Teekate</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Teekate</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
Append gis_ExportFeatures C:\Teenused\Teehooldus\gis.server.linnavalitsus.sde\gis.linnavalitsus.Avalike_teede_nimekiri\gis.linnavalitsus.teeregister "Use the field map to reconcile field differences" "fid_haapsa "FID_Haapsa" true true false 4 Long 0 10,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,fid_haapsa,-1,-1;teenr "TeeNr" true true false 4 Long 0 10,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,teenr,-1,-1;teenimi "TeeNimi" true true false 254 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,teenimi,0,254;kontroll "KONTROLLITUD" true true false 2 Short 0 5,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,kontroll,-1,-1;avkaskp "avkasKp" true true false 8 Date 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,avkaskp,-1,-1;avkaslep "avKasLep" true true false 254 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,avkaslep,0,254;omanik "OMANIK" true true false 254 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,omanik,0,254;k_omanik "KIN OMANIK" true true false 255 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,k_omanik,0,255;jaotus "Jaotus" true true false 254 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,jaotus,0,254;s6idutee "S6idutee" true true false 4 Long 0 10,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,s6idutee,-1,-1;pikkus "Pikkus" true true false 4 Long 0 10,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,pikkus,-1,-1;kasutusv "Kasutusv" true true false 254 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,kasutusv,0,254;teeliik "TeeLiik" true true false 254 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,teeliik,0,254;kov "KOV" true true false 254 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,kov,0,254;maakond "Maakond" true true false 254 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,maakond,0,254;oigaktkp "oigaktKp" true true false 8 Date 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,oigaktkp,-1,-1;oigaknr "oigakNr" true true false 254 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,oigaknr,0,254;omliik "omLiik" true true false 254 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,omliik,0,254;tervliik "TervLiik" true true false 254 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,tervliik,0,254;ay_nimi "AY_NIMI" true true false 100 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,ay_nimi,0,100;leptyyp "Lepingu tüüp" true true false 2 Short 0 5,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,leptyyp,-1,-1;talv_seisunditase "TALV_SEISUNDITASE" true true false 2 Short 0 5,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,talv_seisunditase,-1,-1;talv_hooldaja "TALV_HOOLDAJA" true true false 255 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,talv_hooldaja,0,255;talv_lepingu_nr "TALV_LEPINGU_NR" true true false 255 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,talv_lepingu_nr,0,255;talv_lepingu_algus "TALV_LEPINGU_ALGUS" true true false 8 Date 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,talv_lepingu_algus,-1,-1;talv_lepingu_lõpp "TALV_LEPINGU_LÕPP" true true false 8 Date 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,talv_lepingu_lõpp,-1,-1;talv_hooldus_prk "TALV_HOOLDUS_PRK" true true false 2 Short 0 5,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,talv_hooldus_prk,-1,-1;loik "Loik" true true false 8 Double 8 38,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,loik,-1,-1;alguskm "algus_m" true true false 8 Double 8 38,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,alguskm,-1,-1;l6ppkm "lopp_m" true true false 8 Double 8 38,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,l6ppkm,-1,-1;niitmine "niitmine" true true false 2 Short 0 5,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,niitmine,-1,-1;piirkond "piirkond" true true false 255 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,piirkond,0,255;Teekate "Teekate" true true false 255 Text 0 0,First,#,C:\Teenused\Teehooldus\Teehooldus.gdb\gis_ExportFeatures,Teekate,0,255" # #
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/3.0.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68484e65414b7956346a7446334e4b414331347838755a5371434f4f494c376f586f3955616a5147595759343d2a00;ENCRYPTED_PASSWORD=00022e68786e56355930464f69485a4d414241583252436c4f5a4355444f462f4b464e5a726f6e42396d6479446f493d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></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/3.0.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68484e65414b7956346a7446334e4b414331347838755a5371434f4f494c376f586f3955616a5147595759343d2a00;ENCRYPTED_PASSWORD=00022e6835554661305a7876304f7a4a4434653878736c556147654e673670666a69563064443152335642346a71383d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DisableAttachments /></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/3.0.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68484e65414b7956346a7446334e4b414331347838755a5371434f4f494c376f586f3955616a5147595759343d2a00;ENCRYPTED_PASSWORD=00022e68503971577a4354582f3357547a576f51646e6a5065364579307561444b53486f7a72584867697739762f673d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DisableAttachments /></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/3.0.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68484e65414b7956346a7446334e4b414331347838755a5371434f4f494c376f586f3955616a5147595759343d2a00;ENCRYPTED_PASSWORD=00022e68337934517759596533466879766a435667394f483168307147654d56784b696659395253473837786546383d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DisableAttachments /></workflow></operationSequence>"
CopyMultiple "C:\Teenused\Teehooldus\gis.server.linnavalitsus.sde\gis.linnavalitsus.Avalike_teede_nimekiri\gis.linnavalitsus.teeregister FeatureClass" C:\Teenused\Teehooldus\Teehooldus.gdb teeregister "gis.linnavalitsus.teeregister FeatureClass teeregister #"
CopyMultiple "C:\Teenused\Teehooldus\Teehooldus.gdb\teeregister FeatureClass" C:\Teenused\Teehooldus\gis.server.linnavalitsus.sde\gis.linnavalitsus.Avalike_teede_nimekiri teeregister "teeregister FeatureClass gis.linnavalitsus.teeregister #"
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/3.0.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68484e65414b7956346a7446334e4b414331347838755a5371434f4f494c376f586f3955616a5147595759343d2a00;ENCRYPTED_PASSWORD=00022e6853532f4573493473415233727275312f5247556a416d432f52544953616d396d62565534316b31582b674d3d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><EnableAttachments /></workflow></operationSequence>"
CalculateGeometryAttributes "Avalik tee" "pikkus LENGTH" Meters # PROJCS["Estonia_1997_Estonia_National_Grid",GEOGCS["GCS_Estonia_1997",DATUM["D_Estonia_1997",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",6375000.0],PARAMETER["Central_Meridian",24.0],PARAMETER["Standard_Parallel_1",58.0],PARAMETER["Standard_Parallel_2",59.33333333333334],PARAMETER["Latitude_Of_Origin",57.51755393055556],UNIT["Meter",1.0]] "Same as input"
CalculateField "Teeregister alusandmed" talv_hooldus_prk "Maa" Arcade # Text NO_ENFORCE_DOMAINS
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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6863394c74486d434c6d4849775448454476613445394d744d336c6931666d6d6c4a706e7971774a2f476c553d2a00;ENCRYPTED_PASSWORD=00022e6838325072513436774d79396d2b595a4743436d4150686b496b73586259657033776a67316f6d2f704661593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>talv_hooldus_prk</field_name><domain_name>Talihooldus prk</domain_name></AssignDomainToField></workflow></operationSequence>"
CalculateField "Teeregister alusandmed" talv_hooldus_prk "Maa" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Teeregister alusandmed" talv_hooldus_prk 2 Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Teeregister alusandmed" talv_hooldus_prk null Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Talihooldus piirkondade järgi" talv_hooldus_prk 1 Arcade # Text NO_ENFORCE_DOMAINS
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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6863394c74486d434c6d4849775448454476613445394d744d336c6931666d6d6c4a706e7971774a2f476c553d2a00;ENCRYPTED_PASSWORD=00022e6838325072513436774d79396d2b595a4743436d4150686b496b73586259657033776a67316f6d2f704661593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>jaotus</field_name><domain_name>Jaotus</domain_name></AssignDomainToField></workflow></operationSequence>
CalculateField "Talihooldus piirkondade järgi" pikkus Round($feature['st_length(shape)'],0) Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Talihooldus piirkondade järgi" pikkus Round($feature['st_length(shape)'],1) Arcade # Text NO_ENFORCE_DOMAINS
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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6863394c74486d434c6d4849775448454476613445394d744d336c6931666d6d6c4a706e7971774a2f476c553d2a00;ENCRYPTED_PASSWORD=00022e6838325072513436774d79396d2b595a4743436d4150686b496b73586259657033776a67316f6d2f704661593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>tee_laius</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6863394c74486d434c6d4849775448454476613445394d744d336c6931666d6d6c4a706e7971774a2f476c553d2a00;ENCRYPTED_PASSWORD=00022e6838325072513436774d79396d2b595a4743436d4150686b496b73586259657033776a67316f6d2f704661593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>tee_laius</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField "Talihooldus piirkondade järgi" pindala "$feature.tee_laius * $feature.pikkus" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Talihooldus piirkondade järgi" pikkus $feature['st_length(shape)'] Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Talihooldus piirkondade järgi" pindala "$feature.pikkus * $feature.tee_laius" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Talihooldus piirkondade järgi" pindala "$feature.pikkus * $feature.tee_laius" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField "Talihooldus piirkondade järgi" ay_nimi null Arcade # Text NO_ENFORCE_DOMAINS
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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6863394c74486d434c6d4849775448454476613445394d744d336c6931666d6d6c4a706e7971774a2f476c553d2a00;ENCRYPTED_PASSWORD=00022e6838325072513436774d79396d2b595a4743436d4150686b496b73586259657033776a67316f6d2f704661593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>greiderdamine</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><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/3.1.0'><FeatureDataset>gis.linnavalitsus.Avalike_teede_nimekiri</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6863394c74486d434c6d4849775448454476613445394d744d336c6931666d6d6c4a706e7971774a2f476c553d2a00;ENCRYPTED_PASSWORD=00022e6838325072513436774d79396d2b595a4743436d4150686b496b73586259657033776a67316f6d2f704661593d2a00;SERVER=gis.server.linnavalitsus;INSTANCE=sde:postgresql:gis.server.linnavalitsus;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=gis.server.linnavalitsus;DATABASE=gis;USER=linnavalitsus;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis.linnavalitsus.teeregister</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>greiderdamine</field_name><domain_name>Greiderdamine</domain_name></AssignDomainToField></workflow></operationSequence>
CalculateField Greiderdamine greiderdamine 2023 Arcade # Text NO_ENFORCE_DOMAINS
20230526
16042100
20230530
13493500
150000000
5000
ItemDescription
Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.1.0.41833
Greiderdamine
Teeregister
Teeregister
Enterprise Geodatabase Feature Class
0.000
dataset
EPSG
6.7(9.0.0)
0
Simple
FALSE
0
TRUE
TRUE
gis.linnavalitsus.teeregister
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.
FID_Haapsa
FID_Haapsa
Integer
4
10
0
TeeNr
TeeNr
Integer
4
10
0
TeeNimi
TeeNimi
String
254
0
0
S6idutee
S6idutee
Integer
4
10
0
Pikkus
Pikkus
Integer
4
10
0
kontroll
KONTROLLITUD
SmallInteger
2
5
0
Kasutusv
Kasutusv
String
254
0
0
Jaotus
Jaotus
String
254
0
0
TeeLiik
TeeLiik
String
254
0
0
k_omanik
KIN OMANIK
String
255
0
0
KOV
KOV
String
254
0
0
Maakond
Maakond
String
254
0
0
oigaktKp
oigaktKp
Date
8
0
0
oigakNr
oigakNr
String
254
0
0
avkasKp
avkasKp
Date
8
0
0
avKasLep
avKasLep
String
254
0
0
halKp
halKp
Date
8
0
0
halNr
halNr
Integer
4
10
0
omLiik
omLiik
String
254
0
0
TervLiik
TervLiik
String
254
0
0
TUNNUS
TUNNUS
String
25
0
0
AY_NIMI
AY_NIMI
String
100
0
0
L_AADRESS
L_AADRESS
String
240
0
0
KINNISTU
KINNISTU
String
50
0
0
OMVORM
OMVORM
String
50
0
0
OMANIK
OMANIK
String
254
0
0
leptyyp
Lepingu tüüp
SmallInteger
2
5
0
field
Field
Integer
4
10
0
talv_seisunditase
TALV_SEISUNDITASE
SmallInteger
2
5
0
talv_hooldaja
TALV_HOOLDAJA
String
255
0
0
talv_lepingu_nr
TALV_LEPINGU_NR
String
255
0
0
talv_lepingu_algus
TALV_LEPINGU_ALGUS
Date
8
0
0
talv_lepingu_lõpp
TALV_LEPINGU_LÕPP
Date
8
0
0
talv_hooldus_prk
TALV_HOOLDUS_PRK
SmallInteger
2
5
0
loik
Loik
Double
8
38
8
algus_m
algus_m
Double
8
38
8
lopp_m
lopp_m
Double
8
38
8
KONTAKTID
KONTAKTID
String
254
0
0
st_length(shape)
st_length(shape)
Double
0
0
0
20230530
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2OVC4
XDlcHJ461C1x5JKtHM59VXOas0UAQ+eGgaQKy47MMVnVo3QJt2xWdQAUYoooAKBRQFLHABJ9qBE0
/wAwSX+8OfqKdZviUr2YU6O3kaIowwCcjPapo7VIyGySw/CgZMSB1NU7wcq2PargAHQVFdJugPqO
aAM6nICZFAGST0pnarljErlmYHI6c9KBFwZ6HqKjU4klz6j+VTNgsSSF+p61TnVnlAgGT3Ycj/Cg
Y6W6jUFVJY+1UCcnJq3Hp0pG55AP9nbzUd5aLEI8FirDkGgCsGDdCD9K14+IYgM/dzz2rJEXmOAo
+Y8DFacG5UKkltp2g+uKYiWik3eoP5Ubh6ikMoXbbp8f3Rilgh85GyenA9qhdt7s3qat2P3H+tMQ
w2TDo2fwoSM20gdyAOlXarXv+rX60gFN16Jn6MDTkn3D5sIf9qqMS75VX3rTwDQA0YbPzg59KpSs
YrtmXqD3q29vE38IB9uKoSRxiZl3OOeucj8v/r0wNK3laX7qkIDkn9cfrRNLmEvvMbIxAHqaYgih
dwsm0EDvn/PWkuI2lhUR5f5skk9aQx1td70ZpXAK9vX3rHkuo08XsyHf5tgMD/dkP/xdaEttI/zL
CIwBz81ZLRG38V6XI4/4+LaeMA+xRv6UF0+q8mb0bSMCXUL6Cpc/KVwD7mkooIGupeMocHIxkjmq
/wBiX++atUUBYQcgEjFLRRQAEZGDWfcW5iO5eU/lWhSEAjB6UAZNFTz25jbKjKnp7VJFaE/NJx7U
AVQCxwASfarVvbyLIHOABVpUVBhVA+lOoAKKKKACkYblK+oxS0UAZGMHHcUZI71Lcrtnb35qKgAz
mtLTwDCTzw3r7Vm1at7jyU2iPcxbIoA0+uGIII7ZqlqDxlAM/PkZGelSXE/lxxM6HceoBxis+4kW
aYuq7QaAJLb5A8oGSBtX6mrqKEQKOwqtAgGxSf8AbI9+36VbpvYlb3DpSAq4yCCKWjGOlIohmt1k
T5QAw6YqOyBAcHqDVqm7dpJA69aAHVWvf9Uv+9VkHNVrzHlrnON3agCKyXMhb0FXqigSNUzHnaec
t1qWgArLZd0xBOOeTWjKHMTiMgORgE9jWdNbT+cMSEqx5ZUBwfxoADj7ifNz1x1NaEKskSq3UCmw
QeV8zHc57+lTUAHYjsaxtQsyNZ0i4iKgQyzFkaTBbdGRhc++K2aq3Sk3VmcgASHPJH8JoHGTTui1
+dAJB4xRRQIDycnr9TSY9zS0UAAIIBHQ0UiqFUKOgpaACiiigAooo7A9QRkUAFFFFABRRRQAUUUU
AU71Puv+BqpWjdAG3b25rOzQAVPbSJFIruMgZ6VBS/wj60AOlk8yQnJxngE9KSNPMcKMc+tNqaBQ
2R3b5R9O9NCbJEQS3CEZ+U7yP0FXaihhMW4s25mPXGOKloYJWQUY4zRUbqynenXuvr/9ekMkopqM
HUMOlOoAQjuODVe5+bYjfKM53HpVmkZQylWGQaAEjAEahSCAO1OqhJDJC+YyxB6Yq2hk2AsMnuKB
D26f0oAIOT371E06A7Wyh96lBzz/ACoGLRRRQAx5AnU1TuJVa4tN67f32ELc5O09PwzVie3a5OwS
Iowchl3Z9Khu49psFcozxzjlUxj5W/KgEXaKKKACiiigAooooAKMjIyQM8UU10EiFT0NAEybcBg2
R6+tMd9zDjio4oxHGEBJFObpn0oAWiiigAooooAKKia5hRtrSDPoOaT7SD92KVvotOzFzIbeHEOP
U1QqxLcrKSrRONvqcc1EHVWyIlPsxJosK4yrVtarPExJIOcKe1QmeQ5xsUHsEFPXz3jBSUnnlVOC
KLeYX8h8to8WFVC5P8QqS3j2tyQdgxx6nr/SqTbicOWJ9zU0NyYhtIBWgNWaFFMjlSQZU/hT6RQU
UUUARupRi8Y5/iX1/wDr09WDruU8UtROpRjJGM/3l9f/AK9AEtFRwyiVNwGO2KkoAKKKKAGuiuMM
ARVdreZMmFhtHOM8/wD16tUUAVlmmVAzoGUjOVqRLmJ/4sH0NFv/AMe0fsoFNmtVk5X5W/nTEEcz
/a3RSNp457e9U/EE8kM2jhGI36giPx1BRz/MCnJAxnEbfLnvVbxCAG0duRt1KP6cq9I0pJOWptUU
0OpGQwIHegOpGQQaCB1FMEsZJw4OOaTz4h1daAJKKRiQp2jJ7CgZwN2M98UALRRRQAUUUUAIvSlp
B94/nQzKilmOAOpNAC9KgzJdEpCSsY6yf0FVZLn7TlVBEfYD+L/61WzNJFabGiKHG1SKexO5XW1M
cpGA6r15xmr4kRQu47AOAM1DGpVFB5PINKMFwpGcrwD0JoGEtnE6NJ8ynknnNZlX4mjmyib4nIPy
g5FQSWcsYzjcB1xSGV6sKpICuoYjjaflI+h71XAyQPXirpUlANqsmfvZyB/UUxMYFDjYIy+0cdmX
/GqpBU4IIPvVsDDlXUjjKtu5/A96k4m+RlL7R3+Vx/jQBQBIOQcEVaivCOJBkeopv2QuzCNgcfwt
w1QMjI21wQfekBphllT5HI9x1oTzOd+32xVW0MAyZGIftzgVbLruCqwY4ycHpQMdRSbh06H3paAI
mUxsZEGQfvKO/uKkVgyhgcg0MwVSxOAKjhB+ZiNoY5C0AS0UUUAFFFFAEcHEQHoSP1qSo4fuH/eP
86koAMVi+Jsm009jnEd/C2R9dv8AWtqszxDBLcaFciBd80YEsa+rIwYD8xQXT+NDmFyXCbm8otyD
jJHvmnJewxxBFdS2DjnHerFldw39lDdwNuimQOp9jUpjQ9VFBDTWjKkcMiwsWG0uMZPXH0qB4Wzn
aWz3xWnj5wxOSBgZpCoJz0+hI/rTFYjneSIBgAQDg1Ijh1DA5BpSAQc9O9UYZhHKVB+QnjNIZfoo
60UAFFFQXFyluvPzOeijqaAbsPmlSFd7nAH61myyvctl+EH3U/xpDvmkDyfM/YDoKmktpIwucHPH
HY+lO9tibX3I43Mbh16irSsbqXJGEQfKPeomtWVlTILHrjsKtxxiJdo7GkNj/f6Gqs7sr7lONpqz
/TIqlOMRR8YLc80AE/yzCRCQHG4YrSg3GBXODIVzzWav7212/wAUZyPoa1VXaoA27woFAyreogCM
FG8sOR1phYL8xzk87hgH/A0moNiVApwwGSRVYTEoVYZz3FMRKkyu2zbgfTg/Uf4Usp2JnAK5AHOc
f1FVKt2pRs+a4OBgAntQDHJOJuGAJHQE4b8DSysWj2SMG5wNwwwqKe0dMsuCueg7VEG80eTKSUBB
IPUUAXmit1AV9ijHGeOfrS7FjumwMFlHA6VVaCIYCtHjeGXLHj9amna2UIxRd5O1SDj9aQyx1pMc
gA4J7VXSWTkoPNiHGejf/XqR4o5XjkyxK8gdBQAmDLJ833FPA9TU1HAHoBWamvac45n2kngMpye3
T86ANKiqC61pzOFW5UksFGAeSenar9ABRUU0pjICruJ5P0oFzDjJlQcdCw4oAWL+P/fNSVDA6u8u
1gw3djnsKmoAKKKKAOeAl8OahBFGwk0y9ufLWPGGt5Gyfl9VJB47ZroaxNbXzdW0KA9DdtIf+AxO
R+tbdBpU1SfVr9RGG5SMkZ7imxqyJtZt3vT6KDMgu3KQ4H8RxVAAscAEn2qzeuCQg6jk06yjwGlP
ToKAHW0px5b5Dds96s1UlDSXeclUQA5x2qOW8d4gIRjPBY9qdhXJbq7EXyR/NIe3pVUW8xO9lZnY
ZJPpRbbI51ZxkZ5Lc1YuLxmOxG+UdW9aLit1Y+xjwS2V3EZXPYZ5q8zADIYYB+bvVKcmMFlPryPR
h/iKfCN0asWLHHGe1IocB+8Lkcsf0pSOfqKdRQBEQFVzk/Nz1qvdq0TBC24YyM9qtlRt5qhcO0pD
EdsZoAliRYTC5P8ArMgihryeN2VtpIOORUdzkeUpPRBRP+8RJvUYb6igCK4uDLLvdcDGMjpTQcjI
oppQZyp2n2oAdRUn2a4VAzRkg85Xn9KcEjjGZG3nsqH+ZoAfb3MoIUjzAPXqPxqS5NurkyQRySnn
JUcfWqzzM42gBVH8K0+HZIFidVyfutnBNMRIsFtdQghIklX/AGev4UjxxwsgGFKgfKp/p3pzQeQF
/fKrZ/CmystzGUlMQ6fOp6e1IY0qsL7o3fB7Adz3I9Kjtp7gSsu1ZdxyD5nUf41I0yxrsLqyMCDI
GHy/4UWnlfawi8sBkNu3VV+5LWt0WIrlZOCCrf3etSDYT0ANO2JvLAcnviggHrUlBtX0H5UtMwy9
DkehpwINADJg2zKDLHr9KjhtkEQEkSsf9sAmrFHegCCKNEnl2oq5weAB2qwuMjPSoR/x8t/uD+Zp
4OScHJHagB7YDcdKSjI9aKAMe9G/xRpSH+CGeT8flX/2Y1sVik7/ABoFPSPT8r/wKTn/ANBFbVBc
9kvIKKKa0iqcGggqXokwjEIQOOODU63FvHEu1m+UY246+9LJGJHjRi2CT0x6UosodufLkPsSKYiC
5kMdm8p+/N91fQdqpR4RQhPUY/Grd/sxEgBz2BPQD/P6U3yIhamQnMo7A9M0MS3K5GOtHatCO3il
gRCDvA5I6ipooFgjMZUnd1akUUmmLW/KnpsP8xUlk+VZPTkU2eJ40dUGYy2eO1QQy+RIHMMsnsg/
nQBdlllR8JAZFwOQwFMaXfD+8LwHPXIyPxpxvo9u821wMHGPL5+tVbtvOjEqIwcAgJIvX8KALFoR
KZAbl5VB28qOv1qc2aBcMxOT6Ulv5SxkxKN55IznBNSKZVVjKAQf7vagDLmcPISCSBwCadD88bxe
o3L9RUNORijhh1BzQAgUscAEn0FTeSsXMx5/uL1p08hRsRgIrDOR1NVqALxvFa2K8qw4AX0qGaaK
YA+VtbuRVcAnpUqKikGUnGcHbzj60AAizgr82eg6GpmiG1QsazHOWycY9MCqkzsszYifGeDkcirC
XTAgSZYDv3FAD5HnkGHsQw9DIpqaKNTEN0Cx56pwaWOTcSAdwGDnaRUgINADGgjaMoFVR7AcVAtn
LHgJdyKo6Dav+FW6g+xwZzsOR7mgCVFZUAZi7AcsRjNOqAWkIZWCkEHI+Y1PQAUhHcUtAyTgdaAK
5luRIVEClc8HdjjNNM1yCAsCn6v25/8ArVeCgDBBORy1RXI2wsVUkjB+tAFCZ3f95bsjqOuepPf8
MVNDDBNhmClmHQnvRbTpMixtA4H3sn1qMRyK8ZT5YwM8ZyT9KfQXUJktlcFYBIR12tyMYHr14/Sp
RdP8o+yTjOOw4/WmfZbZUMkkMRZm645JJP8AjS+U5DFLt8A5IwDikMp61byOkWo2ALX1kSwQD/Wx
n7yfiBx7gVfs723v7OK6t5A8Mq7lP+e9N8l7ZWkU7pHHO0AZpLaK3gst8MCxGRjI4UdGJySfc0FO
V42fQs70zjcv51WkieZy4mjjXoA7Yz7/AJ5qKSZseWZSzEEgY7UkkhDlSFYL8oJGelMhlguxv0U/
dHQfhVwjjcVGcdN1UbZHnYStMd6EAfKKnl8xIWkLJvUEgbfSgGU5QZ7r5emdij6daeJI1kUk4VpN
34DpVYMRtIOMDHFJQxJaFuWeBp90UgRwCSW70+G+JiIYbh0yD0qiVB5Iz+FCnapC4APpSKNpUjMf
QMvXd60w4JyFA/CqFrKyyBM/Ke1X6ACmuiupUjg1CLxcZ8ifP/XI0+KdZd20OMHHzKRQA0RQ48mP
cXP3j6CmHIgkjSY4XhgeamuFBidoxggfMe5ql5QCQsM/OcdfegQx4mRip5I64plSPLb/AG1hJKqr
uOecEU6BoZrgqLhdpb5RuzuA9KBhgyW3uh/Q1VvDLFZzPbqrXCoSiN0JxwDV5njFzsQjyz8pIAFV
mUoxU9QcUDRBYagl/YwXcHypIoYeo9R/StAW6tau7oSrHp6CsPRkFrr91pjjEUubu39Dn76/gef+
BV0zXURhLKQr4xtP8qCpxSemxnSvvbpjFMqWWIqokBBUnAqKggliuHi4HK+hq7HNHN0OG9O9ZtHS
gDWyR15pc56VRiu2XAf5h696V7vL/L8o9cdaBFxmCjJIFIrq3Qg1kzSTby7/ADITxjoPx/xp9u6N
MASR6gHBFMDUO7B2rnFJH5uDvQBD71EHzG8cLsG65IqtDLJIzLI5J6BeB06n60IGXfsEGekmCDn9
4cU6Oyhjl3IHH/Azg1Sa4lWHyd2f5gelS26yrcIkr/KRkKTSGWHjXzc7cEUtKTlmPvSUAZl5d30M
svl6eZoUxt2sMvxk9+OcD8fap7Oe6kZ1nszAuMg7wc8njj8/xq5RQBXZbsN8kqbcngg8frTPJuig
DTpnuNpx/OrdFAFWKNrePzJSrOG38Dg4GcfpVCa2iMpYrksAc+vFaVy2IySMjGPxP/1gapYQ87iP
qKYupasCvzg4zwRVmcAwuG279rY/KqdlIkZk3sBkcZq4Zo2QjzELHPT6UAZI6CikX7opaHuEdipN
p8U87TM8oZlC/K2OBn2z3NJ/ZseWInuBuzkCT6/4/oKuVZtVhfIkOGxwaQyjb6WYZVn3XJCyeZ80
hx34+nP8q2UkDjIB29ie9LvLsEkdQnTK/wAR/pU4AQbTtAzhQBQBFUMtuZ50y42KN2zP3j2zVhwF
+8yjOfamJIGyqshkGen6UAPwMkKFycZHsaoBH89YFXcI2zWhnrgjIwTx2NV5GEVzHKCME7HNMQks
CJH5gwxyS5/z6U2S5hkt2AUA7cYxzmiYO8zOuPLAxubgVRIAJAOR60hgoLMAOp6VLOCdsncjDfUV
DU0XzxPH3+8tAGNrQmgih1O2GZ7F/OA/vJ0dfxXP5CtRporjE8JzHIAwPrkZprKGUqRkEYNZnhcS
S6WlqxxJbyyW/PorED9MUGm8PT9f6/E3IZnhMZEXmKTgkEfLT77yy6tGRk53YptxHJDB5O8bd2eO
oqnsbGDITwOcYoMx9FMVGBBMhPrnFSqjPnapOOvtQA2gDJwOtKyshwwwakt2RZQX6dqAL0USpFsI
Bz1zVFIwb3asDeWTgemfX6Vfdsx/KeW4BFRQwSwsD9paQDoHUUCsSswVym5NwGSuecVBd2hmglkS
4kgk2ECSIAsv0BBB/EVZCou7YgVnOWPrS98jg0DW9zkP7L1bzWePxFdPjqJbVGGB9FH6VZhvdbtQ
0klnaagFGf3btE/4BgR+tdHKWWNysaltpGAOtZ0U0aMQzqD0OT0oNPat7pfdb8rC2OsLc2xkuLS4
s2U7WWUA4P1UkVehuoLj/UzRvjghWBIptmipCSoxuYt+tD2du7l2hTeQQWAwcEY60ENpk47DIyeg
oqt9lkSMrBdTIexY7/X1+vrUE8uqW8QMdtBeNnkLJ5Rxj3yCc/SgEruxoUVh/wDCTRW7bNS0+/sT
/fkhLx/99pkVo2uqWF8M2t7bzf8AXOQE0FOnJatDbxssq9sk/wCf1qrUl2x83CjdtGOuOep/Umq+
9zn5F/76/wDrUEIkpQQFbqWPCgeppKVX2zRZ+7vGaa3FLYswWEj43/Iv61WddkjL6HFb1YtwMXEg
/wBo0h2IqUcEZpKKALchQQs0JGG6g/eWn2l48hMJ+ZuzVnt8zbc8YyfepIiyuPLOG6DFAFqKNpbv
E6Mc5JDgEDtU4hit5/3caIXTG5UA5FBuPIULcEtIRzt7CkS4W4iKbtsg5UnvTEWASeBkY7kY4qtd
cxYIJTI3NjFWI23qCM9jnGf1psqCRGViQO/egRlyNl2wxYdiaZSsNrEZzikpFBT4y0bq+DjP501S
AwJGQDVmW98xSvlKF7Z7UAQTJslYD7vUfSoYgI5ptowSwfjPcY/mKsv89ur90+U/TtVOT/j6jU52
ujD72BkEHp+JoAuPeNcYjfnB6qO9MKjy95yp/usOaYAAMAYFIxkJ4YY96BC1fsTiF+epxWaRIScM
MdvlrVgi8qMDOTjn696Bj2RXGGUEVWksweYzj2NWWcLjJ5PQdzTdrOMv8q/3R/WgDODSRTcHAX8Q
TV2K6R8Bvlb9KpyvvkJAwOw9qZQI16KzYrh4uhyPQ1ciuEk4zhvQ0DHyyCOMsfwrJl+YMxALGrN1
N5j7R91aqyfdH1FAi9DdokaoUICjAxU6TLIx2ngY/rWWWVB8zBfqcVLBOwkVYxlTyWU5oA1KKjB5
5xjuacAcDk/jQFyK7bbAR/e4rEuNG0/UXVbizhkZiAHKAMPxHIrVvW+ZU9OagjO0s3opx+PH9aCl
Jx1QlnawKdoTMaAYDZc4yPXJp9wqLLhFCjA4ApsZblFxl8D9afdIUnIPoMfSgRXy/oPzpkjsAp2M
CGHPGOtWZIWiVC38QyMVBKMxN9Ka3E9iz9qnP/LRuaiZi7FmOSeppo5ApaQwwcZ7UVfuYP3K7MYT
tVDoKAGryzH3xTwSpBBwR3piDCD35p1ACkljkkk+ppKKngiXaZpf9WO3qfSgBwmlhgVPXkE9hUDy
PJ99iaJJGlcs3J/lTKYhaKOaKQwFFWLWFZVYtnipjZR9mYUCK9vgs0Z6OMfj2qvJvGwBmXDjcFxy
OmOfrV9bMK4O84HtUGo2hkt524xsLYBwcjn09aBi/ZX8gynAUDPPeoKutcLPp0JidCsiqQQwORjO
aiSBMHcXY9tqnH50AJbRbnVmxjsPU1dZiDsXlv0H1qtBBIjE429gTiraqEGB+J9aAEVAvPVu5PWo
rqTZFgdW4qes65k3zH0HAoAhooooAKKKKAADJxT7qERXCxjOMbue5plNclpEBJOMn8KAFKg9QD9R
VrT1HmyAoPKVQeBjBqtT7eRo3ZCSqOfmb2oAuSXEUcnl8kY64oN5FkAZJP4VScguxBJGeM02mKw6
4LytvB2N3U84pEDLAxcglmAGBjpyf5ikleRyMFR9Vz/WnHcI4wxBOCeBjqf8AKAGg4ORSkknJOTS
UUhjlkKqykbgRjB7Usx835hk/KAeOhoooEMVcW8T/wB4H9KazMpG1C3rz0oopvcUdkTyajI0W0Qu
CevT/Gq4LyMsflkbyFySO9FFIotXUHkyADaARwAagoooAkijDsSzBVXk5pZpvNIAG1F4VfSiigCK
iiigCSIxgsJACCOOO9RGiigRoWYxCT6mrFFFAwoIBBB6GiigDF8Ltu0mK1OA1q8lux7/ACMQP0xW
rJMIZNrg/UUUUF1fjY5JUk+6wNJJPHF948+goopmdylNdSuMJhR6etVwwJwcg+hoopDHUUUUAFFF
FABTNv7zcc+goooEPpM0UUAxaKKKBiYJPHWrctrIzkrgqMKvPYDA/lRRTERi1lzggD3J4pGtpVON
hP05oopAf//Z