1、以省为计算单位进行,先把各个地市的poi合并到一个图层
2、使用工具spatial join或者是identity,把每一个poi投在对应的乡镇边界里面去
3、把计算的poi点进行各个街道的汇总统计分析
--接入板块数据
select * into hubei
from openrowset
('Microsoft.ACE.OLEDB.12.0',
'dBase IV;HDR=NO;IMEX=2; Database=E:\temp',
'select * from [湖北poi总.dbf]')
drop table #tempestate0709
select top 100 * from #tempestate0709
select a.xzdm,ta.快餐,b.肯德基,c.星巴克,d.超市,f.便利店,g.[零售业(去超市、便利店)],t1.百货商场,t2.[酒店(三星及以下)],t3.[酒店(四星及以下)],h.休闲,t4.医院,i.[不利因素(火葬场、殡仪馆)],j.地铁站,k.火车站,l.银行,m.[ATM、自助银行],n.幼儿园,o.小学,p.中学,q.公司企业,r.[工厂、园区],s.大厦 into stat_hubei from
(select xzdm from hubei where xzdm <>'' group by xzdm) as a
left join
--canyin
(select xzdm,COUNT(*) as "快餐" from hubei where KIND like '10%' and xzdm <> '' group by xzdm ) ta
on a.xzdm=ta.xzdm
left join
(select xzdm,COUNT(*) as "肯德基" from hubei where KIND = '10C1' and xzdm <> '' group by xzdm ) b
on a.xzdm=b.xzdm
left join
(select xzdm,COUNT(*) as "星巴克" from hubei where KIND = '1603' and xzdm <> '' grou