データが削除されました

Question

<\/HEAD>状況:<\/P> Waterlinesが誤って私たちのSDEデータベースから削除されました。<\/P> バックアップ\/shapefileを取得することは可能です。<\/P> <\/P> しかし、待っている間に...<\/P> <\/P> 今月初めにエクスポートしたdbaseまたはshpの個人的なバックアップデータを使いたいと思いました。<\/P> <\/P> しかし...持っているdbaseテーブルから新しいラインを作成できる必要があります。xyデータはありません。ファイルに含まれている有用なデータとして私が知っているのはShape_StLeだけです。<\/P> <\/P> テーブルから新しいshapefileを作成することは可能かどうか、何かアイデアはありますか？ #waterlines newlines<\/P><\/BODY><\/HTML>

RexRobichaux3 · Answer

As Robert mentioned- do you have any common unique attributes / data between your exported table and the original / soon to be restored data? Perhaps line segment ID, Asset ID, etc.? If so it should be fairly easy to join up the data via append, data loader, etc. However, if there are no coincident attributes between the two sources (assuming one spatial and the other tabular only) you might have to achieve this manually.

If the personal backup data you mentioned was exported as a shape- you should still have spatial components to the data or possibly I'm misunderstanding the state of the data sources you have? Hope this helps!

rkrisher · Answer

If you had a way to match up your non-spatial table with a spatial source you could use geoprocessing tools to achieve this, but if that line you're trying to create is the one that was deleted out of SDE than you may be out of luck there.  If you were just trying to get the geometries for one or two features you may be able to go back to source drawings for the area or infer its shape based off of some stationing or linear referencing system (if you have one), but all of these approaches can be fairly difficult.