The following was a workaround prior to the development of the Link Shapes to Records functionality. The following workaround is no longer necessary!
Whether due to conversion failures or just trying to add shapes to records which never had a shape, below are instructions for linking a shape to an existing data record. The process described here is merely a workaround until the functionality to link shapes to data records is created in Biotics 5. The overall process is to create a new shape in the Map, as though you would any other feature - don't add any non-essential data however as this new feature will just be used to copy its shape to the existing record, and will then be deleted. Next, run the appropriate script within the attached zip file to copy the shape from the newly created feature to the existing (shapeless) data record. QC the existing record in the Map - it should now have the shape. Assuming that it does have the correct shape, delete the data-less feature created just for its shape, as this is a duplicate of the existing record which now has a shape. If the existing record was a SF associated with an EO for which all SFs now have shapes, Modify Shape of the SF (without making any changes - just click Accept), and the EO shape will be generated. Below are more detailed steps.
NOTE: It is imperative that you use the script which is appropriate for the record to which this process applies, whether it be a Site, MA, or SF. There are also different scripts according Pre-SF/Locational Uncertainty Type:
- SFPolys - applies to Pre-SF poly with either Negligible or Delimited uncertainty
- SFLines - applies to Pre-SF line with either Negligible or Delimited uncertainty
- SFPoints - applies to Pre-SF point with either Negligible or Delimited uncertainty
- SFPointsEstimated - applies to Pre-SF point with Estimated uncertainty
- SFLinesEstimated - applies to Pre-SF line with Estimated uncertainty
If you have questions regarding this process, submit a help desk ticket with your specific question or requesting a GoToMeeting to walk through it.
Create a new MA/Site/SF with the spatial feature - this will later be deleted - it is merely being created for its spatial feature.
Unzip the attached file to c:\temp
Log into SQLPlus with the biotics_dlink password at the DOS Command Prompt: sqlplus biotics_dlink/password@biotics5
- Copy the following into the SQL prompt (utilizing the name for the appropriate script, depending on what type of record the shape is being attached to), which will run the script: @c:\temp\SpatialImportFailed_FixSFPolys.sql
- At the prompts in the script, provide the appropriate SF ID ('Existing' refers to the shapeless SF record from the conversion, whereas 'New' refers to the one that you created just for its beautiful shape!).
- As long as the script was successful (1 row inserted three times and 1 row updated), then within the map, utilize the Feature Search to find the original/existing SF. Zoom to the SF and view the shape. Is it correct? Open the Details dialog.
- From the Task menu of the Details dialog, choose Modify Shape. Don't actually make any changes, just hit Accept. Assuming this is the only SF of the EO, this will cause the EO shape to be generated, because an EO is based on the shapes of its component SFs. If the EO is comprised of >1 SF, the EO cannot be generated until ALL its SFs have shapes.
- After verifying that the existing SF now has the correct shape (step 5), utilize the Feature Search to find the newly created SF, just for the purpose of it's shape and Delete the SF - this is a duplicate and needs to be gotten rid of.
- Repeat steps 3 - 7 for each of the SFs.