Latest Contributions by KeithWeber1

Hello, I have a web application that provides the user with several different options to subset the visible features on the map. Most of the subset criteria is applied using a layer's definition expression. One way I would like to allow the user to subset the visible features is to allow the user to draw a polygon on the map and only the features that are within the polygon get displayed. What is the best way to achieve this behavior? I am currently using ArcGIS Flex API and the layer type is an ArcGISDynamicMapServiceLayer. ... View more

Hello, Description of data The data being collected is environmental data from one device with multiple sensors. There is one location and time stamp with multiple environmental measurements. For example, at 10:00 am on 1/1/15 at some coordinate, the temperature was x, the wind speed was y and the wind direction was z. Different devices collect different types of measurements. The way that the database schema is setup is to have a feature class containing points and a separate table for measurements, where there are multiple measurements per point. Point Table Point ID Shape TimeStamp Measurement Table Measurement ID Measurement Type Measurement Value Measurement Units Point ID The two tables are linked using the Point ID. Desired Functionality My web application is a viewer into an archive of measurements. It's purpose is to allow the user to fill in some query criteria and subset the data that is in the view. An example query would be something like displaying all the points between date x and date y where wind speed was collected. The problem This would normally be handled simply by setting a definition expression like MeasurementTbl.MeasurementType = "wind speed", but the problem is that the spatial table containing the point has a 1-to-many relationship to the measurements table and when creating a join, the result is that only the first measurement record is paired with a point in the resulting layer. For example, for a point with two measurements, say wind speed and temperature, if temperature is the first record to be paired to the point record, the wind speed record is lost. Any suggestions would be greatly appreciated! ... View more

I have a map service that provides a feature layer that is pointing to an Oracle database table with an SDO_GEOMETRY column. The table has 40k+ records and recently I started seeing the following error in the ArcGIS Server logs.   GeoDatabase Error: Underlying DBMS error [ORA-01722: invalid number][tablename]   I'm not sure how to figure out which record is causing the problem. When I attempt to open the map document containing the feature layer, I only see 135 records, but when I use SQLPlus to query the table from Oracle, everything seems fine. Any suggestions?   The server is ArcGIS Server 10.0 and Oracle is 12c ... View more