Statistical query

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 /*  * Copyright 2018 Esri.  *  * Licensed under the Apache License, Version 2.0 (the "License"); you may not  * use this file except in compliance with the License. You may obtain a copy of  * the License at  *  * http://www.apache.org/licenses/LICENSE-2.0  *  * Unless required by applicable law or agreed to in writing, software  * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT  * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the  * License for the specific language governing permissions and limitations under  * the License.  */  package com.esri.samples.statistical_query;  import java.util.Iterator; import java.util.List; import java.util.concurrent.ExecutionException; import java.util.stream.Collectors; import java.util.stream.Stream;  import javafx.application.Application; import javafx.geometry.Insets; import javafx.geometry.Pos; import javafx.scene.Scene; import javafx.scene.control.Alert; import javafx.scene.control.Button; import javafx.scene.control.CheckBox; import javafx.scene.layout.Background; import javafx.scene.layout.BackgroundFill; import javafx.scene.layout.CornerRadii; import javafx.scene.layout.StackPane; import javafx.scene.layout.VBox; import javafx.scene.paint.Paint; import javafx.stage.Stage;  import com.esri.arcgisruntime.ArcGISRuntimeEnvironment; import com.esri.arcgisruntime.concurrent.ListenableFuture; import com.esri.arcgisruntime.data.QueryParameters; import com.esri.arcgisruntime.data.ServiceFeatureTable; import com.esri.arcgisruntime.data.StatisticDefinition; import com.esri.arcgisruntime.data.StatisticRecord; import com.esri.arcgisruntime.data.StatisticType; import com.esri.arcgisruntime.data.StatisticsQueryParameters; import com.esri.arcgisruntime.data.StatisticsQueryResult; import com.esri.arcgisruntime.layers.FeatureLayer; import com.esri.arcgisruntime.mapping.ArcGISMap; import com.esri.arcgisruntime.mapping.BasemapStyle; import com.esri.arcgisruntime.mapping.view.MapView;  public class StatisticalQuerySample extends Application {   private MapView mapView;   @Override  public void start(Stage stage) {   try {  // create stack pane and application scene  StackPane stackPane = new StackPane();  Scene scene = new Scene(stackPane);  scene.getStylesheets().add(getClass().getResource("/statistical_query/style.css").toExternalForm());   // set title, size, and add scene to stage  stage.setTitle("Statistical Query Sample");  stage.setWidth(800);  stage.setHeight(700);  stage.setScene(scene);  stage.show();   // authentication with an API key or named user is required to access basemaps and other location services  String yourAPIKey = System.getProperty("apiKey");  ArcGISRuntimeEnvironment.setApiKey(yourAPIKey);   // create a map with the streets basemap style  final ArcGISMap map = new ArcGISMap(BasemapStyle.ARCGIS_STREETS);   // create a map view and set the map to it  mapView = new MapView();  mapView.setMap(map);   // create a service feature table using the URL  String featureServiceURL = "https://sampleserver6.arcgisonline" +  ".com/arcgis/rest/services/SampleWorldCities/MapServer/0";  final ServiceFeatureTable featureTable = new ServiceFeatureTable(featureServiceURL);   // create a feature layer from the service feature table and add it to the map  FeatureLayer featureLayer = new FeatureLayer(featureTable);  map.getOperationalLayers().add(featureLayer);   // create toggle buttons for the query filters  CheckBox currentExtentFilterToggle = new CheckBox("Only cities in current extent");  CheckBox populationFilterToggle = new CheckBox("Only cities greater than 5M");   // create static definitions for all the statistics we want to query on  // here we specify all statistic types for the "POP" (population) field  List<StatisticDefinition> statisticDefinitions = Stream.of(StatisticType.values())  .map(type -> new StatisticDefinition("POP", type, null))  .collect(Collectors.toList());   // create a button to perform the statistical query  Button queryButton = new Button("Get Statistics");  queryButton.setOnAction(e -> {  // create statistics query parameters with the definitions  StatisticsQueryParameters statisticsQueryParameters = new StatisticsQueryParameters(statisticDefinitions);   if (currentExtentFilterToggle.isSelected()) {  // set the query geometry to the current visible area  statisticsQueryParameters.setGeometry(mapView.getVisibleArea());  // set the spatial relationship to intersects (the default)  statisticsQueryParameters.setSpatialRelationship(QueryParameters.SpatialRelationship.INTERSECTS);  }   if (populationFilterToggle.isSelected()) {  // set an attribute filter to only retrieve large cities (rank = 1)  statisticsQueryParameters.setWhereClause("POP_RANK = 1");  }   // execute the query  ListenableFuture<StatisticsQueryResult> query = featureTable.queryStatisticsAsync(statisticsQueryParameters);  query.addDoneListener(() -> {  try {  StatisticsQueryResult result = query.get();  StringBuilder statistics = new StringBuilder();  for (Iterator<StatisticRecord> it = result.iterator(); it.hasNext();) {  StatisticRecord record = it.next();  record.getStatistics().forEach((key, value) -> statistics.append("\n").append(key).append(": ").append(value));  }  Alert alert = new Alert(Alert.AlertType.INFORMATION, statistics.toString());  alert.setHeaderText("Statistics");  alert.show();  } catch (ExecutionException | InterruptedException ex) {  Alert alert = new Alert(Alert.AlertType.ERROR, ex.getMessage());  alert.show();  }  });  });   // layout the controls  VBox controlsVBox = new VBox(6);  controlsVBox.setBackground(new Background(new BackgroundFill(Paint.valueOf("rgba(0,0,0,0.3)"), CornerRadii.EMPTY,  Insets.EMPTY)));  controlsVBox.setPadding(new Insets(10.0));  controlsVBox.setAlignment(Pos.CENTER);  controlsVBox.setMaxSize(220, Double.MIN_VALUE);  controlsVBox.getStyleClass().add("panel-region");  currentExtentFilterToggle.setMaxWidth(Double.MAX_VALUE);  populationFilterToggle.setMaxWidth(Double.MAX_VALUE);  queryButton.setMaxWidth(Double.MAX_VALUE);  controlsVBox.getChildren().addAll(currentExtentFilterToggle, populationFilterToggle, queryButton);   // add the map view and control panel to stack pane  stackPane.getChildren().addAll(mapView, controlsVBox);  StackPane.setAlignment(controlsVBox, Pos.TOP_LEFT);  StackPane.setMargin(controlsVBox, new Insets(10, 0, 0, 10));   } catch (Exception e) {  // on any error, display the stack trace  e.printStackTrace();  }  }   /**  * Stops and releases all resources used in application.  */  @Override  public void stop() {   if (mapView != null) {  mapView.dispose();  }  }   /**  * Opens and runs application.  *  * @param args arguments passed to this application  */  public static void main(String[] args) {   Application.launch(args);  }  }