DATA MANIPULATION (GISP EXAM)
QUESTIONS AND ANSWERS
Selection Queries - ANSWER-New selection, add to selection, remove from selection,
subset selection, switch selection, clear selection
Contains - ANSWER-Features contain an input polygon (input polygon is selected)
Completely contains - ANSWER-Features must be completely in an input polygon (input
polygon selected)
Contains clementini - ANSWER-Features must be completely in the input polygon but if
it's on the boundary it will not be selected
Within - ANSWER-Features will be selected if inside a selecting polygon
Completely within - ANSWER-Features will be selected if completely within selecting
polygon - no overlap
Within clementini - ANSWER-Features will be selected and cannot be entirely on the
boundary of the features
Are identical to - ANSWER-Features are identical to input layer
Boundary touches - ANSWER-Features will be selected if they have a boundary that
touches a selecting feature - must be completely inside or outside the polygon
Share a line segment with - ANSWER-Features are selected if they share a line
segment
Crossed by the outline of - ANSWER-Input features will be selected if they are crossed
by the outline of a selecting feature
Have their center in - ANSWER-Features will be selected if their center falls within a
selecting feature
Contained by - ANSWER-Selection type that is the same as within
Select by location - ANSWER-Selection type that selects features within a certain
distance of a place
.shp - ANSWER-Data type: shape format - feature geometry itself
, Geometry - ANSWER-Point, line, polygon, multipoint, multipatch
1 to 1 - ANSWER-Relationship where each object of the origin table can be related to 0
or 1 objects of the destination table
1 to Many - ANSWER-Relationship where each object in the origin table can be related
to multiple objects in the destination table.
Many to Many - ANSWER-Relationship where multiple objects in the origin table can be
related to multiple objects in the destination table
.shx - ANSWER-Data type: shape index format - positional index of the feature
geometry to allow seeking forwards and backwards quickly
.dbf - ANSWER-Data type: attribute information
.prj - ANSWER-Data type: projection format/information
.sbn & .sbx - ANSWER-Data type: spatial index
.shp.xml - ANSWER-Data type: geospatial metadata in XML format
.shp, .dbf. and shx - ANSWER-Data files required to properly display a shapefile and its
attributes
.gdb - ANSWER-File geodatabase
.mdb - ANSWER-Personal file geodatabase based on Microsoft Access
Coverage file - ANSWER-Point, arc, node, route, route system, section, polygon, and
region
DGN - ANSWER-File format supported by AutoCAD and Microstation
IMG - ANSWER-Image file
LiDAR - ANSWER-Remote sensing technology that measures distance by illuminating a
target with a laser and analyzing the reflected light
Raster - ANSWER-.jpg, .tif, .gif (rendered file formats)
Short integer - ANSWER-Field type for numbers between -32768 and 32768
Long integer - ANSWER-Field type for numbers between -2,147,483,648 and
2,147,483,647
QUESTIONS AND ANSWERS
Selection Queries - ANSWER-New selection, add to selection, remove from selection,
subset selection, switch selection, clear selection
Contains - ANSWER-Features contain an input polygon (input polygon is selected)
Completely contains - ANSWER-Features must be completely in an input polygon (input
polygon selected)
Contains clementini - ANSWER-Features must be completely in the input polygon but if
it's on the boundary it will not be selected
Within - ANSWER-Features will be selected if inside a selecting polygon
Completely within - ANSWER-Features will be selected if completely within selecting
polygon - no overlap
Within clementini - ANSWER-Features will be selected and cannot be entirely on the
boundary of the features
Are identical to - ANSWER-Features are identical to input layer
Boundary touches - ANSWER-Features will be selected if they have a boundary that
touches a selecting feature - must be completely inside or outside the polygon
Share a line segment with - ANSWER-Features are selected if they share a line
segment
Crossed by the outline of - ANSWER-Input features will be selected if they are crossed
by the outline of a selecting feature
Have their center in - ANSWER-Features will be selected if their center falls within a
selecting feature
Contained by - ANSWER-Selection type that is the same as within
Select by location - ANSWER-Selection type that selects features within a certain
distance of a place
.shp - ANSWER-Data type: shape format - feature geometry itself
, Geometry - ANSWER-Point, line, polygon, multipoint, multipatch
1 to 1 - ANSWER-Relationship where each object of the origin table can be related to 0
or 1 objects of the destination table
1 to Many - ANSWER-Relationship where each object in the origin table can be related
to multiple objects in the destination table.
Many to Many - ANSWER-Relationship where multiple objects in the origin table can be
related to multiple objects in the destination table
.shx - ANSWER-Data type: shape index format - positional index of the feature
geometry to allow seeking forwards and backwards quickly
.dbf - ANSWER-Data type: attribute information
.prj - ANSWER-Data type: projection format/information
.sbn & .sbx - ANSWER-Data type: spatial index
.shp.xml - ANSWER-Data type: geospatial metadata in XML format
.shp, .dbf. and shx - ANSWER-Data files required to properly display a shapefile and its
attributes
.gdb - ANSWER-File geodatabase
.mdb - ANSWER-Personal file geodatabase based on Microsoft Access
Coverage file - ANSWER-Point, arc, node, route, route system, section, polygon, and
region
DGN - ANSWER-File format supported by AutoCAD and Microstation
IMG - ANSWER-Image file
LiDAR - ANSWER-Remote sensing technology that measures distance by illuminating a
target with a laser and analyzing the reflected light
Raster - ANSWER-.jpg, .tif, .gif (rendered file formats)
Short integer - ANSWER-Field type for numbers between -32768 and 32768
Long integer - ANSWER-Field type for numbers between -2,147,483,648 and
2,147,483,647
