Article with ID 26558 in ArcGIS Resource Center has described the steps. Here is an improved version:
1. Add the Advanced Editing toolbar to ArcMap by clicking View > Toolbars > Advanced Editing.
2. If Drawing toolbar does not appear, click on the Editor menu and select Start Editing.
3. Zoom in to the right position and size in order to make precise pinpoint of the circle of the circle, in following steps.
4. Click on the Marker tool (a little dot) on the Drawing toolbar.
5. Click somewhere on the map to specify where the center of the circle will be to place the Marker. Make an adjustment to the size of this Marker.
6. Click on the Circle tool on the Drawing toolbar.
7. Click the Markers on the map which specifies where the center of the circle will be, and don't release the button on your mouse.
8. Move your mouse little bit while still hold your mouse button, hit the 'R' key on the keyboard.
9. Specify the radius of the circle in map units and hit the Enter key.
10. If you do not want the Marker to be seen, you can either remove it or color it into invisible. The latter is suggested because any future move and copy may rely on this Marker to be precised.
Done.
To move or copy a circle, you may regard the center of the circle as base point. In this case, use the Marker as mentioned above.
1. Zoom in to the right position and size in order to make precise pinpoint for both old and new position of the center of the circle.
2. Click "Select Elements" button, then click the circle.
3. Press Ctrl in keyboard while click the Marker at the center of the circle, to grouping it.
4. Ctrl C and Ctrl V to copy and paste. For move, just use your mouse to drag and drop.
5. Drag and drop to right position base on the Marker.
http://resources.arcgis.com/content/kbase?fa=articleShow&d=26558
How to Upload Data to ArcEditor
Save data in Excel file. Open ArcCatalog, connect to that folder, find the table/worksheet in Excel file, right click it, click Create Feature Class, click From XY Table, a pop-up window Create Feature Class From XY Table will be shown. Select with XY columns and select right folder and file name for new SHP file destination, then click OK.
If it does not show on the folder, right click the folder to refresh it.
In ArcEditor, menu Windows, select Table of Contents. In the layer you want to add, right click it, click Add Data, and then upload the SHP files you have just created.
Done.
If it does not show on the folder, right click the folder to refresh it.
In ArcEditor, menu Windows, select Table of Contents. In the layer you want to add, right click it, click Add Data, and then upload the SHP files you have just created.
Done.
Javascript Error Message: is not a function
This error message appears when you use Varibalized Function (or called Function Literal, Function Reference, Function Pointer) method to declare function while you did not put into right order:
(Caller here)
; var func = function()
{
...
}
Solution 1:
; var func
(Caller here)
; func = function()
{
...
}
Solution 2:
(Caller here)
; function func()
{
...
}
http://www.dustindiaz.com/javascript-function-declaration-ambiguity/
Function Declaration in JavaScript
(Caller here)
; var func = function()
{
...
}
Solution 1:
; var func
(Caller here)
; func = function()
{
...
}
Solution 2:
(Caller here)
; function func()
{
...
}
http://www.dustindiaz.com/javascript-function-declaration-ambiguity/
Function Declaration in JavaScript
How to Create a New Report by Copy from Existing One in SSRS
First of all, if the Solution and Project for which the new report is supposed to be there is not exist yet, create the Solution and/or Project first.
1. In Solution Explorer, find existing report, right click and select COPY.
2. Click the Project where you want your new report be, right click and select PASTE.
Done.
1. In Solution Explorer, find existing report, right click and select COPY.
2. Click the Project where you want your new report be, right click and select PASTE.
Done.
Optional Parameters In SQL Server Reporting Services
Optional parameters In SSRS means if parameters have been selected, it would be passed back to SQL query as condition in WHERE clause, and when no parameter(s) have been selected, the WHERE condition should be not in use. Dynamic SQL is not the best solution. Following solution is much better:
SELECT Col_A
, Col_B
FROM Tab
WHERE (Col_A=@para_A OR @para_A IS NULL)
AND (Col_B=@para_B OR @para_B IS NULL)
What make life harder is when parameters are selected, but due to lack of records, the result is nil? These would be happened often when multiple parameters get involved. Depends on situations, you may wish to abandon that condition completely. So, the real issue is not if you have option to select a particular parameter, it is if you have selected that parameter but it turns out nil result and you need to abandon it after this discovery.
There is no programmatic solution so far. However, following approach may help:
1, Limit the number of parameters, because you will need to combine them in matrix. Too many parameters will increase the task load exponentially.
2, Classify parameters into hierarchy.
3, Write queries for each combination case of the parameters. Hierarchical structure of parameters will help a lot.
4, From low position in hierarchy to pick up the best available result amongst the results generated from above queries. Following is an example to do this procedure:
; SET @Stopper = 0
; IF 0 = @Stopper
BEGIN
SELECT @result = SUM(CASE WHEN Hierarchy = 'Level_1' AND Result_From_Set IS NOT NULL THEN Result_From_Set ELSE 0 END)
FROM Tab
IF @result <> 0 SET @Stopper = 1
END
; IF 0 = @Stopper
BEGIN
SELECT @result = SUM(CASE WHEN Hierarchy = 'Level_2' AND Result_From_Set IS NOT NULL THEN Result_From_Set ELSE 0 END)
FROM Tab
IF @result <> 0 SET @Stopper = 1
END
...
What you need to do next is in SSRS to enable the optional parameters. While you have made it possible to accept the NULL value in your back-end queries, by default the report interface of SSRS cannot be flagged out the parameters. The users would have no choice but to select parameters. In this case, include NULL value record for your parameter data set:
SELECT NULL AS Id
, 'Unknown' AS Name
UNION
SELECT DISTINCT Id
, Name
FROM Tab
If you have problem on how to position this NULL value record, please refer to following article:
Special Function of ORDER BY Clause in T-SQL
Next, in Report Parameters window of SSRS, make sure the "Allow null value" option has been selected for this particular parameter.
Done.
http://bloggingabout.net/blogs/egiardina/archive/2007/06/26/sql-server-reporting-services-optional-parameters.aspx
SELECT Col_A
, Col_B
FROM Tab
WHERE (Col_A=@para_A OR @para_A IS NULL)
AND (Col_B=@para_B OR @para_B IS NULL)
What make life harder is when parameters are selected, but due to lack of records, the result is nil? These would be happened often when multiple parameters get involved. Depends on situations, you may wish to abandon that condition completely. So, the real issue is not if you have option to select a particular parameter, it is if you have selected that parameter but it turns out nil result and you need to abandon it after this discovery.
There is no programmatic solution so far. However, following approach may help:
1, Limit the number of parameters, because you will need to combine them in matrix. Too many parameters will increase the task load exponentially.
2, Classify parameters into hierarchy.
3, Write queries for each combination case of the parameters. Hierarchical structure of parameters will help a lot.
4, From low position in hierarchy to pick up the best available result amongst the results generated from above queries. Following is an example to do this procedure:
; SET @Stopper = 0
; IF 0 = @Stopper
BEGIN
SELECT @result = SUM(CASE WHEN Hierarchy = 'Level_1' AND Result_From_Set IS NOT NULL THEN Result_From_Set ELSE 0 END)
FROM Tab
IF @result <> 0 SET @Stopper = 1
END
; IF 0 = @Stopper
BEGIN
SELECT @result = SUM(CASE WHEN Hierarchy = 'Level_2' AND Result_From_Set IS NOT NULL THEN Result_From_Set ELSE 0 END)
FROM Tab
IF @result <> 0 SET @Stopper = 1
END
...
What you need to do next is in SSRS to enable the optional parameters. While you have made it possible to accept the NULL value in your back-end queries, by default the report interface of SSRS cannot be flagged out the parameters. The users would have no choice but to select parameters. In this case, include NULL value record for your parameter data set:
SELECT NULL AS Id
, 'Unknown' AS Name
UNION
SELECT DISTINCT Id
, Name
FROM Tab
If you have problem on how to position this NULL value record, please refer to following article:
Special Function of ORDER BY Clause in T-SQL
Next, in Report Parameters window of SSRS, make sure the "Allow null value" option has been selected for this particular parameter.
Done.
http://bloggingabout.net/blogs/egiardina/archive/2007/06/26/sql-server-reporting-services-optional-parameters.aspx
Special Function of ORDER BY Clause in T-SQL
Compare to MS Access Jet Engine SQL, T-SQL's ORDER BY clause is flexible, which can point either the column name or alias of the column. Which special function can be used for special purpose. Here is any example. Let us say, you need a data set in order:
SELECT DISTINCT Name
FROM Tab
ORDER BY Name
Then you need to add a record called "Unknown" at the top:
SELECT 'Unknown' AS Name
UNION
SELECT DISTINCT Name
FROM Tab
There is problem, you won't able to add ORDER BY clause in T-SQL because you used UNION. Following is next step:
SELECT Name
FROM
( SELECT 'Unknown' AS Name
UNION
SELECT DISTINCT Name
FROM Tab
) AS Inner_Q
ORDER BY Name
You won't be able to get the right result, because "Unknown" is not on the top. Solution is:
SELECT CASE WHEN Name = '0000' THEN 'Unknown' ELSE Name END AS New_Name
FROM
( SELECT '0000' AS Name
UNION
SELECT DISTINCT Name
FROM Tab
) AS Inner_Q
ORDER BY Name
Why use '0000'? Because it would be on the top after sort. In this case, if you use
ORDER BY New_Name
it won't work.
http://koncordpartners.blogspot.com/2009/11/contain-data-layout-in-sql-part-for.html
SELECT DISTINCT Name
FROM Tab
ORDER BY Name
Then you need to add a record called "Unknown" at the top:
SELECT 'Unknown' AS Name
UNION
SELECT DISTINCT Name
FROM Tab
There is problem, you won't able to add ORDER BY clause in T-SQL because you used UNION. Following is next step:
SELECT Name
FROM
( SELECT 'Unknown' AS Name
UNION
SELECT DISTINCT Name
FROM Tab
) AS Inner_Q
ORDER BY Name
You won't be able to get the right result, because "Unknown" is not on the top. Solution is:
SELECT CASE WHEN Name = '0000' THEN 'Unknown' ELSE Name END AS New_Name
FROM
( SELECT '0000' AS Name
UNION
SELECT DISTINCT Name
FROM Tab
) AS Inner_Q
ORDER BY Name
Why use '0000'? Because it would be on the top after sort. In this case, if you use
ORDER BY New_Name
it won't work.
http://koncordpartners.blogspot.com/2009/11/contain-data-layout-in-sql-part-for.html
Subscribe to:
Posts (Atom)
Posts
