Culvert pipes and parcels from ArcGIS Online to Civil 3D

Last updated: 2022-02-14

Warning: The data downloaded in this exercise is for planning purposes only. It is not spatially accurate enough for design or plat purposes.

Tip: The website used below is for internal staff and requires VPN.

Info:

The WisDOT coordinate projection zone category which was in use through Civil 3D 2016 and 2018 has been retired and is no longer needed in Civil 3D 2020 and beyond.

Coordinate systems in Civil 3D should only be applied when a projection transformation is needed.

Projections for Civil 3D 2020 and beyond should be selected from the Zone Category: USA, Wisconsin. WISCRS projections begin with NSRS2011 Wisconsin County CRS

Projections for Civil 3D 2016 and 2018 should be selected from the Zone Category: WisDOT.
  1. Access the Statewide Culvert Inventory App
  2. Zoom to the project area.
    1. Default is for the Culvert Pipe layer to be active. The Parcel layer is also available from this app.

Download culvert data

  1. Select Menu > Select by Polygon

    1. Select an area surrounding the Project
  2. In the Select Menu, Next to Active Culvert Condition Rating, click the ellipse > Export to GeoJSON
    1. Rename the downloaded file to culverts.geojson. The file was saved to the user's Downloads folder
  3. Convert to shape file by following Convert GeoJSON files to SHP #convert below

Download parcel data

  1. If previously downloaded culvert data, clear the selected data.

    1. Select Menu > Clear

  2. Layers Menu > Deselect Culvert Condition Rating

  3. Layers Menu > Select WDOA 2018 Parcels

  4. Select Menu > Select by Polygon

    1. Select an area surrounding the project, making sure the parcels desired to be seen are selected. The selection maxes out at 1000 parcels.
    2. In the select menu, click the ellipse > Export to GeoJSON
      1. Rename the downloaded file to parcels.geojson

Convert GeoJSON files to SHP #convert

  1. Visit mapshaper.org
  2. Drag and drop the culverts.geojson into the web app.

    1. Import

  3. Export > *Select* Shapefile > Export
    1. File is saved in Downloads
  4. Refresh mapshaper.org and repeat the same process for the parcels.geojson
  5. Extract the zip files to a known location such as Civil 3D Project/BaseData/Other

Import culvert data into Civil 3D

  1. Set DWG coordinate system
    1. App menu > Drawing Utilities > Drawing Settings
    2. Set the Coordinate system to the project coordinate system.
      1. Category: WisDOT
      2. Cooridinate System: Appropriate county USF
  2. MAPIMPORT

    1. Change file type to ESRI Shapefile (*.shp)

    2. Navigate to the location of the shapefile for culverts > OK

    3. Click the ellipse under Input Coordinate System to choose the coordinate system of the imported map data.

      1. In the Coordinate Sytem Library, search LL84

        1. Select the LL84 Coordinate System > Select

    4. Data column > ...
      1. Create object data: selected

      2. OK

    5. OK
  3. Culverts are imported as AutoCAD Points. All attributes in the database are imported into the properties of the point.
  4. Adjust the style display of the points as desired
    1. DDPTYPE
      1. Choose an point marker
      2. Change Size:
        1. Set size in absolute units
        2. Size = 10 to 50 units

Import parcel data into Civil 3D

  1. Set DWG coordinate system
    1. App menu > Drawing Utilities > Drawing Settings
    2. Set the Coordinate system to the project coordinate system.
      1. Category: WisDOT
      2. Cooridinate System: Appropriate county USF
  2. MAPIMPORT

    1. Change file type to ESRI Shapefile (*.shp)

    2. Navigate to the location of the shapefile for parcels > OK

    3. Click the ellipse under Input Coordinate System to choose the coordinate system of the imported map data.

      1. In the Coordinate Sytem Library, search LL84

        1. Select the LL84 Coordinate System > Select

    4. Data column > ...
      1. Create object data: selected

      2. OK

    5. OK
  3. Parcels are imported into Civil 3D as filled shapes. All attributes in the database are imported into the properties of the shape.
  4. Turn off the shape fill
    1. FILLMODEEnter 0Enter
    2. REAEnter

  5. The data should line up with project data and aerial imagery.