Name: Form_3
Display Field: objectid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)
Drawing Info:
{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"ClimatePlus_4_15","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: objectid
Unique ID Field:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field:
Fields:
- objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
- Survey_desc (type: esriFieldTypeString, alias: This survey will ask you to provide basic context on your project and data on potential emissions sources from the project, including 1) combustion from heating, cooking, or the use of generators 2) vehicles, 3) flights, and 4) refrigeration and cooling. Please fill out all questions on an annual basis, entering information from the past calendar year (2020). This will guide the Climate+ Team in calculating initial emissions from your project and determine where follow-up questions may be needed. You may leave questions blank if you do not know the answer, and there will be space to provide any additional comments or clarifications at the end of the survey. Do not exit out the survey – your results will not be saved. If you run out of time or only want to complete part of the survey, please click Next until you reach the end and then click Submit. You may submit more than one survey response if needed, but if you do please ensure that you use the same project name. Please reach out to climateplus@winrock.org with any questions or concerns., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_name (type: esriFieldTypeString, alias: What is the project name?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Business_unit (type: esriFieldTypeString, alias: Business unit (if Winrock), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Accounting_admin: Accounting administration], [AGILE: AGILE], [Ag_and_Vol_programs: Agriculture and Volunteer Programs], ... 29 more ...)
- person (type: esriFieldTypeString, alias: Please enter your name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- email (type: esriFieldTypeString, alias: Please enter your email address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- title (type: esriFieldTypeString, alias: Please enter your title/role within this project, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- date_of_entry (type: esriFieldTypeDate, alias: Date of entry, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contact_person (type: esriFieldTypeString, alias: Who do we contact for more information? (if different than above), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Num_of_offices (type: esriFieldTypeInteger, alias: How many offices are involved with this project (please include main offices and field offices leased or owned by project funds), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Offices_count (type: esriFieldTypeString, alias: Offices_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_st_date (type: esriFieldTypeDate, alias: Project start date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_end_date (type: esriFieldTypeDate, alias: Project end date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_budget (type: esriFieldTypeInteger, alias: Project ceiling (USD), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Spent_to_date (type: esriFieldTypeInteger, alias: Total spent to date (USD), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Funder (type: esriFieldTypeString, alias: Project funder, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Num_staff (type: esriFieldTypeInteger, alias: Number of full-time staff for the calendar year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Fuel_desc (type: esriFieldTypeString, alias: This section covers emissions from three major sources of fuel that could be used for cooking, heating, or on-site electricity generation: diesel, natural gas, and LPG. Please enter data from the 2020 calendar year. Please note that this section does not include fuel consumption from vehicles or flights, only from project office emissions. Vehicle and flight emissions will be covered in a later section. Email climateplus@winrock.org with any questions or concerns., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Fuel_Consump_offices_count (type: esriFieldTypeString, alias: Fuel_Consump_offices_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Elec_desc (type: esriFieldTypeString, alias: This page collects information on the amount of electricity used by each office per year. If project electricity use is not from a generator (for which fuel use would be entered in the previous page), it is assumed to be from the national grid system, which will have different emissions in each country based on the national energy mix (i.e., how much hydroelectricity, coal, natural gas, etc. contribute to electricity).If you have electricity bills on a monthly basis, add them together to obtain annual kWh purchased. Please enter data from the 2020 calendar year. Email climateplus@winrock.org with any questions or concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- elec_offices_count (type: esriFieldTypeString, alias: elec_offices_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- solar_yesno (type: esriFieldTypeString, alias: Is any electricity from your project derived from solar panels?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- solar_describe (type: esriFieldTypeString, alias: Please describe:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- vehicle_desc (type: esriFieldTypeString, alias: This page collects data that will allow us to calculate emissions from vehicles. Please include any vehicles that the project owned or leased in the past calendar year. This includes automobiles, trucks, motorcycles, construction vehicles, or vehicles used in agriculture. If you do not know the fuel efficiency of the vehicle and only know the distance traveled (rather than the amount of fuel consumed), leave the fuel efficiency (mpg or l/100km) blank. Please enter data from the 2020 calendar year. Email climateplus@winrock.org with any questions or concerns., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- number_of_cars (type: esriFieldTypeInteger, alias: How many vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Cars_count (type: esriFieldTypeString, alias: Cars_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- total_car_emissions (type: esriFieldTypeDouble, alias: Total vehicle emissions, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Flights_desc (type: esriFieldTypeString, alias: This page calculates emissions from any flights for which the project paid for the ticket (i.e., if someone from a separate organization takes a flight to attend a meeting or training the project held, this information does not need to be entered below). You can enter as many separate flight routes as needed for the project. Note that if a trip has a layover, each leg of the trip must be entered as a separate flight route. For example, a trip to Dhaka from Washington D.C. that stops in Istanbul would be entered below as two separate journeys – Washington D.C. to Istanbul and Istanbul to Dhaka. If the same flight route was taken multiple times throughout the year, you can enter this as one flight and specify total number of trips taken between those locations in the appropriate box below.You can enter as many flight routes as needed for the project using the "+" at the bottom of the page. Please enter data from the 2020 calendar year. Email climateplus@winrock.org with any questions or concerns., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- cargo_yesno (type: esriFieldTypeString, alias: Does the project use any cargo flights for shipping any products?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- cargo_desribe (type: esriFieldTypeString, alias: Please explain in more detail, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- total_flight_emissions (type: esriFieldTypeDouble, alias: Total flight emissions, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Refrig_desc (type: esriFieldTypeString, alias: This page calculates emissions from refrigerants, which are substances with high global warming potentials used for cooling. Please only include equipment currently owned, leased, or purchased. For each piece of equipment using refrigerants, please enter the type of equipment (e.g., a refrigerator, cold storage, air conditioning) and the type of refrigerant used in that equipment.You can enter as many refrigeration types as needed for the project using the "+" at the bottom of the page. Email climateplus@winrock.org with any questions or concerns., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Refrigerants_count (type: esriFieldTypeString, alias: Refrigerants_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- total_refig_emission (type: esriFieldTypeDouble, alias: Total refrigerant emissions, SQL Type: sqlTypeOther, nullable: true, editable: true)
- current_waste_info (type: esriFieldTypeString, alias: What information on waste (e.g., amount of waste, where waste goes, what types of waste such as food, non-food, plastic, metals, etc are generated and how much, how often waste is generated) do you collect?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- future_waste_info (type: esriFieldTypeString, alias: What information on waste would you be willing to collect moving forward? What waste categories would be easiest to collect information on?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- Cons_efforts (type: esriFieldTypeString, alias: Is the project engaged in any conservation efforts? If so, please describe., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- tree_planting (type: esriFieldTypeString, alias: Is the project engaged in any tree planting, forest restoration, coastal management, or land management efforts? If so, please describe, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- agriculture (type: esriFieldTypeString, alias: Is the project engaged in any agricultural practices (e.g. improved tillage, applying fertilizer) that may influence the project emissions (either positively or negatively)? If so, please describe., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- other_activity (type: esriFieldTypeString, alias: Can you think of any other activity that you think would be important source of emissions to consider? If so, the Climate+ team will follow up with you., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- Hard_Easy (type: esriFieldTypeString, alias: How difficult was it to enter your information into this survey?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [very_hard: Very Difficult], [fairly_hard: Fairly Difficult], [unsure: Unsure], ... 2 more ...)
- Comments (type: esriFieldTypeString, alias: How can we improve this survey?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Relationships:
- Form_3_Offices (1) -- Related To: Offices (1)
- Form_3_Fuel_Consump_offices (2) -- Related To: Fuel_Consump_offices (2)
- Form_3_elec_offices (4) -- Related To: elec_offices (4)
- Form_3_Cars (5) -- Related To: Cars (5)
- Form_3_Flights (6) -- Related To: Flights (6)
- Form_3_Refrigerants (7) -- Related To: Refrigerants (7)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/3/2021 4:02:24 PM
Schema Last Edit Date: 5/3/2021 4:02:24 PM
Data Last Edit Date: 5/3/2021 4:02:24 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Add Features
Update Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat