Latest Contributions by EdwardGause

I am curious about the answer to this question that Masood Shaikh has asked as well. I think I had something similar happen a few years ago, but just thought I messed up somewhere along the way so I ignored it and started over with my process. After seeing this message thought, its got me wondering about the two Map Projections I was using myself. Most data we use from external sources is in NAD83 Geographic Coordinates, however since our Engineers work in NAD83 South Carolina State Plane 3901, I had converted the data to State Plane and afterwards I got different results with Moran's I. Is this because the coordinates are larger numbers than the Lat\Long coordinates. I mean Degrees are up to 3 whole number digits and the rest is fractional, where as State Plane is in the tens of thousands of feet from Origin, could this throw off the statistic? Our County is the furthest from the origin of South Carolina State Plane to the North East of the Origin. ... View more

Thank you for your response, while it was not what I wanted to hear, it at least lets me know I don't need to research this until your ESRI team upgrades the product again.  I am at least glad, that you all plan on it being in the product.  I have brought this up at the last two ESRI UC Conference, because we need it.  We are currently doing Duct Tape patching to make something useful in Power BI, by getting Centroids for the polygons, and putting a point symbol on the map and coloring the point symbol based on the data, but that is not as nice as coloring a polygon would be.  We have a lot of home-grown polygons representing anything from a Project to a Community Development\Subdivision.  And since Communities are built in phases, they tend to have different budget dollars and we want to do analysis at this phase level. Either way these don't match you standard Country, State, County, Census, Zip and City polygon layers that you do allow colorization symbolization on.   Thank you for your comment. ... View more

Yes, I would like any links to the Slim Gim Model as well. -------------------------------------------------------------------------------------------------------------------------------------------------- Robert "Edward" Gause, GISP | Director of Information Services | HTC | p 843-369-8483 | www.htcinc.net ... View more

Since Time is just an added dimension, it does not change the fact that your Explanatory Variable need to be significantly significant. Remember that OLS is a multivariable linear regression, which means it is multi-dimensional in a sense of each Explanatory Variable is on its own scale dimensionally, which doesn't have to be space and time but could be. So, yes, your p-values should still be checked for the Explanatory Variables. For you explanatory variable that is not Significantly significant, maybe you can find another variable that it shares a high Multicollinearity with your variable since these variables share the same story mathematically with your variable. Obviously, it would need to be a different variable that makes sense, but the list of variables that share high Multicollinearity with your variable that is not significant may produce one that is significant and makes sense in the model. Another thought, verify that there is a linear relationship between your in-significant variable and the Dependent, and not some quadratic relationship or other curve relationship. Maybe you need to do a transformation to flatten the relationship to linear before you put it into your linear equation. ESRI has the built-in Data Engineering Tool in ArcGIS Pro that can do transformations on variables, and you can create a new column when you do that. Disclaimer: I have never used their GTWR tool, but I have used OLS, GWR, and Exploratory Regression and built my own Multivariable Linear Regression using Matrix Math and a programming language. ... View more

I believe if you do the 6 month intervals, what you would have to do is Interpolate the values between the start of a year and the end of the year, which I think doing the average of the start and end values would be fine for the half a year Mark. Doing that would only leave Bias at the half year mark of the first year or at the half year mark of the last year depending on how you align you Time Interval dimension. So, yes you would be creating records out of thin air for data you did not have at the Half Year mark, but since you are averaging the start and end, you will get a good estimate for the Half Year mark, and that would be more accurate guess for value instead of just duplicating the value for either the beginning of the year or the end of the year. ... View more

If all you want is to see your network on a map this is core foundation to just about every product of ESRI. I am going to make an assumption that your data is in a Geodatabase. ArcGIS Pro and the older ArcMap can pull this data in from the Geodatabase simply by connecting to the database and you dragging the map layers into the map, and choosing a Basemap from several options that ESRI has. Basemaps include Aerial Imagery (photo from overhead) or a terrain map or OpenStreets map. You can also do this in ArcGIS Online but you would need to get your datasource over to ArcGIS Online either posting the layer as a hosted feature on ArcGIS Online or you will need help getting the data to feed live to ArcGIS Online. We use ArcGIS Enterprise which is the local copy of ArcGIS Online, and we have added our Geodatabase tables\layers to the ArcGIS Severs used by the ArcGIS Enterprise. We haven't did this with editable data, but you can sync that ArcGIS Enterprise dataset with ArcGIS Online for you company, and then that opens up to do what you would want to do in ArcGIS Online. ArcGIS Online is simpler for you to use once the infrastructure is in place, and opens up ESRI Field Apps, Experience Builder and Operational Dashboard to be able to use your data. Again the hard part is getting the infrastructure setup for ArcGIS Online to give you access to the underlying datasources. Recap: ArcGIS Pro and ArcMap would be quicker to get working for you if you don't have expertise in your company to get the infrastructure in place. ArcGIS Online and ArcGIS Enterprise would be easier for you to use, but you need someone to get the infrastructure setup for these and these open up all the newer mobile applications like Field Maps, Operational Dashboard, Story Maps, Survey123, Experience Builder, etc... ... View more

