阿里云全国地图省市县坐标JSON字符串汇总

/* Navicat Premium Data Transfer Source Server : 营养餐服务器1 Source Server Type : Oracle Source Server Version : 110200 Source Host : 114.242.6.6:1521 Source Schema : JYB_YYC_BUSINESS Target Server Type : Oracle Target Server Version : 110200 File Encoding : 65001 Date: 14/04/2023 09:58:55 */ -- ---------------------------- -- Table structure for ADMIN_DIVISION -- ---------------------------- DROP TABLE "JYB_YYC_BUSINESS"."ADMIN_DIVISION"; CREATE TABLE "JYB_YYC_BUSINESS"."ADMIN_DIVISION" ( "DEPT_ID" NUMBER(38,0) NOT NULL, "PARENT_ID" NUMBER(38,0), "ANCESTORS" VARCHAR2(50 BYTE), "DEPT_NAME" VARCHAR2(100 BYTE), "ORDER_NUM" NUMBER(4,0), "LEADER" VARCHAR2(20 BYTE), "PHONE" VARCHAR2(11 BYTE), "EMAIL" VARCHAR2(50 BYTE), "STATUS" CHAR(1 BYTE), "DEL_FLAG" CHAR(1 BYTE), "CREATE_BY" VARCHAR2(64 BYTE), "CREATE_TIME" DATE, "UPDATE_BY" VARCHAR2(64 BYTE), "UPDATE_TIME" DATE, "DIVISION_LEVEL" CHAR(1 BYTE), "DIVISION_TYPE" VARCHAR2(10 BYTE), "STS" CHAR(1 BYTE), "IS_JHDLS" CHAR(1 BYTE), "IS_SGX" CHAR(1 BYTE), "STS_TIME" DATE, "DEPT_CODE" VARCHAR2(255 BYTE), "PRO_CODE" VARCHAR2(60 BYTE), "PRO_NAME" VARCHAR2(100 BYTE), "CITY_CODE" VARCHAR2(60 BYTE), "CITY_NAME" VARCHAR2(100 BYTE), "COUNTY_CODE" VARCHAR2(60 BYTE), "COUNTY_NAME" VARCHAR2(100 BYTE), "IS_JHX" CHAR(1 BYTE) DEFAULT 0 ) TABLESPACE "JYB_YYC_BUSINESS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; COMMENT ON COLUMN "JYB_YYC_BUSINESS"."ADMIN_DIVISION"."PRO_CODE" IS '省编码'; COMMENT ON COLUMN "JYB_YYC_BUSINESS"."ADMIN_DIVISION"."PRO_NAME" IS '省名称'; COMMENT ON COLUMN "JYB_YYC_BUSINESS"."ADMIN_DIVISION"."CITY_CODE" IS '市编码'; COMMENT ON COLUMN "JYB_YYC_BUSINESS"."ADMIN_DIVISION"."CITY_NAME" IS '市名称'; COMMENT ON COLUMN "JYB_YYC_BUSINESS"."ADMIN_DIVISION"."COUNTY_CODE" IS '县编码'; COMMENT ON COLUMN "JYB_YYC_BUSINESS"."ADMIN_DIVISION"."COUNTY_NAME" IS '县名称'; COMMENT ON COLUMN "JYB_YYC_BUSINESS"."ADMIN_DIVISION"."IS_JHX" IS '是否计划省、市、县'; COMMENT ON TABLE "JYB_YYC_BUSINESS"."ADMIN_DIVISION" IS '省市县表'; -- ---------------------------- -- Records of ADMIN_DIVISION -- ---------------------------- INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('211303000000', '211300000000', NULL, '龙城区', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '3', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '211303000000', '210000000000', '辽宁省', '211300000000', '朝阳市', '211303000000', '龙城区', '0'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('211322000000', '211300000000', NULL, '建平县', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '3', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '211322000000', '210000000000', '辽宁省', '211300000000', '朝阳市', '211322000000', '建平县', '1'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('211324000000', '211300000000', NULL, '喀喇沁左翼蒙古族自治县', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '3', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '211324000000', '210000000000', '辽宁省', '211300000000', '朝阳市', '211324000000', '喀喇沁左翼蒙古族自治县', '1'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('211381000000', '211300000000', NULL, '北票市', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '3', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '211381000000', '210000000000', '辽宁省', '211300000000', '朝阳市', '211381000000', '北票市', '1'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('211382000000', '211300000000', NULL, '凌源市', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '3', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '211382000000', '210000000000', '辽宁省', '211300000000', '朝阳市', '211382000000', '凌源市', '1'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('211404000000', '211400000000', NULL, '南票区', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '3', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '211404000000', '210000000000', '辽宁省', '211400000000', '葫芦岛市', '211404000000', '南票区', '1'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('211421000000', '211400000000', NULL, '绥中县', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '3', 'A', '0', '1', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '211421000000', '210000000000', '辽宁省', '211400000000', '葫芦岛市', '211421000000', '绥中县', '0'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('211422000000', '211400000000', NULL, '建昌县', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '3', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '211422000000', '210000000000', '辽宁省', '211400000000', '葫芦岛市', '211422000000', '建昌县', '1'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('220100000000', '220000000000', NULL, '长春市', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '3', '2', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '220100000000', '220000000000', '吉林省', '220100000000', '长春市', NULL, NULL, '0'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('220102000000', '220100000000', NULL, '南关区', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '2', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '220102000000', '220000000000', '吉林省', '220100000000', '长春市', '220102000000', '南关区', '0'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('220103000000', '220100000000', NULL, '宽城区', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '2', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '220103000000', '220000000000', '吉林省', '220100000000', '长春市', '220103000000', '宽城区', '0'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('220104000000', '220100000000', NULL, '朝阳区', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '2', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '220104000000', '220000000000', '吉林省', '220100000000', '长春市', '220104000000', '朝阳区', '0'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('220122000000', '220100000000', NULL, '农安县', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '2', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '220122000000', '220000000000', '吉林省', '220100000000', '长春市', '220122000000', '农安县', '0'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('220181000000', '220100000000', NULL, '九台市', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '2', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '220181000000', '220000000000', '吉林省', '220100000000', '长春市', '220181000000', '九台市', '0'); INSERT INTO "JYB_YYC_BUSINESS"."ADMIN_DIVISION" VALUES ('220183000000', '220100000000', NULL, '德惠市', '0', 'ruoyi', NULL, NULL, '0', '0', 'ruoyi', NULL, 'ruoyi', NULL, '4', '2', 'A', '0', '0', TO_DATE('2022-08-04 15:14:45', 'SYYYY-MM-DD HH24:MI:SS'), '220183000000', '220000000000', '吉林省', '220100000000', '长春市', '220183000000', '德惠市', '0'); INSERT INTO "J