SQL Count - comp.soft-sys.gis.esri

Message from discussion SQL Count

Paul Cooper

View profile

More options Apr 14, 12:49 pm

Newsgroups: comp.soft-sys.gis.esri

From: Paul Cooper <paul.coo...@invalid.bas.ac.uk>

Date: Mon, 14 Apr 2008 17:49:14 +0100

Local: Mon, Apr 14 2008 12:49 pm

Subject: Re: SQL Count

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

On Sat, 12 Apr 2008 15:48:51 -0700 (PDT), "BklynT...@gmail.com"

<BklynT...@gmail.com> wrote:
>All,

>I have a map layer with a row for each case of a disease. Using a
>spatial join in I got the census tract for each point and now I want a
>layer with the frequency by census tract.

>I would like to do something like:

>select CensusTract, count(*) as CensusCount
>into NewLayer
>from MyTable
>group by censusTract

>Is such a thing possible within ArcMap?

>thanks ahead of time
>deborah

Won't the "SUmmary Statistics" tool do this? The "Frequency" command
in Workstation Arc/INFO will do it.

Reply to author Forward