Select the data source for each layer from a list of tables with geography columns
Dynamically view the data source by entering a SQL Server common table expression (CTE)
user can select a geography column for each feature’s geography
user can optionally select a column to be the source for text for feature labeling on the map
the optional generalize distance can be entered to reduce the amount of detail for each feature
the optional feature limit can restrict the amount of data returned by the database
whether the layer is based on a table or a CTE, the user can enter a SQL WHERE clause to select specific rows
WHERE clauses (and the CTE definition) can contain spatial queries. For example, a WHERE clause may select only those features within a certain area contained in a row in a different table
WHERE clause execution can be optimized by using a parameterized query
SQL expressions are fully validated before being used to creating layers
features can be limited to a particular area of the map
the mapping limit can be taken from the current map view, from a selection box on the map, or the coordinates can be entered directly
the geometry type of the features in a layer can all be the same type, or differ (points, lines, or polygons)
the feature geometry shown on the map may be altered by the SQL code used to define the layer
Ingen kommentarer:
Send en kommentar