insert_wind_field.sql 724 B

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. USE `energy_dt`;
  2. INSERT INTO `wind_field` (
  3. `id`,
  4. `field_id`,
  5. `field_code`,
  6. `company_code`,
  7. `field_name`,
  8. `density`,
  9. `state`,
  10. `engine_number`,
  11. `rated_capacity_number`,
  12. `province_id`,
  13. `province_name`,
  14. `city_id`,
  15. `city_name`,
  16. `longitude`,
  17. `latitude`,
  18. `elevation_height`,
  19. `power_contract_url`,
  20. `del_state`,
  21. `data_source`,
  22. `create_by`,
  23. `create_time`,
  24. `update_by`,
  25. `update_time`
  26. ) VALUES (
  27. 2677,
  28. 'zVrHBiQU',
  29. 'WOF047602984',
  30. 'COM00048',
  31. '内蒙大黑山风电场',
  32. 1.16,
  33. 1,
  34. NULL,
  35. 197600.0,
  36. 5,
  37. '内蒙古自治区',
  38. 314,
  39. '赤峰市',
  40. 117.75553000,
  41. 42.70472300,
  42. 1727.0,
  43. NULL,
  44. 0,
  45. 2,
  46. 2,
  47. '2026-05-26 09:59:35',
  48. NULL,
  49. '2026-05-26 09:59:35'
  50. );