20250728
12532000
1.0
FALSE
CreateFeatureclass J:\mpw\PWAMasterData\Engineering.gdb\TrafficControl MidBlockCrossings_V3 Point # No Yes "PROJCS["NAD_1983_StatePlane_Kentucky_North_FIPS_1601_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1640416.666666667],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.25],PARAMETER["Standard_Parallel_1",37.96666666666667],PARAMETER["Standard_Parallel_2",38.96666666666667],PARAMETER["Latitude_Of_Origin",37.5],UNIT["Foot_US",0.3048006096012192]];-120428400 -95345400 3048.00609601219;-100000 10000;-100000 10000;3.28083333333333E-03;0.001;0.001;IsHighPrecision" # # # # #
UpdateSchema J:\mpw\PWAMasterData\Engineering.gdb\TrafficControl\MidBlockCrossings_V3 "<operationSequence><workflow><AddField><field_name>CID</field_name><field_type>Short</field_type><field_alias>Crossing ID</field_alias><field_is_nullable>TRUE</field_is_nullable></AddField></workflow><workflow><AddField><field_name>CROSSST</field_name><field_type>TEXT</field_type><field_alias>Cross Street</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>100</field_length></AddField></workflow><workflow><AddField><field_name>ATTRACT</field_name><field_type>TEXT</field_type><field_alias>Attraction</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>ATTRACTADD</field_name><field_type>TEXT</field_type><field_alias>Attraction Address</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>MILEPOINT</field_name><field_type>DOUBLE</field_type><field_alias>Milepoint</field_alias><field_is_nullable>TRUE</field_is_nullable></AddField></workflow><workflow><AddField><field_name>AADT</field_name><field_type>Long</field_type><field_alias>AADT</field_alias><field_is_nullable>TRUE</field_is_nullable></AddField></workflow><workflow><AddField><field_name>COUNDIST</field_name><field_type>Long</field_type><field_alias>Council District</field_alias><field_is_nullable>TRUE</field_is_nullable></AddField></workflow><workflow><AddField><field_name>COUNDIST1</field_name><field_type>Long</field_type><field_alias>Other Council District</field_alias><field_is_nullable>TRUE</field_is_nullable></AddField></workflow><workflow><AddField><field_name>RWCOMPKEY</field_name><field_type>Long</field_type><field_alias>RWCOMPKEY</field_alias><field_is_nullable>TRUE</field_is_nullable></AddField></workflow><workflow><AddField><field_name>ROADNAME</field_name><field_type>TEXT</field_type><field_alias>ROADNAME</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>40</field_length></AddField></workflow><workflow><AddField><field_name>DIR</field_name><field_type>TEXT</field_type><field_alias>DIR</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>2</field_length></AddField></workflow><workflow><AddField><field_name>STRNAME</field_name><field_type>TEXT</field_type><field_alias>STRNAME</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>30</field_length></AddField></workflow><workflow><AddField><field_name>TYPE</field_name><field_type>TEXT</field_type><field_alias>TYPE</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>LOCROSSPR</field_name><field_type>TEXT</field_type><field_alias>LOCROSSPR</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>2</field_length></AddField></workflow><workflow><AddField><field_name>LOCROSSNA</field_name><field_type>TEXT</field_type><field_alias>LOCROSSNA</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>30</field_length></AddField></workflow><workflow><AddField><field_name>LOCROSSSU</field_name><field_type>TEXT</field_type><field_alias>LOCROSSSU</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>HICROSSPR</field_name><field_type>TEXT</field_type><field_alias>HICROSSPR</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>2</field_length></AddField></workflow><workflow><AddField><field_name>HICROSSNA</field_name><field_type>TEXT</field_type><field_alias>HICROSSNA</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>30</field_length></AddField></workflow><workflow><AddField><field_name>HICROSSSU</field_name><field_type>TEXT</field_type><field_alias>HICROSSSU</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>MUNI_NAME</field_name><field_type>TEXT</field_type><field_alias>MUNI_NAME</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>30</field_length></AddField></workflow><workflow><AddField><field_name>MAIN_DIST</field_name><field_type>TEXT</field_type><field_alias>MAIN_DIST</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>OWNER_ABRV</field_name><field_type>TEXT</field_type><field_alias>OWNER_ABRV</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>MAIN_RESP</field_name><field_type>TEXT</field_type><field_alias>MAIN_RESP</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>14</field_length></AddField></workflow><workflow><AddField><field_name>CLASS_ABRV</field_name><field_type>TEXT</field_type><field_alias>CLASS_ABRV</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>6</field_length></AddField></workflow><workflow><AddField><field_name>ROUTE_LBL</field_name><field_type>TEXT</field_type><field_alias>ROUTE_LBL</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>15</field_length></AddField></workflow><workflow><AddField><field_name>FLD_ZONE</field_name><field_type>TEXT</field_type><field_alias>Flood Zone Type</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>17</field_length></AddField></workflow><workflow><AddField><field_name>ZONE_SUBTY</field_name><field_type>TEXT</field_type><field_alias>Flood Zone Subtype</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>72</field_length></AddField></workflow><workflow><AddField><field_name>EFF_DATE</field_name><field_type>TEXT</field_type><field_alias>DFIRM Effective Date</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>50</field_length></AddField></workflow><workflow><AddField><field_name>Track_Num</field_name><field_type>TEXT</field_type><field_alias>Tracking Grid Number</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>50</field_length></AddField></workflow><workflow><AddField><field_name>Id</field_name><field_type>Long</field_type><field_alias>Tracking Grid ID</field_alias><field_is_nullable>TRUE</field_is_nullable></AddField></workflow><workflow><AddField><field_name>SortOrder</field_name><field_type>Short</field_type><field_alias>Tracking Grid Sort Order</field_alias><field_is_nullable>TRUE</field_is_nullable></AddField></workflow><workflow><AddField><field_name>LOCATION</field_name><field_type>TEXT</field_type><field_alias>Asset Location</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>ONE_WAY</field_name><field_type>TEXT</field_type><field_alias>ONE_WAY</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>2</field_length></AddField></workflow><workflow><AddField><field_name>CROSSTYPE</field_name><field_type>TEXT</field_type><field_alias>CROSSING TYPE</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>25</field_length></AddField></workflow><workflow><AddField><field_name>STATUS</field_name><field_type>TEXT</field_type><field_alias>STATUS</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>25</field_length></AddField></workflow><workflow><AddField><field_name>AIDTYPE</field_name><field_type>TEXT</field_type><field_alias>AID TYPE</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>100</field_length></AddField></workflow><workflow><AddField><field_name>HVCROSS</field_name><field_type>TEXT</field_type><field_alias>HIGH VISIBILITY CROSSWALK</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>PEDREF</field_name><field_type>TEXT</field_type><field_alias>PEDESTRIAN REFUGE</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>CURBEXT</field_name><field_type>TEXT</field_type><field_alias>CURB EXTENSIONS</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>DELPOST</field_name><field_type>TEXT</field_type><field_alias>DELINEATOR POSTS</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>TARC</field_name><field_type>TEXT</field_type><field_alias>TARC ROUTE</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>GUARD</field_name><field_type>TEXT</field_type><field_alias>CROSSING GUARD</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>AADTSO</field_name><field_type>TEXT</field_type><field_alias>AADTSO</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>20</field_length></AddField></workflow><workflow><AddField><field_name>AADTYR</field_name><field_type>Short</field_type><field_alias>AADT</field_alias><field_is_nullable>TRUE</field_is_nullable></AddField></workflow><workflow><AddField><field_name>SPEED</field_name><field_type>Short</field_type><field_alias>SPEED</field_alias><field_is_nullable>TRUE</field_is_nullable><field_default_value>25</field_default_value></AddField></workflow></operationSequence>"
AssignDefaultToField J:\mpw\PWAMasterData\Engineering.gdb\TrafficControl\MidBlockCrossings_V3 SPEED 25 # DO_NOT_CLEAR
UpdateSchema J:\mpw\PWAMasterData\Engineering.gdb\TrafficControl\MidBlockCrossings_V3 <operationSequence><workflow><AlterField><field_name>OBJECTID</field_name><field_alias>OBJECTID</field_alias></AlterField></workflow><workflow><AlterField><field_name>SHAPE</field_name><field_alias>SHAPE</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.0.0'><FeatureDataset>TrafficControl</FeatureDataset><WorkspaceConnectionString>DATABASE=J:\mpw\PWAMasterData\Engineering.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MidBlockCrossings_V3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>MAIN_DIST</field_name><domain_name>Maintenance District</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>OWNER_ABRV</field_name><domain_name>Owner_Name</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>MAIN_RESP</field_name><domain_name>Main_Abrv</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>CLASS_ABRV</field_name><domain_name>Class_Abrv</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>ROUTE_LBL</field_name><domain_name>Routes_LBL</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>FLD_ZONE</field_name><domain_name>Flood Zone</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>LOCATION</field_name><domain_name>Asset Location</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>ONE_WAY</field_name><domain_name>One Way</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>CROSSTYPE</field_name><domain_name>Crossing Type Alphabetic</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>STATUS</field_name><domain_name>Crossing Status Alphabetic</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>AIDTYPE</field_name><domain_name>Warning Types Alphabetic</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>HVCROSS</field_name><domain_name>Yes No Alphabetic</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>PEDREF</field_name><domain_name>Yes No Alphabetic</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>CURBEXT</field_name><domain_name>Yes No Alphabetic</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>DELPOST</field_name><domain_name>Yes No Alphabetic</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>TARC</field_name><domain_name>Yes No Alphabetic</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>GUARD</field_name><domain_name>Crossing Guard Alphabetic</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>AADTSO</field_name><domain_name>AADT Source Alphabetic</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>SPEED</field_name><domain_name>Speed</domain_name></AssignDomainToField></workflow></operationSequence>"
Rename J:\mpw\PWAMasterData\Engineering.gdb\TrafficControl\MidBlockCrossings_V3 J:\mpw\PWAMasterData\Engineering.gdb\TrafficControl\MidBlockCrossings FeatureClass
ExportFeatures MidBlockCrossings_V3 "J:\mpw\GIS Projects\Transportation Planning\Transportation Planning.gdb\MidBlockCrossi_ExportFeature" # NOT_USE_ALIAS "ROADNAME "ROAD NAME" true true false 40 Text 0 0,First,#,MidBlockCrossings_V3,ROADNAME,0,40;CID "CROSSING ID" true true false 2 Short 0 0,First,#,MidBlockCrossings_V3,CID,-1,-1;CROSSTYPE "CROSSING TYPE" true true false 25 Text 0 0,First,#,MidBlockCrossings_V3,CROSSTYPE,0,25;CROSSST "CROSS STREET" true true false 100 Text 0 0,First,#,MidBlockCrossings_V3,CROSSST,0,100;ATTRACT "ATTRACTION" true true false 255 Text 0 0,First,#,MidBlockCrossings_V3,ATTRACT,0,255;ATTRACTADD "ATTRACTION ADDRESS" true true false 255 Text 0 0,First,#,MidBlockCrossings_V3,ATTRACTADD,0,255;STATUS "STATUS" true true false 25 Text 0 0,First,#,MidBlockCrossings_V3,STATUS,0,25;MILEPOINT "MILE POINT (State roads)" true true false 8 Double 0 0,First,#,MidBlockCrossings_V3,MILEPOINT,-1,-1;AIDTYPE "AID TYPE" true true false 100 Text 0 0,First,#,MidBlockCrossings_V3,AIDTYPE,0,100;HVCROSS "HIGH VISIBILITY CROSSWALK" true true false 10 Text 0 0,First,#,MidBlockCrossings_V3,HVCROSS,0,10;PEDREF "PEDESTRIAN REFUGE" true true false 10 Text 0 0,First,#,MidBlockCrossings_V3,PEDREF,0,10;CURBEXT "CURB EXTENSIONS" true true false 10 Text 0 0,First,#,MidBlockCrossings_V3,CURBEXT,0,10;DELPOST "DELINEATOR POSTS" true true false 10 Text 0 0,First,#,MidBlockCrossings_V3,DELPOST,0,10;TARC "TARC ROUTE" true true false 10 Text 0 0,First,#,MidBlockCrossings_V3,TARC,0,10;GUARD "CROSSING GUARD" true true false 10 Text 0 0,First,#,MidBlockCrossings_V3,GUARD,0,10;AADT "AADT" true true false 4 Long 0 0,First,#,MidBlockCrossings_V3,AADT,-1,-1;AADTSO "AADT SOURCE" true true false 20 Text 0 0,First,#,MidBlockCrossings_V3,AADTSO,0,20;AADTYR "AADT YEAR" true true false 2 Short 0 0,First,#,MidBlockCrossings_V3,AADTYR,-1,-1;COUNDIST "COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,MidBlockCrossings_V3,COUNDIST,-1,-1;COUNDIST1 "OTHER COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,MidBlockCrossings_V3,COUNDIST1,-1,-1;RWCOMPKEY "RWCOMPKEY" true true false 4 Long 0 0,First,#,MidBlockCrossings_V3,RWCOMPKEY,-1,-1;DIR "DIR" true true false 2 Text 0 0,First,#,MidBlockCrossings_V3,DIR,0,2;STRNAME "STRNAME" true true false 30 Text 0 0,First,#,MidBlockCrossings_V3,STRNAME,0,30;TYPE "TYPE" true true false 4 Text 0 0,First,#,MidBlockCrossings_V3,TYPE,0,4;SPEED "SPEED" true true false 2 Short 0 0,First,#,MidBlockCrossings_V3,SPEED,-1,-1;ONE_WAY "ONE WAY" true true false 2 Text 0 0,First,#,MidBlockCrossings_V3,ONE_WAY,0,2;MUNI_NAME "MUNICIPALITY" true true false 30 Text 0 0,First,#,MidBlockCrossings_V3,MUNI_NAME,0,30;MAIN_DIST "MAINTENANCE DISTRICT" true true false 10 Text 0 0,First,#,MidBlockCrossings_V3,MAIN_DIST,0,10;OWNER_ABRV "OWNER ABRV." true true false 4 Text 0 0,First,#,MidBlockCrossings_V3,OWNER_ABRV,0,4;MAIN_RESP "MAINTENANCE RESPONSIBILITY" true true false 14 Text 0 0,First,#,MidBlockCrossings_V3,MAIN_RESP,0,14;CLASS_ABRV "FUNCTIONAL CLASS ABRV." true true false 6 Text 0 0,First,#,MidBlockCrossings_V3,CLASS_ABRV,0,6;ROUTE_LBL "ROUTE LABEL" true true false 15 Text 0 0,First,#,MidBlockCrossings_V3,ROUTE_LBL,0,15;LOCROSSPR "LOCROSSPR" true true false 2 Text 0 0,First,#,MidBlockCrossings_V3,LOCROSSPR,0,2;LOCROSSNA "LOCROSSNA" true true false 30 Text 0 0,First,#,MidBlockCrossings_V3,LOCROSSNA,0,30;LOCROSSSU "LOCROSSSU" true true false 4 Text 0 0,First,#,MidBlockCrossings_V3,LOCROSSSU,0,4;HICROSSPR "HICROSSPR" true true false 2 Text 0 0,First,#,MidBlockCrossings_V3,HICROSSPR,0,2;HICROSSNA "HICROSSNA" true true false 30 Text 0 0,First,#,MidBlockCrossings_V3,HICROSSNA,0,30;HICROSSSU "HICROSSSU" true true false 4 Text 0 0,First,#,MidBlockCrossings_V3,HICROSSSU,0,4;FLD_ZONE "Flood Zone Type" true true false 17 Text 0 0,First,#,MidBlockCrossings_V3,FLD_ZONE,0,17;ZONE_SUBTY "Flood Zone Subtype" true true false 72 Text 0 0,First,#,MidBlockCrossings_V3,ZONE_SUBTY,0,72;EFF_DATE "DFIRM Effective Date" true true false 50 Text 0 0,First,#,MidBlockCrossings_V3,EFF_DATE,0,50;Track_Num "Tracking Grid Number" true true false 50 Text 0 0,First,#,MidBlockCrossings_V3,Track_Num,0,50;Id "Tracking Grid ID" true true false 4 Long 0 0,First,#,MidBlockCrossings_V3,Id,-1,-1;SortOrder "Tracking Grid Sort Order" true true false 2 Short 0 0,First,#,MidBlockCrossings_V3,SortOrder,-1,-1;LOCATION "Asset Location" true true false 10 Text 0 0,First,#,MidBlockCrossings_V3,LOCATION,0,10" #
ExportFeatures MidBlockCrossi_ExportFeature J:\mpw\PWAMasterData\Engineering.gdb\TrafficControl\MidBlockCrossings # NOT_USE_ALIAS "ROADNAME "ROAD NAME" true true false 40 Text 0 0,First,#,MidBlockCrossi_ExportFeature,ROADNAME,0,40;CID "CROSSING ID" true true false 2 Short 0 0,First,#,MidBlockCrossi_ExportFeature,CID,-1,-1;CROSSTYPE "CROSSING TYPE" true true false 25 Text 0 0,First,#,MidBlockCrossi_ExportFeature,CROSSTYPE,0,25;CROSSST "CROSS STREET" true true false 100 Text 0 0,First,#,MidBlockCrossi_ExportFeature,CROSSST,0,100;ATTRACT "ATTRACTION" true true false 255 Text 0 0,First,#,MidBlockCrossi_ExportFeature,ATTRACT,0,255;ATTRACTADD "ATTRACTION ADDRESS" true true false 255 Text 0 0,First,#,MidBlockCrossi_ExportFeature,ATTRACTADD,0,255;STATUS "STATUS" true true false 25 Text 0 0,First,#,MidBlockCrossi_ExportFeature,STATUS,0,25;MILEPOINT "MILE POINT (State roads)" true true false 8 Double 0 0,First,#,MidBlockCrossi_ExportFeature,MILEPOINT,-1,-1;AIDTYPE "AID TYPE" true true false 100 Text 0 0,First,#,MidBlockCrossi_ExportFeature,AIDTYPE,0,100;HVCROSS "HIGH VISIBILITY CROSSWALK" true true false 10 Text 0 0,First,#,MidBlockCrossi_ExportFeature,HVCROSS,0,10;PEDREF "PEDESTRIAN REFUGE" true true false 10 Text 0 0,First,#,MidBlockCrossi_ExportFeature,PEDREF,0,10;CURBEXT "CURB EXTENSIONS" true true false 10 Text 0 0,First,#,MidBlockCrossi_ExportFeature,CURBEXT,0,10;DELPOST "DELINEATOR POSTS" true true false 10 Text 0 0,First,#,MidBlockCrossi_ExportFeature,DELPOST,0,10;TARC "TARC ROUTE" true true false 10 Text 0 0,First,#,MidBlockCrossi_ExportFeature,TARC,0,10;GUARD "CROSSING GUARD" true true false 10 Text 0 0,First,#,MidBlockCrossi_ExportFeature,GUARD,0,10;AADT "AADT" true true false 4 Long 0 0,First,#,MidBlockCrossi_ExportFeature,AADT,-1,-1;AADTSO "AADT SOURCE" true true false 20 Text 0 0,First,#,MidBlockCrossi_ExportFeature,AADTSO,0,20;AADTYR "AADT YEAR" true true false 2 Short 0 0,First,#,MidBlockCrossi_ExportFeature,AADTYR,-1,-1;COUNDIST "COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,MidBlockCrossi_ExportFeature,COUNDIST,-1,-1;COUNDIST1 "OTHER COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,MidBlockCrossi_ExportFeature,COUNDIST1,-1,-1;RWCOMPKEY "RWCOMPKEY" true true false 4 Long 0 0,First,#,MidBlockCrossi_ExportFeature,RWCOMPKEY,-1,-1;DIR "DIR" true true false 2 Text 0 0,First,#,MidBlockCrossi_ExportFeature,DIR,0,2;STRNAME "STRNAME" true true false 30 Text 0 0,First,#,MidBlockCrossi_ExportFeature,STRNAME,0,30;TYPE "TYPE" true true false 4 Text 0 0,First,#,MidBlockCrossi_ExportFeature,TYPE,0,4;SPEED "SPEED" true true false 2 Short 0 0,First,#,MidBlockCrossi_ExportFeature,SPEED,-1,-1;ONE_WAY "ONE WAY" true true false 2 Text 0 0,First,#,MidBlockCrossi_ExportFeature,ONE_WAY,0,2;MUNI_NAME "MUNICIPALITY" true true false 30 Text 0 0,First,#,MidBlockCrossi_ExportFeature,MUNI_NAME,0,30;MAIN_DIST "MAINTENANCE DISTRICT" true true false 10 Text 0 0,First,#,MidBlockCrossi_ExportFeature,MAIN_DIST,0,10;OWNER_ABRV "OWNER ABRV." true true false 4 Text 0 0,First,#,MidBlockCrossi_ExportFeature,OWNER_ABRV,0,4;MAIN_RESP "MAINTENANCE RESPONSIBILITY" true true false 14 Text 0 0,First,#,MidBlockCrossi_ExportFeature,MAIN_RESP,0,14;CLASS_ABRV "FUNCTIONAL CLASS ABRV." true true false 6 Text 0 0,First,#,MidBlockCrossi_ExportFeature,CLASS_ABRV,0,6;ROUTE_LBL "ROUTE LABEL" true true false 15 Text 0 0,First,#,MidBlockCrossi_ExportFeature,ROUTE_LBL,0,15;LOCROSSPR "LOCROSSPR" true true false 2 Text 0 0,First,#,MidBlockCrossi_ExportFeature,LOCROSSPR,0,2;LOCROSSNA "LOCROSSNA" true true false 30 Text 0 0,First,#,MidBlockCrossi_ExportFeature,LOCROSSNA,0,30;LOCROSSSU "LOCROSSSU" true true false 4 Text 0 0,First,#,MidBlockCrossi_ExportFeature,LOCROSSSU,0,4;HICROSSPR "HICROSSPR" true true false 2 Text 0 0,First,#,MidBlockCrossi_ExportFeature,HICROSSPR,0,2;HICROSSNA "HICROSSNA" true true false 30 Text 0 0,First,#,MidBlockCrossi_ExportFeature,HICROSSNA,0,30;HICROSSSU "HICROSSSU" true true false 4 Text 0 0,First,#,MidBlockCrossi_ExportFeature,HICROSSSU,0,4;FLD_ZONE "Flood Zone Type" true true false 17 Text 0 0,First,#,MidBlockCrossi_ExportFeature,FLD_ZONE,0,17;ZONE_SUBTY "Flood Zone Subtype" true true false 72 Text 0 0,First,#,MidBlockCrossi_ExportFeature,ZONE_SUBTY,0,72;EFF_DATE "DFIRM Effective Date" true true false 50 Text 0 0,First,#,MidBlockCrossi_ExportFeature,EFF_DATE,0,50;Track_Num "Tracking Grid Number" true true false 50 Text 0 0,First,#,MidBlockCrossi_ExportFeature,Track_Num,0,50;Id "Tracking Grid ID" true true false 4 Long 0 0,First,#,MidBlockCrossi_ExportFeature,Id,-1,-1;SortOrder "Tracking Grid Sort Order" true true false 2 Short 0 0,First,#,MidBlockCrossi_ExportFeature,SortOrder,-1,-1;LOCATION "Asset Location" true true false 10 Text 0 0,First,#,MidBlockCrossi_ExportFeature,LOCATION,0,10" #
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>TrafficControl</FeatureDataset><WorkspaceConnectionString>DATABASE=J:\mpw\PWAMasterData\Engineering.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MidBlockCrossings</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DeleteDomain><domain_name>Fiscal Year_1</domain_name></DeleteDomain></workflow><workflow><AssignDomainToField><field_name>CROSSTYPE</field_name><domain_name>Crossing Type Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>STATUS</field_name><domain_name>Crossing Status Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>AIDTYPE</field_name><domain_name>Warning Types Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>HVCROSS</field_name><domain_name>Yes No Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>PEDREF</field_name><domain_name>Yes No Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>CURBEXT</field_name><domain_name>Yes No Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>DELPOST</field_name><domain_name>Yes No Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>TARC</field_name><domain_name>Yes No Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>GUARD</field_name><domain_name>Crossing Guard Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>AADTSO</field_name><domain_name>AADT Source Alpha</domain_name></AssignDomainToField></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>TrafficControl</FeatureDataset><WorkspaceConnectionString>DATABASE=J:\mpw\PWAMasterData\Engineering.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MidBlockCrossings</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DeleteDomain><domain_name>Fiscal Year_1</domain_name></DeleteDomain></workflow><workflow><AssignDomainToField><field_name>CROSSTYPE</field_name><domain_name>Crossing Type Alpha</domain_name></AssignDomainToField></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>TrafficControl</FeatureDataset><WorkspaceConnectionString>DATABASE=J:\mpw\PWAMasterData\Engineering.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MidBlockCrossings</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>STATUS</field_name><domain_name>Crossing Status Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>AIDTYPE</field_name><domain_name>Warning Types Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>HVCROSS</field_name><domain_name>Yes No Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>TARC</field_name><domain_name>Yes No Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>GUARD</field_name><domain_name>Crossing Guard Alpha</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>AADTSO</field_name><domain_name>AADT Source Alpha</domain_name></AssignDomainToField></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>TrafficControl</FeatureDataset><WorkspaceConnectionString>DATABASE=J:\mpw\PWAMasterData\Engineering.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MidBlockCrossings</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>STATUS</field_name><domain_name>Crossing Status Alpha</domain_name></AssignDomainToField></workflow><workflow><AddField><field_name>xxx</field_name><field_type>TEXT</field_type><field_length>25</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Crossing Status Alpha</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/3.0.0'><FeatureDataset>TrafficControl</FeatureDataset><WorkspaceConnectionString>DATABASE=J:\mpw\PWAMasterData\Engineering.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MidBlockCrossings</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>xxx</field_name></DeleteField></workflow></operationSequence>
AddXY MidBlockCrossings_NEW
DeleteField MidBlockCrossings_NEW POINT_Z "Delete Fields"
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>TrafficControl</FeatureDataset><WorkspaceConnectionString>DATABASE=J:\mpw\PWAMasterData\Engineering.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MidblockCrossings</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>PEDREF</field_name><domain_name>Crossing Guard Alpha</domain_name></AssignDomainToField></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>TrafficControl</FeatureDataset><WorkspaceConnectionString>DATABASE=J:\mpw\PWAMasterData\Engineering.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MidblockCrossings</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>FLD_ZONE</field_name><field_name>ZONE_SUBTY</field_name><field_name>EFF_DATE</field_name><field_name>Track_Num</field_name><field_name>Id</field_name><field_name>SortOrder</field_name><field_name>LOCATION</field_name></DeleteField></workflow></operationSequence>
CalculateGeometryAttributes "Midblock Crossings" "POINT_X POINT_X" # # # "Decimal Degrees"
CalculateGeometryAttributes "Midblock Crossings" "POINT_Y POINT_Y" # # # "Decimal Degrees"
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.2.0'><FeatureDataset>TrafficControl</FeatureDataset><WorkspaceConnectionString>DATABASE=J:\mpw\PWAMasterData\Engineering.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MidblockCrossings</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>LOCROSSPR</field_name><field_name>LOCROSSNA</field_name><field_name>LOCROSSSU</field_name><field_name>HICROSSPR</field_name><field_name>HICROSSNA</field_name><field_name>HICROSSSU</field_name></DeleteField></workflow></operationSequence>
CalculateGeometryAttributes "Midblock Crossings" "POINT_X POINT_X" # # GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] "Same as input"
CalculateGeometryAttributes "Midblock Crossings" "POINT_Y POINT_Y" # # GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] "Same as input"
ExportFeatures "Midblock Crossings" J:\Common\LMPW.gdb\MidblockCrossings # NOT_USE_ALIAS "ROADNAME "ROAD NAME" true true false 40 Text 0 0,First,#,Midblock Crossings,ROADNAME,0,39;CID "CROSSING ID" true true false 2 Short 0 0,First,#,Midblock Crossings,CID,-1,-1;CROSSTYPE "CROSSING TYPE" true true false 25 Text 0 0,First,#,Midblock Crossings,CROSSTYPE,0,24;CROSSST "CROSS STREET" true true false 100 Text 0 0,First,#,Midblock Crossings,CROSSST,0,99;ATTRACT "ATTRACTION" true true false 255 Text 0 0,First,#,Midblock Crossings,ATTRACT,0,254;ATTRACTADD "ATTRACTION ADDRESS" true true false 255 Text 0 0,First,#,Midblock Crossings,ATTRACTADD,0,254;STATUS "STATUS" true true false 25 Text 0 0,First,#,Midblock Crossings,STATUS,0,24;MILEPOINT "MILE POINT (State roads)" true true false 8 Double 0 0,First,#,Midblock Crossings,MILEPOINT,-1,-1;AIDTYPE "AID TYPE" true true false 100 Text 0 0,First,#,Midblock Crossings,AIDTYPE,0,99;HVCROSS "HIGH VISIBILITY CROSSWALK" true true false 10 Text 0 0,First,#,Midblock Crossings,HVCROSS,0,9;PEDREF "PEDESTRIAN REFUGE" true true false 10 Text 0 0,First,#,Midblock Crossings,PEDREF,0,9;CURBEXT "CURB EXTENSIONS" true true false 10 Text 0 0,First,#,Midblock Crossings,CURBEXT,0,9;DELPOST "DELINEATOR POSTS" true true false 10 Text 0 0,First,#,Midblock Crossings,DELPOST,0,9;TARC "TARC ROUTE" true true false 10 Text 0 0,First,#,Midblock Crossings,TARC,0,9;GUARD "CROSSING GUARD" true true false 10 Text 0 0,First,#,Midblock Crossings,GUARD,0,9;AADT "AADT" true true false 4 Long 0 0,First,#,Midblock Crossings,AADT,-1,-1;AADTSO "AADT SOURCE" true true false 20 Text 0 0,First,#,Midblock Crossings,AADTSO,0,19;AADTYR "AADT YEAR" true true false 2 Short 0 0,First,#,Midblock Crossings,AADTYR,-1,-1;COUNDIST "COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,Midblock Crossings,COUNDIST,-1,-1;COUNDIST1 "OTHER COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,Midblock Crossings,COUNDIST1,-1,-1;RWCOMPKEY "RWCOMPKEY" true true false 4 Long 0 0,First,#,Midblock Crossings,RWCOMPKEY,-1,-1;DIR "DIR" true true false 2 Text 0 0,First,#,Midblock Crossings,DIR,0,1;STRNAME "STRNAME" true true false 30 Text 0 0,First,#,Midblock Crossings,STRNAME,0,29;TYPE "TYPE" true true false 4 Text 0 0,First,#,Midblock Crossings,TYPE,0,3;SPEED "SPEED" true true false 2 Short 0 0,First,#,Midblock Crossings,SPEED,-1,-1;ONE_WAY "ONE WAY" true true false 2 Text 0 0,First,#,Midblock Crossings,ONE_WAY,0,1;MUNI_NAME "MUNICIPALITY" true true false 30 Text 0 0,First,#,Midblock Crossings,MUNI_NAME,0,29;MAIN_DIST "MAINTENANCE DISTRICT" true true false 10 Text 0 0,First,#,Midblock Crossings,MAIN_DIST,0,9;OWNER_ABRV "OWNER ABRV." true true false 4 Text 0 0,First,#,Midblock Crossings,OWNER_ABRV,0,3;MAIN_RESP "MAINTENANCE RESPONSIBILITY" true true false 14 Text 0 0,First,#,Midblock Crossings,MAIN_RESP,0,13;CLASS_ABRV "FUNCTIONAL CLASS ABRV." true true false 6 Text 0 0,First,#,Midblock Crossings,CLASS_ABRV,0,5;ROUTE_LBL "ROUTE LABEL" true true false 15 Text 0 0,First,#,Midblock Crossings,ROUTE_LBL,0,14;POINT_X "POINT_X" true true false 8 Double 0 0,First,#,Midblock Crossings,POINT_X,-1,-1;POINT_Y "POINT_Y" true true false 8 Double 0 0,First,#,Midblock Crossings,POINT_Y,-1,-1" "ATTRACT ASCENDING"
FeatureClassToFeatureClass J:\Common\LMPW.gdb\MidblockCrossings "H:\Administrative Tools\tools\dataUtilities\runtime\updateExistingData\runtime.gdb" MidblockCrossings_runtime # "ROADNAME "ROAD NAME" true true false 40 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,ROADNAME,0,40;CID "CROSSING ID" true true false 2 Short 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,CID,-1,-1;CROSSTYPE "CROSSING TYPE" true true false 25 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,CROSSTYPE,0,25;CROSSST "CROSS STREET" true true false 100 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,CROSSST,0,100;ATTRACT "ATTRACTION" true true false 255 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,ATTRACT,0,255;ATTRACTADD "ATTRACTION ADDRESS" true true false 255 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,ATTRACTADD,0,255;STATUS "STATUS" true true false 25 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,STATUS,0,25;MILEPOINT "MILE POINT (State roads)" true true false 8 Double 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,MILEPOINT,-1,-1;AIDTYPE "AID TYPE" true true false 100 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,AIDTYPE,0,100;HVCROSS "HIGH VISIBILITY CROSSWALK" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,HVCROSS,0,10;PEDREF "PEDESTRIAN REFUGE" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,PEDREF,0,10;CURBEXT "CURB EXTENSIONS" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,CURBEXT,0,10;DELPOST "DELINEATOR POSTS" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,DELPOST,0,10;TARC "TARC ROUTE" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,TARC,0,10;GUARD "CROSSING GUARD" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,GUARD,0,10;AADT "AADT" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,AADT,-1,-1;AADTSO "AADT SOURCE" true true false 20 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,AADTSO,0,20;AADTYR "AADT YEAR" true true false 2 Short 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,AADTYR,-1,-1;COUNDIST "COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,COUNDIST,-1,-1;COUNDIST1 "OTHER COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,COUNDIST1,-1,-1;RWCOMPKEY "RWCOMPKEY" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,RWCOMPKEY,-1,-1;DIR "DIR" true true false 2 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,DIR,0,2;STRNAME "STRNAME" true true false 30 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,STRNAME,0,30;TYPE "TYPE" true true false 4 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,TYPE,0,4;SPEED "SPEED" true true false 2 Short 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,SPEED,-1,-1;ONE_WAY "ONE WAY" true true false 2 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,ONE_WAY,0,2;MUNI_NAME "MUNICIPALITY" true true false 30 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,MUNI_NAME,0,30;MAIN_DIST "MAINTENANCE DISTRICT" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,MAIN_DIST,0,10;OWNER_ABRV "OWNER ABRV." true true false 4 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,OWNER_ABRV,0,4;MAIN_RESP "MAINTENANCE RESPONSIBILITY" true true false 14 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,MAIN_RESP,0,14;CLASS_ABRV "FUNCTIONAL CLASS ABRV." true true false 6 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,CLASS_ABRV,0,6;ROUTE_LBL "ROUTE LABEL" true true false 15 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,ROUTE_LBL,0,15;POINT_X "POINT_X" true true false 8 Double 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,POINT_X,-1,-1;POINT_Y "POINT_Y" true true false 8 Double 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,POINT_Y,-1,-1" #
Rename C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidblockCrossings_L C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidblockCrossings FeatureClass
ChangePrivileges C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidblockCrossings LOJIC_ROLE "Grant view privileges" "Do not change edit privileges"
ChangePrivileges C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidblockCrossings SDE "Grant view privileges" "Do not change edit privileges"
ExportFeatures "C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings" J:\Common\LMPW.gdb\MidblockCrossings # NOT_USE_ALIAS "ROADNAME "ROAD NAME" true true false 40 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,ROADNAME,0,39;CID "CROSSING ID" true true false 2 Short 0 5,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,CID,-1,-1;CROSSTYPE "CROSSING TYPE" true true false 25 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,CROSSTYPE,0,24;CROSSST "CROSS STREET" true true false 100 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,CROSSST,0,99;ATTRACT "ATTRACTION" true true false 255 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,ATTRACT,0,254;ATTRACTADD "ATTRACTION ADDRESS" true true false 255 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,ATTRACTADD,0,254;STATUS "STATUS" true true false 25 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,STATUS,0,24;MILEPOINT "MILE POINT (State roads)" true true false 8 Double 8 38,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,MILEPOINT,-1,-1;AIDTYPE "AID TYPE" true true false 100 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,AIDTYPE,0,99;HVCROSS "HIGH VISIBILITY CROSSWALK" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,HVCROSS,0,9;PEDREF "PEDESTRIAN REFUGE" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,PEDREF,0,9;CURBEXT "CURB EXTENSIONS" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,CURBEXT,0,9;DELPOST "DELINEATOR POSTS" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,DELPOST,0,9;TARC "TARC ROUTE" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,TARC,0,9;GUARD "CROSSING GUARD" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,GUARD,0,9;AADT "AADT" true true false 4 Long 0 10,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,AADT,-1,-1;AADTSO "AADT SOURCE" true true false 20 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,AADTSO,0,19;AADTYR "AADT YEAR" true true false 2 Short 0 5,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,AADTYR,-1,-1;COUNDIST "COUNCIL DISTRICT" true true false 4 Long 0 10,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,COUNDIST,-1,-1;COUNDIST1 "OTHER COUNCIL DISTRICT" true true false 4 Long 0 10,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,COUNDIST1,-1,-1;RWCOMPKEY "RWCOMPKEY" true true false 4 Long 0 10,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,RWCOMPKEY,-1,-1;DIR "DIR" true true false 2 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,DIR,0,1;STRNAME "STRNAME" true true false 30 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,STRNAME,0,29;TYPE "TYPE" true true false 4 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,TYPE,0,3;SPEED "SPEED" true true false 2 Short 0 5,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,SPEED,-1,-1;ONE_WAY "ONE WAY" true true false 2 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,ONE_WAY,0,1;MUNI_NAME "MUNICIPALITY" true true false 30 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,MUNI_NAME,0,29;MAIN_DIST "MAINTENANCE DISTRICT" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,MAIN_DIST,0,9;OWNER_ABRV "OWNER ABRV." true true false 4 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,OWNER_ABRV,0,3;MAIN_RESP "MAINTENANCE RESPONSIBILITY" true true false 14 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,MAIN_RESP,0,13;CLASS_ABRV "FUNCTIONAL CLASS ABRV." true true false 6 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,CLASS_ABRV,0,5;ROUTE_LBL "ROUTE LABEL" true true false 15 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,ROUTE_LBL,0,14;POINT_X "POINT_X" true true false 8 Double 8 38,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,POINT_X,-1,-1;POINT_Y "POINT_Y" true true false 8 Double 8 38,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep (5).sde\JEFLIB.MidblockCrossings,POINT_Y,-1,-1" #
FeatureClassToFeatureClass J:\Common\LMPW.gdb\MidblockCrossings C:\ScheduledTasks\maintenanceUtilities\data\runtime\updateExistingData4Catalog\runtime.gdb MidblockCrossings_runtime # "ROADNAME "ROAD NAME" true true false 40 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,ROADNAME,0,39;CID "CROSSING ID" true true false 2 Short 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,CID,-1,-1;CROSSTYPE "CROSSING TYPE" true true false 25 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,CROSSTYPE,0,24;CROSSST "CROSS STREET" true true false 100 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,CROSSST,0,99;ATTRACT "ATTRACTION" true true false 255 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,ATTRACT,0,254;ATTRACTADD "ATTRACTION ADDRESS" true true false 255 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,ATTRACTADD,0,254;STATUS "STATUS" true true false 25 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,STATUS,0,24;MILEPOINT "MILE POINT (State roads)" true true false 8 Double 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,MILEPOINT,-1,-1;AIDTYPE "AID TYPE" true true false 100 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,AIDTYPE,0,99;HVCROSS "HIGH VISIBILITY CROSSWALK" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,HVCROSS,0,9;PEDREF "PEDESTRIAN REFUGE" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,PEDREF,0,9;CURBEXT "CURB EXTENSIONS" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,CURBEXT,0,9;DELPOST "DELINEATOR POSTS" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,DELPOST,0,9;TARC "TARC ROUTE" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,TARC,0,9;GUARD "CROSSING GUARD" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,GUARD,0,9;AADT "AADT" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,AADT,-1,-1;AADTSO "AADT SOURCE" true true false 20 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,AADTSO,0,19;AADTYR "AADT YEAR" true true false 2 Short 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,AADTYR,-1,-1;COUNDIST "COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,COUNDIST,-1,-1;COUNDIST1 "OTHER COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,COUNDIST1,-1,-1;RWCOMPKEY "RWCOMPKEY" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,RWCOMPKEY,-1,-1;DIR "DIR" true true false 2 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,DIR,0,1;STRNAME "STRNAME" true true false 30 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,STRNAME,0,29;TYPE "TYPE" true true false 4 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,TYPE,0,3;SPEED "SPEED" true true false 2 Short 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,SPEED,-1,-1;ONE_WAY "ONE WAY" true true false 2 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,ONE_WAY,0,1;MUNI_NAME "MUNICIPALITY" true true false 30 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,MUNI_NAME,0,29;MAIN_DIST "MAINTENANCE DISTRICT" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,MAIN_DIST,0,9;OWNER_ABRV "OWNER ABRV." true true false 4 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,OWNER_ABRV,0,3;MAIN_RESP "MAINTENANCE RESPONSIBILITY" true true false 14 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,MAIN_RESP,0,13;CLASS_ABRV "FUNCTIONAL CLASS ABRV." true true false 6 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,CLASS_ABRV,0,5;ROUTE_LBL "ROUTE LABEL" true true false 15 Text 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,ROUTE_LBL,0,14;POINT_X "POINT_X" true true false 8 Double 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,POINT_X,-1,-1;POINT_Y "POINT_Y" true true false 8 Double 0 0,First,#,J:\Common\LMPW.gdb\MidblockCrossings,POINT_Y,-1,-1" #
Rename C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidBlockCrossings_L C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidBlockCrossings FeatureClass
ChangePrivileges C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidBlockCrossings LOJIC_ROLE "Grant view privileges" "Do not change edit privileges"
ChangePrivileges C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidBlockCrossings SDE "Grant view privileges" "Do not change edit privileges"
ExportFeatures C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings J:\Common\LMPW.gdb\MidBlockCrossings # NOT_USE_ALIAS "ROADNAME "ROAD NAME" true true false 40 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,ROADNAME,0,39;CID "CROSSING ID" true true false 2 Short 0 5,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,CID,-1,-1;CROSSTYPE "CROSSING TYPE" true true false 25 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,CROSSTYPE,0,24;CROSSST "CROSS STREET" true true false 100 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,CROSSST,0,99;ATTRACT "ATTRACTION" true true false 255 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,ATTRACT,0,254;ATTRACTADD "ATTRACTION ADDRESS" true true false 255 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,ATTRACTADD,0,254;STATUS "STATUS" true true false 25 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,STATUS,0,24;MILEPOINT "MILE POINT (State roads)" true true false 8 Double 8 38,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,MILEPOINT,-1,-1;AIDTYPE "AID TYPE" true true false 100 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,AIDTYPE,0,99;HVCROSS "HIGH VISIBILITY CROSSWALK" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,HVCROSS,0,9;PEDREF "PEDESTRIAN REFUGE" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,PEDREF,0,9;CURBEXT "CURB EXTENSIONS" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,CURBEXT,0,9;DELPOST "DELINEATOR POSTS" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,DELPOST,0,9;TARC "TARC ROUTE" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,TARC,0,9;GUARD "CROSSING GUARD" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,GUARD,0,9;AADT "AADT" true true false 4 Long 0 10,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,AADT,-1,-1;AADTSO "AADT SOURCE" true true false 20 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,AADTSO,0,19;AADTYR "AADT YEAR" true true false 2 Short 0 5,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,AADTYR,-1,-1;COUNDIST "COUNCIL DISTRICT" true true false 4 Long 0 10,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,COUNDIST,-1,-1;COUNDIST1 "OTHER COUNCIL DISTRICT" true true false 4 Long 0 10,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,COUNDIST1,-1,-1;RWCOMPKEY "RWCOMPKEY" true true false 4 Long 0 10,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,RWCOMPKEY,-1,-1;DIR "DIR" true true false 2 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,DIR,0,1;STRNAME "STRNAME" true true false 30 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,STRNAME,0,29;TYPE "TYPE" true true false 4 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,TYPE,0,3;SPEED "SPEED" true true false 2 Short 0 5,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,SPEED,-1,-1;ONE_WAY "ONE WAY" true true false 2 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,ONE_WAY,0,1;MUNI_NAME "MUNICIPALITY" true true false 30 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,MUNI_NAME,0,29;MAIN_DIST "MAINTENANCE DISTRICT" true true false 10 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,MAIN_DIST,0,9;OWNER_ABRV "OWNER ABRV." true true false 4 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,OWNER_ABRV,0,3;MAIN_RESP "MAINTENANCE RESPONSIBILITY" true true false 14 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,MAIN_RESP,0,13;CLASS_ABRV "FUNCTIONAL CLASS ABRV." true true false 6 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,CLASS_ABRV,0,5;ROUTE_LBL "ROUTE LABEL" true true false 15 Text 0 0,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,ROUTE_LBL,0,14;POINT_X "POINT_X" true true false 8 Double 8 38,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,POINT_X,-1,-1;POINT_Y "POINT_Y" true true false 8 Double 8 38,First,#,C:\Users\sstepro\AppData\Roaming\Esri\ArcGISPro\Favorites\gisprep.sde\JEFLIB.MidBlockCrossings,POINT_Y,-1,-1" #
FeatureClassToFeatureClass J:\Common\LMPW.gdb\MidBlockCrossings C:\ScheduledTasks\maintenanceUtilities\data\runtime\updateExistingData4Catalog\runtime.gdb MidBlockCrossings_runtime # "ROADNAME "ROAD NAME" true true false 40 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,ROADNAME,0,39;CID "CROSSING ID" true true false 2 Short 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,CID,-1,-1;CROSSTYPE "CROSSING TYPE" true true false 25 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,CROSSTYPE,0,24;CROSSST "CROSS STREET" true true false 100 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,CROSSST,0,99;ATTRACT "ATTRACTION" true true false 255 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,ATTRACT,0,254;ATTRACTADD "ATTRACTION ADDRESS" true true false 255 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,ATTRACTADD,0,254;STATUS "STATUS" true true false 25 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,STATUS,0,24;MILEPOINT "MILE POINT (State roads)" true true false 8 Double 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,MILEPOINT,-1,-1;AIDTYPE "AID TYPE" true true false 100 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,AIDTYPE,0,99;HVCROSS "HIGH VISIBILITY CROSSWALK" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,HVCROSS,0,9;PEDREF "PEDESTRIAN REFUGE" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,PEDREF,0,9;CURBEXT "CURB EXTENSIONS" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,CURBEXT,0,9;DELPOST "DELINEATOR POSTS" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,DELPOST,0,9;TARC "TARC ROUTE" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,TARC,0,9;GUARD "CROSSING GUARD" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,GUARD,0,9;AADT "AADT" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,AADT,-1,-1;AADTSO "AADT SOURCE" true true false 20 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,AADTSO,0,19;AADTYR "AADT YEAR" true true false 2 Short 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,AADTYR,-1,-1;COUNDIST "COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,COUNDIST,-1,-1;COUNDIST1 "OTHER COUNCIL DISTRICT" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,COUNDIST1,-1,-1;RWCOMPKEY "RWCOMPKEY" true true false 4 Long 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,RWCOMPKEY,-1,-1;DIR "DIR" true true false 2 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,DIR,0,1;STRNAME "STRNAME" true true false 30 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,STRNAME,0,29;TYPE "TYPE" true true false 4 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,TYPE,0,3;SPEED "SPEED" true true false 2 Short 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,SPEED,-1,-1;ONE_WAY "ONE WAY" true true false 2 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,ONE_WAY,0,1;MUNI_NAME "MUNICIPALITY" true true false 30 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,MUNI_NAME,0,29;MAIN_DIST "MAINTENANCE DISTRICT" true true false 10 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,MAIN_DIST,0,9;OWNER_ABRV "OWNER ABRV." true true false 4 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,OWNER_ABRV,0,3;MAIN_RESP "MAINTENANCE RESPONSIBILITY" true true false 14 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,MAIN_RESP,0,13;CLASS_ABRV "FUNCTIONAL CLASS ABRV." true true false 6 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,CLASS_ABRV,0,5;ROUTE_LBL "ROUTE LABEL" true true false 15 Text 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,ROUTE_LBL,0,14;POINT_X "POINT_X" true true false 8 Double 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,POINT_X,-1,-1;POINT_Y "POINT_Y" true true false 8 Double 0 0,First,#,J:\Common\LMPW.gdb\MidBlockCrossings,POINT_Y,-1,-1" #
Rename C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidBlockCrossings_L C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidBlockCrossings FeatureClass
ChangePrivileges C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidBlockCrossings LOJIC_ROLE "Grant view privileges" "Do not change edit privileges"
ChangePrivileges C:\egdbConnections\production\1373\presentation\JEFLIB@preprdmaint.sde\JEFLIB.MidBlockCrossings SDE "Grant view privileges" "Do not change edit privileges"
JEFLIB.MidBlockCrossings_L
Server=gisprep; Service=sde:oracle$gisprep; User=jeflib; Version=SDE.DEFAULT
ArcSDE Connection
1161892.995000
1290249.510000
206857.095000
310764.750000
1
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Kentucky_North_FIPS_1601_Feet
<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.2.0'><WKT>PROJCS["NAD_1983_StatePlane_Kentucky_North_FIPS_1601_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1640416.666666667],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.25],PARAMETER["Standard_Parallel_1",37.96666666666667],PARAMETER["Standard_Parallel_2",38.96666666666667],PARAMETER["Latitude_Of_Origin",37.5],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2246]]</WKT><XOrigin>-120428400</XOrigin><YOrigin>-95345400</YOrigin><XYScale>800</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0025000000000000001</XYTolerance><ZTolerance>2</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>102679</WKID><LatestWKID>2246</LatestWKID></ProjectedCoordinateSystem>
20260520
14513500
20260520
14513500
NAP
LOJIC Metadata
JEFLIB.MidBlockCrossings_L
Feature Class
379
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.
CID
CROSSING ID
SmallInteger
2
5
0
Crossing feature identification number.
LMPW
CrossType
CROSSING TYPE
String
25
0
0
Crossing Type.
LMPW
1
BIKE/PED
LMPW
2
CART
LMPW
3
PEDESTRIAN
LMPW
4
SCHOOL
LMPW
CrossSt
CROSS STREET
String
100
0
0
LMPW
AttractAdd
ATTRACTION ADDRESS
String
255
0
0
Street direction, name, type and suffix direction of Attraction.
LMPW
ATTRACT
ATTRACTION
String
255
0
0
Status
STATUS
String
25
0
0
Current maintenance status of feature.
LMPW
1
EXISTING
LMPW
2
CONVERTED
LMPW
3
REMOVED
LMPW
4
FUTURE
LMPW
Milepoint
MILE POINT (State roads)
Double
8
38
8
State maintained route mileage at feature's location.
KYTC
AidType
AID TYPE
String
100
0
0
Crossing aid type for feature.
LMPW
1
ADVANCE FLASHING SIGNAGE, FLASHING OVERHEAD LIGHT
LMPW
2
ADVANCE SIGNAGE
LMPW
3
FLASHING OVERHEAD LIGHT
LMPW
4
LMPW
FLASHING OVERHEAD LIGHT
5
HAWK
LMPW
6
ILLUMINATED SIGNAGE
LMPW
7
SCHOOL ZONE WARNING SYSTEM
LMPW
8
RUMBLE STRIPS
LMPW
9
RRFB - POLE MOUNTED
LMPW
10
RRFB - OVERHEAD
LMPW
11
OVERHEAD SIGN
LMPW
12
SPEED HUMPS
LMPW
99
NONE
LMPW
HVCross
HIGH VISIBILITY CROSSWALK
String
10
0
0
Feature has a high visibility crosswalk (Yes/No).
LMPW
1
YES
LMPW
2
NO
LMPW
3
UNKNOWN
LMPW
CurbExt
CURB EXTENSIONS
String
10
0
0
Feature has curb extensions (Yes/No).
LMPW
1
YES
LMPW
2
NO
LMPW
3
UNKNOWN
LMPW
PEDREF
PEDESTRIAN REFUGE
String
10
0
0
DelPost
DELINEATOR POSTS
String
10
0
0
Feature has Delineator Posts (Yes/No).
LMPW
1
YES
LMPW
2
NO
LMPW
3
UNKNOWN
LMPW
TARC
TARC ROUTE
String
10
0
0
Crossing on TARC route (Yes\No)
LMPW
1
YES
LMPW
2
NO
LMPW
3
UNKNOWN
LMPW
Guard
CROSSING GUARD
String
10
0
0
Feature has a crossing guard (Yes/No/or Not Applicable).
LMPW
1
YES
LMPW
2
NO
LMPW
3
UNKNOWN
LMPW
AADT
AADT
Integer
4
10
0
Annual average daily traffic (AADT) at location.
LMPW
AADTYR
AADT YEAR
SmallInteger
2
5
0
Annual Average Daily Traffic (AADT) Collection Date (YYYY) at location.
LMPW
AADTSO
AADT SOURCE
String
20
0
0
Ownership of AADT and AADTYR measurements.
LMPW
1
YES
LMPW
2
NO
LMPW
3
NOT APPLICABLE
LMPW
RWCOMPKEY
RWCOMPKEY
Integer
4
10
0
ROUTE_LBL
ROUTE LABEL
String
15
0
0
ROADNAME
ROAD NAME
String
40
0
0
DIR
DIR
String
2
0
0
STRNAME
STRNAME
String
30
0
0
TYPE
TYPE
String
4
0
0
MUNI_NAME
MUNICIPALITY
String
30
0
0
COUNDIST
COUNCIL DISTRICT
Integer
4
10
0
MAIN_DIST
MAINTENANCE DISTRICT
String
10
0
0
Maintenance District
LMPW
SPEED
SPEED
SmallInteger
2
5
0
OWNER_ABRV
OWNER ABRV.
String
4
0
0
MAIN_RESP
MAINTENANCE RESPONSIBILITY
String
14
0
0
CLASS_ABRV
FUNCTIONAL CLASS ABRV.
String
6
0
0
COUNDIST1
OTHER COUNCIL DISTRICT
Integer
4
10
0
ONE_WAY
ONE WAY
String
2
0
0
POINT_X
POINT_X
Double
8
38
8
POINT_Y
POINT_Y
Double
8
38
8
dataset
Scott Stepro, GISP
Louisville Metro Public Works
GIS Supervisor
(502)574-3871
444 S 5th St.
Louisville
Kentucky
40202
US
scott.stepro@louisvilleky.gov
8am - 4pm
Please call or email for further information.
20260512
ArcGIS Metadata
1.0
File Geodatabase Feature Class
GIS Support
LOJIC
Customer Support Administrator
(502)540-6400
700 W. Liberty St.
Louisville
Kentucky
40203
US
gis@lojic.org
8am - 4pm
Please call or email for further information.
Jefferson County KY Midblock Crossings HP2
2023-02-17
2023-02-17
2026-05-12
Scott Stepro, GISP
Louisville Metro Public Works
GIS Supervisor
(502)574-3871
444 S 5th St
Louisville
Kentucky
40202
US
scott.stepro@louisvilleky.gov
8am - 4pm
Please call or email for further information.
Midblock crossings offer pedestrians and bicyclists approved locations to legally cross a street other than a fully controlled intersection, such as an all-way stop or traffic signal. This list can be used by the public, researchers, and roadway owners, such as Louisville Metro Government or the state, to prioritize safety improvements at existing midblock crossing locations and help standardize criteria for considering requests for new crossings or evaluate existing locations.
Contains all midblock crossing locations within Jefferson County, KY. Road assets and data are maintained by Louisville Metro Public Works.
LMPW
GIS Support
LOJIC
Customer Support Administrator
(502) 540-6400
700 W Liberty St.
Louisville
Kentucky
40202
US
gis@lojic.org
8am - 4pm
Please call or email for further information.
Louisville, Kentucky, KY
Louisville, Louisville Metro, Louisville Metro Public Works
Louisville
Kentucky
KY
Louisville
Louisville Metro
Louisville Metro Public Works
LIMITATION OF LIABILITY: MSD and the participants of the Louisville/Jefferson County Information Consortium (LOJIC) have no indication or reason to believe that there are any inaccuracies or defects of information incorporated in this work and make NO REPRESENTATIONS OF ANY KIND, INCLUDING, BUT NOT LIMITED TO, THE WARRANTIES OF MERCHANTBILITY OR FITNESS FOR A PARTICULAR USE, NOR ARE ANY SUCH WARRANTIES TO BE IMPLIED, WITH RESPECT TO THE INFORMATION OR DATA, FURNISHED HEREIN. The attached data is owned by the LOJIC participants and is protected by United States Copyright laws and applicable international copyright treaties and/or conventions.
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
true
-85.903825
-85.473541
38.059917
38.33017
1
-85.918513
-85.466238
38.346996
38.056182
Scott Stepro, GISP
Louisville Metro Public Works
GIS Supervisor
502-574-3871
444 S 5th St.
Louisville
Kentucky
40202
US
scott.stepro@louisvilleky.gov
8am - 4pm
Please call or email for further information.
379
EPSG
5.3(9.0.0)
5.3(9.0.0)
Simple
FALSE
379
TRUE
FALSE
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk
GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY
QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ
hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW
kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG
YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF
ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh
WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB
GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY
FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA
hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG
BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ
YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=