Advertisement
daniilak

Untitled

Jan 23rd, 2022
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.58 KB | None | 0 0
  1. Table "public.reforma_opendata"
  2. Column | Type | Collation | Nullable | Default
  3. ---------------------------------+------------------------+-----------+----------+----------------------------------------------
  4. id | integer | | not null | nextval('reforma_opendata_id_seq'::regclass)
  5. id_ref | integer | | not null |
  6. management_organization_id | integer | | |
  7. region_id | character varying(40) | | not null |
  8. area_id | character varying(40) | | not null |
  9. city_id | character varying(40) | | not null |
  10. street_id | character varying(40) | | not null |
  11. houseguid | character varying(40) | | not null |
  12. built_year | smallint | | |
  13. exploitation_start_year | smallint | | |
  14. house_type | character varying(255) | | |
  15. is_alarm | character varying(3) | | |
  16. method_of_forming_overhaul_fund | character varying(255) | | |
  17. floor_count_max | smallint | | |
  18. floor_count_min | smallint | | |
  19. entrance_count | smallint | | |
  20. energy_efficiency | character varying(255) | | |
  21. elevators_count | smallint | | |
  22. quarters_count | smallint | | |
  23. living_quarters_count | smallint | | |
  24. unliving_quarters_count | smallint | | |
  25. area_total | double precision | | |
  26. area_residential | double precision | | |
  27. area_non_residential | double precision | | |
  28. area_common_property | double precision | | |
  29. area_land | double precision | | |
  30. parking_square | double precision | | |
  31. playground | smallint | | |
  32. sportsground | smallint | | |
  33. foundation_type | character varying(255) | | |
  34. floor_type | character varying(255) | | |
  35. wall_material | character varying(255) | | |
  36. basement_area | double precision | | |
  37. chute_type | character varying(255) | | |
  38. chute_count | smallint | | |
  39. electrical_type | character varying(255) | | |
  40. electrical_entries_count | smallint | | |
  41. heating_type | character varying(255) | | |
  42. hot_water_type | character varying(255) | | |
  43. cold_water_type | character varying(255) | | |
  44. sewerage_type | character varying(255) | | |
  45. sewerage_cesspools_volume | double precision | | |
  46. gas_type | character varying(255) | | |
  47. ventilation_type | character varying(255) | | |
  48. firefighting_type | character varying(255) | | |
  49. drainage_type | character varying(255) | | |
  50. project_type | text | | |
  51. other_beautification | text | | |
  52. address | text | | |
  53. fias_id | integer | | |
  54. geo_lat | double precision | | |
  55. geo_lon | double precision | | |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement