|
Help Contents |
|
 |
|
|
|
|
Standard Tools |
| |
The Standard Tools are located in the
toolbar located directly above the map. It includes the tools Zoom
In, Zoom Out, Zoom Prev., Zoom Extents, Pan, Identify, and Stop.
These tools will control your view of the map. |
| |

|
| |
Zoom In – This tool is operated
by first selecting the tool and then either making a single click
in the map window for an incremental zoom in or by dragging a window
covering the area of interest for a specific zoom to function.
|
| |
Zoom Out – This tool is operated
by first selecting the tool and then clicking on the area for which
you would like the map to center around. There is no window select
option for this tool. |
| |
Zoom Prev. – This tool will
allow the user to go back to the previous zoom. |
| |
Zoom Extents – This tool will
show the user the full extent of the data. |
| |
Pan- This tool is operated by
first selecting the tool and then clicking and dragging the window
in the direction which you wish to view. It allows the user to move
around within the map view without zooming in and out.
|
| |
Identify- This tool is operated
by first selecting the tool and then clicking on the area for which
you would like to identify. This tool works with the active layer.
When a feature is selected using identify a pop up will be produced
which lists the attributes of the feature selected. These results
can then be printed directly by clicking Print Results, or they
can be emailed by selecting Email Results. |
| |
Stop – This will halt
the processing. |
|
|
TOC Tools |
| |
To the right of the map window is a
box with the tabs Layer and Legend. These tools will display the
layer information the user chooses to show on the map. Located directly
below these tabs is the Auto Refresh. When active, this tool will
automatically update the map view after a change is made. It is
useful to turn this option off when switching multiple layers on
or off, so as to increase efficiency. |
| |
Layer Tab - Within the Layers
box, you can turn the layers, or data, on or off depending on what
you would like to display. When a layer is checked and the map is
refreshed, the data from that layer will appear in the view. If
the group layer, (Base, Labels, Environmental, etc.) is unchecked
the layers within that group will turn off. The layer shown in yellow
is the active layer. It is made active by clicking on the text.
The active layer will also be shown in the lower right hand corner
of the window. |
| |
Legend Tab - In the legend
tab you can view the symbols associated with the layers that are
switched on in the map. It is also a preview of what the legend
will look like on the finished map. |
| |
Top
of page |
|
|
Find Parcel |
| |
To find a particular parcel, select
Find Parcel from the Search Tools menu. The Search Box will then
appear for you to enter the block, lot, qualifier, and or municipality
information on the parcel. Once you click search, the parcel you
have selected will be highlighted in red and zoomed to the proper
extents. If you find that you have chosen the wrong parcel, you
can clear your selected parcel by clicking Clear Selected. You can
also add more parcels to your selected parcel by entering the data
for another parcel and clicking Add to Selected. |
| |
Top
of page |
|
|
Find Address |
| |
To find a particular address select
Find Address from the Search Tools Menu. Enter the address
and municipality and click search. (Hint – If you are unsure of
the spelling or do not know the complete address, simply type in
a portion of the name.)
|
| |
 |
| |
Once you have found the correct address
click Map It! to show the parcel associated with that
address in the viewer. It will appear in red in the viewer.
|
| |
Top
of page |
|
|
Find Owner |
| |
To search by owner, select
"Find Owner" from the Search Tools menu.
The Search Box will then appear for you to enter the last name of the
owner you want to search for. Once you click Search, you will see the
results appear in the window.
(Hint – If you are unsure of the
spelling or do not know the complete owner name, simply type in
a portion of the name.)
|
| |
Once you have found the correct owner
click Map It! to show the parcel associated with that
address in the viewer. It will appear in red in the viewer.
|
| |
Top
of page |
|
|
Find Street(s) |
| |
To search for a specific street, select Find Street from the Search Tools menu.
The Search Box will then appear for you to enter the name of the street you want
to search for. Once you click Search, you will see the results appear in the window.
Don’t know the full street name or correct spelling? Enter the first letter of the
street name and street names beginning with that letter will show up in the list below.
|
| |
Click on the street name in the list and click Zoom to
Selected to see the street in the map window. Your selected street will be shown in red.
You can also turn on the road names layer to see the names of nearby cross streets by
clicking on Road Names in the Layers list.
|
| |
Top
of page |
|
|
Query Tool |
|
For all other searches, the
Query Tool can be used. Select the tool from the Search
Tools menu. In the pop up window select which layer you wish to
look at. Then select which of the fields from that layer you
will use. Then select a Query Operator and enter in the
information you wish to query. Once you hit Create a SQL
statement will appear in the query box, and then click Search.
You can click Zoom to selected to view the selected
features in the map window, they will appear in red. The first
Clear button will clear the query data entered. The
second Clear located below it will clear the selected
features from the map view. |
| |
Append - The Append
button is used to create a statement such as
”UPPER(ROADNAME) = BERKELEY OR UPPER(ROADNAME) =
'MAIN'”. This will select roads with either the name
Berkeley, or the name Main. |
| |
Verify - You can
then check that statement for error by clicking on
Verify. Once you have verified the statement, click on
Search. |
| |
View Results - To
see the selected features, click View Results and
the Attribute Viewer will appear. |
| |
Queries can also be saved
or loaded by selecting
one of these icons
|
 |
