세상의 모든 아침

http://www.redmine.org/projects/redmine/wiki/PluginScreenshotPaste

할일 : 아래 링크의 doc 파일을 다운받아서, 첨부하기.

-> 이미 ucloud에 넣었네... ^^;

-------------------------------------------

출처: http://blog.naver.com/ansysda/10028865422

내가 등록한 것.

http://www.redmine.org/plugins/ckfinder_for_redmine

Plugins Directory » Image Uploader of CKEditor plugin (CKFinder)

Redmine & WIN32OLE(excel) 성공.xls

Drones+ 아이폰앱 제작자인 Josh Begley의 작품.

(Drones+에 대한 한국기사: http://www.bloter.net/archives/136377)

출처: http://prisonmap.com/about

About

Prison Map is not a map -- it's a snapshot of the earth's surface, taken at various points throughout the United States. It was made by Josh Begley, a graduate student studying Interactive Telecommunications at New York University.

The United States is the prison capital of the world. This is not news to most people. When discussing the idea of mass incarceration, we often trot out numbers and dates and charts to explain the growth of imprisonment as both a historical phenomenon and a present-day reality.

But what does the geography of incarceration in the US actually look like? Prison Map is my attempt to answer that question.




The project came about in a Data Representation class with Jer Thorp at NYU. It begins from the premise that mapping the contours of the carceral state is important. A number of people and organizations have done excellent work in this regard. Among them are the Prison Policy Initiative and Prisoners of the Census. Over the past few years, they have culled together a database of seemingly mundane but hard-to-locate information: the latitude and longitude of every carceral facility in the United States (currently with the exception of WA, WV, WI, and WY). Their locator tool, which aims to identify correctional facilities counted in the 2010 census for the purposes of accuracy and redistricting, is the first database I know of to include state and federal prisons alongside local jails, detention centers, and privately-run facilities. You can explore their facility locator here.

When using the tool, however, it was hard for me to get a sense of volume -- what does it mean to have 5,000 or 6,000 people locked up in the same place? What do these carceral spaces look like? How do they transform (or get transformed by) the landscape around them?

In order to begin answering some of these questions, I started playing with satellite imagery. The Google Maps API allows you to pass any latitude and longitude into its Static Maps service, specifying parameters such as format and zoom level, and it will spit back an image of that particular location. With Jer's help, I wrote a simple Processing sketch that would grab image tiles at various lat/lons, save them as a .jpg file, and cycle through all 4,916 facilities:

String[] prisons;

void setup() {
}

void draw() {
  prisons = loadStrings("prisons-latlon.csv");
  for(int i = 0; i < prisons.length; i++) {
    String[] values = split(prisons[i], ",");
    String lat = values[0];
    String lon = values[1];
    String id = values[2];
    PImage test = getSatImage(lat,lon);
    test.save("facility" + id + ".jpg");
  }
  
}

PImage getSatImage(String lat, String lon) {
    String url = "http://maps.googleapis.com/maps/api/staticmap?center=" + lat + "," + lon + "&zoom=
    16&scale=1&size=640x640&maptype=satellite&sensor=false&junk=.jpg";
    return(loadImage(url));
}

참고 : http://support.microsoft.com/kb/321185/ko

1. 새 쿼리  선택

2. select @@VERSION 실행

   -> 쿼리 결과에서 버전은 R2 (SP2),

       Edition은 Enterprise Edition을 조회가능.

[ASP,ASP.NET,PHP,JSP,JavaScript,Database 등 웹개발자 모임] | tlsgidgh

http://cafe.naver.com/webdeveloper/4014

+---------------------+-----------------------------------------------------------+
| Variable_name       | Value                                                     |
+---------------------+-----------------------------------------------------------+
| log_slow_queries    | OFF                                                       |
| slow_launch_time    | 2                                                         |
| slow_query_log      | OFF                                                       |
| slow_query_log_file | C:\ProgramData\MySQL\MySQL Server 5.5\Data\E01-1-slow.log |
+---------------------+-----------------------------------------------------------+
4 rows in set (0.00 sec)

출처: http://blog.naver.com/zsssd/150021318263

출처 : http://serverfault.com/questions/329845/how-to-forcibly-close-a-socket-in-time-wait

/etc/init.d/networking restart

/etc/init.d/networking restart

1장의 이미지로 표현된 HTML5 역사

출처: http://walyou.com/html5-infographic/

3개의 방법이 있다.

(아래그림들은 PID 324를 사례로 설명)

1. 명령 프롬프트에서 tasklist -svc

   - 별도의 툴없이 간단 확인용도

2. Process Explorer 사용

  - 특징:  내부서비스의 파일명과 위치까지 확인 가능

ProcessExplorer-v12.04.zip

3. Svchost Viewer 사용

 - 특징 : 위 1,2번과 달리 프로세스 중에서 Svchost만 보여주고, Description에서 상세설명 있음

Svchost Viewer Ver 0.5.0.1.zip

참고 url

http://www.orz.kr/tt/orz/entry/svchost-%EB%84%88%EB%A5%BC-%EB%A7%90%ED%95%B4%EC%A4%98?category=0

http://muzbox.tistory.com/m/189

open source guide.pdf

32bit는 freeware.

http://www.eterlogic.com/Products.VSPE.html

It's a permission-related error. Set write permissions for web user to the folder templates_c.
To set permissions in Windows:
- right-click on your folder, go to Properties -> Security
- add user named UISR_<machine name> (if don't exists)
- and assign Full Permissions for this user.
- Then click OK.

* 목적: redmine의 CKEditor plug-in에 image upload 기능 추가하기

* 테스트 항목

  : javascript에서 html 파일을 거치지 않고, php로 이미지 파일 업로드하기

 1. CKEditor에  파일(이미지) 찾기 기능 추가     -> 완료

 2. win7에서 IIS7에서 jquery 이용하여 php 호출

 3. php에서는  이미지 업로드

동적으로 jquery.js를 삽입하기

from:

이젠 기억도 잘 안나는 OSI 7계층...ㅠㅠ 인터넷에 돌아다니는 이미지들을 참고하여 정리해보았다. 먼저, 각 층별 데이터 단위를 살펴보면 다음과 같다. 

DELIMITER $$
### PROCEDURE ------ ###
DROP procedure  IF EXISTS bitnami_redmine.proc1 $$

CREATE PROCEDURE bitnami_redmine.proc1(IN Process TEXT, IN Maker TEXT, IN ProbType TEXT)
BEGIN
#    DECLARE i INT DEFAULT 0;
#    DECLARE min_beforedate INT DEFAULT 0;

select a2.customized_id, a2.value, c.value from

(select a.customized_id, a.value, a.custom_field_id from
#(select customized_id, value, custom_field_id  from custom_values as a where (custom_field_id = 17 and value = 'BOSCH')) as a
(select customized_id, value, custom_field_id  from custom_values as a where (custom_field_id = 17 and value = Maker)) as a
inner join
#(select customized_id, value, custom_field_id from custom_values as b where (custom_field_id = 1 and value = 'PAINT')) as b
(select customized_id, value, custom_field_id from custom_values as b where (custom_field_id = 1 and value = Process)) as b
where a.customized_id = b.customized_id) as a2

inner join
#(select customized_id, value from custom_values as c where (custom_field_id = 3 and value = 'SFEM S/W')) as c
(select customized_id, value from custom_values as c where (custom_field_id = 3 and value = ProbType)) as c
where a2.customized_id = c.customized_id;

END $$

   
DELIMITER ;

* Table Join 소요시간 (MySQL)

inner join이 self join보다 빠름 : 테이블의 내부검색시(테이블 1개를 2개로 간주)


select a.customized_id, a.value, a.custom_field_id from
(select customized_id, value, custom_field_id  from custom_values as a where (custom_field_id = 17 and value = 'AMAT')) as a
inner join
(select customized_id, value, custom_field_id from custom_values as b where (custom_field_id = 1 and value = 'ETCH')) as b
/* 0 rows affected, 38 rows found. Duration for 1 query: 0.016 sec. */


select a.customized_id from custom_values a, custom_values b
where
    (a.custom_field_id = 17 and a.value = 'AMAT')
and (b.custom_field_id = 1 and b.value = 'ETCH')
and a.customized_id = b.customized_id
/* 0 rows affected, 38 rows found. Duration for 1 query: 0.124 sec. */