Land and Water Access and Protection
Arizona, one of the most rapidly growing states in the country, is also one of the nation’s leaders in the conversion of agricultural land to primarily urban/highly developed and low-density residential uses. The state is also facing an impending water crisis, most recently felt by cutbacks to its share of water from the Colorado River, which supplies over a third of the state’s water. Now more than ever, the value of preserving land and water for agriculture should be at the forefront of the minds and hearts of policymakers and citizens alike. Although the issues of land and water are often complex, we are encouraged by the budding opportunities to work together on the issues step by step.
The land and water access and protection priority area has three objectives. Explore the indicators we are tracking for each objective below. The stages of change model is used to describe the progress on each objective of the food action plan.
We are asking AZFSN partners to help us gather and collect data across the state to help track and monitor the progress of the food action plan.
Objective 1:
Facilitate / develop five trainings and/or resources focused on easing barriers to land access for the next generation of farmers.
google.charts.load(“current”, { packages: [“timeline”] });
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var container = document.getElementById(“example2.1”);
var chart = new google.visualization.Timeline(container);
var query = new google.visualization.Query(
“https://docs.google.com/spreadsheets/d/1x04fW6pC0-EANHW5bTotamLGBxAFWdBOAE64RmAujMs/gviz/tq?sheet=Indicator4&tq=”
); // Replace with your Google Sheet URL
// Add ‘format date’ option to parse real dates
query.setQuery(
‘SELECT A, B, toDate(C), toDate(D) LABEL toDate(C) “”, toDate(D) “”‘
);
query.send(handleQueryResponse);
function handleQueryResponse(response) {
if (response.isError()) {
console.error(
“Error in query: ” +
response.getMessage() +
” ” +
response.getDetailedMessage()
);
return;
}
var options = {
colors: [“#b8216f”, “#Ffbe55”, “#98cd58”],
};
var dataTable = response.getDataTable();
chart.draw(dataTable, options);
}
}
Training 1Training 2Training 3Training 4Training 5Jan 2023AprJulOctJan 2024AprJulOctNot St…In ProcessCompletedNot StartedIn ProcessNot StartedI..CompletedNot StartedIn ProcessNot Started
Status: Action
Description: AZFSN will partner with individuals and organizations that specialize in farmland preservation to offer workshops, webinars, and/or toolkits on land access.
- Training 1: AZ Good Food Forum and Expo
- Training 2: Training with AZ Land and Water Trust
- Training 3: Northern Arizona Farmer and Rancher Resource Fair
- Training 4: Strategies for Acquiring or Leasing Land
Data Source: AZFSN members. Progress (not started, in process, completed) on each training/resource is indicated.
Objective 2:
Engage twenty food producers to implement or improve water-efficient agricultural practices to reduce demand on limited water supply.
Cumulative TotalGoal0510152025308Goal 20 ProducersGoal 20 ProducersProgress to DateCumulative Total of Producers
Status: Action
Description: Provide resources such as funding, trainings, and technical assistance to food producers that enable them to increase water conservation efforts.
Data Source: Number of producers who have implemented water conservation practices, reported by AZFSN members.
google.charts.load(“current”, {
packages: [“corechart”],
});
google.charts.setOnLoadCallback(drawChartTwo);
function drawChartTwo() {
var queryString = encodeURIComponent(
“SELECT A, B, C, D, E WHERE YEAR(A) = 2023 OR YEAR(A) = 2024”
);
console.log(“Query string:”, queryString); // Log query string
var query = new google.visualization.Query(
“https://docs.google.com/spreadsheets/d/1x04fW6pC0-EANHW5bTotamLGBxAFWdBOAE64RmAujMs/gviz/tq?sheet=Indicator5&tq=” +
queryString
);
query.send(handleSampleDataQueryResponse);
}
function handleSampleDataQueryResponse(response) {
if (response.isError()) {
console.error(
“Error in query: ” +
response.getMessage() +
” ” +
response.getDetailedMessage()
);
alert(
“Error in query: ” +
response.getMessage() +
” ” +
response.getDetailedMessage()
);
return;
}
console.log(“Query response received”); // Log when response is received
writeChart(response.getDataTable());
}
function writeChart(data) {
console.log(“Writing chart with data:”, data); // Log the data received
var tt = new google.visualization.DataTable();
tt.addColumn(“date”, “Date”);
tt.addColumn(“number”, “Weight”);
tt.addColumn({
type: “string”,
role: “annotation”,
});
tt.addColumn({
type: “string”,
role: “tooltip”,
p: {html: true}
});
tt.addColumn({
type: “string”,
role: “style”,
});
for (var i = 0; i < data.getNumberOfRows(); i++) {
var row = [];
row[0] = data.getValue(i, 0); // Date
row[1] = data.getValue(i, 1); // Weight
row[2] = data.getValue(i, 2) ? data.getValue(i, 2).toString() : null; // Annotation
row[3] = data.getValue(i, 3) ? "
” + data.getValue(i, 3).toString() + “
” : null; // HTML Tooltip
row[4] = data.getValue(i, 4) ? data.getValue(i, 4).toString() : null; // Style
tt.addRow(row);
}
var options = {
title: “Timeline of Funding Accumulated”,
hAxis: {
format: “MMM yyyy”,
gridlines: {
color: “transparent”,
},
},
vAxis: {
title: “”,
gridlines: {
color: “transparent”,
},
textPosition: “none”,
baselineColor: “#000000”,
baselineWidth: 2,
},
legend: “none”,
annotations: {
textStyle: {
fontSize: 12,
color: “black”,
},
stem: {
length: -25,
},
highContrast: true,
},
pointSize: 12,
backgroundColor: “#f5f5f5”,
tooltip: {isHtml: true} // Use HTML tooltips
};
var chart = new google.visualization.ScatterChart(
document.getElementById(“chart_div”)
);
var ticks = [];
for (var year = 2023; year <= 2025; year++) {
for (var month = 0; month < 12; month += 3) {
var date = new Date(year, month, 1);
var label = "Q" + Math.floor(month / 3 + 1) + " " + year;
ticks.push({
v: date,
f: label,
});
}
}
options.hAxis.ticks = ticks;
google.visualization.events.addListener(chart, "ready", function () {
Array.prototype.forEach.call(
document.getElementById("chart_div").getElementsByTagName("text"),
function (text, index) {
if (text.getAttribute("text-anchor") === "middle") {
text.setAttribute("fill", "black");
}
}
);
});
console.log("Drawing chart"); // Log before drawing the chart
chart.draw(tt, options);
}
Timeline of Funding AccumulatedQ1 2023Q2 2023Q3 2023Q4 2023Q1 2024Q2 2024Q3 2024Q4 2024Q1 2025Q2 2025Q3 2025Q4 20252/28: 7 Producers Engaged2/28: 7 Producers Engaged12/23: 1 Producer Engaged12/23: 1 Producer Engaged
Objective 3:
Increase the number of state and local policies passed that protect and preserve agricultural land and water for smaller famers and food producers.
google.charts.load(“current”, { packages: [“corechart”] });
google.charts.setOnLoadCallback(drawChart6);
function drawChart6() {
var query = new google.visualization.Query(
“https://docs.google.com/spreadsheets/d/1x04fW6pC0-EANHW5bTotamLGBxAFWdBOAE64RmAujMs/gviz/tq?gid=1286995380&headers=1”
);
query.send(handleQueryResponse6);
}
function handleQueryResponse6(response) {
if (response.isError()) {
console.error(
“Error in query: ” +
response.getMessage() +
” ” +
response.getDetailedMessage()
);
return;
}
var data = response.getDataTable();
var transformedData = new google.visualization.DataTable();
transformedData.addColumn(“string”, “Quarters”);
transformedData.addColumn(“number”, “Producers”);
transformedData.addColumn({ type: “string”, role: “annotation” });
transformedData.addColumn({ type: “string”, role: “tooltip” });
// Dynamically add rows based on the data from the spreadsheet
for (var i = 0; i < data.getNumberOfRows(); i++) {
transformedData.addRow([
data.getValue(i, 0), // Quarter
data.getValue(i, 1), // Value
data.getValue(i, 2), // Label
data.getValue(i, 3), // Tooltip
]);
}
formatHAxisLabels(transformedData); // Call the formatting function
var options = {
title: null,
backgroundColor: "#f5f5f5",
hAxis: {
title: null,
},
vAxis: {
title: "Number of Policies Passed",
minValue: 1,
gridlines: {
color: "#f5f5f5",
},
},
legend: { position: "none" },
lineWidth: 0,
pointSize: 11,
pointShape: "circle",
series: {
0: {
color: "#3b9825",
},
},
annotations: {
alwaysOutside: true, // Display outside the chart area
textStyle: {
fontSize: 12,
color: "#000",
auraColor: "none",
},
},
chartArea: {
left: "10%",
top: "10%",
width: "90%",
height: "70%", // Adjusted to leave more space at the bottom
},
};
var chart = new google.visualization.LineChart(
document.getElementById("line_chart_div6")
);
chart.draw(transformedData, options);
}
// The new function to format hAxis labels
function formatHAxisLabels(dataTable) {
for (var i = 0; i < dataTable.getNumberOfRows(); i++) {
var originalLabel = dataTable.getValue(i, 0);
var newLabel = "\n" + originalLabel; // Add two new lines to push the label down
dataTable.setFormattedValue(i, 0, newLabel);
}
}
Q1 2023Q2 2023Q3 2023Q4 2023Q1 20240.00.20.40.60.81.000010Number of Policies Passed
Status: Contemplation
Description: Local and regional coalitions will track local policies related to land and water, including through city general plans.
Data Source: Number of poliies reported by AZFSN members.
