| TARGET SQL |
Target SQL allows making selections based on SQL enquiries on existing records. The Query SQL procedure is another way to target regions with inadequate resources and poor performance (or contrary), by directly retrieving data that answers specific criteria.
When is analyzed a database, it will be selected a subset of the data contained in the active table and will show the target cases on the Map. The results will be displayed simultaneously in the Query window and the Map window. The Query window contains the selected cases and displays only the variables used in the SQL criteria. The Map highlights in red only the cases obtained from the SQL, while all the other cases being colored in white (deselected), as shown below.
Example: Query SQL procedure for Leningrad Oblast
We chose to select the municipalities with Demographic load over 160 and percentage of employees in private enterprises over 60
Indicators and formula used are:
- [DEMOGRAPHIC_LOAD] over 160
- [%EMPLOYED_PRIVATE_ENTR] > 60
- formula: [DEMOGRAPHIC_LOAD] > 160 AND [%EMPLOYED_PRIVATE_ENTR] > 60
The municipalities selected are those who accomplish the imposed criteria.
| CASE | DEMOGRAPHIC_LOAD | '%'EMPLOYED_PRIVATE_ENTR | '%'EMPLOYED | AVG_SALARY/EMPL |
| VOLOSOVO DISTRICT | 167.22 | 66.67 | 85.28 | 5669.00 |
| VSEVOLOZHSK DISTRICT | 177.85 | 66.88 | 57.93 | 8339.00 |
| VYBORG DISTRICT | 172.33 | 66.03 | 87.62 | 8659.00 |
| KIRISHI DISTRICT | 171.77 | 60.16 | 91.96 | 13588.00 |
| LOMONOSOVSKY DISTRICT | 176.70 | 67.22 | 54.02 | 10302.00 |
| TOWN OF NOVAYA LADOGA | 175.00 | 67.57 | 58.73 | 4966.00 |
| TOWN OF SVETOGORSK | 178.57 | 76.19 | 107.69 | 9490.00 |