Latest Contributions by FlorianPattis

UPDATE: I tried to do the same task in the ArcGis 9.3 Version and it worked correct. There are no values with -1170 in the zonal statistics table so i think this is a bug in the Arcgis10 Version. ... View more

Hello again..i tried it with the setNull Method but i cant get the values of the single cells out of the where clause. When i look into the attribute table of the layer there is only one value specified. How can i get the values of each cell to see if the value is "-9999" so that i can change it into "0". In the attachement there is the layer and the attributetable, the nodata fields are filled red. ... View more

I tried it with resampling and it gives more "realistic" values. But when i compare the values from the zonaltable without resampling with the zonaltable with resampling i noticed that the the values are totally different. my idea is that the zonal statistic doesnt get the novaluedata-information correct from the raster and thats why it gives -1170. In my raster the nodatavalues are marked with -9999. i tried both ways with the ignore-nodata-button but it didnt change the result. Is it possible that he doesnt detect the nodata values? thanks for ur help! heres the table with resampling [ATTACH=CONFIG]12434[/ATTACH] ... View more

What license level do you have?  If you have an ArcInfo license you could instead Append all of the tables together and use the Pivot Table tool to create the columns.  The appended tables would each need a numeric field with field the name that you want.  The value in the field would be the number of the output column you want for each table (i.e., the first hour table would have a value of 1, the seccond would have a 2, etc.).  The only pain of the Pivot Table tool is that the number value is treated like a string, so 1 is followed by 10, by 100, by 1000, and then 11.  That could be overcome by adding 10000 to all numbers, which would properly sort out as FIELD10001, FIELD10002, etc. I expect you will have problems getting a table to work with 8760 columns.  Shapefiles won't work with that many columns.  I'm not sure what the limit is for the various geodatabases. I have a ArcView License, but maybe there is a chance (since i am a student and using the program for my diploma thesis) to get the ArcInfo license. Ok since i have read that there might be a problem working with so many columns, i thought that maybe im using the Arcgis program only to generate the files and then do further calculation with Matlab. Since i am a beginner with Arcgis and i just started a month ago to work with this program i want to ask if its actually possible to realize the model i have in mind with Arcgis. My input data consists of a XY-Table with Photovoltaics (Zip-Code, PeakPower...), NC-Files of Solar Irradiance(hourly means) and NC-Files of Temperature(daily means). The goal of my model is to get the Energy produced within one year (and later on for more years, i have input data for 30 years) and validate this with energy-values submitted to the electricity-stock exchange. My idea is to do this with Arcgis as far as possible. Since there is a lot of output data i need to minimize the number of files, thats why i want to put as much columns as possible in one file (any maybe do the calculation with matlab). Here is a picture of my model up to now ( i splitted it in two models to test the functionality): model1 does the spatial joins so i have a output class with the Photovoltaics (ZIP-Code ,Peak Power) joined with the Irradiance and the Temperature. model2 does the addField and CalculateField part and exports it to an Ascii File. [ATTACH=CONFIG]11355[/ATTACH] [ATTACH=CONFIG]11356[/ATTACH] Do you think its possible to realize these steps for more input data? Thanks in advance for your help i appreciate it. ... View more

Yes thats right, one field in many shapefiles. So what i need to do is to extract this field called Leistung from all the shapefiles and put it together in only one file, because i need to do further calculations with another program. The aim is to avoid that i have thousands of shapefiles on my computer. for example: if i do the calculation for one year, and the input values are given hourly i have 8760 output files, so i wanted one file with 8760 colums instead. i hope this is more understandable. I tried to draw a schematic maybe it helps to explain my problem! [ATTACH=CONFIG]11289[/ATTACH] ... View more

Thank you for your help..it took me some time to figure it out but now it works! ... View more