Energy
18 columns
150 rows
8 formats

Geographic Information System (GIS) Asset Locations

This dataset provides detailed geospatial and operational information for utility assets such as poles, towers, underground cables, manholes, and pad-mounted equipment. It enables precise mapping, network connectivity analysis, and outage management planning for utility infrastructure, supporting both operational efficiency and strategic decision-making.

last updated 2 Nov 2025
by GoMask

The brief that made it

Geospatial mapping and visualization of utility infrastructure

Sample rows

preview · 8 of 150 rows · all 18 columns

asset_idstring	statusstring	criticality_levelinteger	address_countrystring	asset_typestring	installation_datedate	latitudefloat	longitudefloat	address_streetstring	address_citystring	address_statestring	address_postal_codestring	owner_organizationstring	maintenance_contactstring	last_maintenance_datedate	connected_asset_idstring	outage_zone_idstring	asset_descriptionstring
P001	active	3	USA	pole	1998-04-15	40.7128	-74.006	123 Broadway Ave	New York	NY	10007	Metro Utility Group	+1-212-555-0192	2023-08-24	P002	NYC-01	Steel pole supporting overhead lines in downtown New York. Inspected annually; critical for local distribution.
P002	maintenance	2	USA	pole	2002-07-10	40.713	-74.007	125 Broadway Ave	New York	NY	10007	Metro Utility Group	+1-212-555-0193	2024-01-17	P001	NYC-01	Wood utility pole adjacent to a busy intersection. Scheduled for inspection and minor repairs.
T001	decommissioned	1	USA	tower	1985-12-11	34.0522	-118.2437	400 Sunset Blvd	Los Angeles	CA	90028	Western Grid Energy	tower.maintenance@wge.com	2016-05-10	blank	LA-03	Old transmission tower retired from service. Formerly supported high-voltage lines across Hollywood area.
U001	active	5	UK	underground_cable	2021-03-12	51.5074	-0.1278	220 Fleet St	London	Greater London	EC4A 2AB	London Power Networks	maintenance.london@lpn.co.uk	2023-11-04	U002	LON-CEN	High-capacity underground cable beneath Fleet Street, serving commercial blocks and government offices.
U002	active	4	UK	underground_cable	2022-05-30	51.5075	-0.128	222 Fleet St	London	Greater London	EC4A 2AB	London Power Networks	cableservice@lpn.co.uk	2024-01-10	U001	LON-CEN	Paired underground cable for redundancy, facilitating uninterrupted supply to central London area.
M001	active	3	Canada	manhole	2017-10-05	43.6532	-79.3832	77 King St W	Toronto	ON	M5H 1J5	Toronto Grid Services	+1-416-555-0101	2023-09-11	M002	TOR-DT	Street-level manhole accessing underground utility lines in Toronto downtown. Inspected semiannually.
M002	maintenance	3	Canada	manhole	2018-08-19	43.6534	-79.3834	79 King St W	Toronto	ON	M5H 1J5	Toronto Grid Services	+1-416-555-0102	2024-02-02	M001	TOR-DT	Utility manhole paired for redundancy. Maintenance scheduled to ensure safe access and compliance.
PME001	active	5	France	pad_mounted_equipment	2020-01-20	48.8566	2.3522	15 Rue de Rivoli	Paris	Île-de-France	75001	Paris Utility Authority	pma.paris@pua.fr	2023-10-27	PME002	PAR-01	Transformer equipment mounted near sidewalk, vital for central Paris grid stability and peak load balancing.
PME002	active	4	France	pad_mounted_equipment	2020-02-15	48.8567	2.3524	17 Rue de Rivoli	Paris	Île-de-France	75001	Paris Utility Authority	service.pma@pua.fr	2023-10-28	PME001	PAR-01	Companion pad-mounted transformer. Installed for increased demand and backup support in city center.
P003	inactive	2	USA	pole	1995-06-30	34.0524	-118.244	401 Sunset Blvd	Los Angeles	CA	90028	Western Grid Energy	pole.maintenance@wge.com	2018-04-15	blank	LA-03	Wood pole in residential neighborhood, marked as inactive after line rerouting in 2017.
T002	maintenance	3	Germany	tower	1990-09-22	52.52	13.405	30 Alexanderplatz	Berlin	Berlin	10178	Berlin Utility Works	service.tower@buw.de	2023-12-15	blank	BER-CEN	Steel lattice transmission tower in central Berlin, undergoing scheduled maintenance for corrosion control.
M003	active	2	USA	manhole	2011-04-18	41.8781	-87.6298	201 S State St	Chicago	IL	60604	Chicago Energy	+1-312-555-0151	2023-07-19	M004	CHI-02	Manhole providing access to district heating lines beneath State Street. High traffic area, inspected frequently.
M004	active	2	USA	manhole	2012-07-22	41.8783	-87.63	203 S State St	Chicago	IL	60604	Chicago Energy	+1-312-555-0152	2023-07-20	M003	CHI-02	Manhole paired for redundancy in heating network. Regular inspections ensure reliability.
T003	inactive	2	Japan	tower	2000-03-08	35.6895	139.6917	5 Chome-1 Marunouchi	Tokyo	Tokyo	100-0005	Tokyo Transmission	tower.service@tokyo-trans.jp	2020-11-25	blank	TOK-05	Inactive transmission tower near Tokyo Station, awaiting scheduled removal.
PME003	active	4	UK	pad_mounted_equipment	2019-06-17	55.9533	-3.1883	44 Princes St	Edinburgh	Scotland	EH2 2ER	Scottish Utilities	pm.maintenance@scotutil.co.uk	2023-08-01	blank	EDIN-01	Pad-mounted transformer serving local retail district, critical during Edinburgh Festival peak demand.
U003	maintenance	5	Finland	underground_cable	2015-02-14	60.1699	24.9384	16 Mannerheimintie	Helsinki	Uusimaa	00100	Helsinki Power	service@helsinkipower.fi	2024-02-18	blank	HEL-CEN	Major underground cable in Helsinki city center, currently under routine maintenance for insulation and capacity.
P004	active	4	USA	pole	2010-09-03	37.7749	-122.4194	350 Market St	San Francisco	CA	94103	Pacific Electric	+1-415-555-0172	2023-11-15	blank	SF-01	Composite pole for trolley lines in San Francisco’s financial district, maintained regularly for safety.
M005	active	3	USA	manhole	2016-12-01	40.4406	-79.9959	15 Grant St	Pittsburgh	PA	15219	Pittsburgh Utility Co.	+1-412-555-0192	2023-12-05	blank	PIT-01	Manhole entry to water and power lines, at intersection of Grant and Fifth. Inspected every six months.
EDGE01	active	5	Polar Outpost	tower	blank	89.9999	0	blank	blank	blank	blank	Global Extreme Energy	blank	blank	EDGE02	POL-01	Experimental tower at northern extremity, testing resilience to polar conditions. No physical address.
EDGE02	inactive	5	Polar Outpost	tower	blank	89.9997	0.0002	blank	blank	blank	blank	Global Extreme Energy	blank	blank	EDGE01	POL-01	Paired polar tower, currently inactive pending environmental review. No address or contact.

