stevevance · December 9, 2016 04:56
diff --git a/queries.sql b/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
diff --git a/user-609-businesses.csv b/user-609-businesses.csv
diff --git a/user-609-businesses.geojson b/user-609-businesses.geojson
diff --git a/user-609-businesses_100feet.csv b/user-609-businesses_100feet.csv
diff --git a/user-609-businesses_100feet.geojson b/user-609-businesses_100feet.geojson
	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
account_number	business_activity	name	address	longitude	latitude
405955	Dry Cleaning - Drop Off Location	1130 VALET SHOP	1130 S MICHIGAN AVE GROUND	-87.62425305	41.868305012
395294	Consumption of Liquor on Premises	BURGER BAR CHICAGO	1150 S MICHIGAN AVE 1	-87.624256704	41.867758644
395294	Preparation of Food and Dining on Premise With Seating	BURGER BAR CHICAGO	1150 S MICHIGAN AVE 1	-87.624256704	41.867758644
304306	Consumption of Liquor on Premises	FORNETTO-MEI ON GRANT	1108 S MICHIGAN AVE	-87.624270066	41.869002215
304306	Catering of Liquor To Events	FORNETTO-MEI ON GRANT	1108 S MICHIGAN AVE	-87.624270066	41.869002215
304306	Retail Sales of Perishable Foods	FORNETTO-MEI ON GRANT	1108 S MICHIGAN AVE	-87.624270066	41.869002215
394321	Skincare Services \| Retail Sales of General Merchandise \| Provide Massage Services	HAND & STONE MASSAGE AND FACIAL SPA	1130 S MICHIGAN AVE 1 B	-87.62425305	41.868305012
65004	Retail Sales of Perishable Foods	POTBELLY SANDWICH WORKS	48 E ROOSEVELT RD	-87.625568619	41.867544428
63160	Provide Parking Spaces For a Fee - to Residents, Tenants, Users, Employees and/or Guests (Not Available or Advertised to the Public)	STANDARD PARKING CORPORATION	1130 S MICHIGAN AVE	-87.62425305	41.868305012
211718	Retail Sales of Perishable Foods	TRADER JOE'S #701	1147 S WABASH AVE 1 100	-87.625686841	41.86786709
211718	Retail Sales of Packaged Liquor on Sundays from 8AM - 11AM \| Retail Sales of Packaged Liquor	TRADER JOE'S #701	1147 S WABASH AVE 1 100	-87.625686841	41.86786709
306959	Retail Sales of Perishable Foods	YOLK	1120 S MICHIGAN AVE 1ST	-87.624260744	41.868622039