Timeline for Creating spatial view from materialized view?
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 28, 2016 at 21:06 | vote | accept | DenaliHardtail | ||
| Jan 28, 2016 at 4:42 | answer | added | Vince | timeline score: 5 | |
| Jan 27, 2016 at 23:47 | history | tweeted | twitter.com/StackGIS/status/692494238743973888 | ||
| Jan 27, 2016 at 21:45 | comment | added | Vince | No, it's been the recommended procedure since native types came into general use at ArcSDE 8.0. | |
| Jan 27, 2016 at 21:34 | comment | added | DenaliHardtail |
@Vince I used the sdetable -o create_view approach since that's what I've been told by everyone here. Is your suggestion one of those tips / best practices you pick up by working with Arc* and being bitten a few times?
|
|
| Jan 27, 2016 at 21:24 | comment | added | Vince |
Please don't use sdetable -o create_view to create spatial views on tables with native or SDE.ST_GEOMETRY geometry columns. Instead use SQL tools to create the view and sdelayer -o register to register them. If you need to change the view, you should drop it with sdetable -o delete first to avoid corrupting the geodatabase's metadata, then use SQL and re-register.
|
|
| Jan 27, 2016 at 20:50 | history | edited | PolyGeo♦ | CC BY-SA 3.0 |
deleted 11 characters in body; edited tags; edited title
|
| Jan 27, 2016 at 20:49 | answer | added | John Reiser | timeline score: 2 | |
| Jan 27, 2016 at 19:43 | history | edited | DenaliHardtail | CC BY-SA 3.0 |
added 340 characters in body
|
| Jan 27, 2016 at 19:20 | history | edited | DenaliHardtail | CC BY-SA 3.0 |
added 8 characters in body
|
| Jan 27, 2016 at 19:13 | history | asked | DenaliHardtail | CC BY-SA 3.0 |