Les données ont été supprimées

Question

<\/HEAD>Situation :<\/P> Les waterlines ont été accidentellement supprimées de notre base de données SDE.<\/P> Je peux obtenir une sauvegarde\/shapefile.<\/P> <\/P> Cependant, pendant que j'attends...<\/P> <\/P> Je voulais utiliser certaines de mes données personnelles de sauvegarde que j'ai depuis le début du mois (en exportant les données vers une dbase ou shp)<\/P> <\/P> Mais... je dois pouvoir créer une nouvelle ligne à partir de la table dbase que j'ai. Je n'ai pas de données xy. Tout ce que le fichier contient comme type de données utiles que je connais pourrait être le Shape_StLe.<\/P> <\/P> Des idées si créer un nouveau shapefile à partir d'une table est possible ? #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.