Businesses and their activity codes in the user-609 block (within the block and within 100 feet of the block)

queries.sql

select
	b.account_number,
	b.business_activity, 
	b.doing_business_as_name as name, 
	b.address,
	st_x(b.geom) as longitude,
	st_y(b.geom) as latitude
from business_licenses b, 
	users_boundaries u

where st_dwithin(b.geom_3435, u.geom, 0)
and expiration_date > current_date
 and slug = 'user-609' order by name;
 
 select
	b.account_number,
	b.business_activity, 
	b.doing_business_as_name as name, 
	b.address,
	st_x(b.geom) as longitude,
	st_y(b.geom) as latitude
from business_licenses b, 
	users_boundaries u

where st_dwithin(b.geom_3435, u.geom, 100)
and expiration_date > current_date
 and slug = 'user-609' order by name;
 
# view the map: http://www.chicagocityscape.com/places.php?place=user-609

user-609-businesses.csv

user-609-businesses.geojson

{
  "type": "FeatureCollection",
  "features": [
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.62425305,
          41.868305012
        ]
      },
      "properties": {
        "account_number": "405955",
        "business_activity": "Dry Cleaning - Drop Off Location",
        "name": "1130 VALET SHOP",
        "address": "1130 S MICHIGAN AVE GROUND"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.624256704,
          41.867758644
        ]
      },
      "properties": {
        "account_number": "395294",
        "business_activity": "Consumption of Liquor on Premises",
        "name": "BURGER BAR CHICAGO",
        "address": "1150 S MICHIGAN AVE 1"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.624256704,
          41.867758644
        ]
      },
      "properties": {
        "account_number": "395294",
        "business_activity": "Preparation of Food and Dining on Premise With Seating",
        "name": "BURGER BAR CHICAGO",
        "address": "1150 S MICHIGAN AVE 1"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.624270066,
          41.869002215
        ]
      },
      "properties": {
        "account_number": "304306",
        "business_activity": "Consumption of Liquor on Premises",
        "name": "FORNETTO-MEI ON GRANT",
        "address": "1108 S MICHIGAN AVE"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.624270066,
          41.869002215
        ]
      },
      "properties": {
        "account_number": "304306",
        "business_activity": "Catering of Liquor To Events",
        "name": "FORNETTO-MEI ON GRANT",
        "address": "1108 S MICHIGAN AVE"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.624270066,
          41.869002215
        ]
      },
      "properties": {
        "account_number": "304306",
        "business_activity": "Retail Sales of Perishable Foods",
        "name": "FORNETTO-MEI ON GRANT",
        "address": "1108 S MICHIGAN AVE"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.62425305,
          41.868305012
        ]
      },
      "properties": {
        "account_number": "394321",
        "business_activity": "Skincare Services | Retail Sales of General Merchandise | Provide Massage Services",
        "name": "HAND & STONE MASSAGE AND FACIAL SPA",
        "address": "1130 S MICHIGAN AVE 1 B"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.625568619,
          41.867544428
        ]
      },
      "properties": {
        "account_number": "65004",
        "business_activity": "Retail Sales of Perishable Foods",
        "name": "POTBELLY SANDWICH WORKS",
        "address": "48 E ROOSEVELT RD"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.62425305,
          41.868305012
        ]
      },
      "properties": {
        "account_number": "63160",
        "business_activity": "Provide Parking Spaces For a Fee - to Residents, Tenants, Users, Employees and/or Guests (Not Available or Advertised to the Public)",
        "name": "STANDARD PARKING CORPORATION",
        "address": "1130 S MICHIGAN AVE"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.625686841,
          41.86786709
        ]
      },
      "properties": {
        "account_number": "211718",
        "business_activity": "Retail Sales of Perishable Foods",
        "name": "TRADER JOE'S #701",
        "address": "1147 S WABASH AVE 1 100"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.625686841,
          41.86786709
        ]
      },
      "properties": {
        "account_number": "211718",
        "business_activity": "Retail Sales of Packaged Liquor on Sundays from 8AM - 11AM | Retail Sales of Packaged Liquor",
        "name": "TRADER JOE'S #701",
        "address": "1147 S WABASH AVE 1 100"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [
          -87.624260744,
          41.868622039
        ]
      },
      "properties": {
        "account_number": "306959",
        "business_activity": "Retail Sales of Perishable Foods",
        "name": "YOLK",
        "address": "1120 S MICHIGAN AVE 1ST"
      }
    }
  ]
}

user-609-businesses_100feet.csv

user-609-businesses_100feet.geojson