A few comments:
I think FME is the best option here for sure and there are a few ways to set it up.
You can indeed set up one workspace to do this but depending on how you go you might need to split it up if things get too complex.
For shapefile and geojson (and probably Scene layer package) I think this approach and document is perfect but it gets a little more difficult for CAD and IFC/Revit.
- Depending on which tool the team are using it's possible that there will be no attributes on the data for CAD. Indeed DWG can store attributes but it's not always clear how or where they are stored - you should make sure that what you're asking is possible and/or figure out the best approach to get the required data from the team.
- With both CAD and IFC (and also revit) it's quite likely that the coordinate system information will be missing or not projected correctly at all - as long as it's consistent you should be able to get something working though.
- For ICF/Revit the model will typically already be in 3D and could be quite complex - I'm not sure what kind of geometry you're expecting in the end in SDE but you might need to figure out a good way to handle the complex geometries - in FME there are lots of options.
I would make sure that part of your process is a validation of the data - you can do things like check the location is in an expected area and that the required attributes are defined in the way you expect.
You can have the user upload the data to the app themselves or set up an email to process an attachment and send back a validation report.
A few comments:
I think FME is the best option here for sure and there are a few ways to set it up.
You can indeed set up one workspace to do this but depending on how you go you might need to split it up if things get too complex.
For shapefile and geojson (and probably Scene layer package) I think this approach and document is perfect but it gets a little more difficult for CAD and IFC/Revit.
- Depending on which tool the team are using it's possible that there will be no attributes on the data for CAD. Indeed DWG can store attributes but it's not always clear how or where they are stored - you should make sure that what you're asking is possible and/or figure out the best approach to get the required data from the team.
- With both CAD and IFC (and also revit) it's quite likely that the coordinate system information will be missing or not projected correctly at all - as long as it's consistent you should be able to get something working though.
- For ICF/Revit the model will typically already be in 3D and could be quite complex - I'm not sure what kind of geometry you're expecting in the end in SDE but you might need to figure out a good way to handle the complex geometries - in FME there are lots of options.
I would make sure that part of your process is a validation of the data - you can do things like check the location is in an expected area and that the required attributes are defined in the way you expect.
You can have the user upload the data to the app themselves or set up an email to process an attachment and send back a validation report.
Thank you very much Matt I appreciate all the comments you've shared. I am not against multiple workspaces. I think at a base level, I would like the process to be functional and based on your comments my final goal should be to amalgamate it into a single workspace.
Regarding point 1, are you implying that certain software's used by developers may not innately store attributes? Additionally, does the said software make it difficult to find (if it exists) or are you referring to FME struggling to "find" it when Feature Caching is enabled?
Regarding point 2, thank you thats a good point. I will ask for a coordinate system to be applied and if not use our parcels and create a validation step to match the dwg to a parcel. This may have to be a manual step depending on how skewed it may be, but I am thinking maybe using a User Parameter to input the ARN of the parcel so that it automatically selects it and "matches" it. I will figure that hurdle when i get there haha.
Regarding point 3, it made me have a discussion with my other GIS Analyst and he's also has not worked with 3D buildings in and SDE environment so I appreciate it. I am going to have to look up options to figure this out. thank you!
Thank you very much Matt I appreciate all the comments you've shared. I am not against multiple workspaces. I think at a base level, I would like the process to be functional and based on your comments my final goal should be to amalgamate it into a single workspace.
Regarding point 1, are you implying that certain software's used by developers may not innately store attributes? Additionally, does the said software make it difficult to find (if it exists) or are you referring to FME struggling to "find" it when Feature Caching is enabled?
Regarding point 2, thank you thats a good point. I will ask for a coordinate system to be applied and if not use our parcels and create a validation step to match the dwg to a parcel. This may have to be a manual step depending on how skewed it may be, but I am thinking maybe using a User Parameter to input the ARN of the parcel so that it automatically selects it and "matches" it. I will figure that hurdle when i get there haha.
Regarding point 3, it made me have a discussion with my other GIS Analyst and he's also has not worked with 3D buildings in and SDE environment so I appreciate it. I am going to have to look up options to figure this out. thank you!
Yeah, for point 1 for example if the user is using vanilla AutoCAD and creating a DWG or DXF then the Features themselves wont have Attributes. But if using something like Map3D toolset then attributes and coordinate systems are supported.
