I inform you that I am an intermediate user of arcgis for desktopArcMap (version 10x), and the process that I do manually is:
When operated manually,I I select the records in the table with data from the real estate market and the relationship automatically selected table records in the feature class "parcels" (with the same number) and, from this selection I create a new layer representing the parcels of the city about which you have a real estate information.
Well, atAt this point, the result is satisfactory, the problem I have is when I want to automate the process with model builderModelBuilder, especially when trying to relate the tables, as the relationship does not appear as a tool in arc-toolbox It is about this thatArcToolbox
How do I consulted, how to implement the process described in model builder?
Thank you very much for any help you can offer me, and sorry for my bad english. Robert.
In spanish:
Estimados: les informo que soy un usuario intermedio del arcgis for desktop (version 10x),y el proceso que hago manualmente es el siguiente:
relaciono la tabla de una feature class (que representa las parcelas -division catastral- de una ciudad) con otra tabla que contiene datos del mercado inmobiliario (ofertas de venta , de resultados remates de inmuebles , registros de valores de venta efectivamente realizadas). El campo en común que uso para la relación es el número de padrón de la parcela , y uso la relación de tablas porque es una relación de uno a muchos.
Cuando opero manualmente , selecciono los registros de la tabla con datos del mercado inmobiliario y por la relación de tablas automáticamente se seleccionan los registros en la feature class "parcelas" (con igual número de padrón) y, a partir de esta selección creo un nuevo layer que representa a las parcelas de la ciudad acerca de las que se tiene alguna información inmobiliaria. Bueno, hasta este punto, el resultado es satisfactorio; el problema lo tengo cuando quiero automatizar el proceso con model builder, especialmente cuando intento relacionar las tablas , ya que la relación de tablas no aparece como herramienta.
Es acerca de esto que les consulto , o sea , cómo se puede implementar el proceso descripto en model builder ModelBuilder?
Muchas gracias por la ayuda que me puedan ofrecer.
Atentamente, Robert. **I'llI'll try to explain better:I have a shapefile and its attribute table ("table "1") has a field called "padron" whose number identifies each parcel.Also I have a table (table "2") with real estate market's data relating the price of homes for sale with the registration number of the parcel (field called "padron" too). Sometimes, it may be that there are several houses in a parcel (therefore with the same number in "padron"). In this cases, in the table "2" each house is identified with a different record's number in a field called "UNIDAD". For example: Shapefile attribute table ("1"):
When I do (manually in ArcMap) a "relate" ( notes that the relation is one to many) betwen the layer of shapefile and the table "2" , finally I can export the selected features and finally get a new layer with all data, including the same PADRON values and different records in each UNIDAD. But, I could not do this procedure (relate tables and export new layer) in the ModelBuilder. I could make a join , but this tool not maintain all records where there are several houses on the same parcel (same "padron"'s record and different "unidad"'s record). I hope it's more clear the problem I have Thanks for all the help you can give.**
