区域类型数据——规划库刷新

select l.site_planning_id,st_x(macro.ant_geopoint) as lon,st_y(macro.ant_geopoint) as lat from npas.pl_macro_station macro inner join 

 npas.meta_localinfo l on macro.site_planning_id=l.site_planning_id

where l.subordinate_area is null 

and macro.ant_geopoint is not null

union all
select l.site_planning_id,st_x(macro.ant_geopoint) as lon,st_y(macro.ant_geopoint) as lat from npas.pl_micro_station macro inner join 

 npas.meta_localinfo l on macro.site_planning_id=l.site_planning_id

where l.subordinate_area is null 

and macro.ant_geopoint is not null

union all
select l.site_planning_id,st_x(macro.ant_geopoint) as lon,st_y(macro.ant_geopoint) as lat from npas.pl_indoor macro inner join 

 npas.meta_localinfo l on macro.site_planning_id=l.site_planning_id

where l.subordinate_area is null 

and macro.ant_geopoint is not null

区域类型meta_localinfo数据更新.java