Layers:

Layer: Dano_Sustancial_sde (0)

Name: Dano_Sustancial_sde

Display Field: username

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b3716e953c084b0e9332c7717f95c3ec

Copyright Text:

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -67.25292201399998
YMin: 17.937722115245606
XMax: -65.25251270699994
YMax: 18.51467109300006
Spatial Reference: 4326  (4326)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [158, 97, 53, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• uniquerowid ( type: esriFieldTypeGUID, alias: RowID, length: 38 )
• isnpectionid ( type: esriFieldTypeString, alias: Número Inspección, length: 255 )
• idtemp ( type: esriFieldTypeString, alias: idtemp, length: 255 )
• uuidfinal ( type: esriFieldTypeString, alias: uuidfinal, length: 255 )
• inspector ( type: esriFieldTypeString, alias: ID Inspector, length: 255 , Coded Values: [jusino_a@JPNTC: agu-Alex Juan Jusino Silva] , [conti_a@JPNTC: agu-Aracelis Conti Roldan] , [vazquez_d2@JPNTC: agu-Diana Vázquez Velázquez] , ...109 more... )
• username ( type: esriFieldTypeString, alias: username, length: 255 )
• tipoinspeccion ( type: esriFieldTypeString, alias: Tipo de inspección, length: 255 )
• fechainicial ( type: esriFieldTypeDate, alias: Fecha Visita, length: 8 )
• estatusinsp ( type: esriFieldTypeString, alias: Estatus de la Inspección, length: 255 , Coded Values: [Pendiente Visita: Pendiente Visita] , [En Análisis: En Análisis (Inspeccionando)] , [Determinación Realizada: Determinación Realizada] , ...2 more... )
• comentvisita ( type: esriFieldTypeString, alias: Comentario de la visita, length: 1073741822 )
• dueno ( type: esriFieldTypeString, alias: Nombre del Dueño, length: 255 )
• telefono ( type: esriFieldTypeString, alias: Teléfonos, length: 255 )
• email ( type: esriFieldTypeString, alias: Correo Electrónico, length: 255 )
• placename ( type: esriFieldTypeString, alias: Sector, Comunidad o Nombre Lugar, length: 255 )
• streetnumber ( type: esriFieldTypeString, alias: Número de Casa o PO BOX, length: 255 )
• streetname ( type: esriFieldTypeString, alias: Calle, length: 255 )
• municipio ( type: esriFieldTypeString, alias: Municipio, length: 255 , Coded Values: [Adjuntas: Adjuntas] , [Aguada: Aguada] , [Aguadilla: Aguadilla] , ...75 more... )
• stateid ( type: esriFieldTypeString, alias: País, length: 255 )
• zipcode ( type: esriFieldTypeString, alias: Código Postal, length: 255 )
• sameaddress ( type: esriFieldTypeString, alias: Es la postal igual a la física, length: 255 , Coded Values: [yes: Yes] , [no: No] )
• mailingownerfirstname ( type: esriFieldTypeString, alias: Nombre, length: 255 )
• mailingownerlastname ( type: esriFieldTypeString, alias: Apellido, length: 255 )
• mailing_placename ( type: esriFieldTypeString, alias: Sector, Comunidad o Nombre Lugar, length: 255 )
• mailing_streetnumber ( type: esriFieldTypeString, alias: Número de Casa o PO BOX, length: 255 )
• mailing_streetname ( type: esriFieldTypeString, alias: Calle, length: 255 )
• municipio_postal ( type: esriFieldTypeString, alias: Municipio Postal, length: 255 , Coded Values: [Adjuntas: Adjuntas] , [Aguada: Aguada] , [Aguadilla: Aguadilla] , ...75 more... )
• mailing_stateid ( type: esriFieldTypeString, alias: País Postal, length: 255 )
• mailing_zipcode ( type: esriFieldTypeString, alias: Código Postal, length: 255 )
• qc_tipo_structura ( type: esriFieldTypeString, alias: Structure Type, length: 255 , Coded Values: [Residencial: Residencial] , [No Residencial: Non Residencial] )
• costo_base ( type: esriFieldTypeInteger, alias: Base Cost )
• range_deprec ( type: esriFieldTypeString, alias: Rango Depreciación, length: 255 , Coded Values: [1 - Very Poor Condition: 1 - Very Poor Condition] , [2 - Requires Extensive Repairs: 2 - Requires Extensive Repairs] , [3 - Requires Some Repairs: 3 - Requires Some Repairs] , ...3 more... )
• cantidad_pisos ( type: esriFieldTypeString, alias: Cantidad de Pisos, length: 255 , Coded Values: [Un piso: Un piso] , [Dos a cuatro: Dos a cuatro] , [Cinco o mas: Cinco o mas] )
• tipo_residencia ( type: esriFieldTypeString, alias: Tipo Residencia, length: 255 , Coded Values: [Unifamiliar: Unifamiliar] , [Casa en Hilera: Casa en Hilera] , [Prefabricada: Prefabricada] )
• foundation_zapata ( type: esriFieldTypeString, alias: Zapata (foundation), length: 255 , Coded Values: [Pared continua con losa (estándar): Pared continua con losa (estándar)] , [Sótano: Sótano] , [Espacio de arrastre: Espacio de arrastre] , ...3 more... )
• superstructuretypeid ( type: esriFieldTypeString, alias: Super-Estructura, length: 255 , Coded Values: [Enmarcado por el Perno (stud frame): Enmarcado por el Perno (stud frame)] , [Ladrillo Común (common Brick: Ladrillo Común (common Brick] , [Concreto Aislante (ICF): Concreto Aislante (ICF)] , ...1 more... )
• roofcoveringtypeid ( type: esriFieldTypeString, alias: Cubierta Techo, length: 255 , Coded Values: [Madera: Madera (Shingles-Ashpalt, Wood)] , [Tejas: Tejas (Clay Tile)] , [Metal: Metal (SatandingSeamMetal)] , ...1 more... )
• exteriorfinishtypeid ( type: esriFieldTypeString, alias: Acabado Exterior, length: 255 , Coded Values: [Revestimiento o estuco (estándar): Revestimiento o estuco (estándar)] , [Revestimiento de Ladrillo: Revestimiento de Ladrillo] , [EIFS (sistema de acabado de aislamiento): EIFS (sistema de acabado de aislamiento)] , ...1 more... )
• hvactypeid ( type: esriFieldTypeString, alias: HVAC Sistema, length: 255 , Coded Values: [HeatingCooling: Heating and/or Cooling] , [None: None] )
• categoryuse ( type: esriFieldTypeString, alias: Uso Estructura, length: 255 , Coded Values: [Apartments: Apartments] , [Auditorium: Auditorium] , [Commercial Retail: Commercial Retail] , ...21 more... )
• tiene_rociadores ( type: esriFieldTypeString, alias: Tiene Rociadores?, length: 255 , Coded Values: [yes: Yes] , [no: No] )
• conveyance ( type: esriFieldTypeString, alias: Transporte (conveyance), length: 255 , Coded Values: [yes: Yes] , [no: No] )
• buildingcondition ( type: esriFieldTypeString, alias: Condición Estructura (Quality), length: 255 , Coded Values: [Pobre: Pobre] , [Presupuesto: Presupuesto] , [Regular: Regular] , ...2 more... )
• contador_aaa ( type: esriFieldTypeString, alias: AAA Meter Number, length: 255 )
• qc_struc_info ( type: esriFieldTypeString, alias: Información de la Estructura, length: 3000 )
• tipoevento ( type: esriFieldTypeString, alias: Tipo Evento, length: 255 , Coded Values: [Sequía: Sequía] , [Terremoto: Terremoto] , [Explosión: Explosión] , ...17 more... )
• evento_principal ( type: esriFieldTypeString, alias: Nombre Evento, length: 255 )
• marca_agua ( type: esriFieldTypeString, alias: marca_agua, length: 255 )
• marca_pies ( type: esriFieldTypeInteger, alias: Marca Agua Pies )
• marca_pulgadas ( type: esriFieldTypeInteger, alias: Marca Agua Pulgadas )
• fecha_dano ( type: esriFieldTypeDate, alias: Fecha Ocurrio Daño, length: 8 )
• causadano ( type: esriFieldTypeString, alias: Causa de los Daños, length: 255 )
• causa_inundacion ( type: esriFieldTypeString, alias: Causa de la Inundación, length: 255 , Coded Values: [Lluvia-Alcantarilla Tapada: Lluvia-Alcantarilla Tapada] , [Lluvia-Agua Estancada: Lluvia-Agua Estancada] , [Tuberia Rota: Tuberia Rota] , ...3 more... )
• zona_inundable ( type: esriFieldTypeString, alias: Flood Zone, length: 255 )
• zona_inund_advisory ( type: esriFieldTypeString, alias: Advisory Flood Zone, length: 255 )
• panel ( type: esriFieldTypeString, alias: Flood Panel, length: 255 )
• calificacion ( type: esriFieldTypeString, alias: Qualification, length: 255 )
• num_catastro ( type: esriFieldTypeString, alias: Parcel Number, length: 255 )
• cordenadas_lambert ( type: esriFieldTypeString, alias: Lambert, length: 255 )
• latitude ( type: esriFieldTypeString, alias: Latitude, length: 255 )
• longitud ( type: esriFieldTypeString, alias: Longitude, length: 255 )
• permisos ( type: esriFieldTypeString, alias: Permits, length: 255 )
• forma_estruc_medidas ( type: esriFieldTypeString, alias: Seleccione Forma Estructura, length: 255 , Coded Values: [l: Tipo L] , [t: Tipo T] , [r: Tipo R] , ...1 more... )
• lengtha ( type: esriFieldTypeInteger, alias: Largo A (LA) )
• lengthb ( type: esriFieldTypeInteger, alias: Largo B (LB) )
• lengthc ( type: esriFieldTypeInteger, alias: Largo C (LC) )
• lengthd ( type: esriFieldTypeInteger, alias: Largo D (LD) )
• widtha ( type: esriFieldTypeInteger, alias: Ancho A (WA) )
• widthb ( type: esriFieldTypeInteger, alias: Ancho B (WB) )
• widthc ( type: esriFieldTypeInteger, alias: Ancho C (WC) )
• widthd ( type: esriFieldTypeInteger, alias: Ancho D (WD) )
• storiesa ( type: esriFieldTypeInteger, alias: Pisos A (PA) )
• storiesb ( type: esriFieldTypeInteger, alias: Pisos B (PB) )
• storiesc ( type: esriFieldTypeInteger, alias: Pisos C (PC) )
• qc_costo ( type: esriFieldTypeString, alias: qc_costo, length: 255 )
• costo_valor_mercado ( type: esriFieldTypeString, alias: costo_valor_mercado, length: 255 )
• costo_remplazo_sde ( type: esriFieldTypeInteger, alias: Replacement Cost )
• costo_danos_computado ( type: esriFieldTypeDouble, alias: Computed Damages )
• costo_actual_cash ( type: esriFieldTypeInteger, alias: Costo Actual Cash Computado )
• deprec_porciento ( type: esriFieldTypeDouble, alias: Depreciación Porciento )
• pd_foundation ( type: esriFieldTypeInteger, alias: Foundation )
• pd_superstructure ( type: esriFieldTypeInteger, alias: Superstructure )
• pd_roof_cover ( type: esriFieldTypeInteger, alias: Roof Covering )
• pd_exterior_finish ( type: esriFieldTypeInteger, alias: Exterior Finish )
• pd_doors_windows ( type: esriFieldTypeInteger, alias: Doors and Windows )
• pd_cabinets_counter ( type: esriFieldTypeInteger, alias: Cabinets and Countertops )
• pd_floor_finish ( type: esriFieldTypeInteger, alias: Floor Finish )
• pd_plumbing ( type: esriFieldTypeInteger, alias: Plumbing )
• pd_electrical ( type: esriFieldTypeInteger, alias: Electrical )
• pd_appliances ( type: esriFieldTypeInteger, alias: Appliances )
• pd_interior_finish ( type: esriFieldTypeInteger, alias: Interior )
• pd_hvac ( type: esriFieldTypeInteger, alias: HVAC )
• dsustancial ( type: esriFieldTypeString, alias: Sustancial Damage?, length: 255 , Coded Values: [yes: Yes] , [no: No] )
• qc_percent_damage ( type: esriFieldTypeString, alias: Percent of Damage, length: 255 )
• qc_comments ( type: esriFieldTypeString, alias: QC comments, length: 3000 )
• reg_funcional ( type: esriFieldTypeString, alias: Region Funcional, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• costo_remplazo_sde2 ( type: esriFieldTypeDouble, alias: Replacement Cost )
• costo_actual_cash2 ( type: esriFieldTypeDouble, alias: Costo Actual Cash Computado )
• shape ( type: esriFieldTypeGeometry, alias: shape )
• objectid ( type: esriFieldTypeOID, alias: ObjectID )
• region_ogpe ( type: esriFieldTypeString, alias: Region Ogpe, length: 255 )
• direccion ( type: esriFieldTypeString, alias: Direccion Crim, length: 255 )
• direccion_postal ( type: esriFieldTypeString, alias: Direccion Postal Crim, length: 255 )
• analizado ( type: esriFieldTypeString, alias: analizado, length: 255 )

Relationships:

• Dano_Sustancial_v2_fotossdd (0) -- Related To: fotossdd (3)
• Dano_Sustancial_v2_inspecciones (1) -- Related To: inspecciones (4)
• Dano_Sustancial_v2_documentossde (2) -- Related To: documentossde (2)

Tables:

Table: documentossde (2)

Name: documentossde

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: b3716e953c084b0e9332c7717f95c3ec

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• parentrowid ( type: esriFieldTypeGUID, alias: ParentRowID, length: 38 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• objectid ( type: esriFieldTypeOID, alias: ObjectID )

Relationships:

• Dano_Sustancial_v2_documentossde (2) -- Related To: Dano_Sustancial_sde (0)

Table: fotossdd (3)

Name: fotossdd

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: b3716e953c084b0e9332c7717f95c3ec

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• parentrowid ( type: esriFieldTypeGUID, alias: ParentRowID, length: 38 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• objectid ( type: esriFieldTypeOID, alias: ObjectID )

Relationships:

• Dano_Sustancial_v2_fotossdd (0) -- Related To: Dano_Sustancial_sde (0)

Table: inspecciones (4)

Name: inspecciones

Display Field: fecha_inspeccion

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: b3716e953c084b0e9332c7717f95c3ec

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• fecha_inspeccion ( type: esriFieldTypeDate, alias: Fecha Inspeccion, length: 8 )
• tipo_inspeccion ( type: esriFieldTypeString, alias: Selecione Tipo, length: 255 , Coded Values: [Dañó: Dañó] , [Mejora: Mejora] )
• evento ( type: esriFieldTypeString, alias: evento, length: 255 )
• porciento_dano ( type: esriFieldTypeString, alias: Porciento Dañó, length: 255 )
• muniinspc ( type: esriFieldTypeString, alias: muniinspc, length: 255 )
• hallazgos ( type: esriFieldTypeString, alias: Hallazgos, length: 3000 )
• num_catastro_insp ( type: esriFieldTypeString, alias: num_catastro_insp, length: 255 )
• costo_insp ( type: esriFieldTypeString, alias: Costo, length: 255 )
• parentrowid ( type: esriFieldTypeGUID, alias: ParentRowID, length: 38 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• objectid ( type: esriFieldTypeOID, alias: ObjectID )

Relationships:

• Dano_Sustancial_v2_inspecciones (1) -- Related To: Dano_Sustancial_sde (0)