22:
323:
183:
Traditionally, GIS applications have had the ability to read or import a limited number of spatial data formats, but with few specialist ETL transformation tools; the concept being to import data then carry out step-by-step transformation or analysis within the GIS application itself. Conversely,
175:
industry to enable interoperability (or the exchange of information) between the industry's diverse array of mapping applications and associated proprietary formats. However, spatial ETL tools are also becoming increasingly important in the realm of
207:, but some are unique to spatial data. Spatial data commonly consists of a geographic element and related attribute data; therefore spatial ETL transformations are often described as being either
180:
as a tool to help organizations integrate spatial data with their existing non-spatial databases, and also to leverage their spatial data assets to develop more competitive business strategies.
418:
450:
148:
A common use of spatial ETL is to convert geographical information from a data source into another format that can be more easily used, for example by importing it into
168:
tools for processing non-spatial data have existed for some time, ETL tools that can manage the unique characteristics of spatial data only emerged in the early 1990s.
514:
509:
152:. A tool may translate data directly from one format to another, or via an intermediate format. Intermediate formats are often used when
410:
184:
spatial ETL does not require the user to import or view the data, and generally carries out its tasks in a single predefined process.
487:
105:
440:
271:
Semantic processing: Ability to understand the rules of different data formats to minimize user input whilst preserving meaning
378:
43:
191:
within the GIS industry, many existing GIS applications are now incorporating spatial ETL tools within their products; the
177:
172:
86:
231:
58:
39:
203:
The transformation phase of a spatial ETL process allows a variety of functions; some of these are similar to standard
330:
65:
473:
204:
165:
142:
72:
268:
Data dissemination: Ability to publish data via the internet or deliver by email regardless of source format
32:
373:
54:
236:
Topological transformations: the ability to create topological relationships between disparate datasets
153:
483:
300:
383:
290:
188:
145:(ETL) process, with software tools and libraries specialised for geographical information.
306:
134:
79:
265:
Conflict management: Ability to manage conflicts between multiple users of the same data
354:
284:
224:
262:
Data comparison: Ability to carry out change detection and perform incremental updates
503:
303:: The comparison of multiple datasets for verification and quality assurance purposes
240:
149:
230:
Spatial transformations: the ability to model spatial interactions and calculate
227:: the ability to convert spatial data between one coordinate system and another.
21:
294:
479:
246:
293:: The bringing together of multiple datasets into a common framework –
249:: the ability to convert attributes of tabular data into spatial data
192:
411:"What is ETL… and How Can it Turn You into a Geospatial Rock Star?"
445:
360:
317:
138:
15:
243:
characteristics of a feature, such as colour or line-style
195:
334:
258:
Desirable features of a spatial ETL application are:
46:. Unsourced material may be challenged and removed.
472:Miller, Harvey; Han, Jiawei, eds. (27 May 2009).
215:– transformations of the related attribute data.
211:– transformation of the geographic element – or
475:Geographic Data Mining and Knowledge Discovery
133:), is a process for managing and manipulating
8:
309:: Conversion between different data formats.
280:Spatial ETL has a number of distinct uses:
239:Resymbolisation: the ability to change the
106:Learn how and when to remove this message
287:: The removal of errors within a dataset
395:
405:
403:
401:
399:
363:(Geospatial Data Abstraction Library)
7:
421:from the original on 6 November 2022
44:adding citations to reliable sources
453:from the original on 11 April 2023
127:geospatial transformation and load
14:
219:Common geospatial transformations
187:With the push to achieve greater
171:Spatial ETL tools emerged in the
321:
119:Spatial extract, transform, load
20:
31:needs additional citations for
515:Extract, transform, load tools
510:Geographic information systems
178:management information systems
1:
357:(Feature Manipulation Engine)
314:Examples of spatial ETL tools
531:
379:Object–relational database
297:is a good example of this
213:attribute transformations
209:geometric transformations
143:extract, transform, load
141:data. It is a type of
374:Business intelligence
156:must be carried out.
335:adding missing items
40:improve this article
441:"Spatial ETL tools"
254:Additional features
160:Origins and history
154:data transformation
333:; you can help by
232:spatial predicates
351:
350:
301:Data verification
125:), also known as
116:
115:
108:
90:
522:
494:
493:
469:
463:
462:
460:
458:
437:
431:
430:
428:
426:
407:
384:Spatial database
346:
343:
325:
324:
318:
189:interoperability
111:
104:
100:
97:
91:
89:
48:
24:
16:
530:
529:
525:
524:
523:
521:
520:
519:
500:
499:
498:
497:
490:
471:
470:
466:
456:
454:
439:
438:
434:
424:
422:
417:. 4 June 2020.
409:
408:
397:
392:
370:
347:
341:
338:
322:
316:
307:Data conversion
278:
256:
221:
201:
162:
135:geospatial data
112:
101:
95:
92:
49:
47:
37:
25:
12:
11:
5:
528:
526:
518:
517:
512:
502:
501:
496:
495:
488:
482:. p. 63.
464:
432:
394:
393:
391:
388:
387:
386:
381:
376:
369:
366:
365:
364:
358:
349:
348:
328:
326:
315:
312:
311:
310:
304:
298:
288:
285:Data cleansing
277:
274:
273:
272:
269:
266:
263:
255:
252:
251:
250:
244:
237:
234:
228:
220:
217:
200:
199:Transformation
197:
161:
158:
137:, for example
114:
113:
28:
26:
19:
13:
10:
9:
6:
4:
3:
2:
527:
516:
513:
511:
508:
507:
505:
491:
489:9781420073980
485:
481:
477:
476:
468:
465:
452:
448:
447:
442:
436:
433:
420:
416:
412:
406:
404:
402:
400:
396:
389:
385:
382:
380:
377:
375:
372:
371:
367:
362:
359:
356:
353:
352:
345:
336:
332:
329:This list is
327:
320:
319:
313:
308:
305:
302:
299:
296:
292:
289:
286:
283:
282:
281:
275:
270:
267:
264:
261:
260:
259:
253:
248:
245:
242:
238:
235:
233:
229:
226:
223:
222:
218:
216:
214:
210:
206:
198:
196:
194:
190:
185:
181:
179:
174:
169:
167:
159:
157:
155:
151:
146:
144:
140:
136:
132:
128:
124:
120:
110:
107:
99:
88:
85:
81:
78:
74:
71:
67:
64:
60:
57: –
56:
55:"Spatial ETL"
52:
51:Find sources:
45:
41:
35:
34:
29:This article
27:
23:
18:
17:
474:
467:
455:. Retrieved
444:
435:
423:. Retrieved
414:
339:
291:Data merging
279:
257:
241:cartographic
225:Reprojection
212:
208:
202:
186:
182:
170:
163:
150:GIS software
147:
130:
126:
122:
118:
117:
102:
93:
83:
76:
69:
62:
50:
38:Please help
33:verification
30:
123:spatial ETL
504:Categories
425:5 November
390:References
331:incomplete
295:conflation
96:April 2023
66:newspapers
480:CRC Press
342:July 2024
247:Geocoding
164:Although
457:11 April
451:Archived
419:Archived
368:See also
80:scholar
486:
193:ArcGIS
82:
75:
68:
61:
53:
87:JSTOR
73:books
484:ISBN
459:2023
446:Esri
427:2022
415:XYHt
361:GDAL
276:Uses
59:news
355:FME
337:.
205:ETL
173:GIS
166:ETL
139:map
131:GTL
42:by
506::
478:.
449:.
443:.
413:.
398:^
492:.
461:.
429:.
344:)
340:(
129:(
121:(
109:)
103:(
98:)
94:(
84:·
77:·
70:·
63:·
36:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.