20190415
13180800
1.0
FALSE
gisdb.sde.Investeeringute_kava_joon
002
376843.435400
457004.921000
6425659.494200
6498902.950700
1
Server=rebane; Service=sde:postgresql:rebane; Database=gisdb; User=sde; 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/10.6'><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>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</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>
FeatureToLine 'Investeeringute kava' "Database Connections\rebane.gisdb.sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon" # ATTRIBUTES
CalculateField gisdb.sde.Investeeringute_kava_joon hanke_nr 1 VB #
CalculateField gisdb.sde.Investeeringute_kava_joon aasta 2019 VB #
CalculateField "HANGE 3" tegevus "kahekordne pindamine" VB #
CalculateField "HANGE 3" tegevus "kahekordne pindamine" VB #
CalculateField "HANGE 3" tegevus 1 VB #
CalculateField gisdb.sde.Investeeringute_kava_joon hanke_nr 1 VB #
CalculateField gisdb.sde.Investeeringute_kava_joon hanke_nr 4 VB #
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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteCodedValueFromDomain><domain_name>OV_nimi</domain_name><code>1</code><code>2</code><code>3</code><code>4</code><code>5</code><code>6</code><code>7</code><code>8</code><code>9</code><code>10</code><code>11</code><code>12</code><code>13</code></DeleteCodedValueFromDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>1</code><code_description>Kihelkonna</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>2</code><code_description>Kuressaare</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>3</code><code_description>Laimjala</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>4</code><code_description>Leisi</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>5</code><code_description>Lääne-Saare</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>6</code><code_description>Mustjala</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>7</code><code_description>Orissaare</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>8</code><code_description>Pihtla</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>9</code><code_description>Pöide</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>10</code><code_description>Saaremaa</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>11</code><code_description>Salme</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>12</code><code_description>Torgu</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>OV_nimi</domain_name><code>13</code><code_description>Valjala</code_description></AddCodedValueToDomain><SortCodedValueDomain><domain_name>OV_nimi</domain_name><descending>ASCENDING</descending><sortByDescription>CODE</sortByDescription></SortCodedValueDomain></workflow><workflow><AddField><field_name>Piirkond2</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>Piirkond</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>piirkonnad</field_domain></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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Piirkond2</field_name></DeleteField></workflow><workflow><AddField><field_name>Piirkond2</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Piirkond2</field_alias><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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Piirkond2</field_name></DeleteField></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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Piirkond2</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Piirkond2</field_alias><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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>piirkond2</field_name><domain_name>piirkond_text</domain_name></AssignDomainToField></workflow><workflow><AddField><field_name>Field</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Field</field_alias><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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Field</field_name></DeleteField></workflow></operationSequence>
Append TEED_IO_2020 C:\Users\hannes.rohulaid\Documents\ArcGIS\Projects\MyProject5\rebane.sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon "Use the Field Map to reconcile schema differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,C:\Users\HANNES~1.ROH\AppData\Local\Temp\ArcGISProTemp18540\1bfa23f99f9aec2a385ba45d298d174c.sde\test.sde.TEED_IO_2020,tee_nr,-1,-1;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,TEED_IO_2020,nimi,0,1073741822;piirkond "Piirkond" true false false 2 Short 0 5,First,#;aasta "Aasta" true true false 2 Short 0 5,First,#;tegevus "Tegevus" true false false 2 Short 0 5,First,#,TEED_IO_2020,tyyp_id,-1,-1;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,TEED_IO_2020,algus,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,TEED_IO_2020,lopp,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#,TEED_IO_2020,piirkond,0,8000" # #
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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>aasta</field_name><clear_value>True</clear_value></AssignDefaultToField></workflow></operationSequence>
Append TEED_IO_2020 C:\Users\hannes.rohulaid\Documents\ArcGIS\Projects\MyProject5\rebane.sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon "Use the Field Map to reconcile schema differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,C:\Users\HANNES~1.ROH\AppData\Local\Temp\ArcGISProTemp18540\1bfa23f99f9aec2a385ba45d298d174c.sde\test.sde.TEED_IO_2020,tee_number,0,8000;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,TEED_IO_2020,nimi,0,1073741822;piirkond "Piirkond" true false false 2 Short 0 5,First,#;aasta "Aasta" true true false 2 Short 0 5,First,#;tegevus "Tegevus" true false false 2 Short 0 5,First,#,TEED_IO_2020,tyyp_id,-1,-1;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,TEED_IO_2020,algus,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,TEED_IO_2020,lopp,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#,TEED_IO_2020,piirkond,0,8000" # #
CalculateField gisdb.sde.Investeeringute_kava_joon aasta 2020 PYTHON3 # Text
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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><RemoveDomainFromField><field_name>hanke_nr</field_name></RemoveDomainFromField></workflow><workflow><AddField><field_name>hanke_nr2</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Hanke number</field_alias><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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>hanke_nr2</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Hanke number</field_alias><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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>hanke_nr2</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Hanke number</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField Investeeringute_kava_joon hanke_nr 6 "Python 3" # Text
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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>hanke_nr2</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Hanke number</field_alias><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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>hanke_nr_2</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Hanke nr</field_alias><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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Field</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Field</field_alias><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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>hanke_nr_2</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Hanke number</field_alias><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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Field</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Field</field_alias><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/2.5.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6845326c526b55416f5578745a2b74337a2b557147463377584d4874637049784d6b4f644e7559444b3475303d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>hanke_nimi</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>hanke_nimi</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Investeeringute_kava_joon hanke_nimi "I Mustkatete ehitus ja ülepindamine" "Python 3" # Text
CalculateField gisdb.sde.Investeeringute_kava_joon hanke_nimi "II Kruuskatete ehitus" "Python 3" # Text
CalculateField gisdb.sde.Investeeringute_kava_joon hanke_nimi "II Kruuskatete ehitus" PYTHON3 # Text
CalculateField "Kruuskatete ehitus H3" hanke_nimi "III Kruuskatete ehitus" PYTHON3 # Text
CalculateField "Kruuskatete ehitus H4" hanke_nimi "IV Kruuskatete ehitus" PYTHON3 # Text
Append IO2020lisa3 C:\Users\hannes.rohulaid\Documents\Kaardid\Documents\ArcGIS\Projects\MyProject5\rebane(10).sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon "Use the Field Map to reconcile schema differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Abiksikka.gdb\IO2020lisa3,tee_nr,-1,-1;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,IO2020lisa3,nimi,0,1073741822;piirkond "Piirkond" true false false 2 Short 0 5,First,#;aasta "Aasta" true true false 2 Short 0 5,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Abiksikka.gdb\IO2020lisa3,aasta,-1,-1;tegevus "Tegevus" true false false 2 Short 0 5,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Abiksikka.gdb\IO2020lisa3,tegevus,0,8000;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,IO2020lisa3,tee_algus,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,IO2020lisa3,tee_lõpp,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#,IO2020lisa3,piirkond_1,0,8000;hanke_nimi "hanke_nimi" true true false 255 Text 0 0,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Abiksikka.gdb\IO2020lisa3,hanke_nimi,0,255" # #
Append lisateed2020hange4 C:\Users\hannes.rohulaid\Documents\Kaardid\Documents\ArcGIS\Projects\MyProject5\rebane(10).sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon "Use the Field Map to reconcile schema differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,lisateed2020hange4,tee_number,-1,-1;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,lisateed2020hange4,nimi,0,1073741822;piirkond "Piirkond" true false false 2 Short 0 5,First,#;aasta "Aasta" true true false 2 Short 0 5,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Abiksikka.gdb\lisateed2020hange4,aasta,-1,-1;tegevus "Tegevus" true false false 2 Short 0 5,First,#;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,lisateed2020hange4,tee_algus,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,lisateed2020hange4,tee_lõpp,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#,lisateed2020hange4,piirkond_1,0,8000;hanke_nimi "hanke_nimi" true true false 255 Text 0 0,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Abiksikka.gdb\lisateed2020hange4,hanke_nimi,0,255" # #
Append lisateed2020hange4 C:\Users\hannes.rohulaid\Documents\Kaardid\Documents\ArcGIS\Projects\MyProject5\rebane(10).sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon "Use the Field Map to reconcile schema differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,lisateed2020hange4,tee_number,-1,-1;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,lisateed2020hange4,nimi,0,1073741822;piirkond "Piirkond" true false false 2 Short 0 5,First,#;aasta "Aasta" true true false 2 Short 0 5,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Abiksikka.gdb\lisateed2020hange4,aasta,-1,-1;tegevus "Tegevus" true false false 2 Short 0 5,First,#;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,lisateed2020hange4,tee_algus,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,lisateed2020hange4,tee_lõpp,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#,lisateed2020hange4,piirkond_1,0,8000;hanke_nimi "hanke_nimi" true true false 255 Text 0 0,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Abiksikka.gdb\lisateed2020hange4,hanke_nimi,0,255" # #
Append kruusateedrem2 C:\Users\hannes.rohulaid\Documents\ArcGIS\Projects\MyProject5\rebane.sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon "Use the Field Map to reconcile schema differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\Documents\ArcGIS\Projects\MyProject5\MyProject5.gdb\kruusateedrem2,tee_nr,-1,-1;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,kruusateedrem2,tee_nimi,0,8000;piirkond "Piirkond" true false false 2 Short 0 5,First,#;aasta "Aasta" true true false 2 Short 0 5,First,#;tegevus "Tegevus" true false false 2 Short 0 5,First,#;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,kruusateedrem2,algus,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,kruusateedrem2,lopp,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#,kruusateedrem2,piirkond,0,8000;hanke_nimi "hanke_nimi" true true false 255 Text 0 0,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\Documents\ArcGIS\Projects\MyProject5\MyProject5.gdb\kruusateedrem2,hanke_nimi,0,255" # #
Append TEED_IO_2021_ROUTE C:\Users\hannes.rohulaid\Documents\ArcGIS\Projects\MyProject5\rebane.sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon "Use the field map to reconcile field differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,TEED_IO_2021_ROUTE,TEE_NUMBER,-1,-1;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,TEED_IO_2021_ROUTE,TEE_NIMI,0,37;piirkond "Piirkond" true false false 2 Short 0 5,First,#,TEED_IO_2021_ROUTE,PIIRKOND,0,10;aasta "Aasta" true true false 2 Short 0 5,First,#,TEED_IO_2021_ROUTE,aasta,-1,-1;tegevus "Tegevus" true false false 2 Short 0 5,First,#,TEED_IO_2021_ROUTE,Tegevus_domeen,0,40;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,TEED_IO_2021_ROUTE,ALGUS,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,TEED_IO_2021_ROUTE,L_PP,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#;hanke_nimi "hanke_nimi" true true false 255 Text 0 0,First,#" # #
Append TEED_IO_2021_ROUTE gisdb.sde.Investeeringute_kava_joon "Use the field map to reconcile field differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,TEED_IO_2021_ROUTE,TEE_NUMBER,-1,-1;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,TEED_IO_2021_ROUTE,TEE_NIMI,0,37;piirkond "Piirkond" true false false 2 Short 0 5,First,#,TEED_IO_2021_ROUTE,PIIRKOND,0,10;aasta "Aasta" true true false 2 Short 0 5,First,#,TEED_IO_2021_ROUTE,aasta,-1,-1;tegevus "Tegevus" true false false 2 Short 0 5,First,#,TEED_IO_2021_ROUTE,Tegevus_domeen,0,40;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,TEED_IO_2021_ROUTE,ALGUS,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,TEED_IO_2021_ROUTE,L_PP,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#,TEED_IO_2021_ROUTE,Piirkond_domeen,0,255;hanke_nimi "hanke_nimi" true true false 255 Text 0 0,First,#" # #
Append teed_032021_1 C:\Users\hannes.rohulaid\Documents\ArcGIS\Projects\MyProject5\rebane.sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon "Use the field map to reconcile field differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,teed_032021_1,teed_03202,-1,-1;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,teed_032021_1,teed__3203,0,254;piirkond "Piirkond" true false false 2 Short 0 5,First,#;aasta "Aasta" true true false 2 Short 0 5,First,#,teed_032021_1,aasta,-1,-1;tegevus "Tegevus" true false false 2 Short 0 5,First,#;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,teed_032021_1,teed_par_A,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,teed_032021_1,teed_par_L,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#;hanke_nimi "hanke_nimi" true true false 255 Text 0 0,First,#" # #
Append teed_032021_1 C:\Users\hannes.rohulaid\Documents\ArcGIS\Projects\MyProject5\rebane.sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon "Use the field map to reconcile field differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,teed_032021_1,teed_03202,-1,-1;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,teed_032021_1,teed__3203,0,254;piirkond "Piirkond" true false false 2 Short 0 5,First,#;aasta "Aasta" true true false 2 Short 0 5,First,#,teed_032021_1,aasta,-1,-1;tegevus "Tegevus" true false false 2 Short 0 5,First,#;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,teed_032021_1,teed_par_A,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,teed_032021_1,teed_par_L,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#;hanke_nimi "hanke_nimi" true true false 255 Text 0 0,First,#" # #
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/2.7.0'><FeatureDataset>gisdb.sde.Teede_haldus</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6830714f4b4e436264664d6b32536f37314a61434c774e49494f522f5665797074534753312b36684d4a42633d2a00;SERVER=rebane;INSTANCE=sde:postgresql:rebane;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=rebane;DATABASE=gisdb;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gisdb.sde.Investeeringute_kava_joon</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>tegevus</field_name><clear_value>True</clear_value></AssignDefaultToField></workflow></operationSequence>
Append teetood2022 C:\Users\hannes.rohulaid\Documents\ArcGIS\Projects\MyProject5\rebane.sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon "Use the field map to reconcile field differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Teetööd_abiks.gdb\teetood2022,tee_nr_nr,0,8000;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,teetood2022,Tee_nimi,0,8000;piirkond "Piirkond" true false false 2 Short 0 5,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Teetööd_abiks.gdb\teetood2022,piirkond,0,8000;aasta "Aasta" true true false 2 Short 0 5,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Teetööd_abiks.gdb\teetood2022,aasta,-1,-1;tegevus "Tegevus" true false false 2 Short 0 5,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Teetööd_abiks.gdb\teetood2022,tegevus,0,8000;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Teetööd_abiks.gdb\teetood2022,algkaugus,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,teetood2022,lõppkaugus,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#,teetood2022,piirkond,0,8000;hanke_nimi "hanke_nimi" true true false 255 Text 0 0,First,#" # #
Append teetood2022 C:\Users\hannes.rohulaid\Documents\ArcGIS\Projects\MyProject5\rebane.sde\gisdb.sde.Teede_haldus\gisdb.sde.Investeeringute_kava_joon "Use the field map to reconcile field differences" "tee_nr "Tee nr" true true false 4 Long 0 10,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Teetööd_abiks.gdb\teetood2022,tee_nr_nr,0,8000;teenimi "Tee nimi" true false false 150 Text 0 0,First,#,teetood2022,Tee_nimi,0,8000;piirkond "Piirkond" true false false 2 Short 0 5,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Teetööd_abiks.gdb\teetood2022,piirkond,0,8000;aasta "Aasta" true true false 2 Short 0 5,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Teetööd_abiks.gdb\teetood2022,aasta,-1,-1;tegevus "Tegevus" true false false 2 Short 0 5,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Teetööd_abiks.gdb\teetood2022,tegevus_domeen,0,8000;algkaugus "Algkaugus" true true false 4 Long 0 10,First,#,C:\Users\hannes.rohulaid\Documents\Kaardid\ARC\Teetööd_abiks.gdb\teetood2022,algkaugus,-1,-1;loppkaugus "Lõppkaugus" true true false 4 Long 0 10,First,#,teetood2022,lõppkaugus,-1,-1;maksumus "Maksumus" true true false 8 Double 8 38,First,#;akti_kp "Akti kuupäev" true true false 8 Date 0 0,First,#;garantii_kp "Garantii kuupäev" true true false 8 Date 0 0,First,#;toovotja "Töövõtja" true true false 2 Short 0 5,First,#;markus "Märkused" true true false 255 Text 0 0,First,#;tee_laius "Tee laius" true true false 4 Float 1 3,First,#;hanke_nr "Hanke nr" true true false 2 Short 0 5,First,#;piirkond2 "Piirkond2" true true false 255 Text 0 0,First,#,teetood2022,piirkond,0,8000;hanke_nimi "hanke_nimi" true true false 255 Text 0 0,First,#" # #
20190510
09172500
20190510
09172500
Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.0.8321
2022 Teetööd
1
21.880489
23.273499
58.627868
57.955239
2022 Teetööd
2022 Teetööd
SDE Feature Class
dataset
EPSG
6.7(9.0.0)
210
Simple
FALSE
210
TRUE
FALSE
gisdb.sde.Investeeringute_kava_joon
Feature Class
210
objectid
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
shape
shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
tee_nr
Tee nr
Integer
4
10
0
teenimi
Tee nimi
String
150
0
0
piirkond
Piirkond
SmallInteger
2
5
0
aasta
Aasta
SmallInteger
2
5
0
tegevus
Tegevus
SmallInteger
2
5
0
algkaugus
Algkaugus
Integer
4
10
0
loppkaugus
Lõppkaugus
Integer
4
10
0
maksumus
Maksumus
Double
8
38
8
akti_kp
Akti kuupäev
Date
8
0
0
garantii_kp
Garantii kuupäev
Date
8
0
0
toovotja
Töövõtja
SmallInteger
2
5
0
markus
Märkused
String
255
0
0
tee_laius
Tee laius
Single
4
3
1
hanke_nr
Hanke nr
SmallInteger
2
5
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
st_length(shape)
st_length(shape)
Double
0
0
0
20190510
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD0iiii
uw8wKKKKAE3Ke4496Nw9R+dRNbRO2SDnrwaVbSAk7lP4Gk3bUpK7siXI9aKYtuqPuUHOMdaf0oUk
xyg1ugooIyMVALSMdGf/AL6pkk9IGByB1BwaSG2XzRl2wRjJPSmQwC2Z41JZQcgnGce/rWfO+dI2
9mvZuT3LUWVUkDII5HtSTWoWJXZNyseFbk5phbAHXA4xU4eVQhkBHHyn2rKorSN6MrxIYY0Vxuwu
TyQKWXbvxHnGeCamx5Lb9ocEcE1AqFtzelQaksk7y7dx5UYzVeadYI1Lk7WdUwPVmCj+dSYzVTUY
5JLTdEpd43WUIP4tpBx9TimtxwSckmT6ijXk8aqqLHGVxJ3OOePStAQBrUFFBck7iDj1P+frWfBd
wXcOYgQynDBgVYexB5FXCm+zaI3AVXyML97kUtUN32egxlbeVePO/APpTSwgbIUuFHK4yTTo7idb
kMZ4tjZHlsnK+hB/nVlo7eOZWkbIYdAOKGTYgnEZ2mMYLDOKjkVyY4mfIJ6Zzip5vKXy5IztUEgt
2APU1DCkcuXikSbI+UKcgj1yKA8y3cWoSIGMDI6nPNRfZQgfz3JUsOmc+uf0q4Ig0KnnI5AycZ/O
olDAshLEseQT0/8ArUAYF/pluWhCIVy2QAGLMuScdffOasDRrC2VZREoCOGAJOQw6dT7mtSWJknE
pZht9/lx9PWmXcLS2kbkZ4+YYqoP3rMmr8F0EMySW58x8Mp4x6e1Q3LBpT0wBtyO9UQWtz8zZj7H
uKuRvGQMkHPXNaShroYwq6WY6NZEQDoCNwP0/wD1UhhlLKZDyeVJ6D6VEXJAGeB0q1bvJIGygYIm
Bmk6bSHGsm7EVxEwlXncXANQdOtP82Tfv3HcOM0zrW0U0rM5ZNN3RKJPlBPIHG3Jx9aFkJ3DJwe2
aipc8VLgmi41Wmrl1k8y3Y7QxZievI9KbCsk0Ssc8DA4zUEbjOCSOeuelTrdbRtjQhRwME1g4tHY
pxauU6KKK6jzgooooAkwGjAHUdfajy9oBLA56YqMEjoabKzpEzRruK4OPbvWc7pNm1O0pJWJwxLA
BgCBwCetMZjJ8xAB9qLdY7yNpUG4IducdM1Kke1CsWxUTICk9fb3rCMtbo7JRunFkFOVc9s5pgOQ
DUi5GCMg1vUlZaHHRjeWo9dvlsTjd2zUDSRNK6q3zAD5RycVM20ICpJf3HFRIyQTtsiRQRn5Rgc9
ePrWCbTujscU4tMReXGRjHrUx3YUtkjtmmiQg4XoetWJCXjDOjAAYVh0P1obbd2KMVFWQ4pGUVV5
ZgQVB/HNVp5Yk2fw54+tW5kAt4T3KnkfSqqwLIdrRiVeMFuxpDGxXsSAr5ilW689qHuLRztjlCKc
jcTkg+v4UjWMcRx5SDPYfnUYtrZshoufUDpQMEgRxDdbx9oaILJ5Ywre9WoIwrbiN2R1645p86RB
EMMe1AMYHSnLcIINiph2BBx39KYNuRUNuZSCwYOnzLtP86snbIixLGwkB79abvdIUkSQq2eRnrSL
IzSmV2JYcnoB9KQDkjdW8vGXbjaemKlaaZblVECoi4AIx+VR7jEWcEBiMKOpFQ5aR+7MeaANJpxC
QuCY8Z3DtVe4kQRSXUalnBA9zz0qd3T7OqkbeMhWHWqkU/nFoWj2ISSxwQRg/Tmhgrk0dmmChuHd
WwQG5x7ZqaJJI4nDT7vmOCwx36VErP8AZxLtMcg+Yo2CR+RI6VXmu3d3CnClRkY6mhLohyfctExG
LZcRrlv7vNUXtFhwI5FKnoM81IgXzFEbEnHJLYpkxIKtH+8dT91+Mc1alKJk4xqEBGDg09JZI87G
Iz1xU0qtJAsxXJzyfaq1dCfMjjknFikknJ60lFFMgKKKKACp4d2w4mCDPQmoQpIyBQBmpla2ppTT
voJRRRVGYUUUEbgR60DSuFHSohZE5KSSAegahrVl+UyyA9etSpJluDWpcTcHC5xuweO9OePAAzlj
zgdqgibylA5YjoSanefzl3MgzjGR/WueceVnZTmpIpRypJkruCk8blK5/On2NxJNPOWACgmONSMc
AdfepCMjmiJyhYrjrwafNeNmNRUZNrqIz7yPLUKuMEnuaRRsdXIJGcE/5+lRSTS78hNwJOT0708z
zNGYhCpXOc7utQNl2aWGUKACOeuO1Nd5JFAJYxLwDjtVA3KJOsBJZyMkAfdHvVgt70DJ3l8yVAo+
VcACkRd1uxGcrzSRxMwL9tpwPXinQgqHy4X5cUAytZzC8mO1mYK2GYjGRV6TTrdFyPMbIwAGJNRZ
a2YKArZGVYD3/wDr1atZ32uZAcdjihX6g7dCnDaxiQLI2ABkAuRnFLLBAH86Ikhcg4bIDUsjbpGZ
wQuchafZwQyTTyAFWcYIBPPv7mgNCK4wSpggd06Myjp9asCECxPmMjSAZJQYB5OKr20ksLNCZVZW
Y43jGB/WqNxcavbTCKKG3Ksgy2enqPrxn8aEV5F+NQIGk27nU5A9vU0SBop1l29eduetU7ae/mYR
3MEdtG7FBluW4yMfXFX5pmZsMqt/dIHGaCWmh0V087kPHnCnGMcUyC586zNxFKjgsUDBx+PTvTYJ
Fjmy6knsB60joF37ZGO5y2zstA1axPbs4hkVwSG5Vh2qCcR71IUru6nFJLKGjVQDlRiomdnOWJJr
WFPZnNUq2vEEba4Oce9SNCvls4cMQccGoaK2cdbnOp6WZOsjJbOpH3j3qClJLHJOTSUJWFKVwooo
pkhRRRQAVbghjkj3M2DnpkVUopSjzKxcJ8ruFFFFMgKBwaUYyM9KdIqKQUbcp/MUDXcf9ocptG3A
54HSml/MPzDnHWiDaZQrZw3HFDr5UpAPQ4zU6J2NPekrvYj702aSWCINHD5u+RRgHoM8nH0qfCmL
JBBzwfX2qRImJBADgDlfSspyTOijBwdzNa21FYwPtcLMANx2cNnvjtQsd9g77iEcfeCf0+mf0rSa
MxgLIOSenpUTKjAqCR7msjYhhjnSMpOyM4Y8qOMVJGp2sQDgHn2p4UE4BJP0pz3kGnMFkK/vEGcn
HOf/AK9O+lhcqvckGnJJFvuNwU/wqSCfammaIQmFUAIPBHANR/2kLkviZE2/KEbqxpyxqYxJuU7e
WXviloPXZlmBWWLflDv7ntUYV5XbCEbxkAmgyQvA+xQuBgEv37Z/Gqtxc6pvwtqhAb5GDe1AEiM8
fAySDkjHQ+lPRy0vzEFc5wTxUNrfkXAEzRLM5wyFuRk+lXmXcX2qpkxxgUBZoJWiaNgzfvAMDA5N
V7KKSR5Q8qrgfuyq4ODnr60NE3m/vHVSRknNLFstScFmY557UAMddrCMYLA9fenT7kCxybcj+LPa
o5H8yTf0NLEVcvufB6DjOaAFWJJZo55QNsJyDj1BH8iaduNwiwplcHIZ+oqWCQwKzSAnPrVZDmVA
FH0JoC43zGtZGZQXYHGRzmpX/eF5QQo7gnr9KLqSN2Xy02kZzUGTWyp3szmdaycWOeTqsagIe5PO
KZRRWqVjnlJy3CiiimSFFFFABRRRQAUUUUAFFFFABRRRQAUpO5sn9BSUUDHEDPy5qUxhIA0mBk5z
nmlEZ+zGWPLMP4R1pm5p4S8hKKOdjLg+nP5VzSm9mdsaUbcy2ZE4EqNGCfKP61L9omD/ACvt4HGO
D9aVIWePeoyuccdqeyxBZ1jcs8bAMuMknFRfU1tpYgEjZwSQf505juOcAfSldvtKjbGVZfvZIpkZ
ZGUkhgDnnvQA7ccY/GhLfzrqQ3TxywhFZAyjIOckZ/75pJWLNuKqB1IU9aX5UjimMZiWQhdrsDzn
GPegavYf/ZNopEsMMewfvAD3PrUYweQAcjjIrRl/490BU+XwOeMdhVWKOMpu8yIKD6igQ64jkWBG
gl2JnLgLyT9e1Ltml+fftXqSWqKSQSnasobHbPX3qQzmOFV3HGMFSKLBcrRRIhl2xRsXJdyyjk8e
3oKuzFjFFIrbeMHnFQSzQWBVpXRNxCgt0yeg+tI99BNHIrSxIUPA8wc8enY80D1erHRtHG3IJJ6M
R/Ko33u5cqQGIxSxSb5F27HI55YYp0u5JldgWVsYHagRGDtVlKgk9z2p8EcYQ+Zu3EkriklAIUj5
VyTgNk1bgwbY7Gzt52t2oAqSSmRFVyTikAjjc5O9Svyk9RTHkLNkAL9KHleQAMentW6pvQ5XWWth
lFFFanMFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA+OV4m3I2DUzyCe6WdpGjwhjKjk
HJB5qtRUyimaQqyhsXIHWFnVkDr6gVC0n79xFkAjnHeo0coScZyMc0iht2VzkdhWUqdlc3hWvKw7
7nzhsdiKUg4zg49aEkVz+8GYz3x1NSyTRbFiCEFTw2eDWR0ERX5N2RjuKRbQX1uYJpWRNoGQBwM5
70+Tyio2Bge+adbTLCrgrlwPl9PrQNNp3RpMsUkPlSEFTwMnrWf5cQE0axrx8qrjnr1qLUPLv0Xe
jDy+QVYgj8vpVOPS4BGGErowxjL5JwO9UjOXR3LkOFceWgU9SQKydbW80mwjl09jKVx5iSgEEk5z
65+lbW4xxgAgju/c1GsgMuWXcpOcGrSvshQreyeutzEh1OG6tUOqyQySKgkKKp+Vm6f4UxZtKnZQ
zRoxlCpgnOScD9a6CUQvdcKgTAXIFIwj5wE2r0YLyTUuDH7aLbuZ1nqGnkRRWkibSDs2KecdfyrU
aO7mAZgDHsJznnqOP8+lQxNHEoKoNwPp2q1bkPjDmJuxA4IocXB3FGaqKxTVipyODUiTsrMTyWGK
kvY1jmGMcjJxVat1aSucbcoO1woooqiAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACi
iigAooooAKlgcJMpYcdDUVFDVxp2dx0wmEqxpETHu7nGPrUs1v5ajJBBHOD0qPzX37yct6mnrIrk
LKq445IFc8qbWp2QrRloFvGZHCt64PvTriJY7yQDhQF/rVQ2949xsS7twrE7TtyVHYdKbE98JJYr
1QSrnbIp4YcD1+tTGN3ZlzlaLkidmzwOF9KbRUQgA/jkx6buK6krbHC227sloqIQANnfIfYtxViJ
Q8qqehPNAra2Qyp3kja1VduJFPb0pk8XlTMnbt9KjpaPUesboKcsjqMBiBTaKYk7bCkljknJpKKK
BBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFICCMgiggMpB6Gov
s0XHB496Bk2aTI9RUf2eL+7+tKtvHvBC5bPFAaEi5aRUQjzDyATjgdaklDYQv97GD+ZouLGK5jjQ
ttZRuWRTyrH/AD0pHdikaMc7BjPrWSfNO6OqUVClvqMooorU5AqZNpUKPvn/ADioaZIjOuFcofUU
pK6sVGXK7ll9u0hyd46Y/lUNQGCQkf6Q/HsKcIpA+TMxGemBRFWVhyfM7ktFFFMgKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKciNIwVRkmga1JbdI5MhiS
fTpUZ/dSEqfu5INNB2AL/EOCB696RBkZPXNc/tHrc7HRWliXfnc5OewqNm3NnGKlyiIysuWP6VDV
0lpczxEtbBRRRWpzBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAF
FFFABRRRQAUUUUAFFFFABUiFVjJ/iJx1poRyu4KSM9cVJLGQwbAUEdzWdSVlY3owu7kS/eYkc/0p
6L85YZ4GePXt+uKVoHXMi4dQOdtKmdjEZ5Hb88/59a5zsIj1pKfIuGHTkZ4pldcdtDzp35ncKKKK
ZIUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA
BRRRQA+aWcWkccABJc5/LvUHmXYjKsqEAE4B74qePlsbtueM4plw8kDIrJ87OAc+nU/yrmqqzO6j
LmjbsLC0scLGTABOAqnjpUhlHZeccc8CmOwYJjsKbWkKfVmVWtraIEknJ60UUVqcwUUUUAFFFFAB
RRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFO
d2k++xP1ptFA7sKKKKBBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUU
UAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQ
AUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH/9k=