计算方圆1000内的所有其他学校坐标代码,ObjC代码库,德仔网

代码语言

代码分类

【ObjC】计算方圆1000内的所有其他学校坐标

作者:伯钊 / 发布于2014/11/17/ 1379

所有学校的地图经纬度坐标都保存数据库中，依据传入的经纬度，计算出方圆1000米访问的最大和最小经纬度数值，然后调用SQL语句，就可以查找出该范围内所有学校


	-(void)initSchoolByjinduweidu:(NSString*)s_lg withParam:(NSString *)s_lt whitePara2:(double)dis{
	
	 dis=1.0;
	 //------------
	 float d_lng=2*asin(sin(dis/(2*EARTH_RADIUS))/cos(([s_lt floatValue])));
	 d_lng= RADIANS_TO_DEGREES(d_lng);
	
	 float d_lat = dis/EARTH_RADIUS;
	 d_lat= RADIANS_TO_DEGREES(d_lat);
	
	 float d_lng_max=([s_lg floatValue]+fabs(d_lng));
	 float d_lng_min=([s_lg floatValue]-fabs(d_lng));
	
	 float d_lat_max=([s_lt floatValue]+fabs(d_lat));
	 float d_lat_min=([s_lt floatValue]-fabs(d_lat));
	
	 //--------
	
	 // NSLog(@"s_lg:%@ d_lng:%f d_lng_max:%f d_lng_min:%f",s_lg,d_lng,d_lng_max,d_lng_min);
	 //NSLog(@"s_lt:%@ d_lat:%f d_lat_max:%f d_lat_min:%f",s_lt,d_lat,d_lat_max,d_lat_min);
	
	
	 self.schoollist_id=[NSMutableArray array];
	 self.schoollist_name=[NSMutableArray array];
	 self.schoollist_type=[NSMutableArray array];
	 self.schoollist_addr=[NSMutableArray array];
	 self.schoollist_lg=[NSMutableArray array];
	 self.schoollist_lt=[NSMutableArray array];
	 self.schoollist_property=[NSMutableArray array];
	 self.schoollist_stage=[NSMutableArray array];
	
	 self.schoollist_commentnum=[NSMutableArray array];
	 self.schoollist_content=[NSMutableArray array];
	
	 self.schoollist_likenum=[NSMutableArray array];
	
	 self.schoollist_piclist=[NSMutableArray array];
	
	
	
	 self.schoollist_publishtime=[NSMutableArray array];
	
	
	
	 self.schoollist_summary=[NSMutableArray array];
	
	
	
	
	
	 if (SQLITE_OK != sqlite3_open([self getFilePath ], &pdb;)){
	 return;
	 }
	
	 char* sql ="";
	
	
	 sql = "select * from schoollist where s_lg>? and s_lg<? and s_lt>? and s_lt<?;";//查询语句
	
	
	 sqlite3_stmt* stmt;
	
	 if (sqlite3_prepare_v2(pdb, sql, -1, &stmt;, nil)==SQLITE_OK) {//准备
	
	 sqlite3_bind_text(stmt, 1,[[NSString stringWithFormat:@"%f",d_lng_min]UTF8String], -1, NULL);
	
	 sqlite3_bind_text(stmt, 2,[[NSString stringWithFormat:@"%f",d_lng_max]UTF8String], -1, NULL);
	
	 sqlite3_bind_text(stmt, 3,[[NSString stringWithFormat:@"%f",d_lat_min]UTF8String], -1, NULL);
	
	 sqlite3_bind_text(stmt, 4,[[NSString stringWithFormat:@"%f",d_lat_max]UTF8String], -1, NULL);
	
	 }else{
	 return;
	 }
	
	
	
	 while( SQLITE_ROW == sqlite3_step(stmt) ){//执行
	
	 char* _s_addr = (char*)sqlite3_column_text(stmt, 1);
	
	
	
	 }//while
	
	
	
	 sqlite3_finalize(stmt);
	 sqlite3_close(pdb);
	
	
	
	}

试试其它关键字

　坐标　

同语言下

可能有用的

伯钊贡献的其它代码(24)