Australian Community Energy PUBLIC DATA
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
AB
1
Mapping data managed by Community Power Agency.

www.cpagency.org.au/map

email: info@cpagency.org.au
2
How does it work?

A Google Sheets add-on pulls data from it's home in Community Power Agency's Salesforce database. This is a manual process, requiring a member of the Community Power Agency team to trigger the update.

The resulting update will be reflected in the spreadsheet and the map immediately.
3
SOSQL Query:
SELECT
Id,
Name,
Group_Status__c,
Group_Project_Count__c,
Group_Installed_Capacity__c,
Group_Suburb_Town__c,
City_vs_Regional__c,
Group_State__c,
Group_URL__c,
Group_Federal_Electorate__r.name,
Federal_MP__c,
Federal_MP_Party__c,
Group_Geolocation__Latitude__s,
Group_Geolocation__Longitude__s,
CreatedDate,
LastModifiedDate
FROM CE_Group__c
4
Salesforce connector (add-on)G-Connector for Salesforce
5
Mapping solution (add-on)GeoSheets for Google Sheets
6
7
8
9
10
11
12
Loading...
 
 
 
group data notes
group data
group mapping data
Project Sites data notes
Project Sites data
Project Sites mapping data