PGD Builder

The PGD Builder is a command-line utility that builds a specialized "prepared geometry" index for TAB files. A PGD index built for a TAB file improves the performance of the LocalSearchNearest UDTF when searching data that is based on polygons. This tool is included in the utilities directory of the spectrum-bigdata-locationintelligence-<version>.zip distribution file. Because environments and use cases vary widely, we recommend you evaluate the PGD index against a sample to verify that it improves performance.

Note: A PGD index file is a supplemental file to the TAB file set. It is 5-6 times larger than the .MAP file for the TAB. One PGD file is generated per TAB file, except in the case of a seamless TAB which will have PGD files created for each sub-TAB.

Also, a PGD file will no longer be used by the system if you change the data in the TAB (that is, if rows have been added or deleted or a geometry has been changed in the MAP portion of the TAB). In this case you must you must then regenerate the PGD for the updated TAB file.