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  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  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  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  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.
Find Street
  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  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

Field LIKE pattern

 

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':

FirstName LIKE 'O%'

 

The following SQL statement will return persons with first names that end with an 'a':

FirstName LIKE '%a'

 

The following SQL statement will return persons with first names that contain the pattern 'la':

FirstName LIKE '%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  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  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  Top of page
Data Export Tool
  To extract data to be used in ArcGIS software, click on the Data Export Tool.
Find Street
  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 page  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.
Report Tool

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”.
Report Tool Results
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.

Report Tool
 
  Top of page  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  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  Top of page