Question: I'm developing a OneMap Android application and the code is as follows:

```
    private MapView map;

    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);

        map = (MapView) findViewById(R.id.map); 

        map.addLayer(new ArcGISTiledMapServiceLayer(Practice_3.this,
                "http://www.onemap.sg/ArcGIS/rest/services/BASEMAP/MapServer"));}

```

I'm lost at figuring out **how to set the zoom level when the map is first loaded** on the emulator as on load, the map is too small.

Could anyone help me with this?

Any help would be greatly appreciated.

Answer: 
add an extra column changecount 

```
CREATE TABLE crewWork( 
       FloorNumber int, AptNumber int, WorkType int, simTime int ,changecount int)

```

increment `changecount` value for each updation 

if want to know count for each field then add columns corresponding to it for changecount
Assuming that each record represents a different change, you can find changes per floor by:

```
select FloorNumber, count(*)
from crewWork
group by FloorNumber

```

And changes per apartment (assuming AptNumber uniquely identifies apartment) by: 

```
select AptNumber, count(*)
from crewWork
group by AptNumber

```

Or (assuming AptNumber and FloorNumber together uniquely identifies apartment) by: 

```
select FloorNumber, AptNumber, count(*)
from crewWork
group by FloorNumber, AptNumber

```