dunnies

Data source: National Public Toilet Map on data.gov.au

3 rows where IconURL = "https://toiletmap.gov.au/images/icons/ma.png"

View and edit SQL

Suggested facets: State, Male, Female, FacilityType, ToiletType, ParkingAccessible, RHTransfer, IsOpen, SharpsDisposal

IconURL

  • https://toiletmap.gov.au/images/icons/ma.png · 3
Link rowid ▼ ToiletID URL Name Address1 Town State Postcode AddressNote Male Female Unisex DumpPoint FacilityType ToiletType AccessLimited PaymentRequired KeyRequired AccessNote Parking ParkingNote AccessibleMale AccessibleFemale AccessibleUnisex AccessibleNote MLAK ParkingAccessible AccessibleParkingNote Ambulant LHTransfer RHTransfer AdultChange IsOpen OpeningHoursSchedule OpeningHoursNote BabyChange Showers DrinkingWater SharpsDisposal SanitaryDisposal IconURL IconAltText Notes Status Latitude Longitude
3547 4449 https://toiletmap.gov.au/toilet/4449 Denman Memorial Park Ogilvie Street Denman New South Wales 2328.0   1 0 0 0 Park or reserve Sewerage 0 0 0   1 Park located between Isobel/Ogilvie Street. 1 0 0 Door way narrow, door inward opening, cubicle floor space large, toilet seat height low, grab rails and wash basin. 0 0 Park located between Isobel/Ogilvie Street. 0 0 1 0 DaylightHours     0 0 0 0 0 https://toiletmap.gov.au/images/icons/ma.png Male (Accessible)   Verified -32.3887299 150.6856285
3811 4815 https://toiletmap.gov.au/toilet/4815 Nowra - Stewart Place (Male) Stewart Place Nowra New South Wales 2541.0   1 0 0 0 Bus station Sewerage 0 0 0   1 Central CBD carparking 1 0 0 Facilities are male only 0 1 Central CBD carparking 0 0 0 0 DaylightHours     0 0 0 1 0 https://toiletmap.gov.au/images/icons/ma.png Male (Accessible)   Verified -34.8754335 150.601742
13292 34831 https://toiletmap.gov.au/toilet/34831 Wowan Park Don Street Wowan Queensland 4702.0   0 1 0 0 Park or reserve Septic 0 0 0   1   1 0 0   0 1   0 0 0 0 AllHours     0 0 0 0 0 https://toiletmap.gov.au/images/icons/ma.png Male (Accessible)   Verified -23.90894907 150.19494579

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "dunnies" (
"ToiletID" INTEGER,
  "URL" TEXT,
  "Name" TEXT,
  "Address1" TEXT,
  "Town" TEXT,
  "State" TEXT,
  "Postcode" REAL,
  "AddressNote" TEXT,
  "Male" INTEGER,
  "Female" INTEGER,
  "Unisex" INTEGER,
  "DumpPoint" INTEGER,
  "FacilityType" TEXT,
  "ToiletType" TEXT,
  "AccessLimited" INTEGER,
  "PaymentRequired" INTEGER,
  "KeyRequired" INTEGER,
  "AccessNote" TEXT,
  "Parking" INTEGER,
  "ParkingNote" TEXT,
  "AccessibleMale" INTEGER,
  "AccessibleFemale" INTEGER,
  "AccessibleUnisex" INTEGER,
  "AccessibleNote" TEXT,
  "MLAK" INTEGER,
  "ParkingAccessible" INTEGER,
  "AccessibleParkingNote" TEXT,
  "Ambulant" INTEGER,
  "LHTransfer" INTEGER,
  "RHTransfer" INTEGER,
  "AdultChange" INTEGER,
  "IsOpen" TEXT,
  "OpeningHoursSchedule" TEXT,
  "OpeningHoursNote" TEXT,
  "BabyChange" INTEGER,
  "Showers" INTEGER,
  "DrinkingWater" INTEGER,
  "SharpsDisposal" INTEGER,
  "SanitaryDisposal" INTEGER,
  "IconURL" TEXT,
  "IconAltText" TEXT,
  "Notes" TEXT,
  "Status" TEXT,
  "Latitude" REAL,
  "Longitude" REAL
);
CREATE INDEX "ix_dunnies_ToiletID"ON "dunnies" ("ToiletID");
Powered by Datasette · Query took 603.314ms · Data source: National Public Toilet Map on data.gov.au