Secure websites use HTTPS
Updated 6 months ago
SFA (Singapore Food Agency)Attribute Legend
| Attributes | Data Type | Description |
|---|---|---|
| Name | Text | - |
| Description | Text | - |
Dataset preview
This code can be used to view the raw JSON dataset for Certificate Grading Info of Licensed Eating Establishments (GEOJSON). Large datasets may be truncated in the preview. Please download the dataset for complete data.
{
"type": "FeatureCollection",
"crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
"features": [
{ "type": "Feature", "properties": { "Name": "kml_1", "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes<\/em><\/th><\/tr><tr bgcolor=\"#E3E3F3\"> <th>LICENSEE_NAME<\/th> <td>CANTON PARADISE PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE16G95X000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE #01-02 MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE49A51D153<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.0 ] } },
{ "type": "Feature", "properties": { "Name": "kml_2", "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes<\/em><\/th><\/tr><tr bgcolor=\"#E3E3F3\"> <th>LICENSEE_NAME<\/th> <td>ROYAL T GROUP PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE11H51K000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE #01-72 MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE422F559F3<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.0 ] } },
{ "type": "Feature", "properties": { "Name": "kml_3", "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes<\/em><\/th><\/tr><tr bgcolor=\"#E3E3F3\"> <th>LICENSEE_NAME<\/th> <td>SEAFOOD PARADISE (S) PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE16A90V000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE #02-03 MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE416AAB7B6<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.0 ] } },
{ "type": "Feature", "properties": { "Name": "kml_4", "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes<\/em><\/th><\/tr><tr bgcolor=\"#E3E3F3\"> <th>LICENSEE_NAME<\/th> <td>MARINA BAY SANDS PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE12U27L000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE #03-01 MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE4C1DD686C<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.0 ] } },
{ "type": "Feature", "properties": { "Name": "kml_5", "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes<\/em><\/th><\/tr><tr bgcolor=\"#E3E3F3\"> <th>LICENSEE_NAME<\/th> <td>MARINA BAY SANDS PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE14P28B000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE #55-00 MARINA BAY SANDS (55TH STOREY) SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE4E11A4798<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.0 ] } },
{ "type": "Feature", "properties": { "Name": "kml_6", "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes<\/em><\/th><\/tr><tr bgcolor=\"#E3E3F3\"> <th>LICENSEE_NAME<\/th> <td>MARINA BAY SANDS PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE13U45A000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE (BASEMENT 2) MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE4FBEBC4E4<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.0 ] } },
{ "type": "Feature", "properties": { "Name": "kml_7", "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes<\/em><\/th><\/tr><tr bgcolor=\"#E3E3F3\"> <th>LICENSEE_NAME<\/th> <td>MARINA BAY SANDS PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE11H75P000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE 3RD STOREY (SERVICE PANTRY 1) MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE47D508C8E<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.0 ] } },
{ "type": "Feature", "properties": { "Name": "kml_8", "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes<\/em><\/th><\/tr><tr bgcolor=\"#E3E3F3\"> <th>LICENSEE_NAME<\/th> <td>MARINA BAY SANDS PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE11H76N000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE 3RD STOREY (SERVICE PANTRY 2) MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE4174FB05E<\/td> <\/tr><tr bgcolor=\"#E3E3FThis code can be used to test a sample API query. It retrieves the data catalogue of this dataset. For a complete guide on query parameters and syntax, please refer to the API documentation
import requests
dataset_id = "d_546a95c5e6a0a264a82247ec107a0629"
url = "https://api-open.data.gov.sg/v1/public/api/datasets/" + dataset_id + "/poll-download"
response = requests.get(url)
json_data = response.json()
if json_data['code'] != 0:
print(json_data['errMsg'])
exit(1)
url = json_data['data']['url']
response = requests.get(url)
print(response.text)This dataset can be reused and cited in research publications.
07 Feb 2019
Free forever for personal or commercial use, under the Open Data Licence.