Name: XYall_glri_projects_20200124_gdit
Display Field:
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
Description: <div><p style="margin-top:0px; margin-bottom:1.5rem; font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;">This point feature class represents the symbolic location (and attribute table records) of all Great Lakes Restoration Initiative projects funded since the program's inception in 2010 through September 30, 2019. It was derived from source data provided in *.xlsx spreadsheet format via https://glri.us/projects accessed on 16 July, 2020.</p><p style="margin-top:0px; margin-bottom:1.5rem; font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;">Source data: all_glri_projects_20200124.xlsx</p><p style="margin-top:0px; margin-bottom:1.5rem; font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;">The intended purpose of this data is to provide a feature class layer representing all GLRI projects for the AGOL web map application 'GLRI Coastal Wetland Monitoring Program Web Map Application' for public viewing.</p><p style="margin-top:0px; margin-bottom:1.5rem; font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;"><b>Post-Processing:</b> Source data required removal of multiple delimiters found embedded in the attribute fields 'Project Title' and Project Description,' possibly introduced during the record import or upload process by grantees from content originally documented using word processing software. In addition, it was necessary to replace missing minus signs in front of the longitude values for two records so feature locations were displayed in proximity to the Great Lakes region. Attribute names (column headers or field names) were modified in abbreviated form to conform to the 10 character limit required by the file geodatabase format. Two additional attributes (columns) were added to the attribute table to include search terms to allow records to be filtered based on whether the words 'coast' or 'wetland' were included in the project title or project description - and with the intended purpose of creating a means to select a subset of all GLRI projects with titles and descriptions indicating that the project included efforts focusing on coastal wetlands in context of restoration, enhancement, protection or monitoring. Data records were exported from their native *.xlsx format to CSV format, then imported into a geodatabase table to maintain the full string of text (>255 characters) included in the 'Project Description' column. A file geodatabase feature class was created using the 'make x-y event layer' (based on the latitude and longitude coordinates) and the 'feature class to feature class' tool sets. All coordinates were presumed to be representative of WGS 1984 geographic coordinate system.</p><p style="margin-top:0px; margin-bottom:1.5rem; font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;"><b>Feature Class Attribute Explanations:</b><br /></p></div><div><ul><li><b>Funder:</b> the Federal agency managing the project.</li><li><b>Year:</b> the fiscal year in which the project funding was appropriated.</li><li><b>GLRI Amount (GLRIAmount):</b> the dollar amount of the GLRI funding the project received for the given fiscal year.</li><li><b>Project Type (ProjType):</b> project funding or scope types: new, continuation, etc. "Continuation" means incremental funding of an on-going project. "Increase" means an increase in funding. “Revision” means a change in the scope and/or a decrease in the funding.</li><li><b>Project Title (ProjTitle): </b>the official title of the project.</li><li><b>Project Description (ProjDesc):</b> a short description of the project, such as who is going to do what and where.<br /></li><li><b>InCoast (Includes Coast):</b> represents 'Yes' or 'No' values where 'Yes' indicates that the term 'coast' was included in the Project Title or Project Description attribute fields.</li><li><b>InWetland (Includes Wetland):</b> represents 'Yes' or 'No' values where 'Yes' indicates that the term 'wetland' was included in the Project Title or Project Description attribute fields.</li><li><b>Recipient Name (RcpntName):</b> the organization actually doing the work for the identified project.</li><li><b>Focus Area (FocusArea):</b> the Action Plan focus area under which the project line is funded.</li><li><b>Project Start Date (ProjStDate): </b>the date that the project began or is planned to begin.</li><li><b>Project End Date (ProjEnDate):</b> the date that the project work ended or is planned to end.</li><li><b>Affected States (AffStates):</b> the state(s) in which the project takes place.</li><li><b>Latitude:</b> North-south (Y) coordinate in decimal degrees (DD) representing the WGS 1984 geographic coordinate system.</li><li><b>Longitude:</b> East-west (X) coordinate in decimal degrees (DD) representing the WGS 1984 geographic coordinate system.</li></ul><div><b>NOTE: The combination of latitude and longitude represent the feature's location as submitted by grant recipients, and may not represent the actual location of the project(s) as described in the 'project description.'</b><br /></div></div>
Copyright Text: https://glri.us/projects accessed on 16 July, 2020, Great Lakes Restoration Initiative, GLRI, USEPA, GLRI.US, GDIT
Min. Scale: 36978596
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -10576670.7613269
YMin: 4442009.22421454
XMax: -8209655.26288292
YMax: 6134071.43664254
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- Funder (type: esriFieldTypeString, alias: Funder, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- RecNum (type: esriFieldTypeInteger, alias: RecNum, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Year_ (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GLRIAmount (type: esriFieldTypeDouble, alias: GLRIAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ProjType (type: esriFieldTypeString, alias: ProjType, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- ProjTitle (type: esriFieldTypeString, alias: ProjTitle, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- ProjDesc (type: esriFieldTypeString, alias: ProjDesc, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- IncCoast (type: esriFieldTypeString, alias: IncCoast, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- IncWetland (type: esriFieldTypeString, alias: IncWetland, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- RcpntName (type: esriFieldTypeString, alias: RcpntName, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- FocusArea (type: esriFieldTypeString, alias: FocusArea, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- ProjStDate (type: esriFieldTypeDate, alias: ProjStDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ProjEnDate (type: esriFieldTypeDate, alias: ProjEnDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- AffStates (type: esriFieldTypeString, alias: AffStates, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- XYAdjNeed (type: esriFieldTypeString, alias: XYAdjNeed, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- AdjLat (type: esriFieldTypeString, alias: AdjLat, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- AdjLon (type: esriFieldTypeString, alias: AdjLon, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/4/2020 9:29:22 PM
Schema Last Edit Date: 8/4/2020 9:29:22 PM
Data Last Edit Date: 8/4/2020 9:29:22 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat