> 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

>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

> <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.- Hide quoted text -

> - Show quoted text -

>> <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.- Hide quoted text -

>> - Show quoted text -

>The 'Frequency' command is also under the GUI in ArcGIS using
>ArcToolbox.  ArcMap -> ArcToolbox -> Analysis Tools -> Statistics ->
>Frequency.

>I'm not sure why ArcGIS doesn't support full SQL instead of just the
>where clause, joins/relates, and separate commands like the one
>above.  It seems to me that ArcGIS is missing out on the real power of
>a RDMS, which is full SQL support.
>.