SQL Count

[Bkly...@gmail.com]

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

[Jean H]

Have a look at Hawth's tools (freeware for ArcGIS).
http://www.spatialecology.com/htools/enumfeatures.php

Jean

[Paul Cooper]

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

[bob.he...@gmail.com]

On Apr 14, 11:49 am, Paul Cooper <paul.coo...@invalid.bas.ac.uk>
wrote:
> 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.- 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.
.

[Paul Cooper]

On Tue, 15 Apr 2008 07:22:42 -0700 (PDT), bob.he...@gmail.com
wrote:

Mainly because of its heritage in a non-SQL database, I think. You can
use native database enquiries in Arc Workstation.

Paul