Autodesk 15606-011408-9005 Tutorial - Page 304

Exercise 4: Save the properties to a new data store

Page 304 highlights

NOTE This exercise uses the map you modified in Exercise 2: Connect to the Microsoft Access database (page 294). To join the ODBC parcel data to the geospatial parcel layer 1 In Display Manager, select the Parcels layer and click Table. 2 At the bottom of the Data Table, click Options ➤ Create A Join. 3 In the Create A Join dialog box, the Primary Table Initiating The Join entry reads SDF_1:Schema1:Parcels. For Table (Or Feature Class) To Join To, select the ODBC_1:Fdo:Assessor layer. 4 For This Column From The Left Table, select APN. 5 For Matches This Column From The Right Table, select APN (if it is not selected automatically). Leave the other settings with their current values. 6 Click OK to display the original and joined data in the Data Table. 7 Scroll to the right to see the owner information. NOTE The joined data values for the new parcel you created with the Split command are not accurate. The database that contains the joined data does not know about the change to the parcel, so it cannot provide the proper new data for it. Update the original data store independently to enter the data for the split parcels. To continue this tutorial, go to Exercise 4: Save the properties to a new data store (page 296). Exercise 4: Save the properties to a new data store The Parcels layer now displays joined data. However, the joined data in the Data Table is gray. The gray text reflects the fact that the joined data is not part of the original data store. You cannot edit it or use it in a calculated property. You can save the layer out to a new data store, which will make the joined properties available as native properties in the future. 296 | Chapter 8 Tutorial: Working with Polygon Features

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310
  • 311
  • 312
  • 313
  • 314
  • 315
  • 316
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330
  • 331
  • 332

NOTE
This exercise uses the map you modified in
Exercise 2: Connect to the
Microsoft Access database
(page 294).
To join the ODBC parcel data to the geospatial parcel layer
1
In Display Manager, select the Parcels layer and click Table.
2
At the bottom of the Data Table, click Options
Create A Join.
3
In the Create A Join dialog box, the Primary Table Initiating The Join
entry reads SDF_1:Schema1:Parcels. For Table (Or Feature Class) To Join
To, select the ODBC_1:Fdo:Assessor layer.
4
For This Column From The Left Table, select APN.
5
For Matches This Column From The Right Table, select APN (if it is not
selected automatically).
Leave the other settings with their current values.
6
Click OK to display the original and joined data in the Data Table.
7
Scroll to the right to see the owner information.
NOTE
The joined data values for the new parcel you created with the Split
command are not accurate. The database that contains the joined data does
not know about the change to the parcel, so it cannot provide the proper
new data for it. Update the original data store independently to enter the
data for the split parcels.
To continue this tutorial, go to
Exercise 4: Save the properties to a new data
store
(page 296).
Exercise 4: Save the properties to a new data store
The Parcels layer now displays joined data. However, the joined data in the
Data Table is gray. The gray text reflects the fact that the joined data is not
part of the original data store. You cannot edit it or use it in a calculated
property.
You can save the layer out to a new data store, which will make the joined
properties available as native properties in the future.
296
| Chapter 8
Tutorial: Working with Polygon Features