|
| SQL
string syntax and examples: |
| Operator |
Description |
| = |
Equal |
| <> |
Not equal |
| > |
Greater than |
| < |
Less than |
| >= |
Greater than or equal |
| <= |
Less than or equal |
The LIKE Condition
The LIKE condition is used to specify a search
for a pattern in a column.
Syntax
A "%" sign can be used to define wildcards
(missing letters in the pattern) both before and after the
pattern.
Example
The following SQL statement will return persons
with first names that start with an 'O':
The following SQL statement will return persons
with first names that end with an 'a':
The following SQL statement will return persons
with first names that contain the pattern 'la':
|
The BETWEEN ... AND Condition
The BETWEEN ... AND operator selects a
range of data between two values. These values can be numbers,
text, or dates.
Syntax
| Field
BETWEEN value1 AND value2
|
IMPORTANT! BETWEEN..AND selects values that are
between and including the test values
|
The IN Condition
The IN operator may be used if you know the
exact value you want to return for at least one of the columns.
Syntax
|
Field IN (value1,value2,..)
|
Example
To display the persons with LastName equal
to "Hansen" or "Pettersen", use the following SQL:
|
LastName IN ('Hansen','Pettersen')
|
|
The AND & OR logical connectors
AND and OR join two or more conditions in
a WHERE clause.
The AND operator displays a row if ALL conditions
listed are true. The OR operator displays a row if ANY of
the conditions listed are true.
Example 1
Use AND to display each person with the first
name equal to "Tove", and the last name equal to "Svendson":
|
FirstName='Tove'
AND LastName='Svendson'
|
Example 2
Use OR to display each person with the first
name equal to "Tove", or the last name equal to "Svendson":
|
Firstname='Tove'
OR lastname='Svendson'
|
|
|
Top
of page |
|
|
Buffer Search |
| |
To create a buffer around a
selected area use the Buffer Tool located under the
Spatial Search menu. First select a feature either using one of
the search tools or the select tool. The selected feature
should appear in red. Then click the Buffer Tool. Once
you have chosen your buffer width click create buffer. You can
select the features within the buffer by selecting "Select
features" and then choosing the appropriate layer. Your
buffer will appear as a gray outline surrounding the chosen
area. You can also click View Results to see the
attributes of the selected features. By selecting Clear
Buffer you can clear the buffer and the selected features,
but the original selected feature (shown in red) will remain
selected |
| |
Top
of page |
|
|
Map Tools |
| |
Select Tool – This tool
allows the user to select a feature, or multiple features. It
functions as a window and selects all of the features which
intersect the window created. The selected features will appear
in red. |
| |
Clear Selection – This tool
clears the selected feature. When a buffer is created, the clear
selection tool will clear the selected feature, the created
buffer, and any selected features intersecting the buffer.
|
| |
Attribute Viewer – This tool
is used to view all of the attributes of the selected feature(s).
It is used by selecting a feature and clicking on Attribute
Viewer. In the viewer window, select the fields of the attribute
you are interested in and click update. The attributes of the
selected feature will display in the window. The selected
feature attributes can then be exported as a text file, an excel
workbook, or an xml file, by selecting the type of export and
clicking export. Note – If you choose to export the data, be
sure to click the save button. This will save the data to your
hard drive or disk. The results can also be printed directly
from the viewer by choosing print page. In the viewer you have
two options, Select All Fields, or Clear All Fields. Select All
will toggle all the possible fields and clicking Update will
produce those results. Once all fields are selected you will
have the option to Clear All Fields, and select only those
fields you want to view. |
| |
Top
of page |
|
|
Data Export Tool |
|
|
To extract data to be used in ArcGIS software, click on the Data Export Tool.
|
|
|
There are several options available for extracting data, but you will only
be able to extract a maximum of 100,000 records at a time.
(This limit can be changed in the iDV Admin but anything over this could slow the site down)
The layers listed that can be extracted are set in the iDVAdmin.
By default no layers are available and most be enabled to be
extracted.
Extract using current extent:
This option will extract layers that intersect with the current extent. The current extent is defined by what you can see on
the map. The picture above highlights the current extent. Everything that intersects that highlight will be extracted.
Extract selected features:
This option lets you extract selected features from the layer that has been selected. When this option is chosen only the selected layer will be available in the layer list.
Extract using selected features extent:
This option will extract the selected features and any feature that intersects the extent of the selected features. The picture above highlights in red what the extents would be for those selected features. That extent will then be used to select any surrounding features.
Extract using save queries:
This option will let you use queries that have been created using the query tool to select the features you want to extract. Click on a layer and if any saved queries exist for that layer, they will be loaded into the pull down list below the layer tree.
Steps on using this feature are...
1. Click on the layer you want to attach a query too.
2. If any exist, pick the saved query you want from the pull down list.
3. Then click the attach button. If you notice next to the layer you picked appears a query icon.
This icon lets you know there is a query attached to the layer.
|
|
|
Top
of pagefont> |
|
|
Report Tool |
| |
To create reports, select the features you want to include in your
report using the Select Tool. Than click on the Report Tool, in the dropdown menu provided,
select the type of report. Than click Create Report.
In the Report Window, click on Sub Title and Main Title to change the text in these areas. A text box will pop up to allow you to edit, click Format to set your title. You can also use this tool to edit “Notes”.
Custom Reports
To create custom reports select the Create Report tab at the bottom of the
Report Tool window.
Enter the Name of your custom report, select your layers
from the dropdown menu and select you report template.
Template types include Basic List, Buffer List, Buffer Parcel List, and Address Labels.
Basic List
A basic report tool, this will produce a listing of the features selected by the user.
Buffer List
A basic report tool, this will produce a listing of the features selected by the user’s selected buffer area.
Buffer Parcel List
A parcel report tool, this will produce a listing of the parcels selected by the user’s set buffer area. This tool will also show the originally selected parcels, from which the buffer was drawn, in the notes field.
Address Labels
A parcel report tool, this will produce Avery style address labels for the selected parcels.
Select the fields for your report by clicking on the fieldname and selecting
Add.
You can rename a field in your report by setting the Alias.
Once you set the Alias click Apply to update your list.
When you have completed all of your changes, click Create to
create your custom report. Use Update to set any changes you make to the report.
If you do not click Update, your changes will not be saved.
|
| |
|
| |
Top
of page |
|
|
Deed Lookup
|
| |
This tool allows the user to retrieve property-related information
(deed, mortgage, etc) from the Sussex County Clerk's Office. It functions by choosing the
"Deed Lookup" tool and clicking on a particular lot. All of the documents or instruments
which are associated with the lot will be displayed as list. Select the desired instrument
and the document will be displayed in a pdf format. |
| |
Top
of page |
|
|
Print Map
|
| |
Printing Map - There are
several options for map creation in the viewer. First select the
size of map you wish to print, 8 ˝ x 11, 17 x 11, or 24 x 36.
Then select either the landscape (horizontal) or portrait
(vertical) page setup. Then enter a title for you map in the
bottom box.
Edit Map Title - You can edit the Map Title style while
in the layout view by clicking on the title and changing the
text in the pop up box. You can choose alternate colors by
clicking the color box. |
| |
Top
of page |
|
|
|