I need to know when, due to Monday night Julie and I are going to Tijuana, Mexico. But otherwise I am there! ... View more

I did the following MS SQL for my boundary on my database to get the vertices of a polygon:   SELECT a.OBJECTID, t.number as Vertice, a.Shape.STPointN(t.number).STX as Longitude, a.Shape.STPointN(t.number).STY as Latitude FROM DB1.sde.Boundary a JOIN (       SELECT number       FROM DB1.sde.Boundary a       join       (            SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS number            FROM master..spt_values       ) n on ( n.number BETWEEN 1 AND a.SHAPE.STNumPoints() ) where a.objectid = 401 ) t on (t.number <= a.SHAPE.STNumPoints()) where a.objectid = 401 ... View more

It will not be recorded, so you will have to be in person. I believe it will be in the Marriott hotel next to the convention center. It is a telecom presentation, so it will be in one of those. The presenter will be Adam Barrs, so you might be able to search for him on their detail agenda. ... View more

I am pretty sure it is just to optimize the algorithm by allowing the code to jump to a record of data like an index read. I feel like it comes more into play when they are calculating all the other statistics to validate if the model is a good model, but I understand why you think its not needed for the linear regression which would just need to put the data into the Matrix and then calculate an Inverse Matrix and the Transposition to then do the math, all of which would be outside of the original dataset you read in to load the Matrix. I never wrote this kind of code, but where I feel like they would use the unique id is after they did the linear regression algorithm, and then they go back through the dataset to calculate the other statistics you see in their OLS report like the Jarque Bera Statistic (if I miss spelled it sorry) just to name one. ... View more

The engineer I helped with the Vector Model Builder tool to mimic Suitability Modeler with Vector data is supposed to present at ESRI UC 2024 for one of the Telecom Presentations. Not sure the time slot just yet, but most likely it will be one of 3 presentations for the session time, so it will take a little research to figure out the class, luckily there are not a lot of Telecom classes at UC. We are from HTC (Horry Telephone Coop.). ... View more

Central Heating and BedroomNo are not statistically significant in your model, which surprises me, because I thought they always would be for the price of the apartment.  However, the fact that you have variables that are not statistically significant in your model, means it can't be fully trusted.  Look for the * for each of your variables.  You really want *** or ** over even the *, which *** is the most statistically significant.   ... View more

I believe it has to warn people that spatially you have features that is overpowering other features in your model due to so many overlapping features. You as the analysis have to decide for the problem you are dealing with, should I keep them in my model or not and I think that depends on what you are modeling. I work for a Telecommunication Company, and in my industry, most of the time I would want to treat each apartment as an individual record in my model. I mean, if I was using OLS for a Global Model, those data points definitely matter for my model I would be creating, so the fact that I am doing localized model make me think it should still matter. I mean for my business, those are different customers, who are choosing different things, so I want to include all of them. Other industries have a different set of problems that they need only one feature there, because they don't want that one geographic location to have so much weight in the model. So, I am saying, it matters what you are trying to model as to whether that is really a problem or not. ... View more

R Squared tells you how well the model of the prediction fits the actual. You want as high of an R Squared as possible. Its range should be between 0 and 1 (0% and 100%). Areas with low R squared, you can't trust the predicted raster. Areas with high R squared you can trust more. I don't know anything about RMSE for Temperature Harmonic, so I don't know how to tell you to interpret your result, but based off of the fact that you say for the harmonic that a lower value is a better fit, then I would say the purple is a bad fit, but I feel you need someone in your industry to truly answer that question, however R Squared is works just like it does for Linear Regression in how you interpret it. ... View more