topic Geotools Shapefile Multipoint MZ -&gt; ArcMap Import -&gt; Tracking Analyst M=#QNAN in ArcGIS Spatial Analyst Questions https://community.esri.com/t5/arcgis-spatial-analyst-questions/geotools-shapefile-multipoint-mz-gt-arcmap-import/m-p/195440#M2772 <HTML><HEAD></HEAD><BODY><SPAN>A previous post indicated that Tracking Analyst requires point data.&nbsp; Unfortunately, the spatial database was recently converted to storing temporal data as Multipoints with Z and M values in an oracle database from a database based on points with a temporal column. The requirement is to be able to view and analyse this data in Tracking Analyst. </SPAN><BR /><BR /><SPAN>External to the ArcGIS system, GeoTools is used to generate a shapefile from a SQL Query.&nbsp; Debug inspection reveals that the data sent to the shapefile contains both the Z and M values for the points in the Multipoint array. The M value is a Long and represents the time dimension.</SPAN><BR /><BR /><SPAN>The shapefile is then loaded into ArcMap.&nbsp; Points are displayed.&nbsp; The Attribute Table indicates Shape as 'Multipoint ZM'.&nbsp; The tool Multipart to Singlepart is then used to convert the dataset to point data or Point ZM. Using arcpy, an attempt to validate and use the M-value or M-Measure indicates a #QNAN value for the M value.&nbsp; Attempts to extract the M-value into the Attibute Table using the Field Calculator yields syntactical errors.</SPAN><BR /><BR /><SPAN>What process steps&nbsp; and tools will produce a dataset useable for Tracking Analyst and allow easy extraction of the temporal component from the Point MZ data?&nbsp; Does this process require scripting?</SPAN><BR /><BR /><SPAN>Thank you.</SPAN></BODY></HTML> Fri, 22 Jul 2011 08:51:45 GMT MaryFricke 2011-07-22T08:51:45Z Geotools Shapefile Multipoint MZ -> ArcMap Import -> Tracking Analyst M=#QNAN https://community.esri.com/t5/arcgis-spatial-analyst-questions/geotools-shapefile-multipoint-mz-gt-arcmap-import/m-p/195440#M2772 <HTML><HEAD></HEAD><BODY><SPAN>A previous post indicated that Tracking Analyst requires point data.&nbsp; Unfortunately, the spatial database was recently converted to storing temporal data as Multipoints with Z and M values in an oracle database from a database based on points with a temporal column. The requirement is to be able to view and analyse this data in Tracking Analyst. </SPAN><BR /><BR /><SPAN>External to the ArcGIS system, GeoTools is used to generate a shapefile from a SQL Query.&nbsp; Debug inspection reveals that the data sent to the shapefile contains both the Z and M values for the points in the Multipoint array. The M value is a Long and represents the time dimension.</SPAN><BR /><BR /><SPAN>The shapefile is then loaded into ArcMap.&nbsp; Points are displayed.&nbsp; The Attribute Table indicates Shape as 'Multipoint ZM'.&nbsp; The tool Multipart to Singlepart is then used to convert the dataset to point data or Point ZM. Using arcpy, an attempt to validate and use the M-value or M-Measure indicates a #QNAN value for the M value.&nbsp; Attempts to extract the M-value into the Attibute Table using the Field Calculator yields syntactical errors.</SPAN><BR /><BR /><SPAN>What process steps&nbsp; and tools will produce a dataset useable for Tracking Analyst and allow easy extraction of the temporal component from the Point MZ data?&nbsp; Does this process require scripting?</SPAN><BR /><BR /><SPAN>Thank you.</SPAN></BODY></HTML> Fri, 22 Jul 2011 08:51:45 GMT https://community.esri.com/t5/arcgis-spatial-analyst-questions/geotools-shapefile-multipoint-mz-gt-arcmap-import/m-p/195440#M2772 MaryFricke 2011-07-22T08:51:45Z