Showing posts with label Copy. Show all posts
Showing posts with label Copy. Show all posts

How Draw, Copy and Move a Circle in ArcEditor with Specific Radius

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

Copy Only the Structure of A Table

This old little trick had been asked for so many times. So, it might be a good itea to post it on the blog.

In Oracle:

CREATE TABLE NEW_TAB AS
SELECT *
FROM OLD_TAB
WHERE 0 = -1

In SQL Server:

SELECT *
INTO NEW_TAB
FROM OLD_TAB
WHERE 0 = -1

The key point is WHERE condition. Because this condition is never to be met, so there is no records actually being selected. Someone might like WHERE 1 = 2, however, 1 or 2 can be referred to column one and column two. If by chance the value in column one just equals to column two, haha, you will get some data.

Labels