What the 150 rows show

from the 150-row sample

Decommissioned status stands out: mean criticality_level is 1.0, against 3.7 for the rest.

4median criticality_level
5asset types

Mean criticality_level by status150 rows

criticality_level150 rows, in bands of 0.5

Median 4, from 1 to 5.

address_country148 rows with a value · 2 left blank

USA32
Canada11
Germany11
UK10
Japan9
Finland6
France5
India5
Ireland5
Australia5

18 columns by typefrom the column list below

string 13
integer 1
float 2
date 2

Columns

18 columns in three groups

blueprint · 18 columns
column	type	description	example
Text 13 columns
`asset_id`	string	Unique identifier for each utility assetunique	P001
`asset_type`	string	Type of utility asset (e.g., pole, tower, underground cable, manhole, pad-mounted equipment)5 values	pole
`status`	string	Current operational status of the assetactive · inactive · maintenance · decommissioned	active
`address_street`	string	Street address of the asset locationoptional	123 Broadway Ave
`address_city`	string	City where the asset is locatedoptional	New York
`address_state`	string	State or province where the asset is locatedoptional	NY
`address_postal_code`	string	Postal code for the asset locationoptional	10007
`address_country`	string	Country where the asset is locatedoptional	USA
`owner_organization`	string	Name of the organization that owns the assetoptional	Metro Utility Group
`maintenance_contact`	string	Contact information for asset maintenanceoptional	+1-212-555-0192
`connected_asset_id`	string	Identifier of another asset directly connected to this asset (for network connectivity)optional	P002
`outage_zone_id`	string	Identifier for the outage management zone this asset belongs tooptional	NYC-01
`asset_description`	string	Additional descriptive information about the assetoptional	Steel pole supporting ove…
Numbers 3 columns
`latitude`	float	Latitude coordinate of the asset location-90 to 90	40.7128
`longitude`	float	Longitude coordinate of the asset location-180 to 180	-74.006
`criticality_level`	integer	Criticality rating of the asset for outage and planning purposes (1=Low, 5=High)1 to 5 · optional	3
Dates and times 2 columns
`installation_date`	date	Date when the asset was installedoptional	1998-04-15
`last_maintenance_date`	date	Date of the last maintenance activity on the assetoptional	2023-08-24

Use it for

An energy dashboard
Criticality_level by status and a breakdown of address_country. Excel, Power BI or Tableau.
Why do the 18 decommissioned rows have a mean criticality_level of 1.0?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Assets150
P0013active
P0022maintena…
T0011decommis…
A software demo
Believable assets with asset_type, installation_date and status to fill a screen in front of a buyer.

This dataset150 rows18 columns

Yours1,000 rows18 columnsaddress_street: UK only

blueprint · geographic-information-system-gis-asset-locations

Behind this dataset

Same schema. As many rows as you need.

These 150 rows came out of a blueprint — 18 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with

Asset ID unique per physical asset
Asset type: pole, tower, transformer, switch, vault, manhole
Geographic coordinates (latitude, longitude)
Address or location description
Connectivity to upstream and downstream assets
Service area and customers served
Layer information: transmission, distribution, underground
Right-of-way and easement boundaries

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: geographic-information-system-gis-asset-locations

What should your data show?

No signup. No card.

Sample rows

What the 150 rows show

Columns

Use it for

An energy dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Energy

What should your data show?