I've got a large file geodatabase that contains a polyline feature class of water-pipes. The feature class have many fields, but the ones that I'm interested in is that of the water-pipe's Length and Locality Name.
I'm looking for a way to use the Table Select tool to generate a summary table in the same file geodatabase which summarizes the water-pipe's shape lengths for each locality. The output should be file geodatabase table which looks like this example:
- Locality 1 24395.66118
- Locality 2 19572.35849
- Locality 3 17474.87241
- Locality 4 16205.04598
I've tried to follow this link which describes the SQL syntax for such operation. I didn't get where to write it and how. This is the syntax I probably need from the link:
SELECT STATE_NAME, SUM(POP1990) as TotalPopulation FROM counties GROUP BY STATE_NAME ORDER BY STATE_NAME