SDSFIE 3.0 Data Model Generation

translatoryazooInternet και Εφαρμογές Web

12 Νοε 2013 (πριν από 3 χρόνια και 8 μήνες)

269 εμφανίσεις

SDSFIE 3.0 Data Model Generation

For AutoCAD
®

Map 3D

Stephen Brockwell


BITC

Bradford Heasley


Nadir Geomatics

Agenda

1

10:00


9:15

Introduction

FDO,

SDF, Oracle, & DWG

2

9:15


9:30

SDSFIE

3.0 Data Model Design

Design and Download the SDSFIE 3 Data

Model

3

9:30


10:15

SDF Creation with SDSFIE Data Model

Create & Edit SDF Schema

4

10:15


11:00

Display and Editing SDSFIE in Map 3D

Style and Edit SDSFIE 3.0 Data Using Map 3D

5

11:00


11:30

Additional

SDSFIE Data Schemas

Oracle FDO, Oracle Native, & SDE Data Stores

Introduction to Feature Data Objects


What is a
F
eature
D
ata
O
bject (FDO)?


File
-
Based FDO


Database FDO


Raster FDO


Virtualized FDO (WMS & WFS)



What is a
S
patial
D
ata
F
ormat (SDF) file?


Autodesk supported open source data format


Built on SQLite


Each SDF can accommodate multiple feature classes


Each feature class can accommodate one or more geometries


Attributes, geometry, indexing & coordinate system inherent to SDF


FDO Continues to Grow

FDO
-
based
Applications


For example, AutoCAD
Map 3D and Autodesk
MapGuide

Enterprise

Oracle

SQL
-
Server 2005

MySQL

SDF

SHP

ODBC

Raster

WMS

WFS

ArcSDE

Autodesk Certified Providers

Providers from 3
rd

Party &

Open Source

GDAL

OGR

FME

PostGIS

SQL
-
Server

Oracle

Oracle and SQL
-
Server

MS Access

and Excel

25+ vector formats

25+ raster formats

100+ vector formats

.jpg, .jpeg, .jp2, .j2k,

.sid, .png, .tif, .tiff,

.dem, .ecw, .dt0,

.dt1, dt2, .asc, .adf, .nitf





= released by 3
rd

Party

= released by ADSK

SQL
-
Server 2008

SDSFIE 3.0 Data Model Design*


SDSFIE Model Generator


http://www.sdsfie.org/




Login (free to register)



Choose Adaptation



Choose Generator



Download “file”


*SDSFIE 3.0 is currently in Beta. 2010 scheduled release.

Autodesk FDO SDSFIE 3.0 Options


32 bit feature id key for SDF


Included GML Keys


SDSGNISId


[featureclass]IDPK


64 bit feature id key for Oracle and other [RDBMS] data stores

Getting to Know the

AutoCAD Map 3D 2010 User Interface


Ribbon


Task
-
Based


Default Toolbar
-

used for this presentation.


Tool
-
Based


Map Classic



Task Pane



Workspaces


Task
-
Based Ribbon


Home


connect, attach, modify and manager features





Feature Map


edit styles, view attributes, create SDF





Edit Feature


check in/out features & create new features


Task Pane and Data Grid


Display Manager


Connect to Data


Create and Manage Layers


Create and Edit Styles, Joins, and Filters


View Data Table (attributes)


Create Legend


Bulk Copy



Data Grid


Pick Lists


Create Join


Create Calculation


Set Split/Merge Rules

Creating SDSFIE 3.0 Schema Using SDF Format


In the Create Pane, Click on

SDF






Choose the Appropriate
Coordinate System



Creating SDSFIE 3.0 Schema Using SDF Format


Delete the Default Schema
(not required)



Import the SDSFIE 3.0
Schema



Creating SDSFIE 3.0 Schema Using SDF Format


Edit Schema








Verify Data Model
Parameters

Tip: if you need to modify a feature
class from the SDSFIE 3.0 model,
make your changes BEFORE
saving the schema to a data store.



Introduction to the Schema Editor


Schema modifications are possible via
the Schema Editor



Depending on the Data Store, schema
edits might not be permissible



Feature class must be truncated to
edit an existing schema



Domains (List/Range) can be added
to via the schema editor


Editing Schemas


‘New Property’ button


Adds a new field
(attribute)


Can be added to FC with
existing objects (most
FCs)



Removing Properties


No objects can exist in
the feature class


Not available with all FDO
data stores



Editing SDSFIE 3.0 Data


Auto Checkout & Updates


“Easy Button” for editing objects


Auto Checkout


on by default


Auto Update


off by default



Edit Mode


Objects have grips


Can Cancel Feature Checkout


Check
-
In when completed

Deleting and Creating Features


Deleting Features


Select feature (or check
-
out
feature) and press the [Del] key



Creating Features


Select the Feature Edit tab


Click
New Feature


Select the appropriate feature

OR


Right
-
Click on the Feature Class
and choose
create new…

Adding Attributes to Data Table


New Features


Once a new feature is added, the Data Table and respective ROW
highlight for new data entry


OID (FID) is updated automatically


Some fields from SDSFIE 3 model will have automatic pick lists as
defined in the schema editor



Updating Features


Open data table and

double
-
click in a cell to activate edits


Check
-
In data once

attribute edits are completed



Creating SDSFIE 3.0 Schemas for Oracle 11g


Adaptation Data Store Options


FDO Oracle Schema


Generate the FDO 64
-
bit Integer script option from SDSFIE.Org


Recommended method with Map 3D


Create Oracle schema from with Map 3D



Native Oracle Schema


Generate the Oracle script from

SDSFIE.Org from the Oracle Button


Several modifications are required

to make this option work with Map 3D

SDSFIE 3.0 FDO Schema in Oracle


Create New Data Store


Log into Oracle with
System

credentials or user with
F_USER_ROLE assigned


Choose new data store


Complete the Oracle Data Store
parameters for your new dataset



Create SDSFIE 3.0 Schema


Choose
Edit
N
ow
to edit the default
schema


Delete default schema


Import the downloaded schema from
SDSFIE 3.0 Generation Tool



Creating an Oracle SDSFIE 3.0 Schema without
FDO


Creating Schema for use
with Map 3D


Run downloaded scripts
(Qualified DB Admin only)


Modify RAW & Clob Fields


Add spatial metadata


Create spatial indices


Define primary keys




SDSFIE Oracle Spatial Script Generation


Select the proper adaptation or discipline


Choose the Oracle Spatial button


Select the appropriate scripts

Accessing SDSFIE 3.0 Schemas in ArcSDE 9.3


Setup Requirements


From a valid install of ArcGIS
locate and copy the following
files into Map3D/FDO/BIN:


pe.dll


sde.dll


sg.dll



Connect to ArcSDE


Choose ArcSDE connection


Provide login parameters


Choose feature classes


Add to Map w or w/o filter



Demonstration

Questions & Discussion

Stephen Brockwell, BITC


Bradford Heasley, Nadir Geomatics

stephen.brockwell@bitc.ca


bradford.heasley@nadirgeomatics.com